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
• Scrolling - Left/right and Up/down
• Zooming
• Window Resizing
• 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
• Subtraction
• Multiplication and Division
• Setting Decimal Places
• Nested Formula's
• Does This Cell Equal To That Cell (TRUE/FALSE)
• 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
• 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

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: