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

Shortest Microsoft Excel Training Tutorial Video's EVER!

Course Summary

Each video is around 2 minutes or less. It's simple, efficient and get's straight to the point! No more useless chatter!


  • +

    Course Syllabus

    • Introduction
      • Microsoft Excel - Demonstration
      • Course Structure Introduction
      • All My Courses!
    • Opening Excel for the first time
      • How to open Excel
      • How to save Excel
      • How to close Excel
      • How to open file from within Excel
    • Navigation
      • Scrolling - Left/right and Up/down
      • Zooming
      • Window Resizing
    • Building your first table
      • Data Input
      • Random Number Creation - Randbetween()
      • Your First Arithmetic Formula (Introduction)
      • Deleting Cell Contents
      • Fill Handle
      • Copying and Pasting Values
      • Font Type and Size
      • For each review your helping another student!
      • Borders
      • Centre Alignment
      • Applying Bold, Italic and Underline Formatting
      • Applying a Cell Colour
      • Applying a Text Colour
      • Merged Cells
      • Wrap Text
      • Cut, Copy and Paste (In detail)
      • Inserting Rows and Columns
      • Deleting Rows and Columns
    • Formula's, Functions and Calculations
      • Manual Calculations
      • Addition
      • Subtraction
      • Multiplication and Division
      • Setting Decimal Places
      • Nested Formula's
      • Does This Cell Equal To That Cell (TRUE/FALSE)
      • Linking Cells
    • Formula Auditing
      • Tracing Formula's
      • Show Formula's
    • Autosum Functions
      • Autosum Functions Explained
      • Autosum - SUM()
      • Autosum - AVERAGE()
      • Autosum - COUNT()
      • Autosum - MAX() and MIN()
      • Using the Function Library
    • Count Functions
      • Count
      • CountA
      • CountBlank
      • CountIf
      • CountIfs
      • Want to Learn EVEN MORE????
    • Using Sheets
      • What Are Sheets
      • Adding a New Sheet
      • Deleting A sheet
      • Renaming A sheet
      • Changing the tab colour
      • Reordering sheets
      • Copying a sheet
      • Hiding and Unhiding a sheet Explained
      • Hiding and Unhiding a sheet
    • Freeze Panes
      • Freeze Panes Explained
      • Slider divider to freeze panes
      • Freezing the top row
      • Freezing the First Column
      • Horizontal Freeze Pane
      • Vertical Freeze Pane
      • Horizontal and Vertical
    • Even More Lectures to Come!!!!!
      • MORE LECTURES TO COME!!!!!


Course Fee:
Free

Course Type:

Self-Study

Course Status:

Active

Workload:

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