Course Overview

An Excel Dashboard is an amazing tool when it comes to comparing data points, tracking key business metrics, and getting data-driven insights that can help make decisions.

Dashboards can be created for different aspects of any business. For example, a sales dashboard can help you show your sales performance month-on-month and help you track what product or period is bringing the most sales.

Amazing right?

As a result, modern business owners, finance managers, and professionals who want to be on top of business performance and growth increasingly use dashboards. Employees who also want to stand out at work are also prioritizing this skill.

Are dashboards difficult to build? Maybe not.

Do they take time to build? Yes, they can take some time. In this course, however, you'll learn to build faster.

A common mistake professionals make with dashboards is building all over again when they receive new data. That’s not a good practice at all.

You should never have to build a dashboard more than once. We will show you how to exponentially increase your productivity and save a ton of time by using automation in Excel.

In this course, you'll get more comfortable with data analysis using pivot tables in Microsoft Excel and learn how to build an automated dashboard for your business from scratch without formulas. Yes, you read that right. No formulas. No Macros. Zero technicalities. Just tables.

Who is this course for?

  • Early - Mid level Professionals

    You will learn to present your data in a succinct and captivating form, deliver value at work, and possibly bag that much-deserved promotion.

  • Business Owners

    You will learn to track your sales, expenses, profits/losses in one dashboard, helping you tell the story of your business growth to investors and employees.

The learning objectives

At the end of the course, you’ll be empowered to:

  • Create well-structured data tables

  • Analyze simple datasets using tables and pivot tables

  • Design and build automated dashboards

The course is well-bundled for you

  • 12 Video lessons + Quizzes

  • 10+ Additional course materials

  • Exclusive access to cheat sheets and open house AMAs

Course curriculum

  • 1

    Introduction

    • Welcome - Quick Note about the Course

    • Survey

    • Get introduced to the course and the Instructor

    • Transcript: Introduction Module

    • Case Study File: Sugar Factory

    • Resource: Microsoft Excel Cheatsheet

    • Resource: Excel Shortcut for Macbooks

    • Resource: Excel Shortcut for Windows
  • 2

    Module 1: Best practice for creating data sets in Excel

    • 1a: Best Practice for Data Analytics

    • Transcript: Module 1a

    • 1b: The Golden Rules for Tables

    • Transcript: Module 1b

    • 1c: How to create a Table

    • Transcript: Module 1c

    • Module 1 Quiz
  • 3

    Module 2: Understanding your data

    • How to understand your data

    • Transcript: Module 2

    • Module 2 Quiz
  • 4

    Module 3: Super charge your productivity with Pivot-Table automated reports

    • How to create automated reports

    • Transcript: Module 3

    • Module 3 Quiz
  • 5

    Module 4: Planning and designing your dashboard

    • Spice up your reports with slicers

    • Transcript: Module 4

    • Module 4 Quiz
  • 6

    Module 5: Creating charts and other visuals for your dashboard

    • How to plan and design your dashboard

    • Transcript: Module 5

    • Module 5 Quiz
  • 7

    Module 6: Spice up your dashboards with Slicers and Timelines

    • How to create and format charts: Trend Chart

    • Transcript: Module 6a

    • How to create and format charts: Doughnut Chart

    • Transcript: Module 6b

    • Module 6 Quiz
  • 8

    Module 7: Launching your dashboard

    • Build and launch your dashboard

    • Transcript: Module 7
  • 9

    Conclusion

    • Closing

    • Transcript: Module 8

    • Completed Case Study: Sugar Factory

    • Feedback + Certificate

Learn from the best

Senior Instructor

Haneef Abbas

Haneef Abbas is a thorough-bred finance professional with over 10 years of experience in corporate finance, financial analysis, business intelligence, data analytics, and financial modeling. He has trained over 750 professionals in finance and analytics across the globe. He is a Charter holder and a member of the Association of Chartered Accountant UK, and the Financial Market Association. Haneef is an alumnus of reputable African corporates like PriceWaterhouseCoopers (PwC), Access Bank Plc, Asset and Resource Management (ARM), and FSDH Group. He has advised clients in deals worth over $20 billion and built business intelligence solutions for businesses locally and internationally.

500+ students globally find our courses valuable

How to build automated dashboards in excel Course

Caroline Enwesi

