Microsoft Excel: 99 Pro Hacks and Tips
Course Overview
Microsoft Excel users use only a small percentage of what the application is really capable of. But, hidden within are loads of lesser known productivity hacks for a more efficient work experience with the application.
Discover how to avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel.
Mode of Assessment
No Assessment
Course Duration
1 Day
Total Training Duration (Hour)
8 Hours
Course Outline
Workbooks and Worksheets
- Navigational Techniques
- Zooming In and Out Quickly
- Copying and Moving Worksheets
- Custom Views
- Print Setups
- Inserting a Watermark
Formatting
- Leading Zeros
- Adding Text to Numbers
- Managing Line Break within Cell
- Adding Comments Inside Formulas
- Creating Bulleted List
- Format Painter Tips
- Applying Formulas Based Conditional Formatting
Tables and PivotTables
- Creating Table using Shortcuts
- Creating Formulas using Structured References
- Working with Recommended PivotTables
- Splitting PivotTable into Multiple Worksheets
- Extracting Records from PivotTable
Working with Hidden Tools
- Activate Hidden Commands to Quick Access Toolbar or Custom Tabs
- Using the Hidden Tools
Organizing and Working with Data
- Data Entry Techniques
- Using AutoCorrect
- Entering and Linking Data across Multiple Worksheets
- Selection Methods
- Filling Blank Cells with Value
- Copying and Pasting Options
- Using the Quick Analysis Tool
Numbers, Dates and Formulas
- AutoSum Magic
- Managing Range Names
- Applying Formulas Based Data Validation
- Linking Text Boxes to Cell Contents
Charts
- Working with Recommended Charts
- Setting Default Chart
- Creating Mini Charts using Sparklines
- Linking Titles and Labels with Cell Contents
- Dealing with Missing Data
Certification Obtained and Conferred by
Upon successful completion of the 99 Pro Hacks and Tips course, participants who have attended at least 75% of the course will receive a Certificate of Attendance by @ASK Training.
Course Learning Outcome
At the end of the 1-day course, you will learn to:
- Explore keyboard shortcut methods that help you work more efficiently instead of using a mouse
- Organise and work with data productively by using various data entry techniques, linking and entering data in multiple sheets, and Quick Analysis tools
- Perform quick formatting when dealing with numbers, dates, and formulas
- Create PivotTables with formulas using structured references and split PivotTable into multiple worksheets
- Use shortcut keys to create charts and ease chart creation using Recommended Charts
- Uncover hidden tools and use the Quick Access Toolbar and Custom Tabs
Pre-requisites
To enrol in this course, you should possess the following:
- (≥ 16 years old); or
- 1 year working experience
Regularly use Excel to create, edit & format worksheets. Familiar with features such as conditional formatting, data validating & Pivot Tables.
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $360.00 | $392.40 |
Full Course Fee: $392.40 (inclusive 9% GST)
Please note that prices are subjected to change.