Excel Intermediate

Course Description

Course Description

excel_tipOur intermediate Excel training courses cover more complex Excel functions, charting, and data tools. Go beyond the basics to learn more formatting, more formulas, and more functionality. The intermediate Excel training starts working with functions such as IF, Proper, Roundup and Date and Time functions. It also looks at how to create formulas across multiple spreadsheets in the same document.

Training Class Goal

In the Intermediate Excel training, we will begin to explore how to utilize more complex functions, including date & time functions and IF statements. We will also look at organizing data, working with multiple worksheets and basic charting. The Intermediate Excel training courses builds on things learned in the basic class. Students learn how to do more with copying and pasting such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.


Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.

Topics Covered

Formulas & Functions

  • Typing formulas and functions
  • Cell references and reference formulas
  • AutoSum
  • The Functions Library
  • Average, date, and time functions
  • IF statements
  • Nested IF Statements
  • Other classes covering Formulas & Functions

    Moving and Copying Data in Excel

  • Cut, copy, and paste data
  • The Fill Handle
  • Absolute and relative references
  • AutoFill and custom Lists

    Working with More Functions

  • Date and Time Functions
  • Calculating dates in years
  • IF Statements in Date Functions
  • The Proper Function
  • The Roundup Function

    Working with Multiple Worksheets

  • Renaming worksheets
  • Color coding tabs
  • Moving and copying worksheets
  • 3D reference formulas
  • Hyperlinks
  • ScreenTips

    Formatting Cells and Appearance

  • Formatting text and numbers in cells
  • Merging cells
  • Wrapping text within a cell
  • Custom number formats
  • Conditional formatting
  • Copying formatting
  • Other classes covering Excel formatting

    Viewing Worksheets

  • Showing formulas and references
  • Tracing precedents and dependents
  • Grouping rows and columns
  • Cell comments
  • Headers and footers
  • Other classes covering Navigation and Views

    Introduction to Basic Charts

  • Creating and defining a chart
  • Positioning, rotating, and resizing charts
  • WordArt in charts
  • Editing charts in Excel
  • Changing types
  • Formatting a data series
  • Multiple series charts
  • Sparkline charts
  • Other classes covering Excel charts

Upcoming Classes

No Events

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.