Microsoft Excel Advanced - Level 1

Microsoft Excel Advanced - Level 1

Macros, Formulas and Functions, Data Validation, Protection, Templates
 
One Day Course Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Excel.
In particular, delegates will learn how to customise Excel using data validation, protection and templates, how to automate their spreadsheets with macros.
Assumed Knowledge:
Delegates must have a good working knowledge of Excel.  They must be regular users who are able to create, edit, format and print Excel spreadsheets.  They must be able to use basic calculations and functions.  It is an advantage to have attended our Excel Introduction and Intermediate courses.
 
Course Outline:          
Course Introduction and Revision
·         Basic formulae and functions
·         AutoFill options
·         Absolute / relative / mixed referencing
·         Basic and nested if functions
·         Round function
·         Column & row / text / number formats
·         Custom number formats
Dates and Times
·         Calculations
·         Formats
Data Validation and Protection
·         Data validation
·         Protecting ranges & files
Templates
·         Creating a template
·         Editing templates
·         Changing the default template
 
 
Working with Ranges
·         Creating range names
·         Navigating with range names
·         Selecting using range names
·         Calculating with range names
Toolbars
·         Displaying & hiding toolbars
·         Moving & sizing toolbars
·         Docking toolbars
·         Adding & removing tools
·         Creating custom toolbars
·         Toolbar configuration files
Macros
·         Storing macros
·         Recording a macro
·         Running a macro
·         Absolute & relative recording
·         Assigning macros to:
·         Custom tools, buttons & menus
·         Editing a macro
 
 
Follow on course:
Excel Advanced - Level 2