Excel Intermediate

Microsoft Excel –Intermediate Course Overview
(Versions 2000, XP, 2003, 2007)

The Excel Intermediate course will allow you to develop existing Excel skills and help better manage your spreadsheets. The course focuses more on working with larger sets of data for analysis, sorting, printing options, linking multiple spreadsheets, and other useful functions. The course is suitable for users who have had experience in creating their own spreadsheets, worked with formulas or have attended the Excel Introduction course.

By the end of the course you will be able to : Effectively manage multiple worksheets and workbooks Adjust Excel to suit your own requirements Format your spreadsheet and charts more effectively
Working with Multiple Worksheets and Workbooks	Using multiple worksheets Linking worksheets and workbooks 3-D formulas Consolidating data
Printing and Viewing options	Working with Outline view Hiding rows and columns Freeze pane Printing row and column headings Page break preview
Advanced Formatting	Create and use special number formats Conditional Formatting Using styles
Text and Date Functions	NOW function Upper, Lower and Proper functions Concatenate
Advanced Charts	Modifying charts Printing charts Chart Formatting
List Management	Working with lists Sorting and filtering lists Creating custom sorts and lists Advanced filtering
Customising Excel	Creating menu bars Creating and editing toolbars Customising the view of Excel
Documenting and Auditing	Comments Auditing features Password Protection
Working with Logical Functions	Using the IF statement Using the AND function Using the OR function

Excel Introduction, Excel Advanced

Back to Courses