The Microsoft Excel advance course of the Mitiget Learning Academy (MLA) is aimed at users who have been using Excel for a while and either in training or through self-development have a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data.
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables, collaborating on worksheets with others and importing and exporting data.
This course is instructor led, and involves lots of examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience, our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks. We train on version 2013 which is almost identical to 2007, 2010 and 2016, please make the trainers aware on the day if you use a another version and they can point out anything that may be slightly different.
Once you have completed this you will be ready to go on to our Excel Advanced Plus course comprising Excel VBA and financial modelling.
Mitiget Learning Academy (MLA) delivery platform includes your study material, iLab (virtual labs) and totally hands-on instructor-led course which will bring out the best in you.
It is recommended that students have experience with the fundamental use and features of Microsoft Excel including the ability to:
If you have not attended our Essential or Intermediate training courses we do send out an exercise once you have booked this course.
This is just to double-check that you are familiar with all the s covered previously.
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. We also know how difficult it is to find quality instruction that is:
That’s why we developed our Advanced Excel course. This course will transform your Excel skills with none of the usual frustration.
Module 1: Creating Macros
Module 2: Collaborating With Others
Module 3 – Creating Pivot
Module 4: Array functions
Module 5: Advanced Lookup and Ref Functions
Module 6: Analyzing Data
Module 7: Data Validation
Module 8: Import and Export Data
Duration of Course: 4 days
Course Dates: Call to book your seat today
Course Fee: N100,000
Location: Lagos, Nigeria
Contact us today to book your course through: email@example.com, +234 909 552 2003, +2348067191062
We are open for orders. Purchase your professional tool-kits and resources today. Click here Dismiss