This is my second training with Leonine Learning and it is just as fantastic and value-adding as expected/usual. This time, though it was not a Live video, I thought I would get less value but it turned out to be extremely worth the while. The instructors are calm and confident and you can tell by the ease with which they instruct and advise. The course contents are well organized and the end of module quizzes are a really great add-on. I think the most thoughtful for me was the addition of transcripts just in case one needs it. Thanks Leonine! I will definitely be back again and Oh! I already started spreading the word.

How to build automated dashboards in excel Course

Oyinkansola Afunku

The course delivery was brilliant and the course content was clear and to the point. I also appreciated the consideration for Mac users.

How to build automated dashboards in excel Course

Adeola Popoola

This course has helped me see that there is more to excel than just rows and columns. The instructor's explanations, short quizzes, and worksheet provided for practice helped me gain better understanding of the course. I am proud to say that I can create automated dashboards!. Great job Leonine Learning, and thank you for this amazing learning platform. I'll be on a lookout for more interesting courses like this. Cheers.

How to build automated dashboards in excel Course

Habeeb Ola

An excellent course and delivery that immensely improved my knowledge of creating excel dashboards, using pivot tables, understand excel shortcuts, and the quickest ways to manipulate data. I highly recommend it to anyone looking to improve their skill set in a quick and effective manner!

How to build automated dashboards in excel Course

Temitope Adeyemo

The fact that the course was explained in a very simple and understandable way. Like honestly, this look like the first training i have attended and understood all the concept in a very simplified way without no stress. The audio sound was very audible and every message was deliver succinctly. Many thanks to Leonine learning institute, give you guys 100%.

How to build automated dashboards in excel Course

Olamide Rasheed

I got the link of this course through my brother, I’m super happy because it’s meet my needs as a fresh accounting graduate, I know the basic of excel but I never know how to build an automated dashboard. I want to say a big thank you to the brain behind this course.

How to build automated dashboards in excel Course

Tonka Noel

This course was superb! In particular, I loved the friendly tone of the instructor and that the videos were kept short and progressive. By having a transcript at the end of each lesson, I was able to go through after I had watched the videos and also concentrate on learning instead of forming lesson notes which is a major distractor from learning. Performing the tasks along side the instructor using the same data was also key in aiding understanding. I absolutely loved the course!

How to build automated dashboards in excel Course

Celestine Akidi

I was quite doubtful about spending time on this course. However, at the end of the course I can't wait to refer others as it's quite detailed and yet so easy to follow, simplifying automated dashboard building even for first timers!

How to build automated dashboards in excel Course

Emem-Obong Ema

I love the subtitles that were added to the video tutorial. It made it easy to follow what was said. The use of slicers and timelines as a filter rather than the regular filter option in pivot is amazing!

Our trainees are high performers in blue-chips

FAQ

We have attempted to answer some of your questions here

  • How do I know if this course is right for me?

    If you are a financial analyst or business owner and you want to master the skills to analyze and improve the performance of your business, then this is the right course for you.

  • How long will this course take?

    One hour and you are done.

  • Is this Course Free?

    The course is heavily discounted for early birds. We may also run special offers periodically.

  • Will I get certified?

    Yes, you will receive a certificate of completion after completing the course and the final quiz.

  • Do I need to be an Excel pro before taking this course?

    A prior basic understanding of excel is a plus. However, you do not necessarily require any previous excel knowledge to take this course. The content has been broken down to the simplest bits.

  • What software and versions do I require?

    We advise that you install an Excel 2016 or 2019 if you don’t have it already. Office365 is even perfect. These updated versions will avail you with new features and tools to improve your learning experience.

  • I have completed the course, but I have a few questions. How will I get help?

    We have got you covered. We will organize periodic 2-hour Ask Me Anything (AMA) sessions with to provide answers to all your questions.

  • Can I get a refund?

    We encourage you to review the course details comprehensively before proceeding to make payment. We will consider refund requests on a case-by-case basis. However, If you have completed 50% of the course before requesting a refund, you will be ineligible for a refund.

  • I have completed the course. How can I learn more?

    You can indicate interest in one of more of our physical (on-site) and virtual instructor-led training programs via bit.ly/leonineX

Learn to build automated dashboards in Excel

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds
Enroll me in the course now - Stripe