Skip to content

Intermediate Excel

Adult Programs / Professional Development -
Adult Online Professional & Personal Development Spring/Summer 2024
Learn how to organize, display and calculate your data. Find out how to consolidate data proficiently. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Discover how easily pivot tables can be created to quickly summarize large amounts of data. 

This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. 

Class Details

Unit 1: Organizing Worksheet and Table Data
  • Introduction to tables
  • Formatting tables using table styles
  • Using formulas in tables
  • Sorting and Filtering table data
Unit 2: Understanding Popular Excel Functions
  • Understanding Named Ranges
  • Applying business functions
  • Creating functions that handle text
  • Performing basic lookup functions
  • Creating functions that work with dates and times
Unit 3: Improving Worksheet Appearance
  • Formatting cells in worksheets
  • Correcting common function errors
  • Creating and using templates
  • Customizing Excel toolbar
Unit 4: Analyzing Data Using Data Validation and Pivot Tables
  • Understanding how to convert text to columns
  • Understanding how to analyze spreadsheet data
  • Understanding the basic pivot table layout and key terms
  • Creating and formatting simple pivot tables

For more information, visit our question and answer page - Click Here.

Amy Klous

LERN Instructor

Amy Klous completed a BA in Entrepreneurship and an MBA. She has nearly 20 years experience in marketing and the majority of that time was spent working for corporations using Excel to analyze sales and industry data. Her Excel students appreciate the hands-on learning and Amy’s patient teaching style. Amy runs a marketing advising + training business where she helps overwhelmed small businesses feel comfortable and understand how to market their business effectively.

SLCERT20B2 Closed

  Learning Resources Network, Inc , Amy Klous

Virtual Class
Sun-Sat, Jul 1 - Jul 26
12:01 AM - 11:59 PM


Min Age   16 yr.

$ 195.00
single course

Online registration is over