Microsoft Excel for Beginners

A Step-by-Step Guide to Mastering the Basics
4.5 (3 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.
16 students enrolled
$19
$95
80% off
Take This Course
  • Lectures 86
  • Length 4 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course 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.

What are the requirements?

  • A computer with Microsoft Excel
  • A desire to learn something new and a willingness to do the work

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started - An Overview of Excel
What is Excel?
Preview
02:28
The Worksheet
Preview
02:05
The Quick Access Toolbar
Preview
01:43
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
Section 2: The Basics of Entering & Editing Data
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
Section 3: Working with Formulas
Overview
01:14
How to Create a Basic Formula
Preview
02:54
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
Section 4: Formatting Your Data
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
Indenting Data
Preview
01:57
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
Section 5: More Ways to Work with Formulas
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
Section 6: More Ways to Edit Your Worksheet
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
Section 7: Working with Tabs
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
Section 8: Printing and Page Layout
Overview
01:09
Using Print Preview
01:21
Setting Page Orientation (Portrait vs. Landscape)
Preview
01:37
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tom Colorito, 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

Ready to start learning?
Take This Course