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.
161 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.
161 students enrolled
Published 8/2012
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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!

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
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
04:02

Sorting Data Capabilities
Sorting
07:39

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

Filters
07:32

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

Paste Special
16:02
+
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
16:13

Formatting via the Alignment Section of the Home Tab and the Format Cells Dialog Box
Formatting Alignment
11:23

Formatting via the Number Section of the Home Tab and the Format Cells Dialog Box
Formatting Numbers
11:08

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
07:55

Understanding named ranges and creating them to make spreadsheets more efficient

Named Ranges
05:08


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

More Functions
12:29
+
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
07:30


Using many of Excel's text based functions

Text Functions
15:03

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

Remove Duplicates
02:55

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
12:36

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

Find And Replace
05:30

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

Tables
08: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.

Goal Seek
07:32
+
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
06:23

Utilizing Excels library of automatic formats for PivotTables
Format PivotTables
11:24

Useful ways for sorting and filtering in PivotTables

Manipulate PivotTables
08:13

Adding and removing subtotals and grand totals to rows in PivotTables
PivotTable Totals
03:21
+
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
04:23

Creating new metrics in your pivot table based on a calculation

Calculated Fields
05:30

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

PivotTable Maintenance
04:31

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

Slicers
06:04
+
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

Viewing
05:56

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

Printing
14:19


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
06:55
+
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
08:14

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
13:02

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
09:30

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
06:00

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
10:56
About the Instructor
Tom Hinkle
4.4 Average rating
9 Reviews
161 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
162 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>