How to Excel: Intermediate

Description

This intermediate Excel class is designed to build on what was learned in “How to Excel: Basic” by deepening your proficiency in Microsoft Excel. Over three comprehensive modules, participants will explore advanced functionalities, including visual data enhancement through conditional formatting and chart creation, mastering multiple criteria functions and lookup techniques, leveraging data functions for enhanced analysis, and becoming proficient in data validation. The course culminates in an exploration of Pivot Tables and Pivot Charts, empowering participants to efficiently analyze and visualize large datasets. Through a combination of insightful discussions, practical demonstrations, and hands-on projects, this class ensures that attendees not only comprehend the intricacies of intermediate Excel features but also acquire the practical skills necessary to confidently apply them in real-world scenarios, further enhancing their Excel capabilities for professional success.

Length – 4 hours

Requirement – Laptop computer with Excel 2007 or newer

• Module 1

• • Applying and removing conditional formatting
  • Charts

• • • Create
    • Modify X and Y
    • Add and remove elements
    • Apply styles

• • Configure print settings
  • Header and footers

• Module 2

• • Single criteria functions – SUMIF, AVERAGEIF, COUNTIF
  • Lookup functions – VLOOKUP, HLOOKUP, XLOOPUP
  • Data functions – NOW, TODAY, WEEKDAY, WORKDAY
  • Using Data Validation

• Module 3

• • Pivot Tables

• • • Create
    • Change and format
    • Calculated field
    • Filter
    • Group
    • Format

• • Pivot Charts

• • • Create
    • Format

Do you have any questions about this class? Please contact us.