Microsoft Excel for Beginners
4.5 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
52 students enrolled

Microsoft Excel for Beginners

A Step-by-Step Guide to Mastering the Basics
4.5 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
52 students enrolled
Created by Tom Colorito
Last updated 8/2015
English
English [Auto-generated]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 70 Training Videos
  • Practice lessons
  • Video solutions for each practice lesson
  • Job aides
  • If you watch each training video and go through the practice lesson at the end of each section, you should have the ability to create, edit and print your own worksheets upon completion of this course
Requirements
  • A computer with Microsoft Excel
  • A desire to learn something new and a willingness to do the work
Description

Have you always wanted to learn Excel but were afraid it would be too difficult? Do you want to increase your computer skills so you have the potential to earn more money? Do you want to learn Excel so you have the potential to be more marketable? Do you just want to learn a new skill?

If you've answered "yes" to any of these questions, then you've found the perfect course!

Master The Fundamentals of Microsoft Excel In This Course Designed Just For Beginners

  • Learn the Basics Quickly and Easily
  • Edit and Format your Worksheet Like a Pro
  • Create Formulas With Amazing Speed & Accuracy
  • Learn 10 "Success Tips" That Will Help You Be More Efficient
  • Step-by-Step Instructions For All Lessons So It's Super Easy To Learn

This course will take you step-by-step through the process of learning the material. Together, we will start at the very beginning, build a solid foundation of knowledge, and then continue to build upon that knowledge by learning important concepts and features of the Microsoft Excel program.

To ensure your success with this course, I have also included practice lessons, video solutions for each practice lesson, as well as high quality job aides.

Who this course is for:
  • People who have little or no prior experience using Microsoft Excel. This course is for Beginners.
  • Working professionals who need to learn Microsoft Excel
  • People who run a business from their home
  • Students
Course content
Expand all 86 lectures 03:49:59
+ Getting Started - An Overview of Excel
8 lectures 11:53
The Ribbon
03:11
The Formula Bar
01:17
The Status Bar
01:09
JOB AIDE: An Overview of Excel
10 pages
JOB AIDE: Keyboard Navigation & Shortcuts
3 pages
+ The Basics of Entering & Editing Data
9 lectures 14:52
Overview
00:55
Entering Text, Numbers & Dates
03:06
Editing Your Data
01:36
Undo, Redo
02:17
Save Your Worksheet
01:16
SUCCESS TIP #1: Navigating Your Worksheet with Keyboard Shortcuts
03:03
Summary
00:56
PRACTICE LESSON #2
2 pages
PRACTICE LESSON #2 - VIDEO SOLUTION
01:43
+ Working with Formulas
12 lectures 24:51
Overview
01:14
Using Cell References
02:14
3 Advantages of Using Cell References in Formulas
01:49
SUCCESS TIP #2: Create Formulas with Amazing Speed and Accuracy: Method 1
03:26
What is a Range?
02:12
Introduction to Functions: Creating a Formula Using the SUM Function
02:12
SUCCESS TIP #2: Revisited
02:35
SUCCESS TIP #3: Create Formulas with Amazing Speed and Accuracy: Method 2
02:24
Summary
02:07
PRACTICE LESSON #3
3 pages
PRACTICE LESSON #3 - VIDEO SOLUTION
01:44
+ Formatting Your Data
17 lectures 37:19
Overview
01:07
Enhancing Text with Bold, Underline, and Italics
02:04
Adjusting Text Alignment
01:44
Formatting Numbers
02:57
Adding Borders
02:00
Adjusting Column Widths
02:00
SUCCESS TIP #4: Adjust Columns Widths Perfectly Every Time
01:33
SUCCESS TIP #5: A Method to Adjust MULTIPLE Column Widths Perfectly Every Time
01:52
SUCCESS TIP #6: Another Method to Adjust MULTIPLE Column Widths Perfectly
01:18
Adding Titles and Using the Merge & Center Command
01:27
Working with Fonts (Size, Color)
03:33
Adding Shading
03:10
SUCCESS TIP #7: Have Excel Automatically Format Your Worksheet
04:09
Summary
01:37
PRACTICE LESSON #4
8 pages
PRACTICE LESSON #4 - VIDEO SOLUTION
04:51
+ More Ways to Work with Formulas
9 lectures 17:25
Overview
01:11
The AVERAGE Formula
03:58
The INSERT FUNCTION (Fx) Command
02:19
The MAX Formula
02:00
The MIN Formula
01:45
SUCCESS TIP #8: Get Formula Results Without Having to Create a Formula
01:48
Summary
01:17
PRACTICE LESSON #5
7 pages
PRACTICE LESSON #5 - VIDEO SOLUTION
03:07
+ More Ways to Edit Your Worksheet
15 lectures 31:08
Overview
01:01
Using the Format Painter
03:06
Inserting Columns
01:14
SUCCESS TIP #9: Insert Column Headings Without Having to Type Them
03:55
Inserting Rows
02:35
Inserting Cells
02:22
Deleting Columns
02:00
Deleting Rows and Cells
02:16
Hiding and Unhiding Columns & Rows
02:40
SUCCESS TIP #10: How to Unhide All Columns & Rows in a Single Step
01:41
How to Cut & Paste
02:57
How to Copy & Paste
01:29
Summary
01:01
PRACTICE LESSON #6
10 pages
PRACTICE LESSON #6 - VIDEO SOLUTION
02:51
+ Working with Tabs
6 lectures 10:10
Overview
01:14
Renaming, Adding, and Deleting Tabs
02:03
Changing Tab Color, Moving Tabs and Copying Tabs
02:59
Summary
01:20
PRACTICE LESSON #7
10 pages
PRACTICE LESSON #7 - VIDEO SOLUTION
02:34
+ Printing and Page Layout
10 lectures 21:26
Overview
01:09
Using Print Preview
01:21
Adjusting Margins
03:17
Center on Page Horizontally
03:34
Selecting and Clearing the Print Area
01:48
Adding Headers and Footers
04:55
Summary
00:53
PRACTICE LESSON #8
8 pages
PRACTICE LESSON #8 - VIDEO SOLUTION
02:52