phone  +234 806 719 1062      mailinfo@mitiget.com

Microsoft Excel – Advanced Training

Microsoft Excel – Advanced Training

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.


Need Training?

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.

Learn more about training options


Who Should Do the training Course?
  • This course is aimed at end users who want to develop their skills so they can use advanced techniques to manipulate Excel data.
  • Delegates should have attended an Excel Intermediate course or have equivalent knowledge.
Course Prerequisites
  • It is recommended that students have experience with the fundamental use and features of Microsoft Excel including the ability to:

    • Create formulae and basic functions
    • Use Absolute Cell references
    • Edit data using formatting and layout techniques including Charting
    • Work with database tools, including database filtering and functions

    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.

Course Benefits
  • Advanced Excel Skills with exposure to data manipulation tools and techniques.
  • Study guides and tons of e-materials in a USB stick. Exam preparation materials (e-copies).
  • Certificate of attendance.
  • Lunch and Tea Break Refreshments
Course Objectives

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:

  • Easy to follow
  • Gets you the results you want
  • Teaches you advanced methods that you can quickly put into practice

That’s why we developed our  Advanced Excel course. This course will transform your Excel skills  with none of the usual frustration.

Course Content

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: info@mitiget.com, +234 909 552 2003, +2348067191062


Return to Training Options


 

We are open for orders. Purchase your professional tool-kits and resources today. Click here Dismiss