Power Excel: Analyzing Data to Make Business Decisions

Course Objectives

  • Leverage features of Microsoft Excel to facilitate business decisions
  • Develop intelligent worksheets to quickly identify KPIs
  • Perform “what-if” analyses for developing budget and project plans
  • Summarize and analyze large amounts of data using PivotTables and Excel features
  • Automate Excel processes

Course Modules

Troubleshooting and Enhancing Professional Workbooks
Analyzing Data with Functions
Summarizing business data with functions
Controlling calculations and nested formulas
Optimizing Workbook Models with “What-If” Analysis
Planning for contingencies
Quantifying variables in a workbook model
Summarizing Business Information
Organizing workbooks and links
Consolidating ranges
Formulating Decisions from Database Information
Distilling data sets for data analysis
Interpreting and refining data with PivotTables
Visualizing and exploring PivotTable reports
Enhancing Excel Usage with Macros
Automating repetitive tasks

Get To Know The Trainer

Trainer Shabenah

 4.5

Shabenah  is  an  experienced  corporate  trainer,  facilitator  and  consultant with  deep  knowledge  in  the field of IT, soft skills, leadership and communication. She has a great passion for training,  learning and development,  and  is  able  to  work  effectively  with  people  of  all  levels.  Shabenah is also an active participant in local community and social activities.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM1,999/DAY

RRP RM2,860/DAY   SAVE RM861

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

No review yet.

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?