Excel Essentials
4.1 (17 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.
179 students enrolled

Excel Essentials

Learn Excel the FUN way! By working through exercises along with the video tutorial.
4.1 (17 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.
179 students enrolled
Published 8/2012
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 12 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
  • Teach people new to Excel how to use it well, and have fun with it.
  • Show Experienced users some new features and techniques to use that they have not experienced before

This course was designed to make people better in Excel by talking about things that confuse people every day (VLOOKUPs, PivotTables, printing things on one page). Not only do we teach you how to do all of theses wonderful features in Excel, we'll teach you why. With exercise workbooks that let you work EVERY single example we demonstrate so that you can actually learn how features work, we guarantee that you will feel more at ease with Excel when you're done with this course..

Happy Spreadsheeting!

Who this course is for:
  • Beginners: We'll teach you Excel, and make you good!
Course content
Expand all 52 lectures 05:26:17
+ Getting Started
9 lectures 41:33

Navigating through the Ribbon and finding everything you need in no time!

Preview 06:18

Keyboard shortcuts and some of Excel Rain Man’s go-to moves for PC 2010 spreadsheeters

Preview 1.3 MB

Use this Workbook with every lesson in this chapter except Ribbon lecture

Getting Started
38.1 kB

Download this file to follow along with the Ribbon lecture

Ribbon Demo
13.1 kB

Guide to creating your own tab with the Excel Rain Man go-to fields

Customize the Ribbon PC 10
929.4 kB

Using Freeze Panes to efficiently view spreadsheets, Unfreeze Panes

Freeze Panes
Sorting Data Capabilities

Setting up Filters, Using Custom Filters, AutoFilters (Advanced Filtering Techniques)


Copy/Paste Refresher, Paste Special (Formulas, Values, Transpose)

Paste Special
+ Formatting with Excel
5 lectures 49:34

Use this workbook with all the lectures in chapter 2.  it will contain the same workbook we use in the lectures so that you can follow along and practice to learn the concepts

Formatting Exercises Workbook
30.2 kB
Formatting via the Font Section of the Home Tab and the Format Cells Dialog Box
Formatting Fonts
Formatting via the Alignment Section of the Home Tab and the Format Cells Dialog Box
Formatting Alignment
Formatting via the Number Section of the Home Tab and the Format Cells Dialog Box
Formatting Numbers

Enhancing reports with Conditional Formatting (creating thematic maps)

Preview 10:50
+ Formulas - Introduction
5 lectures 29:03

Use this workbook to work along with the all of the lectures in the Introduction to Formulas Chapter.

Handout Excel PC 2010 Introduction To Formulas
42.7 kB
The basics... Entering formulas in Excel and copying them
Preview 03:31

Utilizing absolute and relative references and partial absolute references

Absolute Referencing

Understanding named ranges and creating them to make spreadsheets more efficient

Named Ranges

Exploring more advanced functions and having criteria applied to sum, count and average functions

More Functions
+ Formulas - Intermediate
5 lectures 32:29

Use this exercise workbook to follow along with the lessons in chapter 4, Intermediate functions

Handout Excel PC 2010 Intermediate Functions
128.7 kB

Using the IF function to add logic to formulas and to nest functions

IF Statement And Nesting

Using many of Excel's text based functions

Text Functions

Creating a unique list of items from a column or table with many duplicates

Remove Duplicates

Utilizing one of Excel’s most valuable (and used) functions for looking up data

Preview 07:01
+ Drop Down boxes, Working with Tables, and Goal Seek. Cool tools.
5 lectures 34:10

Exercise file for Validation, Find and Replace, Working with Tables, and Goal Seek.

Excel Tutorial 5 Tables And Validation
29.6 kB

Have you ever wanted to make a drop down list with pre defined choices?  Data validation is the tool in Excel that will let you do that.  This lesson will teach you all about data validation.

Data Validation

Review the Find and Replace functionality of Excel.  Also see how you can use find to search for colors and formats.

Find And Replace

Learn all about Excel's table features.  See how they can add great formatting and efficiency to your data.


This incredible tool is one of the hidden gems of Excel.  It allows you work formulas and functions backwards to solve for component values.

Goal Seek
+ Pivot Tables - Introduction
6 lectures 33:33

This workbook is used with all of the lectures in the Pivot Table Introduction Chapter

Pivot Tables - Introduction
143.4 kB

What is a PivotTable? Sample PivotTables…

Preview 04:12
The basics... Learning how to build rudimentary PivotTables from Excel data
Build Simple PivotTables
Utilizing Excels library of automatic formats for PivotTables
Format PivotTables

Useful ways for sorting and filtering in PivotTables

Manipulate PivotTables
Adding and removing subtotals and grand totals to rows in PivotTables
PivotTable Totals
+ Pivot Tables - Intermediate
5 lectures 20:28

Use this workbook for the lectures in the Intermediate Pivot Tables Chapter

Handout Excel PC 2010 Intermediate Pivot Tables
187.7 kB
Adding multiple values or metrics to PivotTables
Multiple Data Points

Creating new metrics in your pivot table based on a calculation

Calculated Fields

Keeping PivotTables up to date with new data, or data from a different source

PivotTable Maintenance

One of Excel’s coolest new features! Check it out…

+ Printing and Screen settings
5 lectures 31:39

Use this workbook with every lecture in the Viewing and Printing Chapter.

Handout Excel PC 2010 Viewing And Printing Options
50.0 kB

Utilizing Excels different viewing elements including turning on and off gridlines and column headings


Preparing a document to print by setting print area, adjusting page layouts, inserting page breaks and print titles, addressing scaling and sizing issues


Use custom views to set up and save print and screen view settings

Preview 04:29

Adding headers and footers to print important information on each printed page of your workbook

Headers and Footers
+ Building Charts
7 lectures 53:48

Download this file to follow along and practice the charting videos.

Charting Exercise Files
50.9 kB

This lesson introduces you to Excel charting.  Showing you some of the options to enhance your data with graphics that deliver a strong message.

Introduction to Charting

This lesson will teach you the basics of how to build a simple chart.

Preview 06:06
Now that you have learned how to build a chart in Excel, this lesson will teach you how to format it so that it will give your presentation that extra something that makes it stand out.  We will look at excels extensive library of built in chart formats, and then learn how to modify individual components of the chart, from the chart area, to the Axis, to the legend, data series, etc.
Formatting Charts
This lesson will delve deeper into configuring the X axis.  We will learn how to scale the axis, orient the text, set up a date based chart and more.
Configuring the X Axis

In this lesson, we'll see how to configure the Y axis.  We'll see how to orient the values, scale the units (hundreds, thousands, etc), and even set a logrithmic scale.

Configure Y axis
In this lesson we will learn how to highlight your data by adding data tables and data labels to your chart.  The data table will integrate the values of your data into the chart beneath the X axis.  Use data labels to display the values directly on the data points.
Data Labels and Data Tables