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 Step by Step Training for Beginners!

### Course Summary

Learn all the basics of Microsoft Excel and begin creating amazing templates and tables in a matter of minutes!!

• +

### Course Syllabus

• Welcome, Course Introduction, Course Structure, Life Management Tools
• Welcome and Congratulations
• Course Structure
• Topics Covered In This Course
• Life Management Tools
• Before You Start
• All My Other Courses!
• Basic Controls
• The Different Ways To Open Excel
• How To Use The Menu Ribbon
• Page Scrolling
• Page Zooming
• Screen Controls Explained
• Hotdog's anyone?
• Topics
• Case Study
• Naming and Saving an Excel Workbook
• Using the Fill Handle
• Basic Formula's 1 - Adding and Subtracting
• Autosum Functions: Totals and Averages
• Basic Formula's 2 - Multiplying and Dividing
• Using the Status Bar Calculator
• Using Wordart
• Summary
• Quiz
• Quiz Solution
• Reordering the Ribbon
• Controlling the Ribbon from the Keyboard
• My Chocolate Factory
• Topics
• Case Study
• Different Ways to Input Data
• Copying, Cutting and Pasting
• Format Cells Window
• Moving Rows and Columns
• Adding and Deleting Rows and Columns
• Introduction to Sheets: Adding and Deleting Sheets
• Introduction to Sheets: Renaming and Tab Colouring
• Introduction to Sheets: Moving and Copying
• How to Add a New Window: Tiling the Screen
• How to give a review
• Summary
• Quiz
• Quiz Solution
• Life Management Tools
• Introduction
• Holiday Planner
• Financial Planner
• What's For Dinner? (Setup Procedure)
• What's For Dinner?
• If I was Jamaican, my name would be.....
• Topics
• Case Study
• Building you first "If" Function
• Using the "Or" Function"
• Using the "And" Function
• Summary
• Quiz
• Quiz Solution
• I wish I was that rich!!!
• Topics
• Case Study
• Creating a Line Graph
• Creating a Line Graph 2 - Formatting
• Creating a Scatter Plot
• Applying a Trend Line
• What Topics Do You Want Me To Cover?
• Creating a Column Graph
• Creating a Pie Graph
• Summary
• Quiz
• Quiz Solution
• I suck at Art!!!
• Topics
• Case Study
• Importing Image Files: Insert Image Function and Print Screen
• Controlling the Image: Moving, cropping, resizing and rotating
• Formatting the Image: Corrections, Colour and Artistic Effects
• Ovals – Formatting, Rotation, Grouping
• Squares and Textboxes: Formatting, Connecting Shapes and Picture Frames
• Summary
• Quiz
• Quiz Solution
• My wife is going to love me after this!!!
• Topics
• Case Study
• Spellchecker
• How to Search and Replace Text
• Format Painter Basics
• Text Cleaning: UPPER, lower, Proper
• Different Types of Pasting
• Sort and Filter
• Freeze Panes
• Using Borders and Merged Cells
• Summary
• Quiz
• Quiz Solution
• Real men know how to print!
• Topics
• Case Study
• Different Page Views
• Setting the Print Area
• Setting Paper Size, Orientation and Print Margins
• Determining The Scale
• Applying a Header and Footer
• Printing a PDF FIle
• Printing a Document
• Summary
• Quiz
• Quiz Solution
• I knew you were AWESOME!
• Congratulations!

Course Fee:
USD 9

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts:

## Microsoft Excel

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