Excel level 3 - Advanced
Microsoft Office - Microsoft Excel
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 one-day course running from 9:30 am - 4:30 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
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.
Setting up a scenario; switching between scenarios.
Creating comments and defining valid cell entries.
Creating and saving a template.
Setting and using conditional formatting.
Creating and running macros; assigning macros to
buttons, keystrokes, menus and toolbars.
Using hyperlinks to move to specific cell references
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
This course covers material from the Advanced European Computer Driving Licence and the Microsoft Office Specialist Expert Excel syllabus.
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.