Excel Intermediate

Course Syllabus

Working with Large Worksheets Viewing options Hiding and displaying data Printing large worksheets Working with Multiple Worksheets and Workbooks Using multiple worksheets Linking worksheets by using 3-D formulas Consolidating data Linking workbooks Managing workbooks Customising Excel Changing options Customising toolbars and menus Advanced Charting Chart formatting options Creating combination charts Using graphic elements Advanced Formatting Borders and shading Using special number formats Working with dates Working with styles Other advanced formatting

List Management Working with lists Sorting and filtering lists Advanced filtering Documenting and Auditing Comments and text boxes Auditing features Protection Workgroup collaboration Using Templates Built-in templates Creating and managing templates