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