Microsoft Excel: Starter Guide

New to Excel or don't use it often? Here's your free guide to get started.

Created byEric Arseneau, Ph.D.

Last updated 11/2019

English

What you'll learn

A complete guide for using Microsoft Excel starting with the most basic steps.

Course content

5 sections • 45 lectures • 3h 29m total length

Opening Excel and creating a new sheet4:15
Saving Excel files2:09
The important file types2:55
The formula bar2:33
Adding, Modifying, and Deleting data in cells4:35
Creating a new workbook1:59
Develop the habit of using file... save as3:55
The important data types14:18

Before we start: Let's zoom in and out0:44
How Excel works6:47
The relative cell reference3:35
Review: Enter and leave edit mode2:21
Example using relative cell references9:15
Learn how to perform a 'copy and paste' operation to quickly write formulas in many cells.
Relative vs. absolute cell references8:03
Test your skills | Create cell references1:42
Test your skills | Copy and paste a cell reference4:04
Add | Subtract | Multiple | Divide5:04
Add numbers using a more complicated formula8:05
Review: Cut and Paste | "Moving" Cells4:34
Recap: Select | Move (cut and paste) | Copy and paste2:47

Formatting text: changing font1:49
Review: Cut and paste | Move text0:52
Resizing columns5:28
Cleaning up | Wrap text3:07
Adding fake values1:25
Formatting text: centering1:37
Selecting all text at once1:49
Review: Adding a SUM function2:25
Review: Copy and paste the function2:06
Formatting text: center | fill with color | sort3:23
Improve the first function8:15
Learn how to perform the math for a multi-attribute model - a very common mathematical operation in Excel.
Review: Use the fill feature | Merge cells and center text4:07
Improve the formula using the SUMPRODUCT function4:53
The SUMPRODUCT function is a powerful way to make our lengthy formula much more concise.

Requirements

Be able to download and install Microsoft Office / Excel.

Description

This free class is meant for those who need Excel training from the very beginning. I will help you build confidence in using Excel to its full potential and provide you with the skills to navigate Excel efficiently. By the end of the course, you will be able to use Excel for a variety of decision making scenarios. Excel is one of the most powerful software tools ever built. It is just as effective at keeping a grocery list as it is at crunching numbers for a Fortune 500 business. You will immediately create value for your own organization or your employer by learning the Excel skills taught in this class. I hope you enjoy it.

Who this course is for:

Beginner Excel users who want a step-by-step guide to build confidence with the software.

Microsoft Excel: Starter Guide

What you'll learn

Explore related topics

Course content

Getting Started8 lectures • 37min

Beginning Steps12 lectures • 57min

Mini Project #1 | Creating a Small Budget5 lectures • 39min

Mini Project #2 | Creating a Personal Budget7 lectures • 31min

Mini Project #3 | Apartment Comparison Tool13 lectures • 41min

Requirements

Description

Who this course is for: