Course Curriculum

  • 01

    Automating Worksheet Functionality

    • Using Macros Part 1

    • Using Macros Part 2

    • Validation Part 1

    • Validation Part 2

    • Cond Formatting Part 1

    • Cond Formatting Part 2
  • 02

    Auditing Worksheets

    • Trace Cells

    • Troubleshoot and Evaluate
  • 03

    Analyzing and Presenting Data

    • Goal Seek

    • Solver

    • Histograms

    • Sparklines

    • Descriptive Statistics

    • Scenarios
  • 04

    Working with Multiple Workbooks

    • Consolidation

    • Collaboration

    • Appending Data
  • 05

    Exporting Excel Data

    • Importing TXT and CSV

    • Export CSV

What others have been saying about this course:

Use your Call To Action description to encourage students to sign up for your course

Sign up now!
Liquid error: internal

You may also be interested in...