Intermediate Excel PM Session - January 2024

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.