MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Microsoft Excel - Level 3 - Advanced

Course Summary

Learn advanced formatting techniques, how to work with Pivot Tables, Charts, record Macros & trace spreadsheet formulae

  • +

    Course Syllabus

    • Advanced Formatting
      • Introduction
      • Orientation of text
      • Merge and centre options
      • Wrap text
      • Custom formats
      • Find and Select Options
      • Paste special options
    • Pivot Tables and Pivot Charts
      • Introduction
      • What is a Pivot table?
      • How to create a Pivot table
      • Working with an existing Pivot table
      • Slicer tool
    • Macros
      • Introduction
      • Running an existing Macro
      • Recording a macro
      • Recording a macro using relative referencing
      • Deleting a macro
      • Assigning a macro to a command button on the Quick Access Toolbar
      • Applying modifications to a Macro
    • Forms
      • Introduction
      • The data form
      • Inserting form controls and setting their properties
    • Advanced Window Options
      • Introduction
      • Arrange windows
      • Using New window
      • Linking workbooks
      • Advanced Worksheet protection
    • Working with Formulae
      • Introduction
      • Tracing formulae
      • Watch Window
      • Calculate options

Course Fee:
USD 25

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top