Excel Essentials

Learn Excel the FUN way! By working through exercises along with the video tutorial.
4.4 (8 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.
146 students enrolled
$30
Take This Course
  • Lectures 52
  • Contents Video: 5.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2012 English

Course Description

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!

What am I going to get from this course?

  • 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

What is the target audience?

  • Beginners: We'll teach you Excel, and make you good!

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
06:18

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

1.3 MB


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

38.1 kB

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

13.1 kB


Download this file to follow along with the Ribbon lecture

929.4 kB

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

04:02

Using Freeze Panes to efficiently view spreadsheets, Unfreeze Panes

07:39
Sorting Data Capabilities
07:32

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

16:02

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

Section 2: Formatting with Excel
30.2 kB

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

16:13
Formatting via the Font Section of the Home Tab and the Format Cells Dialog Box
11:23
Formatting via the Alignment Section of the Home Tab and the Format Cells Dialog Box
11:08
Formatting via the Number Section of the Home Tab and the Format Cells Dialog Box
10:50

Enhancing reports with Conditional Formatting (creating thematic maps)

Section 3: Formulas - Introduction
42.7 kB


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

03:31
The basics... Entering formulas in Excel and copying them
07:55

Utilizing absolute and relative references and partial absolute references

05:08

Understanding named ranges and creating them to make spreadsheets more efficient

12:29


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

Section 4: Formulas - Intermediate
128.7 kB

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

07:30

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

15:03


Using many of Excel's text based functions

02:55

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

07:01

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

Section 5: Drop Down boxes, Working with Tables, and Goal Seek. Cool tools.
29.6 kB

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

12:36

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.

05:30

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

08:32

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

07:32

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

Section 6: Pivot Tables - Introduction
143.4 kB

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

04:12


What is a PivotTable? Sample PivotTables…

06:23
The basics... Learning how to build rudimentary PivotTables from Excel data
11:24
Utilizing Excels library of automatic formats for PivotTables
08:13

Useful ways for sorting and filtering in PivotTables

03:21
Adding and removing subtotals and grand totals to rows in PivotTables
Section 7: Pivot Tables - Intermediate
187.7 kB

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

04:23
Adding multiple values or metrics to PivotTables
05:30

Creating new metrics in your pivot table based on a calculation

04:31

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

06:04

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

Section 8: Printing and Screen settings
50.0 kB

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

05:56

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

14:19

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

04:29


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

06:55

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

Section 9: Building Charts
50.9 kB

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

08:14

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

06:06

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

13:02
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.
09:30
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.
06:00

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.

10:56
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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tom Hinkle, 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.

Instructor Biography

Excel Rain Man, 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>

Ready to start learning?
Take This Course