Advance Excel: Tips and Techniques for Management Decision Making

Course Objectives

  • Use hidden short-cuts to dramatically reduce the time you spend on spreadsheets.
  • Format your worksheet quickly and accurately
  • Get practical solutions to your business problems through superior spreedsheet design
  • Upgrade your spreadsheet skills with advanced data management techniques
  • Consolidate worksheets from different sources into one workbook
  • Develop efficient techniques for using pivot tables and charts
  • Adopt logical methods of solving complex problems
  • Sharpen your ability to accurately forecast outcomes from various scenarios

Target Audience

This workshop is intended for functional managers, administrators, business professionals and executives who have a working knowledge of Excel and demand a higher than average use of spreadsheets.

Methodology

With a computer for each participant this Excel course format employs hands-on problem solving exercises to reinforce newly acquired skills. Classes are kept small to maximise individual attention. The manual contains the complete training slides and soft copies of all exercises used during the course.

Course Modules

1. USEFUL TIPS, TECHNIQUES AND FEATURES OF EXCEL
2. UNDERSTANDING THE USE OF LOGICAL FUNCTIONS
3. SEARCHING SPECIFIC VALUES USING LOOKUP FUNCTION
4. DECISION MAKING USING FINANCIAL FUNCTIONS
5. ANALYZING DATA USING PIVOT TABLE
6. APPLICATION OF TEXT FUNCTIONS
7. DATE AND TIME FUNCTIONS
8. FORECASTING TECHNIQUES
9. OTHER EXCEL FUNCTIONS

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?