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.

Featured Testimonial

“I've been using Excel for over a decade now and I still managed to pick up 1 or 2 more new nuggets here. Very useful training. Sets up basic principles for developing Excel models and reports in very straightforward and simple bite-size lessons. I'll highly recommend it for anyone that uses Microsoft Excel. No matter your current competence level, you'll learn something.”

Modupe Sanda

“Very articulate in his presentation and has vast experience in the subject matter”

Adeniyi Dotun Christopher

“Exciting and Interesting, class trainers they all did a great job, class was insightful”

Mary Okwusogu

“The trainer was fantastic and he took his time to explain and answer question fully”

Christiana Mobolaji

“The trainer has a perfect knowledge about the subject matter and a perfect presentation skills”

Bodie Nowak, CSAM

“He was engaging and ready to help every student, He was just exceptional”

ivy amaoh

“Passionate explicit and the course was very satisfactory and made sure participants understood what was taught ”

Oluwa toyin Tella Binuyo

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 block-chain protected Certificate

    • How to Attach your Certificates to your LinkedIn Profile

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

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.