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

  • 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • Trainer logistic to client`s place

COURSE BENEFITS

  • 1 or 20 pax, same price
  • Confirmed-to-run even for 1 pax
  • Cheapest available (*we will price match!)
  • Money-Back-Guaranteed Quality
  • HRDF Certified & Claimable

ALL IN FROM ONLY

RM1,600/DAY

RRP RM2,285/DAY   SAVE RM685

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

What Other People Bought

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

Address

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?