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: