Excel Basics

Name: Excel Basics
Rating: 4.4 (170 reviews)

Master Excel functions, charts, and basic PivotTables.

Created byStephen Hill

Last updated 5/2018

English

What you'll learn

Work smart, faster, and more efficiently in Excel.
Use basic Excel functions.
Create charts and understand visualization basics.
Build basic PivotTables.

Course content

5 sections • 32 lectures • 1h 1m total length

Welcome!0:25
IMPORTANT NOTE: Excel Versions0:14
Introduction Outline0:07
Opening Excel and Creating a New Excel Workbook0:11
Workbooks and Worksheets0:33
The Excel Ribbon Interface1:54
Saving Your Work in Excel0:30
Introduction Section Quiz

Functions and Cell References Outline0:12
12 Essential Functions Every User Should Know!0:15
Sample Sales Dataset0:01
Download this dataset to follow along with the work done in this part of the course.
Inputting Data and a Basic Formula6:13
The SUM, AVERAGE, and COUNT Functions5:15
Notes on SUM, AVERAGE, and COUNT0:50
MAX and MIN Functions and Status Bar Statistics3:08
Cell References (Relative and Absolute References)4:25
Section 2 Quiz
Section 2 Exercise

Working with Dates, Counts, and Visualizations Outline0:12
Patient Dataset0:01
Use this dataset for some of the work in this section of the course.
How Excel Handles Dates0:28
Date-Related Functions (WEEKDAY, DAYS, TODAY, and NOW)4:08
COUNTIF, COUNTIFS, and SUMIF5:02
Section 3 Quiz 1
Ice Cream Sales Dataset0:01
Use this dataset for some of the work in this section of the course.
Scatterplots4:35
Bar (Column) Plots3:14
Visualization in Excel: 3 Tips You Should Know1:33
Section 3 Quiz 2
Section 3 Exercises

IF Statements, VLOOKUPs, and PivotTables Outline0:10
Employee Dataset0:01
This dataset contains employee information from several stores. The Sales Rep column gives the first name of the employee. The Store column is the employee's store location. The Date Hired column is the date that the employee was hired by the company. The Rating column refers to performance rating on the employee's last evaluation (1 = Excellent, 5 = Poor).
Flash Fill2:55
IF Statements2:51
Section 4 Quiz 1
The VLOOKUP Function0:57
VLOOKUP4:45
PivotTables6:21
Section 4 Quiz 2
Section 4 Exercise

Requirements

Basic computer skills.

Description

This course is designed for the Excel beginner or the Excel user looking for a refresher. In this course you'll learn how to work with text and numeric data, create basic Excel functions, build impactful charts, and construct basic PivotTables. You'll also learn a variety of tips and tricks to improve your productivity in Excel. The course is taught using Excel 2016, but much of the content is relevant for older versions.

Who this course is for:

Excel beginners or those looking for an Excel refresher.

Excel Basics

What you'll learn

Explore related topics

Course content

Introduction7 lectures • 4min

Functions and Cell References8 lectures • 20min

Working with Dates, Counts, and Visualizations9 lectures • 19min

IF Statements, VLOOKUPs, and PivotTables7 lectures • 18min

Thank You1 lecture • 1min

Requirements

Description

Who this course is for: