Microsoft Excel for Beginners
4.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
26 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel for Beginners to your Wishlist.

Add to Wishlist

Microsoft Excel for Beginners

A Step-by-Step Guide to Mastering the Basics
4.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
26 students enrolled
Created by Tom Colorito
Last updated 8/2015
English
Current price: $10 Original price: $95 Discount: 89% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 86 Lectures Collapse All 86 Lectures 03:50:04
+
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
About the Instructor
Tom Colorito
4.7 Average rating
6 Reviews
26 Students
1 Course
Founder of MyTechTrainer

Hi there! My name is Tom and I will be your trainer for this course.

I have over 25 years of teaching computer classes as well as developing computer based and web based training courses like this one. I've also designed and developed job aides and practice tutorials for online learning.

I design all my lessons to be simple and easy to follow – each one is purposely short and to the point so you can find, and learn, exactly what you want, when you need it. And the best part? I will guide you step-by-step through the entire process by offering simple, easy to follow training videos, practice lessons and job aides.

I have a passion for helping people learn new skills and I think it's great helping them grow personally and professionally. I believe in the “Pay it Forward" philosophy and that's why I try to help people whenever I can.

If you purchase a training course from me, I will do everything I can to ensure your success.

Thanks and wishing you much success!

--Tom