Excel Essentials
4.4 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
158 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Essentials to your Wishlist.

Add to Wishlist

Excel Essentials

Learn Excel the FUN way! By working through exercises along with the video tutorial.
4.4 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
158 students enrolled
Published 8/2012
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum

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 is the target audience?
  • Beginners: We'll teach you Excel, and make you good!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 52 Lectures Collapse 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
About the Instructor
Tom Hinkle
4.4 Average rating
9 Reviews
158 Students
1 Course
Business Intelligence Professional

Professionally, Tom has been in the IT/Computer field for over 20 years.  Much of that time has been spend on 'end user tools' such as Microsoft Visual Basic, Excel and Access.  Tom has spent over 10 years in financial services companies building and maintaing complex spreadsheet models and utilizing a classical programming background to develop accurate and robust reporting solutions. 

From a personal standpoint, Tom LOVES spending time with his wonderfamily, skiing (snow or water), fitness, and sharing his extensive knowledge of microsoft products whenever he gets the chance.

Excel  Rain Man
4.4 Average rating
9 Reviews
159 Students
2 Courses
Providing expertise in the art of Excel Spreadsheet Customization, Outsourcing & Education.

ExcelRainMan.com is designed to help users of every level with problems concerning Excel spreadsheets. Regardless of what industry you are in, most individuals at some point find themselves dealing with the utter aggravation of Microsoft Excel. As the Excel Rain Man Team, people can send us their spreadsheet related questions/problems and in turn, we bring our mad skills to solve whatever the issue may be. We also offer customized classes as well as video tutorials. Check us out at www.excelrainman.com.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /></font>