MS Intermediate Excel

This intensive course is designed for those who have either attended an Excel Introduction course or not been on an official course, but may have been using Excel for a period of time. 

Course Content

  • Review of Basics
  • Relative & Absolute Cell References
  • Using Multiple Sheets
  • Linking Worksheets & Workbooks
  • Create Number formats
  • Moving / Copying Data between
  • Worksheets and Workbooks
  • Naming Ranges
  • Basic IF statements
  • Using Conditional Formatting
  • Using Databases
  • Sorting
  • Autofilter
  • Database Forms
  • Worksheet/Workbook Protection
  • Using and Creating Templates
  • Inserting SmartArt Graphics
  • Creating Charts
  • Review & Close

 

Training Method

Practical course with access to PC's for the duration of the course. Anyone who has attended an Excel Introduction course or has been using Microsoft Excel for some time, however has not been on an official training course.
 

Prerequisites

A working knowledge of Microsoft Excel basics, Windows and file management is assumed.