Microsoft Excel: 99 Pro Hacks and Tips

Course Description

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.

Course Objectives

At the end of the 1-day course, you will learn to:

  • Explore keyboard shortcuts methods that helps you to work more efficiently instead of using a mouse.
  • Organise and work with data productively by various data entry techniques, linking and entering data in multiple sheets and use of
  • Quick Analysis tools
  • Perform quick formatting dealing with numbers, dates and formulas
  • Create PivotTables with formulas with structure references and Splitting PivotTable into Multiple Worksheets
  • Use shortcut keys to create Charts and ease the effort of creating charts by using Recommended Charts.
  • Uncover the hidden tools and use of Quick Access toolbars and Custom tabs

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

Related Courses

Microsoft Excel: Advanced Formulas and Functions

The course “Microsoft Excel: Advanced Formulas and Functions” delves into advanced techniques such as Lookup functions for data retrieval, Statistical functions for criteria-based reports, Text functions for string extraction, and more, utilizing practical examples to facilitate seamless application of these formulas in real-world contexts.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Advanced Pivot Table Techniques in Microsoft Excel

This course explores the potential of Excel’s PivotTables as a robust analytical tool, teaching how to effectively summarize, sort, count, chart, and navigate data complexity, ultimately enabling the creation of PivotTables from various sources, incorporating calculated fields, result filtering, and formatting for improved readability.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Microsoft Excel: 99 Pro Hacks and Tips

Course Duration:

1 Day (9.00am – 5.00pm)

Course Fee Details:

$392.40 (incl. of 9% GST)

UTAP claimable

This course is not eligible for SDF grant.

Course Schedule

Course NameCourse CodeVenueMarch 2024April 2024May 2024June 2024July 2024August 2024September 2024
Microsoft Excel: 99 Pro Hacks and TipsASKTH8JTC Summit-01-06-07-
ASKTH8Mountbatten Square21-10-10-11

Nett Course Fee
$392.40