Foundations of Excel
5.0 (2 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.
5 students enrolled

Foundations of Excel

Get Excel-savvy with a solid foundation in Excel and learn the basics the right way.
5.0 (2 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.
5 students enrolled
Created by Vivian Pyle
Last updated 2/2020
English
English [Auto]
Price: $24.99
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 18 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
  • Learn Excel from the ground up, from creating a workbook to understanding formulas and functions
  • How to create a new workbook
  • Formatting worksheets
  • Working with formulas and functions
  • Printing workbooks
  • And, SO MUCH MORE!
Requirements
  • Basic computer knowledge.
Description

Being Excel-savvy is an essential must-have skill to have in most businesses. Whether you are just starting out or you only know how to do what you've been shown to do in Excel without really understanding 'why' you're doing it, this course is for you.

This course will give you the solid foundation you need with a deep understanding of how Excel works and how best to set up your spreadsheets. You’ll be shown how to create Excel worksheets from start to finish including a comprehensive look at formulas and functions, formatting and setting your worksheet up to be printed.

You’ll learn how to use Excel correctly and will be shown proper steps and shortcuts to complete standard tasks through a series of interactive videos, hands-on demos and exercises, printouts and quizzes to test your new-found knowledge to help you gain confidence in Excel. Thus, putting you on the fast-track to becoming Excel-savvy.

We'll start at the beginning by covering everything you need to get up and running with Excel including:

Excel terms and definitions

  • Navigating Excel

  • Creating and saving a workbook

  • Entering data and values into a worksheet

  • Understanding Excel formulas and functions

  • Formatting your worksheet

  • Working with multiple worksheets

  • Printing your worksheet

  • And, more...

Whether you are looking for a refresher or hoping to gain knowledge employers are looking for, you're in the right place. In today's data driven, analytical world, knowing and understanding Excel is a must and this course will give you the foundation you need to springboard into the more advanced features of Excel.

Course requirements: Computer, Excel (any version 2010-2019)

Course prerequisites: Basic computer knowledge: how to save and retrieve files, how to use the mouse, etc.

Course includes: Lessons, lesson exercises, handouts for each section, quizzes

Who this course is for:
  • The ideal student is one that either doesn't know anything about Excel or is only able to do what has been shown to them.
  • Anyone wanting or needing a strong foundation in Excel quickly and easily.
Course content
Expand all 44 lectures 02:38:16
+ Getting started with Excel
3 lectures 22:54

We will discuss Excel and spreadsheet terms and definitions. The handout with this lecture is for the whole section.

Preview 05:27

Download and take the quiz. Answers will be revealed in the next section.

Navigating the worksheet
06:44
+ Creating a workbook and worksheets
7 lectures 24:01

In this section we will talk about how to create and save a workbook and enter data into a worksheet. The handout is for the whole section.

How to start a new workbook and worksheet
02:03
Entering data into the worksheet
04:33
Selecting data
05:45
Moving and copying data
04:35
Using the autofill handle
02:48
Undo and redo
01:23

Download and take the quiz! Answers will be revealed in the next section.

Closing and saving workbooks.
02:54
+ Performing calculations
4 lectures 10:05

Be sure to download the section handout and demo file here.

Formulas
00:19
Formula Rules
01:47

Be sure to download the hands-on quiz for this section. The answers will be revealed in the next section.

Using operators
03:55

Be sure to download the hands-on quiz for this section. The answers will be revealed in the next section.

Mixed Operators
04:04
+ Understand Basic, Useful Functions
10 lectures 32:42

The handout and demo file for the whole section is here.

Function definition
01:37
Working with ranges
01:20
Anatomy of a function
01:00
Some common functions
08:59
Autosum button
05:01
Basic functions recap exercise
00:39
Common errors and what they mean
04:06
Using functions with formulas
00:50
Copying functions and formulas
02:53

Be sure to download the hands-on quiz for this section. The answers will be revealed in the next section.

Absolute and relative cell references
06:17
+ Formatting the worksheet
6 lectures 30:14

The handout and demo file for the whole section is here.

Modify fonts
06:26
Aligning cell contents
02:49
Number formats
08:06
Borders and color
05:17
Resizing columns and rows
04:35

Be sure to download the hands-on quiz for this section. The answers will be revealed in the next section.

Format painter
03:01
+ Printing worksheet contents
4 lectures 20:05
Page layout ribbon
07:09
Page setup dialog box
03:28
Print preview
02:16
Print titles
07:12
+ Working with multi-sheet workbooks
6 lectures 14:53
Adding additional sheets-setting the default
03:22
Adding and renaming sheets
01:41
Moving and deleting sheets
01:10
Copying sheets-move dialog box
03:38
Add color to tab sheets-quiz
01:18
Excel options
03:44