MS Intermediate Excel.
Course Aims
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. Entirely
Course Brief
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.
Who is this content for?
Training Method
Practical course with access to PC's for the duration of the course.
