What is it about?

This course equips you with skills to create dynamic Excel reports that can support top management's decision making process.

We'll not use formulas in this mini-dashboard course, rather we shall utilize the feature-rich pivots to create clean dashboards that displays content professionally for a board meeting presentation.

What is Included?

  • 11 videos

    Very elaborate, HD videos meant to give you a great experience. Can watch on mobile, laptob, tablet -anywhere. Pause and resume any time

  • 2.5 hours

    Close to 3 hours of valuable lessons. You'll however need more time to complete as you do the practicals

  • 11+ downloadable resources

    Access to Excel files used -solved and unsolved, for further practice

  • 12 months access

    Once enrolled, you'll have 365 days, 24/7 access to the lessons. You can revisit a concept at any time

Client speak

Reviews and testimonials

  • Value for time

    Peterson Mwangi Mucheke Mwangi

    This was excellent course to help save on time and resources and create great and presentable reports. keep it up

    This was excellent course to help save on time and resources and create great and presentable reports. keep it up

    Read Less
  • Course plan and delivery

    Vincent Anyanje

    This course is useful for all people who use data on a daily basis. The examples used relate to virtually everyone and the explanations are well expressed. I...

    Read More

    This course is useful for all people who use data on a daily basis. The examples used relate to virtually everyone and the explanations are well expressed. I highly recommend anyone who wishes to leverage on Excel for data analysis to undertake this course.

    Read Less
  • Pivot tables

    CPA Henry Kihika

    Excellent and well presented

    Excellent and well presented

    Read Less
  • Very well taught

    Charles Onsongo

    This has been a very well taught course. I have learnt new things. William explains difficult concepts effortlessly. I need to rope in someone.

    This has been a very well taught course. I have learnt new things. William explains difficult concepts effortlessly. I need to rope in someone.

    Read Less

Course curriculum

  • 1
    Welcome Note & Files
    • Welcome -read this first!
    • Downloadable Files
  • 2
    PivotTables Fundamentals
    • Pivot Tables 101
    • Pivot Tables Core Concepts
  • 3
    Advanced Pivot Table Concepts
    • Show Values As Percent, Running Totals, Growth Rates
    • Pivot Table Slicers
    • Pivot Tables Show Top/Bottom 'x' Items
    • Pivot Tables Grouping a Date Field
    • Pivot Tables Grouping Non-Date Fields for Ageing Analysis
    • Custom Branded Slicers
    • Test your knowledge
    • Pre-Dashboard - Quiz 1
  • 4
    Make Data Come Live with Pivot-Driven Dashboards
    • Pivot Charts and Pivot-Driven Dashboards
  • 5
    Welcome to Power World with Power Pivot & Power Query
    • 11 Introduction to Power Pivot and Power Query
  • 6
    Conclusion
    • Your Feedback

Ready to Get Started?

Don't work for Excel any more! Let Excel work for you. Free your time with these vital skills

Yes, Am In

You Investment

No credit card required. It's tones of value absolutely free

Featured Instructor(s)

  • William K. Wonder

    BI & Analytics Lead

    William K. Wonder

    For the last 8 years, I've equipped thousands of working professionals in various local and multinational organizations in Kenya among them PwC, Unilever, NIC Bank, Toyota Kenya, World Vision, Gulf Energy, Tullow Oil, etc. with Advanced Excel and Dashboard reporting in Excel and Power BI. This has given me an insider view of the reporting challenges at the work place and all the courses I teach are geared to address such scenarios. I want you to feel in charge of your reporting process. I want you to leave office early! Yes, I look forward for your success story!

FAQs

Clear any doubts that you may have

  • Will I have access to the Excel files used?

    Yes, in fact you can download them upfront and keep them for future reference

  • How much is this course?

    It's absolutely free

  • How long does it take to complete?

    The course has 11 videos amounting to about 2.5 hours. If you put in the effort, I will expect you to finalize the classes in approximately 4 hours