Advanced Excel – level 3 – Online
Become an Excel expert with this Advanced Excel online course! This course is delivered online.
Advanced Excel Training – Online Course Objectives
This hands-on, tutor-led Advanced Excel online training 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 Introduction to Excel – level 1 and Excel Intermediate – level 2 courses, followed by an in-depth look at some of the high-level tools of this package, such as Scenarios, Auditing and Solver. The course covers conditional formatting, creating templates, data validation and data analysis tools. Delegates will learn how to design and edit templates. Delegates will take a detailed look at creating and using simple and complex macros to enhance spreadsheet efficiency.
Advanced Excel – Online Course Contents
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 in spreadsheets.
Advanced Excel – Online Course Details
This is a one-day Advanced Excel training course running from 9:30 am – 4:00 pm.
To gain the maximum benefit from this course, an attendee should have attended our Introduction to Excel – level 1 and Intermediate Excel – level 2 courses, or have an equivalent understanding of Excel, especially the use of formulae, functions and multiple worksheets.
This course is delivered live online. Course delegates will need a reliable internet connection and a PC or laptop with audio and video capability with the relevant software installed for the training. Delegates see, hear and interact with the tutor.
This course covers material from the Advanced International Certificate of Digital Literacy and the Microsoft Office Specialist Expert Excel syllabus.
What Next? Excel VBA
Understand the powerful uses of Visual Basic for Applications. Making use of Excel objects, basic VBA programming, event handling, control structures, and debugging tools.