Microsoft Excel Level 3 - Advanced (Live Online)

On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.What's Included:An Excel training manualCertificate of course completionSmall class sizesFREE repeat valid for 6 monthsDETAILED COURSE OUTLINELogical and Lookup Functions:The IF FunctionConditional CalculationsUsing SUMIFVLOOKUPS and HLOOKUPSRange LOOKUPSAdvanced FormulasAuditing and Error TrappingFormula OptionsArray FunctionsUsing TRANSPOSESpecial Functions:Date and Time FunctionsTODAYNOWDATEDate CalculationsText FunctionsUsing CONCATENATE and TRIMUsing UPPER, LOWER and PROPERExtracting TextStatistical FunctionsUsing MIN and MAXUsing COUNT, COUNTA and COUNTBLANKFinancial FunctionsUsing FVUsing PMTImporting and Exporting:The Power Pivot Data ModelImporting DataUsing Power PivotExporting DataData Analysis:What-if AnalysisScenariosUsing Goal SeekThe Analysis ToolpakMacros and Forms:Recording MacrosRunning MacrosRunning Macros when Workbook is Open or ClosedUsing Forms to Record Input