Program Contents
Topic One: Excel Basics
- An Introduction to the MS Excel environment
- Working with Multiple Worksheets and Workbooks
- Consolidate Data
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Data Forecasting
Topic Two: Excel Functions
- Using MS Excel functions for fundamental data analysis
- Array Functions
- Intermediate MS Excel functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math Functions
- Statistical Functions
- Text Functions
Topic Three: Excel Formula
- What if and scenario analysis using MS Excel
- Vlookup
- Sum, count, average
- If statements
- Sumif, countif, averageif
- Concatenate
- Max & min
- And
- Proper
- Index + match
Topic Four: Building Pivot table
- Creating a Pivot Table
- Specifying PivotTable Data
- Calculation
- Filtering and Sorting a PivotTable
- Creating a PivotChart
- Grouping Items
- Updating a PivotTable
- Formatting a PivotTable
- Using Slicers
Topic Five: Excel Data Analyses
- Carrying out statistical analysis using MS Excel
- Descriptive analyses
- Multiples regression analyses
- Correlation and Covariance analyses
- ANOVA Analyses
- Excel Charts and Graphs
Topic Six Excel For Finance
- Budgeting
- Budget variance analys
