Microsoft Excel for Beginners

Name: Microsoft Excel for Beginners
Rating: 4.7 (30 reviews)

Perfect course for anyone who works with data!

Created byPatricia Hill

Last updated 9/2022

English

What you'll learn

Create and format a spreadsheet
Organize and manage data
Build and edit formulas and functions
Create and modify charts and graphs
Create and modify pivot tables and pivot charts

Course content

9 sections • 32 lectures • 4h 7m total length

Introduction & Resources8:23

Formatting8:35
This video contains the following content:
Editing Vs. Formatting
Formatting Text and Numbers
Manual Formatting
Cell Styles
Workbook Themes
Clear Options & Format Painter3:56
This video contains the following content:
Clear Options
Clear All
Clear Formats
Clear Content
Clear Comments & Notes
Clear Hyperlinks
Format Painter
Merge Options & Wrapping Text2:48
This video contains the following content:
Merge Options
Merge & Center
Merge Cells
Unmerge Cells
Wrap Text
Conditional Formatting6:09
This video contains the following content:
What is Conditional Formatting?
Applying Conditional Formatting
Editing Conditional Formatting Rules
Removing Conditional Formatting Rules
Print Options8:42
This video contains the following content:
Print Entire Workbook
Print Active Sheets
Print Selection
Set Print Area
Clear Print Area
Page Setup Options
Page
Margin
Header/Footer
Sheet
Formatting & Printing Quiz

Generating a Series & Flash Fill5:44
This video contains the following content:
What is a series?
Generating a series of months, days, dates, and numbers
What is Flash Fill?
Using Flash Fill
Insert, Delete, Hide, Unhide Columns, Rows, and Worksheets6:16
This video contains the following information:
Insert/Delete Columns and Rows
Hide/Unhide Columns, Rows, and Worksheets
Freeze Panes3:50
This video contains the following content:
What is Freeze Panes?
Freeze/Unfreeze first row
Freeze/Unfreeze first column
Freeze/Unfreeze panes
Grouping & Ungrouping Worksheets2:35
This video includes the following content:
What is grouping?
The benefits of grouping.
Grouping Worksheets
Ungrouping Worksheets
Sort & Filter10:09
This video includes the following content:
Sorting vs. Filtering
Applying a filter
Using text and number filters
Printing filtered data
Clearing filters
Single and multi-level sorts
Data Validation9:57
This video includes the following content:
What is Data Validation?
Whole number data validation
List data validation
Input messages
Error alerts
Organizing and Managing Data Quiz

Formulas & Functions (Level 1)14:01
This video includes the following content:
Formula vs. Function
Build a simple formula: Addition, Subtraction, Multiplication, Division
AutoSum Functions: Sum, Average, Count Numbers, Max, Min
Show/Hide Formula
Copy Formula
Relative and Absolute Cell References5:53
This video includes the following content:
What are Relative and Absolute Cell References?
How do relative and absolute cell references work?
Trace Precedents and Trace Dependents2:24
This video includes the following content:
What are Trace Precedents and Trace Dependents?
Using Trace Precedents and Trace Dependents
Error Checking4:56
This video includes the following content:
What are the Error Checking options?
How to use Error Checking
Formulas & Functions (Level 1) Quiz

Text to Columns Tool2:45
This video includes the following content:
What is Text to Columns?
Using Text to Columns
Concatenate Function2:47
This video includes the following content:
What is Concatenate?
Using Concatenate
Subtotal Tool4:04
This video includes the following content:
What is the Subtotal Tool?
Using the Subtotal Tool
PMT Function7:28
This video includes the following content:
What is the PMT Function?
Using the PMT Function
VLookup and HLookup Functions13:13
This video includes the following content:
What is the VLookup Function?
Using the VLookup Function
What is the HLookup Function?
Using the HLookup Function
Consolidate Tool3:24
This video includes the following content:
What is the Consolidate Tool?
Using the Consolidate Tool
Formulas & Functions (Level 2) Quiz

