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 this course, you should be able to:

Work effectively on the computer desktop using icons

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

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 1

Perform quick formatting dealing with numbers, dates and formulas

Create PivotTables with formulas with structure references and Splitting PivotTable into Multiple Worksheets

Create PivotTables with formulas with structure references and Splitting PivotTable into Multiple Worksheets

Use advanced formatting formulae and charts features to enhance a spreadsheet

Use shortcut keys to create Charts and ease the effort of creating charts by using Recommended Charts.

Use built in options such as displaying toolbars palettes to enhance productivity

Uncover the hidden tools and use of Quick Access toolbars and Custom tabs

Work effectively on the computer desktop using icons

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

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 1

Perform quick formatting dealing with numbers, dates and formulas

Create PivotTables with formulas with structure references and Splitting PivotTable into Multiple Worksheets

Create PivotTables with formulas with structure references and Splitting PivotTable into Multiple Worksheets

Use advanced formatting formulae and charts features to enhance a spreadsheet

Use shortcut keys to create Charts and ease the effort of creating charts by using Recommended Charts.

Use built in options such as displaying toolbars palettes to enhance productivity

Uncover the hidden tools and use of Quick Access toolbars and Custom tabs

Course Outline

You will be learning the following:

  • Navigational Techniques
  • Zooming In and Out Quickly
  • Copying and Moving Worksheets
  • Custom Views
  • Print Setups
  • Inserting a Watermark
  • 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
  • Creating Table using Shortcuts
  • Creating Formulas using Structured References
  • Working with Recommended PivotTables
  • Splitting PivotTable into Multiple Worksheets
  • Extracting Records from PivotTable
  • Activate Hidden Commands to Quick Access Toolbar or Custom Tabs 
  • Using the Hidden Tools
  • 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
  • AutoSum Magic
  • Managing Range Names
  • Applying Formulas Based Data Validation
  • Linking Text Boxes to Cell Contents
  • Working with Recommended Charts
  • Setting Default Chart
  • Creating Mini Charts using Sparklines
  • Linking Titles and Labels with Cell Contents
  • Dealing with Missing Data

Course Fees And Grants

S$351.00 per participant (Incl. 8% GST)

 

Click here for UTAP Fundings

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueJun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23
Microsoft Excel: 99 Pro Hacks and TipsASKTH8JTC Summit21--13--20
ASKTH8Mountbatten Square--18--22-

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$351.00 per participant (Incl. 8% GST)

 

Click here for UTAP Fundings

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

ASK Training