Microsoft Excel (Intermediate)

This Microsoft Excel intermediate course is a powerful tool you can use to create and format spreadsheets and analyze and share information to make more informed decisions. This class will take students beyond the basics and help them to more fully utilize Excel in the work environment.

Excel Intermediate Course Outline:

• Working with Worksheets
  • Viewing, Renaming, and Color-coding Worksheets
  • Editing a Group
  • Manipulating Worksheets
  • Creating Linked Formulas
  • Using 3-D References
• Working with Functions
  • Using Absolute Cell References
  • Creating and Using Absolute Named Ranges
  • Creating a Relative Named Range
  • Using Custom Zoom
  • Using Functions
  • Working with Insert Function
  • Using Financial Functions
  • Using Date Functions
  • Working with Auditing and Error Checking Tools
• Working with Charts
  • Creating Charts
  • Changing the Chart Location and Size
  • Changing the Chart Type
  • Modifying Chart Elements
  • Adding and Removing Data Series
  • Applying a Chart Filter
  • Printing Charts
  • Creating and Using a Chart Template
• Using Table Features
  • Creating, Sorting, Filtering a Table
  • Working with the Total Row
  • Creating a Calculated Column
  • Formatting a Table
• Working with Formatting and Data Validation
  • Applying Conditional Formatting
  • Using Data Validation
  • Creating and Using Custom Formats
• Using Protection and Shared Workbook Features
  • Protecting Workbooks and Worksheets
  • Allowing Users to Edit Ranges
  • Working with Shared Workbooks
  • Configuring a Workbook for Shared Use
  • Highlighting Tracked Changes
• Using Styles and Templates
  • Working with Cell Styles
  • Merging Styles
  • Using Templates
  • Creating Templates