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

Related Courses

Analysing Financial Data in Excel

  14 hours

Excel For Statistical Data Analysis

  14 hours

Microsoft Office Excel - poziom średnio zaawansowany

  14 hours

Working with spreadsheet in Microsoft Excel

  14 hours

Excel Advanced with VBA

  21 hours

Excel Advanced

  14 hours

Visual Basic for Applications (VBA) in Excel - Introduction to programming

  21 hours

Visual Basic for Applications (VBA) in Excel - Advanced

  14 hours

Visual Basic for Applications (VBA) in Excel (intermediate level)

  14 hours

Microsoft Office Excel - efektywna praca z arkuszem

  14 hours

Financial Analysis in Excel

  14 hours

Visual Basic for Applications (VBA) for Analysts

  21 hours

Excel and VBA Programming for Audit and Finance Professionals

  28 hours

VBA For Access & Excel

  21 hours