Excel Level 3
Duration
One Day
Suitable for
This course is for anyone who wants to gain the skills necessary to create a basic macro, collaborate with others, audit and analyse worksheet data and import and export data.
Objectives
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets and share Excel data with other applications.
Programme
Lesson One – Streamlining Workflow
- Update Workbook Properties
- Create and Edit a Basic Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
Lesson Two – Collaborating with other Users
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
Lesson Three – Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Lesson Four - Analysing Data
- Create a Trendline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Create a One and Two Variable Table
Lesson Five – Working with Multiple Workbooks
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Lesson Six – Importing and Exporting Data
- Export Excel Data
- Import a Delimited Text File
Duration (in days)
1Location | Dates | Price exc. VAT | Status |
---|
Please call us for the next available date for this course. Dates are added regularly and may not appear on this list. Tel: 020 7256 6668