Description

  • Provider: Data-Point Microsystems Ltd
  • Location(s): Lagos
  • Duration: 5 days
  • Fee: ₦40,000
  • Venue: 4, Ayanboye Street, Off Faramobi Ajike Street, Anthony Village, Anthony, Lagos
  • Application Deadline Listing Expired
  • Training Type fulltime
  • Required Experience High School
  • Start Date 17 July, 2017

Training/Course Overview

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.

Training/Course Outline / Requirements

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.

Corporate Office

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


Week Days Training Dates: 17th-21st July 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 Dates: 17th-21st July 2017

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

 

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

Share Sorry this Training Listing has Expired

Related Course/Trainings

Web Design & Development

Web Design & Development

SCILS Management Center Lagos Parttime

₦35,000
Administering Windows Server 2012(20-411)

Administering Windows Server 2012(20-411)

Makintouch Consulting Lagos Fulltime

₦60,000

Latest Jobs in Nigeria Today - Ngcareers

Ngcareers.com is Nigeria's top job search, recruitment and career website. We provide you the latest jobs and vacancies in Nigeria today.

As a job seeker you can search for jobs from latest and verified job adverts and career information from employers and recruiters in all Nigerian states. You can upload/create your resume to improve your visibility.

Our job services are FREE for job seekers. You can subscribe to Ngcareers via: Email, Facebook, Twitter.