Description
***Exercise and demo files included***Excel has always been the go-to software for data organization and financial analysis. Even in the age of Big Data, Excel remains indispensable and relevant, thus almost everyone should at least have some basic Excel skills. If you are brand-new to Excel, then this huge course bundle is perfect for you! This BIG Excel bundle includes not just two, not three, but six full courses to bring you from Excel newbie to Data Analyst quick! Okay, maybe not that quick, as this bundle gives you 32+ hours of tutorials including more than 300 individual video lectures! With the Excel 2019/365 beginner course, you'll gain a fantastic grounding in Microsoft Excel. The course will teach you how to understand spreadsheet basics, including creating your first workbook and how to navigate Excel, an introduction to formulas and functions, how to create amazing-looking charts and graphs, and much more. Excel PivotTables is an interactive way of quickly summarizing large amounts of data. It is ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. The beginner and advanced PivotTables courses will discuss the importance of cleaning your data before you can create your first Pivot Table. You will also learn how to make the most of this powerful data analysis function. The Excel for Business Analysts course focuses on the specific functions, formulas, and tools that Excel has that can help conduct business or data analysis. We take you on a no-nonsense journey to teach you how to use them. In this course, you'll learn several tools and functions that can be used for analysis and visualization, plus some more advanced techniques designed to aid in forecasting. We finish by taking you through our favorite and most-useful advanced Excel functions before moving on to teaching you how to use basic Macros and VBA to automate and supercharge your spreadsheets. This is the only Excel course you are ever going to need! Excel 2019/365 for BeginnersWhat you will learn: What's new in Excel 2019Creating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns, and cellsCut, Copy and PasteIntroduction to functions and formulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas - the basicsPivotTables for BeginnersWhat you will learn: How to Clean and Prepare your DataHow to create a Basic Pivot TableHow to use the Pivot Table Fields paneHow to Add Fields and Pivoting the FieldsHow to Format Numbers in Pivot TableDifferent ways to Summarize DataHow to Group Pivot Table DataHow to use Multiple Fields and DimensionThe Methods of AggregationHow to Choose and Lock the Report LayoutHow to apply Pivot Table StylesHow to Sort Data and use FiltersHow to create Pivot Charts based on Pivot Table dataHow to Select the right Chart for your dataHow to apply Conditional FormattingHow to add Slicers and Timelines to your dashboardsHow to Add New Data to the original source datasetHow to Update Pivot Tables and ChartsAdvanced PivotTables in ExcelWhat you will learn: How to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping, and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing looking dashboardsExcel for Business AnalystsWhat you will learn: How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUPHow to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysisHow to split data using text functions SEARCH, LEFT, RIGHT, MIDHow to standardize and clean data ready for analysisAbout using the PivotTable function to perform data analysisHow to use slicers to draw out informationHow to display your analysis using Pivot ChartsAll about forecasting and using the Forecast SheetsConducting a Linear Forecast and Forecast SmoothingHow to use Conditional Formatting to highlight areas of your dataAll about Histograms and RegressionHow to use Goal Seek, Scenario Manager, and Solver to fill data gapsAdvanced Formulas and Functions in ExcelYou will learn to: Filter a dataset using a formulaSort a dataset using formulas and defined variablesCreate multi-dependent dynamic drop-down listsPerform a 2-way lookupMake decisions with complex logical calculationsExtract parts of a text stringCreate a dynamic chart titleFind the last occurrence of a value in a listLook up information with XLOOKUPFind the closest match to a valueMacros and VBA for BeginnersWhat you will learn: What is VBA?How to record your first macroHow to record a macro using relative referencesHow to record a complex, multi-step macro and assign it to a buttonHow to set up the VBA EditorHow to edit Macros in the VBA EditorHow to get started with some basic VBA codeHow to fix issues with macros using debugging toolsHow to write your own macro from scratchHow to create a custom Macro ribbon and add all the Macros you've createdThis course bundle includes:6 Full Courses32+ hours of video tutorials300+ individual video lecturesExercise and Demo files to practice and follow alongCertificate of completion
