This advanced Microsoft Excel training course will teach you to use the advanced features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.

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 trainer aware on the day if you use a another version and they can point out anything that may be slightly different.




  • Tables and charts
    - Revision of some basic elements of Excel
    - Conditional formatting
    - Logic and nested functions
    - Charts advanced formatting

  • Organizing data   
    - Advanced table formatting
    - Worksheets management
    - Sort and Filters tools
    - Subtotal


  • Functions (part 1)
    - Mathematical functions
    - Statistical functions
    - Database functions
    - Working with references on different worksheets
  • Analyzing data
    - Analyze data with Pivot tables
    - Create and manage Scenarios and Summaries
    - Define and use cells names
    - Other What-if analysis tools


  • Functions (part 2)
    - Date and time functions
    - Text functions
    - Financial functions
    - Create custom number formats

  • Sharing spreadsheets
    - Lookup and reference functions
    - Data validation
    - Auditing tools
    - Security and protection options


  • Data gathering and automations
    - Importing and linking data
    - Advanced copy and paste options
    - Automation with Macros
    - Reviewing tools

  • Exercises
  • General review and final Test


Participants will gain practical skills to:
  • create and use defined names in a workbook
  • work with logical function in Excel
  • use a variety of data validation techniques
  • use a range of lookup and reference functions
  • create summaries in your spreadsheets using subtotals
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • perform a variety of analytical tasks using PowerPivot
  • use the Data Consolidation feature to combine data from several workbooks into one
  • create and work with scenarios and the Scenario Manager
  • use Solver to solve more complex and intricate problems
  • import data into Excel and export data from Excel
  • create and use a range of controls in a worksheet
  • create recorded macros in Excel
  • import data into Excel and export data from Excel


The Advanced Excel course is appropriate for individuals who are:
  • Responsible for administrative duties such as payroll, stoke taking, accounting and ledger records.


There is no prerequisite for this course. It functions as a stand-alone course.


You will receive a course binder containing copies of presentation slides, case studies, exercises, and suggested solutions.



Training Course Fee: N40,000
with a discounts of N10,000 if paid early (Inclusive of Training Materials and Certificate)
ACCOUNT NAME: Data-Point Microsystems Ltd.
BANK NAME: Diamond Bank Plc.   ACCOUNT NUMBER: 0016570624
OR BANK NAME: First Bank Plc.   ACCOUNT NUMBER: 2014201435


After payment send teller details, your name and Choice of training location to: or text 08039262657. You will receive a confirmation text.

Lagos Training Centre

Apapa Office:
Data-Point Building, 21 Kudaisi Street,
by Warehouse Bus Stop, Off Apapa - Mile 2 Exp Way.

Week Days Training Date: 14th - 18th January, 2019.

TIME: 9am - 3pm.

Lagos Corporate Office

4, Ayanboye Street, Off Faramobi Ajike Street,
Anthony Village, Anthony, Lagos

Week Days Training Date: 14th - 18th January, 2019.

TIME: 9:00 am - 3:00 pm (week days).

Portharcourt Training Centre

133, Ikwere Road, By Kampala B/Stop, Mile II Diobu, Portharcourt, Rivers State.

Week Days Training Date: NOT AVAILABLE FOR NOW.

TIME: 9:00 am - 3:00 pm. (week days).

Abuja Training Centre

Alexis Hotel and Conference Centre, Plot 693 Awolowo Obafemi Way Jabi Distract Abuja.

Hurry now early payment will get discount of N5,000. Free consultation for managing your start up business as a Project Manager. You can also pay at the venue but no discount will be given. Details Call: 08039262657, 08056574122

Our Partners