IF Statements4:38
This video includes the following content:
What is an IF Statement?
Building IF Statements
SUMIF & SUMIFS Functions14:20
This video includes the following content:
What is the SUMIF Function?
Using the SUMIF Function
What is the SUMIFS Function?
Using the SUMIFS Function
COUNTIF & COUNTIFS Functions9:12
This video includes the following content:
What is the COUNTIF Function?
Using the COUNTIF Function
What is the COUNTIFS Function?
Using the COUNTIFS Function
IF Statements & IF Functions

What are Charts?4:03
This video includes the following content:
What are charts?
What is the purpose of charts?
Chart types: Pie, Line, Column, and Bar
Building Charts with Adjacent and Non-Adjacent Data10:29
This video includes the following content:
Building Charts with Adjacent Data
Building Charts with Non-Adjacent Data
Chart Design and Format18:08
This video includes the following content:
Chart Tools Contextual Tabs: Chart Design and Format
Adding Chart Elements
Chart Layouts
Chart Styles
Change Chart Type
Move Chart
Formatting Idividual Chart Elements
Updating and Printing Charts2:27
This video includes the following content:
Updating Chart Data
Printing Charts
Printing Charts and Spreadsheet Data
Charts & Graphs Quiz

Building Pivot Tables and Pivot Charts12:14
This video inculdes the following content:
What is a Pivot Table?
What is a Pivot Chart?
Pivot Table and Pivot Chart Fields
Building a Pivot Table and Pivot Chart
Understanding Pivot Table and Pivot Chart data
Using Pivot Table and Pivot Chart filters
Pivot Table and Pivot Chart Tools16:26
This video includes the following content:
Naming Pivot Tables and Pivot Charts
Field Settings
Working with Slicers
Refreshing Data
Clearing Filters
Pivot Table and Pivot Chart Layout and Styles
Pivot Tables and Pivot Charts Quiz

Requirements

No prior spreadsheet knowledge required. Must have Microsoft Excel version 2007 or later.

Description

Microsoft Excel for Beginners is an introductory spreadsheet course. The target audience for this course is anyone with little or no experience using Microsoft Excel. Lesson content will be explained and presented in a way that is easy to understand and follow. This class includes 8 lessons: Orientation & Basics, Formatting & Printing, Organizing & Managing Data, Formulas & Functions (Level 1), Formulas & Functions (Level 2), IF Statements & IF Functions, Charts & Graphs, and Pivot Tables & Pivot Charts. With each lesson you will be provided with an Excel learning file, a PDF of the lesson, a video that explains and demonstrates each concept in the lesson and a 10 question multiple choice quiz. Upon completion of this course you will be able to effectively analyze, organize, manage and visually display data in an Excel spreadsheet.

Learning Microsoft Excel will provide a solid foundation for learning other spreadsheet programs such as: Google Sheets, Numbers, Smartsheet, Zoho Sheet, and LibreOffice. According to Forbes Magazine, 54% of all businesses use Microsoft Excel in some way; this number does not take into account other spreadsheet programs that are also used.

As our world becomes more and more data driven, it is necessary to develop skills that enable us to better understand, interact with, and manage data.

Who this course is for:

Entry level users who what to learn how to organize and manage data in Excel

Microsoft Excel for Beginners

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 8min

Lesson 1: Orientation & Basics1 lecture • 18min

Lesson 2: Formatting & Printing5 lectures • 30min

Lesson 3: Organizing & Managing Data6 lectures • 39min

Lesson 4: Formulas & Functions (Level 1)4 lectures • 27min

Lesson 5: Formulas & Functions (Level 2)6 lectures • 34min

Lesson 6: IF Statements & IF Functions3 lectures • 28min

Lesson 7: Charts & Graphs4 lectures • 35min

Lesson 8: Pivot Tables & Pivot Charts2 lectures • 29min

Requirements

Description

Who this course is for: