About This Course
This is a customized course which covers most commonly used tips and tricks to the corporate users to use the power of Microsoft Excel's powerful time-saving features.
Learning Objectives
By the end of the course, learner will be able to:
- use Paste Special in special formatting and calculation
- select cells of a specified type by using Go To Special
- convert to the correct date/time format
- create custom fiscal year
- create shortcut wordings in AutoCorrect
- create auto calculation in AutoFilter
- calculate cell colors
- create custom formula in Data Validation
- create custom formula in Conditional Formatting
Prerequisites
Learners must have Intermediate knowledge & skill in Microsoft Excel
Target Audience
Learners who need to compile and create a powerful analysis report by using the most effective tips & tricks in Microsoft Excel.
Training Outline
- Working with Paste Special
- Working with Go To Special
- Working with Date & Time
- Working with AutoCorrect
- Calculating Cell Colors
- Custom Formula in Data Validation
- Custom Formula in Conditional Formatting
- Working with Text to Columns
- Other Useful Tips & Tricks in Excel