Course Outline

Introduction to Solving Problems in Excel

Excel Basics

Collecting, Formatting, and Parsing Data

Using Formulas and Functions

Understanding the Spreadsheet Structure

Understanding the Logical Model Flow

Creating a Logical Model Flow

Using Charts, Pivot Tables, and Reporting

Checking, Testing, and Validating

Modeling Scenario and Sensitivity Analysis

Data Visualization and Presentation

Summary and Next Steps

Requirements

  • Basic understanding of Excel

Audience

  • Data Analysts
  7 Hours
 

Testimonials (2)

Related Courses

Microsoft Office Excel - intermediate level

  14 Hours

Related Categories