The Intermediate Excel© course builds on the skills learned in Intro to Excel©. Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet! Some functions that will be taught are working with logical formulas, tracking changes, Goal Seek, grouping spreadsheets, working with large spreadsheets and much more. More "fun" functions of Excel© will be learned in the Advanced Excel© course.
Course Outline:
-
Various methods of selecting cells
-
Creating range names
-
Absolute reference
-
Working with logical formulas
-
Conditional formatting
-
Inserting comments
-
Track changes – the snitch report!
-
Working & printing large spreadsheets
-
Using data sort & filters
-
Creating an outline
-
Goal seek
-
Creating scenarios
-
Macros
-
Creating subtotals
-
Grouping spreadsheets
-
Advanced linking of Spreadsheets
Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
