Overview

This course will teach participants the essential features of these tools that will drastically improve your turnaround time when accomplishing various tasks. You will learn how to utilize MS office tools to enhance your productivity

It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions and techniques that will unlock the 80% of Excel you may not know about.

Course Objectives

A business analytics tools that deliver insights throughout your organization.

  • Build simple yet dynamic templates for “on the job use

  • Employ formulas, functions and data tools to perform simple data analysi

  • Produce a complete reporting solution from scratch in a full Day Case Study Session

Featured Testimonial

“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”

Akinwunmi Bello

“Very well versed on the topic, Was able to gain, sustain the attention and interest of participants. He carried everybody along despite different excel verion used. He was able to Communicate effectively. ”

Osayi Oghenekaro

“The instructor was able to impart Knowledge on how to navigate through excel, effectively Nice way of carrying the class using good example and logics ”

Genevieve Umeh

“An articulate lecturer with good mastery of the subject matter and efficient delivery. Without gainsaying the quality of the course content is superb ”

Andrew U. Nwadiashi

Some of our Clients

Course Curriculum

Here's what you'll learn...

  • 1
  • 2

    1. VLOOKUP, HLOOKUP & MATCH

    • Overview of lookup Functions

    • The VLOOKUP Function

    • The MATCH Function

    • MATCH Function to the rescue of the VLOOKUP function

    • The HLOOKUP Function

    • MATCH Function to the rescue of the HLOOKUP Function

    • Ask the Trainer

  • 3

    2. INDEX, MATCH & OFFSET Functions

    • The INDEX Function

    • MATCH Function double duty to help The INDEX Function

    • The OFFSET Function

    • The OFFSET Function with help from the MATCH Function

    • Ask the Trainer

  • 4

    3. The CHOOSE Function

    • The CHOOSE Function for typical Lookups

    • Ask the Trainer

  • 5

    4. Practice Case Study

    • Practice Assignment

    • Practice Assignment Solution 1 of 2

    • Practice Assignment Solution 2 of 2

    • Ask the Trainer

  • 6

    5. Bonus Material on Lookup Functions

    • The VLOOKUP Function, a cool Feature 1 of 2

    • The VLOOKUP Function, a cool Feature 2 of 2

    • Master the OFFSET Function - Part 1 of 2

    • Master the OFFSET Function - Part 2 of 2

    • Ask the Trainer

    • How to Attach your Certificates to your LinkedIn Profile

Instructor

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.