How to build automated dashboards course

Learn all the basics about building and automating dashboards from scratch in 1 hour.

Course curriculum

Best practice for creating data sets in Excel
Understanding your data
Super charge your productivity with Pivot-Table automated reports
Module 4: Planning and designing your dashboard
Creating charts and other visuals for your dashboard
Spice up your dashboards with Slicers and Timelines
Launching your dashboard

Haneef Abbas is the Chief Executive Officer of Leonine Investment Services Limited (“Leonine”). He is a finance professional with over 12 years 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 Chartered Financial Analyst, a member of the Association of Chartered Accoutant UK.

Haneef was the Head Corporate Finance and business reporting at Asset and Resource Management Holding Company. He is also an alumnus of PwC, Access Bank Plc, and FSDH Merchant Bank Limited.

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.

★★★★★ 5/5

Amazing Course

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%.

Temitope Adeyemo

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

Course Duration

60 minutes

Course Price

$20 / ₦10,250

Course Level

Beginner

Course 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

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.

Caroline Enwesi

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

Oyinkansola Afunku

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!

Habeeb Ola

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.

Adeola Popoola

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, a professional who works with a lot of data 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. Although you will need more time to practice after the course.

Is this Course Free?

The course is paid. 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. You can ask your questions via the course forum or by sending an email. We will also organize periodic 1-hour Ask Me Anything (AMA) sessions 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

Share this page!