Display & Accessibility Options
Excel 2010 Advanced Level 1
Microsoft Office 2010
 Next available Norwich date: 14 March 2012   |
Macros, Formulas and Functions, Data Validation, Protection, Templates
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.
Version:
Microsoft Office 2010
What people say:
Overall the course was enjoyable and educational. Charlie was extremely good at explaining the material.
Bullen developments Limited - Oct 2011
Special Offer
Book one person onto any two levels of Excel training and receive £30 off the total price.
Profile 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
Functions
- Nested functions
- Logic functions
- Error trapping functions
- Auditing Features
- Precedents and Dependants
- Tracing Errors and Invalid Data
Dates and Times
- Calculations
- Formats
- Data validation
- Circling invalid data
- Protecting cells, ranges and files
Templates
- Creating a template
- Editing templates
- Changing the default template
Working with Ranges
- Creating range names
- Workbook and worksheet scopes
- Navigating with range names
- Selecting using range names
- Calculating with range names
Quick Access Toolbar
- Changing position
- Adding and removing commands
- Customising for a workbook
Macros
- Storing macros
- Recording a macro
- Running a macro
- Absolute & relative recording
- Assigning macros to:
- Quick access toolbar
- Spreadsheet buttons and keyboard shortcuts - Editing a macro
Profile Details:
-
Price: £165.00 
Duration: 1 day
Print Page
Norwich Dates:
-
14 March 2012
-
19 April 2012
Links:
People who attended this course, also booked:
Information & print:
