Welcome to the platform for quality computer accounting, management and IT training with worldview content

Previous
Next

Advanced Certification

N80000
N 70,000
  • Manuals, Quality Training, Assessment, Real live Business/Accounting Case Studies, Exams, Certificate
  • Training delivered by Experienced Microsoft Excel Trainers
  • 5week course (Intensive Practical Training)
  • Flexible time, weekdays and weekends training Available
  • Form N2,000
Popular

Advanced Excel Training

Excel is the world’s one of most popular and widely used spreadsheet program. Gaining advanced skills on how to work on excel as an advanced user with Leadway Training shows that you’ve taken one of the best professional Excel training courses available. Excel courses are comprehensive training with up to date material to practice at home and during your class. Advanced Excel courses are offered through classroom and online live. You will also be provided a step by step e-manual of all the tricks you can do using Excel spreadsheets to gain better management reporting, financial planning and budgeting skills. 

Excel spread sheets are the most powerful tool, extensively used for financial reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market if you want to be successful.  

This advanced Microsoft Excel training course will teach you how to use the advanced features of Excel 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.

What are the course objectives? (what trainees can do with Advanced Excel)

At the end of this training trainees will be confident 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 Pivot Tables
  • Construct and operate Pivot Tables using some of the more advanced techniques
  • 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
  • – Run Budget and forecasting
    – Design all-inclusive bookkeeping, ledgers and linking of Financial Accounting reports
    – Design and run comprehensive payroll platform
    – Manage Business Dashboard and Analysis
    – Loan repayment and tracking
    – Calculating IRR of project
    – Inventory Management and analysis
    – Sales And Purchase analysis
    – Graphical presentation of data
    – Imprest system management
    – Financial Analysis
    – Sorting and filtering of business data
    – Production cost analysis
    – Sharing of excel files etc.

Who should do this course?

 

  • Chartered Accountants, Accountants, Auditors
  • Graduates or Undergraduates of Accounting, Economics, Insurance, Management and other related courses or jobs.
  • Civil servants, Business owners, Entrepreneurs,
  • Finance Managers, Cashier, Consultants
  • Corp Members (NYSC), Retail managers
  • Financial Analysts, Statisticians, Project Managers, Project Evaluators
  • Business, Analysts, Sales/Purchase Managers
  • Organizations and businesses that want to upgrade their staff skills organisational and analytical skills.

PREREQUISITE: 
Desire to upgrade one’s skill base/career path to becoming a computer accountant and your laptop. Note, there are also Laptops in the training centre for student’s use.

TO REGISTER, 
Make payment to:
Account Name: Leadway Training And Technology Institute
Current Account No: 0655601884
Bank Name: Guaranty Trust Bank (GTB)

For Details call0706-300-2998
Email us on: info@leadwaytraininghub.com or leadwaytechnology@gmail.comto:

Course Content

The course is organized in modules and each module covers a reasonable content to enable participants connect and progress successively in the next modules.

Module 1: Introduction to Advanced Excel

v  Get a head start with templates and set up an Excel template

v  Create new default workbook and worksheet templates

v  Learn how modular templates can make your spreadsheets more consistent and much quicker to set up

v  Customizing the Excel interface to put the tools that you need at your fingertips.

v  How to build in checks and controls from the outset

v  Key techniques that reduce risk and increase automation and efficiency
v  Documentation and review tools

 Module 2: Data Validation

 v  Extended uses of Data Validation

v  Working with validation formulae
v  Other methods of tracking down invalid entries

 Module 3: Preparing your data for analysis

v  Mastering lookup functions (INDEX, MATCH)
v  Creating helper columns using DATE and TEXT functions
v  Applying NESTED-IF, AND, OR to organize data

Module 4: Methods of Summarizing Data
v  Using SUMIFS and COUNTIFS

v  Advanced uses of PIVOT-TABLE features like Value Field Settings, Grouping Data and Slicers among others

v  Identify Major Customers, Top Products, Top/Bottom Sales reps…LARGE, SMALL, MAX, MIN

v  Advanced Range Names and Formula in Names

v  Calculations and reporting in Power Pivot – an introduction to Data Analysis Expressions (DAX)

Module 5: Report Visualization Techniques in Excel

v  Dynamic charts (using CHOOSE & OFFSET functions) & Sparklines for trends

v  Report Interactivity -Using Pick-Lists, Form Controls like combo box & Excel Camera

v  Effectively using Conditional Formatting (formula-driven) for reporting

v  Exchanging information with VB code

v  Calculations in Power Pivot – an introduction to Data Analysis Expressions (DAX)

Module 6: Decision Making with Excel
v  Applications of Financial functions (Amortization table, FV, NPV, IRR, etc.);
v  Sensitivity (“What-if”) analysis on models using Data Tables, Goal Seek , Scenarios;

v  Laying out a model in Excel (Budget Model case study);

v  Using Excel to help you make decisions

v  Create and manage alternative scenarios

v  Make more profit or incur less expense by using Excel Solver to identify the best solution
v  Use of External Data tools

Other Information

The course is organized in modules and each module covers a reasonable content to enable participants connect and progress successively in the next modules

Venue

Abuja Training Center: Suite 315, Third Floor, Anbeez Plaza, Ndola Crescent, Opp. Old Corporate Affairs Commission, Wuse Zone 5, Abuja.

What does the training Pack contain?

  • Certificate of completion.
  • Training materials (Hard copy)
  • Training Manuals
  • Real life Business simulations/mock exams
  • Students Workbook and Project Templates
  • Real-life application and understanding
  • Certified and Experienced trainers
  • Conducive learning environment 

 Contact or join our live chat  below or call 07063002998, WhatsApp 07063002998

  1. Pay Training fee before training start date or starting of the training
  2. Visit Register and complete the registration form.
  3. Upon confirmation of your registration, an electronic receipt will be sent to your mail.
  4. Commence your training at Leadway Training and Technology Institute venue or use our online classes platform.

features

Company

Subscribe to our Newsletter

2019 © All rights reserved. Design and managed by Leadway Training And Technology Institute

Call Now

WhatsApp chat