primavera_banner

OVERVIEW

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.

DAYS

COURSE CONTENTS

DAY 1

  • 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

DAY 2

  • 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

DAY 3

  • 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

DAY 4

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

  • Exercises
  • General review and final Test

LEARNING OBJECTIVES

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

WHO SHOULD ATTEND

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

PREREQUISITE

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

MATERIALS

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

 

MODE OF PAYMENT

Training Course Fee: N40,000
with a discounts of 5,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

MODE OF APPLICATION

After payment send teller details, your name and Choice of training location to: info@datapoint.com.ng 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 and Time: 30th October - 3rd November, 2017.

TIME: 9am - 3pm.

Lagos Corporate Office

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


Week Days Training Date and Time: 30th October - 3rd November, 2017.

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 and Time: 30th October - 3rd November, 2017.

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