​

Microsoft Excel: 99 Pro Hacks and Tips New

Course Code: ASKHT8

Microsoft Excel: 99 Pro Hacks and Tips

Microsoft Excel: 99 Pro Hacks and Tips

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.

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 Dates and Venue

    Course Duration: 2 day (16 hours): 9:00am – 5:00pm

    CourseVenueOct-20Nov-20Dec-20Jan-21Feb-21Mar-21
    Microsoft Excel: 99 Pro Hacks and TipsJTC Summit-12-13--
    Mountbatten Square14-03-04-

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3

  • Workbooks and Worksheets

    • Navigational Techniques
    • Zooming In and Out Quickly
    • Copying and Moving Worksheets
    • Custom Views
    • Print Setups
    • Inserting a Watermark

    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

    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

    Numbers, Dates and Formulas

    • AutoSum Magic
    • Managing Range Names
    • Applying Formulas Based Data Validation
    • Linking Text Boxes to Cell Contents

    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

    Charts

    • Working with Recommended Charts
    • Setting Default Chart
    • Creating Mini Charts using Sparklines
    • Linking Titles and Labels with Cell Contents
    • Dealing with Missing Data

    Working with Hidden Tools

    • Activate Hidden Commands to Quick Access Toolbar or Custom Tabs
    • Using the Hidden Tools

  • Anyone from a novice to an expert Excel user, from managerial to operational personnel

Download Course PDF

Fees and Grants

$299.60 per participant (Inc. GST)

Click here for UTAP Fundings

Registration

Click here to download registration form.

For Organisations on HRMS Learning Hub & ACE (NEA Only), you are strongly encouraged to use this platform for registration.

Apply Online

Apply Online

Microsoft Excel: 99 Pro Hacks and Tips (ASKHT8)

All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name*

Company UEN*

Company Address*

Postal Code*

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

How did you get to hear about us?*

D. Participants

Participant 1

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.

Share this course

en English
zh-CN Chinese (Simplified)en Englishms Malay