Overview

Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.This course is divided into 6 sections, and made up of 42 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.The course is divided into the following sections and chapters:Getting Started with ExcelIntroducing ExcelEntering and Editing Worksheet DataPerforming Basic Worksheet OperationsWorking with Excel Ranges and TablesFormatting WorksheetsUnderstanding Excel Files and TemplatesPrinting Your WorkCustomizing the Excel User InterfaceWorking with Formulas and FunctionsIntroducing Formulas and FunctionsUsing Formulas for Common Mathematical OperationsUsing Formulas to Manipulate TextUsing Formulas with Dates and TimesUsing Formulas for Conditional AnalysisUsing Formulas for Matching and LookupsUsing Formulas for Financial AnalysisUsing Formulas for Statistical AnalysisUnderstanding and Using Array FormulasMaking Your Formulas Error-FreeCreating Charts and Other VisualizationsGetting Started with Excel ChartsUsing Advanced Charting TechniquesCreating Sparkline GraphicsVisualizing with Custom Number Formats and ShapesImplementing Excel Dashboarding Best PracticesManaging and Analyzing DataImporting and Cleaning DataUsing Data ValidationCreating and Using Worksheet OutlinesLinking and Consolidating WorksheetsIntroduction to PivotTables and Data AnalysisPerforming Spreadsheet What-If AnalysisAnalyzing Data Using Goal Seeking and SolverAnalyzing Data with the Analysis ToolPakProtecting Your WorkUnderstanding Power Pivot and Power QueryIntroducing Power PivotWorking Directly with the Internal Data ModelAdding Formulas to Power PivotPower QueryAutomating ExcelIntroducing Visual Basic for ApplicationsCreating Custom Worksheet FunctionsCreating UserFormsUsing UserForm Controls in a Worksheet through an ExampleWorking with Excel EventsCreating Custom Excel Add-Ins

Skills

Reviews