Helena Daily Courses > Office Productivity > Microsoft > Microsoft Excel for Beginners
4.73 out of 5
4.73
51 reviews on Udemy

Microsoft Excel for Beginners

A Step-by-Step Guide to Mastering the Basics
Instructor:
Tom Colorito
164 students enrolled
English [Auto]
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

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.

Getting Started - An Overview of Excel

1
What is Excel?
2
The Worksheet
3
The Quick Access Toolbar
4
The Ribbon
5
The Formula Bar
6
The Status Bar
7
JOB AIDE: An Overview of Excel
8
JOB AIDE: Keyboard Navigation & Shortcuts

The Basics of Entering & Editing Data

1
Overview
2
Entering Text, Numbers & Dates
3
Editing Your Data
4
Undo, Redo
5
Save Your Worksheet
6
SUCCESS TIP #1: Navigating Your Worksheet with Keyboard Shortcuts
7
Summary
8
PRACTICE LESSON #2
9
PRACTICE LESSON #2 - VIDEO SOLUTION

Working with Formulas

1
Overview
2
How to Create a Basic Formula
3
Using Cell References
4
3 Advantages of Using Cell References in Formulas
5
SUCCESS TIP #2: Create Formulas with Amazing Speed and Accuracy: Method 1
6
What is a Range?
7
Introduction to Functions: Creating a Formula Using the SUM Function
8
SUCCESS TIP #2: Revisited
9
SUCCESS TIP #3: Create Formulas with Amazing Speed and Accuracy: Method 2
10
Summary
11
PRACTICE LESSON #3
12
PRACTICE LESSON #3 - VIDEO SOLUTION

Formatting Your Data

1
Overview
2
Enhancing Text with Bold, Underline, and Italics
3
Adjusting Text Alignment
4
Formatting Numbers
5
Adding Borders
6
Adjusting Column Widths
7
SUCCESS TIP #4: Adjust Columns Widths Perfectly Every Time
8
SUCCESS TIP #5: A Method to Adjust MULTIPLE Column Widths Perfectly Every Time
9
SUCCESS TIP #6: Another Method to Adjust MULTIPLE Column Widths Perfectly
10
Adding Titles and Using the Merge & Center Command
11
Working with Fonts (Size, Color)
12
Indenting Data
13
Adding Shading
14
SUCCESS TIP #7: Have Excel Automatically Format Your Worksheet
15
Summary
16
PRACTICE LESSON #4
17
PRACTICE LESSON #4 - VIDEO SOLUTION

More Ways to Work with Formulas

1
Overview
2
The AVERAGE Formula
3
The INSERT FUNCTION (Fx) Command
4
The MAX Formula
5
The MIN Formula
6
SUCCESS TIP #8: Get Formula Results Without Having to Create a Formula
7
Summary
8
PRACTICE LESSON #5
9
PRACTICE LESSON #5 - VIDEO SOLUTION

More Ways to Edit Your Worksheet

1
Overview
2
Using the Format Painter
3
Inserting Columns
4
SUCCESS TIP #9: Insert Column Headings Without Having to Type Them
5
Inserting Rows
6
Inserting Cells
7
Deleting Columns
8
Deleting Rows and Cells
9
Hiding and Unhiding Columns & Rows
10
SUCCESS TIP #10: How to Unhide All Columns & Rows in a Single Step
11
How to Cut & Paste
12
How to Copy & Paste
13
Summary
14
PRACTICE LESSON #6
15
PRACTICE LESSON #6 - VIDEO SOLUTION

Working with Tabs

1
Overview
2
Renaming, Adding, and Deleting Tabs
3
Changing Tab Color, Moving Tabs and Copying Tabs
4
Summary
5
PRACTICE LESSON #7
6
PRACTICE LESSON #7 - VIDEO SOLUTION

Printing and Page Layout

1
Overview
2
Using Print Preview
3
Setting Page Orientation (Portrait vs. Landscape)
4
Adjusting Margins
5
Center on Page Horizontally
6
Selecting and Clearing the Print Area
7
Adding Headers and Footers
8
Summary
9
PRACTICE LESSON #8
10
PRACTICE LESSON #8 - VIDEO SOLUTION
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7
4.7 out of 5
51 Ratings

Detailed Rating

Stars 5
26
Stars 4
20
Stars 3
5
Stars 2
0
Stars 1
0
f5f056af9119d31d2c633c78550660d3
Get on Udemy
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion