Learn Excel by Building Dashboards and Calculators

Course Objectives

  • 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

Target Audience

  • Anyone that uses Excel and want to learn more about dashboards and the relevant tools that assist in creating eye catching dashboards and calculators

Course Modules

MODULE 1 – INTRODUCTION
MODULE 2 – SHORTCUTS & NAVIGATION
MODULE 3 – FUNDAMENTAL FUNCTIONS FOR BUILDING DASHBOARDS
MODULE 4 – Function Exercises
MODULE 5 – Building Calculators
MODULE 6 – VISUAL TOOLS
MODULE 7 – DEVELOPER TOOL EXERCISES
MODULE 8 – CREATING DYNAMIC CHARTS
MODULE 9 – CREATING YOUR DYNAMIC DASHBOARD
MODULE 10 – PIVOT TABLES, TABLES & SLICERS DASHBOARDS
MODULE 11 – PIVOT AND SLICER DASHBOARD

Get To Know The Trainer

Trainer Siti

 4.5

Siti Suriani Shih Othman graduated with a Master of Science in Distributed Computing from Putra University of Malaysia and a Bachelor of Computer Science from Science University of Malaysia.  She is also a Microsoft Certified Application Specialist (MCAS), Microsoft Certified Professional (MCP), GI-NG Up To Speed ILT Trainer, Master Trainer – PPSMI V and Master Trainer – PPSMI VI.

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

No review yet.

Optimized by Optimole

Don’t Scroll Away Just Yet

Please enable JavaScript in your browser to complete this form.

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

[nextend_social_login]

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

[nextend_social_login]

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?