Intermediate Excel Training Classes in Denver Colorado

Our Intermediate Excel Training class is designed for students with some experience using the software, but who may not use it every day.

Training Class Goal

Students will come from this class with a solid foundation in Microsoft Excel and an ability to use common features to build worksheets with formulas, functions, charts, and other automation tools.

Prerequisites

Experience entering data into Microsoft Excel, familiarity with Windows and basic computer skills.

Intermediate Excel Training Topics

• Formulas & Functions
  • Typing formulas and functions
  • Cell references and reference formulas
  • AutoSum
  • The Functions Library
  • Average, date & time functions
  • If statements
  • Other classes covering Formulas & Functions
• Moving and Copying Data in Excel
  • Cut copy & paste data
  • The Fill Handle
  • Absolute and relative references
  • AutoFill and custom Lists
• Working with Multiple Worksheets
  • Renaming worksheets
  • Color coding tabs
  • Moving and copying worksheets
  • 3D references
  • 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
• Charts
  • Creating and defining a chart
  • Positioning, rotating, & resizing charts
  • WordArt in charts
  • Editing charts in Excel
  • Changing types
  • Formatting a data series
  • Multiple series charts
  • Other classes covering Excel charts