Functions are the backbone of most worksheets. But there are around 500 worksheet functions in Excel! Our course covers the most important Excel functions. The ones you will actually use time and time again…
Microsoft Excel Advanced Course
Excel Advanced Course
Excel is a vital tool for boosting your efficiency and productivity when you’re dealing with large amounts of data and calculations. When you understand Excel at a more advanced level, you’ll have the ability to use its more sophisticated tools to streamline your workflow. Our Excel Advanced course is a journey through the key topics for Excel power users and majors on Macros and Pivot Tables.
All our courses are available online with Zoom or Teams. You are welcome to attend our training centre or we can come to you. Call 020 7920 9500 today for further details.
Macros
Create macros to automate your day-to-day Excel work. Save hours of your precious time otherwise wasted on repetitive tasks. Excel has its own command language, VBA (Visual Basic for Applications) We can use VBA to give instructions to get things done.
Specify a series of commands and instructions that you link together to perform tasks automatically. This is a great help with tasks such as saving and copying files from other sources and aggregating data. Get the Excel robot to work for you!
Pivot Tables
You can analyse massive amounts of data with Pivot Tables. On our Excel Advanced course we will examine some of the advanced Pivot Table features. See how to link different tables together with relationships and weave your magic with multi-table reports.
We can use Grouping to aggregate data and visual Slicers to filter our data by different views. Then we shall produce various metrics with Summarize By calculations and use Power Pivot to calculate measures using DAX formulas. We’ll round up the show by doing some serious data crunching with Power Query.
Stand Out. Get Certified!
In addition to our standard courses we also offer certified courses for those taking their MOS exams. MOS (Microsoft Office Specialist) certification is a world-wide recognised qualification that validates your proficiency in using software applications.
The MOS certified course is a 2-day event held at your office, hosted by a MOS certified trainer. You can take the exam online at your office if you wish. Or arrange the exam for whenever it works for you.
Related Posts
The aim of BI (business intelligence) is to make sense of the vast amounts of data that organisations hold. Our Power BI courses help you analyse and visualise your data and thus guide effective business decision making…
Pivot Tables are one of Excel’s most powerful features. And one of the easiest to learn! You can summarise and analyse huge amounts of data easily and rapidly. Produce calculations, slicers, dynamic reports and a whole lot more…
Get the best from Excel, it’s one of the most used office applications. But, at the same time, it’s one of the most under-used. Come along on our Excel Intermediate course and open the door to what Excel can do for you…
There’s been quite a few changes to Excel in recent years and they’re easily missed. Our New Functions course covers functions like XLOOKUP, FILTER and many more. Number crunchers should check out our Power Query course…