📞 (330) 691-5780

✉ info@cleardirectiontraining.com

Home/ Courses/ Excel
๐Ÿ“Š Microsoft Excel

Excel

Four instructor-led levels that take your team from confident basics to building automated tools. Live online or on-site โ€” tailored to your own spreadsheets, with follow-up help after class.

๐ŸŽ“ 4 levels
๐Ÿ’ป Online or on-site
๐Ÿ‘ฅ Group rates
๐Ÿ“ž Follow-up included

Choose your level

โฑ 1 day / 6 hrs
๐Ÿ“ˆ Beginner
โœ… No prerequisites

Covers the essential skills for creating and editing spreadsheets, plus entering simple formulas and functions. Anyone new to Excel should start here.

What you'll learn

โœ“ Navigate the Excel interface with confidence
โœ“ Create, edit and save spreadsheets
โœ“ Enter and format data cleanly
โœ“ Write simple formulas and functions
โœ“ Use SUM, AVERAGE and basic math
โœ“ Format cells, rows and columns
โœ“ Print and set up pages properly
โœ“ Manage multiple worksheets
โฑ 1 day / 6 hrs
๐Ÿ“ˆ Intermediate
โœ… Intro or equivalent

Moves into data analysis and report design u2014 for anyone who needs to present, search and analyse data with confidence.

What you'll learn

โœ“ Sort and filter large data sets
โœ“ VLOOKUP and other lookup functions
โœ“ Build and customise pivot tables
โœ“ Create charts that communicate clearly
โœ“ Apply conditional formatting
โœ“ Design clean, readable reports
โฑ 1 day / 6 hrs
๐Ÿ“ˆ Advanced
โœ… Intermediate or equivalent

Helps learners gain full mastery of their spreadsheets with advanced formulas, data handling and basic automation.

What you'll learn

โœ“ Nested IF functions and logic
โœ“ SUMIFS and conditional aggregation
โœ“ Import and export data
โœ“ Connect and clean external data
โœ“ Record basic automation macros
โœ“ Troubleshoot complex formulas
โฑ 2 days / 12 hrs
๐Ÿ“ˆ Expert
โœ… Advanced or equivalent

Introduces advanced automation and customisation using the VBA programming language u2014 for those who need to truly take charge of Excel.

What you'll learn

โœ“ Write and edit VBA code
โœ“ Automate repetitive tasks
โœ“ Build custom functions and macros
โœ“ Work with loops and conditions
โœ“ Create user forms and inputs
โœ“ Debug and error-handle reliably

Who it's for & how it's delivered

๐Ÿ‘ฅ Who should attend

Working professionals who use Excel day-to-day, from administrators to managers and their teams.

  • Individuals upskilling
  • Whole teams getting consistent
  • Anyone moving into a heavier role

๐Ÿ’ป How it’s delivered

Led live by an instructor with 20+ years’ experience โ€” never a recorded screen.

  • Live online or on-site
  • Tailored to your own files
  • Follow-up help after class

Upcoming dates

Jul14
Excel Introduction9:00 AMโ€“4:00 PM ET ยท Live online
Online 6 seats Book
Jul22
Excel Intermediate9:00 AMโ€“4:00 PM ET ยท Live online
Online 2 seats Book
Aug05
Excel Advanced9:00 AMโ€“4:00 PM ET ยท Live online
Online 8 seats Book
Aug19
Excel VBA (2 days)9:00 AMโ€“4:00 PM ET ยท Live online
Online 5 seats Book
๐Ÿ“žGet a free quote