Learn Excel Secrets Today

Knowing how Excel works at a deeper level is the secret to harnessing its power and increasing your productivity. Learn Excel secrets and tips in this FREE course.

This course is an extract of our highly acclaimed Report Automation in Modern Excel Course. It is designed to quickly get you started with the basic formulas and techniques you need to quickly automate a report. You will learn some best practices in using Excel and be on your way to becoming proficient.

Learning Outcomes

This course will teach you a methodology for working with Excel that exposes how the Excel application really works. The course highlights many shortcuts, tips and tricks to make you more productive on the job. By the end of the course participants will be able to:

  • Identify and Recall the new features and shortcuts in the latest versions of Excel.

  • Demonstrate general Excel spreadsheet skills by working with tabs, ribbons, dialogue boxes, Excel options and formats

  • Interpret exactly how the Excel engine works and use this knowledge in proffering solution to case studies.

Some of Our Clients

Agusto & Co.
British American Tobacco

Course Curriculum

Here's what you'll learn...

  • 1

    Welcome to the Course

    • Introduction

    • How to use the Platform

    • Before we begin ...

    • Join our Excel & Power BI Meetup Group for Free

  • 2

    The Reporting Infrastructure

    • The Reporting Infrastructure

    • Lab 01 - How Excel Works

    • Reporting Framework & the 7 Golden Rules of Data

    • The role of the Control & Report Sheets

    • How Excel Works

    • Managing Dates, Validations & Format Styles

    • Ask the Trainer

    • Quiz - Reporting Infrastructure

  • 3

    Report Building Blocks

    • Report Building Blocks

    • Lab 02 - Report Building Blocks

    • Simple Report Template

    • Identify your Report Criteria

    • Automate with SUMIFS

    • SUMIFS & the Date Criteria Hack

    • Ask the Trainer

    • Quiz - Report Building Blocks

  • 4

    Bonus Material

    • Overview of Excel Styles

    • Advanced Formatting in Excel

    • Excel Formatting Syntax

    • 50 Excel Keyboard Shortcuts for Windows

    • 50 Excel Keyboard Shortcuts for Mac

  • 5

    Evaluation & Certificate

    • Instructions

    • More resources for you

    • Evaluate & get Certificate

Other courses for you

  • $1,200.00

    $1,200.00Advanced Financial Modeler Virtual Training (10 sessions, 7 weeks)

    Buy Now
  • $750.00

    $750.00Reporting & Analytics with Power BI Virtual Training (5 Weeks, 6 sessions)

    Buy Now
  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now

What People Have to Say...

“Quality Of The Course Fine, Course Content Great Especially Because David Simplify The Report With Excel ”

Ajayi Abimbola C

“The Course Content Was Deep And Very Applicable To My Daily Work ”

Afolabi Durotaye

“Very Detailed And Encompassed Relevant Aspects Of Excel ”

“It Was Rich,Navigating From The Basic To The Advanced Function ”

Okwuchi Eberendu

Some of our Clients

FAQ

  • How does Virtual Training Work?

    You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.

  • How long is each Virtual Session?

    Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.

  • How long do I have access to the course content and platform?

    You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.

  • Can I defer my Session?

    Deferral requests are treated on a case by case basis. Please email training@dbrownconsulting.net with your request.

  • Are the videos available offline?

    Our videos are only available for streaming online. But you can download all exercise files and materials.

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.