Excel Basics

Name: Excel Basics
Rating: 4.4 (171 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
Welcome to the excel basics course. Review the course after enrolling to help improve quality and visibility in the marketplace, and let's get started.
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
Explore the Excel ribbon interface, its tabs such as Home and Insert, the groups within tabs, and how the ribbon dynamically adapts when you insert a chart.
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
Input data and create a new sales per customer column in Excel, then use a basic formula to divide sales by customers and fill down.
The SUM, AVERAGE, and COUNT Functions5:15
Learn how to use built-in Excel functions to calculate sums, averages, and counts. Explore the function library and insert function button to apply these calculations to cell ranges.
Notes on SUM, AVERAGE, and COUNT0:50
MAX and MIN Functions and Status Bar Statistics3:08
This lecture shows how to use max and min in Excel to find highest and lowest sales per customer, and status bar displays statistics like average, min, max, and sum.
Cell References (Relative and Absolute References)4:25
Explore relative references that adjust when you fill formulas down, and absolute references that stay fixed using dollar signs, as shown with a tax rate in C14.
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
Master excel basics with countif, countifs, and sumif to count by criteria, compare ranges, and sum charges based on patient last names like Jones or hospital days.
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
Explore scatter plots to compare quantitative data on the x and y axes and examine the relationship between temperature and ice cream sales over time in Excel.
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
Learn how to use Excel's flash fill to quickly extract the year from patterned date data in column c by adding a new column and applying the flash fill pattern.
IF Statements2:51
Explore using the Excel if function to flag employees with ratings greater than 3, returning yes or blank, and see how the flag updates dynamically as ratings change.
Section 4 Quiz 1
The VLOOKUP Function0:57
VLOOKUP4:45
Master VLOOKUP in Excel to pull hours worked for a unique sales rep from a table using the leftmost column and a column index, and use false for exact matches.
PivotTables6:21
Learn to create pivot tables in Excel basics by converting dataset to an Excel table, using filters, and dragging fields to rows, columns, and values to summarize hours and ratings.
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: