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.
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!
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.