Excel Advanced Part 2
Training
Inhouse
Description
-
Type
Training
-
Methodology
Inhouse
-
Duration
1 Day
To give users an extended knowledge of Excels advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases. Suitable for: This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time.
About this course
Participants on this course should have good knowledge of Excel, gained from prior attendance on an Excel Advanced course or from a user environment
Reviews
Course programme
Excel / Expert/Advanced part 2
Objective: To give users an extended knowledge of Excel’s advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.
Delegates: Maximum 8
This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time. Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Advanced” course or from a user environment. Delegate numbers are restricted to 8, to ensure personal attention from the trainer.
Structure: PC for every delegate All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.
Duration: 1 day 9.30 am – 4.30 pm
Course Outline:
Excel Expert
· Review Exercise
Auditing a Worksheet
· Using Worksheet Auditing Tools
· Data Entry Validation
· Validating the Whole Worksheet
· Auditing Data Dependency
· Finding and Replacing Data
Working with Data Lists
· Setting Up Lists
· Sorting Lists
· Filtering Lists
· Using Forms
Data Management
· Searching for Data with Advanced Filters
· Compiling Consolidations
· Summarising Data with Outlines
· Querying a Database
· Data Sources
· Controlling Formatting and Layout
· Refreshing External Data
PivotTables
· Creating a PivotTable
· Modifying a PivotTable
· Creating a PivotTable Chart
· Creating Interactive PivotTables for the Web
Using Analysis Tools
· Goal Seeking
· Using Solver
· The Scenario Manager
· Scenario Summaries
· Merging Scenarios
Collaborating with Workgroups
· Applying Worksheet Protection
· Password Protecting a File
· Changing Workbook Properties
· Adding Comments to the Worksheet
· Shared Workbooks
· Tracking Changes
· Resolving Conflicts
· Merging Workbooks
· E-mailing Workbooks for Review
Fee £220+ VAT
Additional information
Payment options: All Courses can be held privately at our premises or otherwise.
Students per class: 8
Excel Advanced Part 2