Excel Tips and Tricks (In-House Training)

Excel is an electronic spreadsheet. Almost everybody in any organization works with Excel to accomplish specific tasks. Excel has lots of commands, buttons, functions and formulas. There are also so many short-cuts, tips and tricks.

You will become more productive by learning many of the Tips and Tricks in Excel. You can substantially reduce the time taken to accomplish specific tasks in your daily work.

Brochure

— Course Fee: RM 6,480.00 (Inclusive of 8% Service Tax) —

A working knowledge of Excel Tips and Tricks as Excel is extensively used by all companies in the day to-day operations
Practical tips which can make a major difference on how to work with Excel.
How to list and organize data
How to present data in a clear and concise way to management for easy understanding.
Better how to project planning and making future predictions based on raw data.
How this course can primarily assist in reducing the time taken to complete certain tasks as we all know that short cuts saves times.

• Understand how to use many of the useful short-cut keys to speed data entry and movement in Excel e.g. Ctrl G
• Learn over 50 practical tips and tricks e.g. Format Painter
• Learn to how to combine files using Power Query Tables
• Learn many of the useful Excel Commands and Functions e.g. IF function
• Learn Text Functions and Conditioning Formatting in Excel e.g. =LEN
• Learn about protection. (Cell/Worksheet/
• Workbook)
• Learn when to use Lookup vs Index Match
• How to recover your Excel file in case of power failure
• Learn about conditional formatting
• Changing the settings in Excel Options
• There will be extensive hands-on exercises and data
sets will be provided together with a comprehensive training guide.

Brochure

What Will You Learn?