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 All one day IT courses are bespoke and not qualification-based. Training formats available: - 1 day instructor-led at the College - On-site at your company office UK wide - Bespoke one-to-one basis - Tailored training courses to your requirements The course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features; to be able create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a ...more on College website
Name: Intermediate Microsoft Excel Qualification title: - Qualification type: Assessment Awarding - Created 20150904 12:28:48 Updated 20150904 12:28:48
Pen and paper. Equipment required Pen and paper.
Eastleigh College
Further Education
experts@eastleigh.ac.uk
023 8091 1000
https://www.eastleigh.ac.uk/
Chestnut Avenue Town: Eastleigh County:Hampshire