Udemy

Learn excel by building dashboards and calculators

Enroll Now
  • 183 Students
  • Updated 9/2018
  • Certificate Available
4.5
(16 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 36 Minute(s)
Language
English
Taught by
Excel University
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.5
(16 Ratings)

Course Overview

Learn excel by building dashboards and calculators

Build complex dashboards and calculators using basic Excel functions, tools, slicers and pivot tables

This course teaches you to create well-designed Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.

This Excel Dashboard course comes with templates, tools and checklists that can be applied directly to your Excel reports.

  • Excel dashboard & Report templates

  • Excel calculators and exercises

  • Excel workbook to follow along

What differentiates this course from the other dashboard courses? It includes:

  1. The entire process from idea to delivery - every single step without skipping key points.

  2. Tried-and-trusted techniques that are not only applicable to Excel dashboards but any Excel report.

  3. Includes Excel templates, tools and checklists that you can use for your own Excel reports.

  4. Lots of ideas and inspiration to help you come up with own report design

The course is designed to have an even balance between theory and practical.

Content is clearly organised so more advanced learners can jump in at any point and follow along with the relevant project file.

Course Content

  • 12 section(s)
  • 68 lecture(s)
  • Section 1 Introduction
  • Section 2 Shortcuts & Naviation
  • Section 3 Fundamental functions for building dashboards
  • Section 4 Function Exercises
  • Section 5 Building Calculators
  • Section 6 Visual Tools
  • Section 7 Developer Tool exercises
  • Section 8 Creating Dynamic Charts
  • Section 9 Creating your Dynamic Dashboard
  • Section 10 Pivot Tables, Tables & Slicers dashboards
  • Section 11 Pivot and Slicer dashboard
  • Section 12 Final word and review

What You’ll Learn

  • Understand and apply the basic functions associated with dashboards and calculators.
  • Understand and apply the variety of tools in Excel in conjunction with the various functions
  • Building dashboards by using Pivot tables and slicers

Skills covered in this course


Reviews

  • D
    Dolores Skowronski
    5.0

    So far, in less than 10 minutes, I'm learning a lot of hot keys I will actually use in my current role at work!

  • T
    Thys Maree
    5.0

    Excellent Course, Great to Learn fundamentals of Excel!!

  • S
    Siti Suriani Shih Othman
    5.0

    Good

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed