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

Ultimate Excel Shortcut Guide Become a Power User in Days!

Course Summary

Do you use Microsoft Excel ? If you do then you need to watch this course. Learn the shortcuts to become a power user.


  • +

    Course Syllabus

    • Welcome
      • Important - Download These First - Working Files
      • 0101 Introduction
      • 0102 Using The Working Files
    • The Simple Ones Are The Best Ones
      • 0201 How To Enter Numbers And Retain The Leading Zero
      • 0202 Using The Fill Handle For Quick Data Patterns
      • 0203 Controlling Pages On Printing
      • 0204 Adding Hyperlinks To Excel Objects
      • 0205 Recommended Pivot Tables
      • 0206 Recommended And Quick Creation Charts
      • 0207 Ctrl Keyboard Shortcuts
    • Excel Interface Shortcuts
      • 0301 Accessing Ribbon Commands With The Keyboard
      • 0302 Customize The Ribbons And Quick Access Toolbar
      • 0303 Activating And Deactivating Interface Options
    • Workbooks And Worksheets
      • 0401 Moving Swiftly Between Workbooks And Worksheets
      • 0402 Displaying File Path, File Name And Sheet Name
      • 0403 Controlling The Quantity Of Worksheets
    • Data Organization
      • 0501 Creating A Table
      • 0502 Table Styles Of Your Own
      • 0503 Creating And Using Custom Views
      • 0504 Testing What Ifs With Goal Seek
      • 0505 Use Scenarios To Experiment With Different Values
    • Entering Data And Formatting
      • 0601 Managing Cells With Large Text Content
      • 0602 Creating And Managing A Pick List
      • 0603 Multiple Sheet Data Entry And Sheet Management
    • Working With Dates And Times
      • 0701 Inserting The Date And Time As Static Or Dynamic
      • 0702 Time Difference And Duration: Particularly Over 24 Hours
      • 0703 Calculate Time Required To Reach Investment Goal
    • Working With Data And Formulas
      • 0801 Create Your Own Fill Handle Lists
      • 0802 Flash Fill In Action - Completing Data Columns
      • 0803 Removing Duplicate Values
      • 0804 Work Out Mortgage Repayments
      • 0805 Adding Comments To Formulas
      • 0806 Displaying The Formula In Use: Formula Text
      • 0807 Use Watch To Keep An Eye On A Cell Value
      • 0808 Adding Formulas To Text Boxes
    • Charts And Pivot Tables
      • 0901 Create A Chart With A Single Key
      • 0902 Summarizing Data Using A Sparkline
      • 0903 Reference A Pivot Table Value In A Formula
      • 0904 Separate Worksheets From A Single Pivot Table
      • 0905 Drilling Down Into Pivot Table Data
    • Conclusion
      • 1001 Shortcut Summary


Course Fee:
USD 24

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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