Learn Excel by Building Dashboards and Calculators

0

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!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM1,600/DAY

RRP RM2,285/DAY   SAVE RM685

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

Courses you may like

MEMBERS ONLY FEATURE

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

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

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?