Course description
Excel Level 3
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.
Upcoming start dates
Suitability - Who should attend?
Pre-Requisites
Before starting this course, it is recommended that you take the Microsoft Office Excel Level 2 course.
Outcome / Qualification etc.
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..
Training Course Content
Introduction & Workshop Objectives
Lesson 1: Streamlining Workflow
- Update Workbook Properties
- Create and Edit a Basic Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
Lesson 2: Collaborating with other Users
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
Lesson 3: Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Lesson 4: Analysing Data
- Create a Trendline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Create a One and Two Variable Table
Lesson 5: Working with Multiple Workbooks
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Lesson 6: Importing and Exporting Data
- Export Excel Data
- Important a Delimited Text File
Why choose GBC Learning & Development
Established in 1994 and still learning!
Trusted by 400 world-wide
Save! Bring a Buddy Half Price
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Expenses
Course Price: £360 + VAT
Request info
GBC Learning & Development – Invest for High Performing People
Practical yet inspiring topics, comprehensive content, and passionate trainers. Tap into the expertise of our trainers who have a wealth of experience in business, coupled with an understanding of how people learn and put their learning into practice in the...