Excel Level 3 - Virtual
Online Courses - Microsoft Office 365 - Virtual
Book Course NowCourse Overview
Become an expert Excel user!
This course is designed to enable the proficient user to gain extended use of the spreadsheet package. The day starts with a brief review of commands covered in the Level 1 and 2 courses, followed by an in-depth look at some of the advanced tools of this package, such as Scenarios, Auditing and the Solver. The course covers conditional formatting, creating templates, data validation and data analysis tools. There will also be a detailed look at creating and using macros to enhance spreadsheet efficiency.
This is a VIRTUAL course.
This is a one-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual and certification.
This course can be run as a company specific option.
Course Content
General Review
General review of existing knowledge and the
commands covered in Levels 1 and 2.
Goal Seek and Solver
Finding values for one or more input cells to optimise
the value of a formula.
Scenario Manager
Setting up a scenario; switching between scenarios.
Auditing
Error checking.
Data Validation
Creating comments and defining valid cell entries.
Templates
Creating and saving a template.
Conditional Formatting
Setting and using conditional formatting.
Macros
Creating and running macros; assigning macros to
buttons, keystrokes, menus and toolbars.
Hyperlinks
Using hyperlinks to move to specific cell references
in spreadsheets.Prerequisites
To gain the maximum benefit from this course, an attendee should have attended our Levels 1 and 2 courses, or have an equivalent understanding of Excel, especially the use of formulae, functions and multiple worksheets.
Delegates will need a PC / laptop with a reliable internet connection and audio and video capability.Qualification
This course covers material from the Advanced European Computer Driving Licence and the Microsoft Office Specialist Expert Excel syllabus.
What Next?
Access
Use the powerful Access database capability to keep and organise all your records. Learn how to create tables of information, design useful forms, query your database and produce professional reports.
- 170.00 +VAT Per Person
- 1 Day Course