Level : Advanced
Edition/Version : Microsoft Excel 2007/2010/2013/2016/2019/Excel for Office 365
(Preferable one version is conducted in training)
Duration : 2 days
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.
By the end of the course, participant 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.
Participant who needs to compile and create a powerful analysis report by using the most effective tips & tricks in Microsoft Excel.
Participant must have Intermediate knowledge & skill in Microsoft Excel.
- Lectures 36
- Quizzes 0
- Duration 2 days
- Skill level All levels
- Students 10
- Certificate No
- Assessments Yes