Effective Use of Microsoft Excel for Business Analysis (One Day)
- Overview on Office
- Change in User Interface
- Preprocess
- Cleaning Up your Data with Text Functions
- Filtering
- Using Advanced Filter to Screen your Data
- Look and Reference
- Using Vlookup Formula to Reference Data
- Dynamic Data Range
- Introducing Table
- Data Validation
- Ensuring Data Correctness by Validation
- Data Consolidation
- Summarize Similar Structured Data
- Pivot Table
- Pivot Table Fundamentals
- Creating a Basic Pivot Table
- Customizing Fields in a Pivot Table
- Formatting Your Pivot Table Report
- Controlling the Way You View Your Pivot Data
- Creating and Using Pivot Charts
- Recording Macro for Pivot Table