Excel Advanced (Live Online)

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more!Course Outline:Unit 1: Logical and statistical functionsTopic A: Logical functions (IF, OR, AND, NOT, IFERROR)Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND)Unit 2: Financial and date functionsTopic A: Financial functions (PMT)Topic B: Date and time functions (DATE, TODAY, YEAR, NOW, NETWORKDAYS)Topic C: Array formulasTopic D: Displaying and printing formulasUnit 3: Lookups and data tablesTopic A: Using lookup functions (VLOOKUP, HLOOKUP)Topic B: Using MATCH and INDEXTopic C: Creating data tablesUnit 4: Advanced data managementTopic A: Validating cell entriesUnit 5: Exporting and importingTopic A: Exporting and importing text filesTopic B: Exporting and importing XML dataTopic C: Getting external dataUnit 6: Analytical toolsTopic A: Goal Seek and SolverTopic B: The Analysis ToolPakTopic C: ScenariosUnit 7: Macros and custom functionsTopic A: Running and recording a macroTopic B: Working with VBA code