No Upcoming Events
No upcoming Scheduled Courses. Contact us for information on booking a private course or join the waiting list for a public event.
Contact Us
Learn all about the advanced functionality Microsoft Excel has to offer...
Descriptions
Who is this course for
Anyone that manages, stores or looks at data as part of their role.
Purpose of the course
This course will continue your journey with Excel and give you the skills to use advanced functions and features.
You will learn how to
Create pivot tables and graphsUse Excel functions and formulae for mathematical processes and automation
Program Excel using Visual Basic
Benefits for you as an individual
An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.
Benefits for your organisation
This course will enable delegates to format and present data in easier to understand ways, as well as improving their efficiency through the use of advanced Excel Macros and shortcuts.
Prerequisites
Delegates are expected to have attended Microsoft Excel Fundamentals or to have equivalent knowledge.Advanced Data Management
- Automatic grouping, outlining and subtotalling
- Scenario Manager
- Data analysis tools
- One and two data input tables
- Goal Seek
- Solver
Pivot Tables
- Creation and formatting of Pivot Tables
- External Data
- Slicers
- PowerPivot
Pivot Charts
- Creation and formatting of Pivot Charts
- Advanced Tasks
- Scenarios
Advanced Excel Tasks
- Advanced functions
- Vlookup
- Hlookup
- Logical functions
- Pivot consolidated data
Excel Programming
- Macros
- Keyboard Shortcuts
- Visual Basic
Get Started
Forget trawling through endless course catalogues – Find the training that’s right for you
Learn MoreLatest News from Quanta
Service Management State of Play: All talks available to watch now.
Following the recent Service Management State of Play event in collaboration with PeopleCert, we are pleased to share the presentations…
Read More
Quanta Achieves FTG Gold Partner Status
We’re thrilled to share that Quanta Training has been awarded FTG Gold Partner status at this year’s FTG (Forces Transition…
Read More
ITIL Version 5: Bringing Clarity, Confidence & Connection to the Digital Age
With the launch of ITIL Version 5, Quanta’s head of portfolio for IT Service Management and ITIL Master, Adam White-Bower…
Read More