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.

  • Course Dates and Venue

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

    CourseVenueAug-20Sep-20Oct-20Nov-20Dec-20
    Microsoft Excel: 99 Pro Hacks and TipsJTC Summit-14-12-
    Mountbatten Square11-14-03

    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

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

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 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.

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