Excel: Soup to Nuts
4.8 (21 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.
402 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: Soup to Nuts to your Wishlist.

Add to Wishlist

Excel: Soup to Nuts

Become A Master Of Excel And Learn To Use Excel Like A True Professional With This Comprehensive, Yet Fun Excel Course
4.8 (21 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.
402 students enrolled
Created by Dave McCubbin
Last updated 2/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 12 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The goal is simple, yet lofty. To provide a solid foundation in Excel so you look like a rock star
  • Specifically you'll learn the topics sought after by most employers
  • Plus taking existing skills to the proverbial next level
View Curriculum
Requirements
  • None. Just a desire to learn and an honest effort
Description

This Excel class is comprehensive guide during which you will learn a whole host of topics. It represents the most common Excel "stuff" used in modern business and understanding the content within will arguably catapult you into the upper echelon of Excel users.

During the class you will learn by watching the instructor actually demonstrate the topics on screen using annotations to make sure you don't get lost, along with providing full, detailed explanation of the subjects. This class starts at absolute square one, and then gradually walks through the remaining topics explaining the most relevant aspects of Excel in a simple, east, yet light-hearted, fun approach.

The "secret" to Excel is this-- realize there are NO such categories like Basic, Intermediate and Advanced Excel. They simply do not exist. With Excel you learn the basics, from there it's nothing but another layer of fundamentals. Phrased differently, the Excel curriculum is topical, not progressive. Meaning the order in which you learn things does not matter since all the topics are not interrelated. Therefore, knowing this fact, when you look at the class as nothing more than a bunch of individual topics that have been strung together, Excel becomes a breeze!

Last, no matter what version of Excel you are using there has always been some core topics that represent the "need to know". Phrased differently, all the material in this class contains the essentials and is transferable to all versions of Excel- 2007, 2010, 2013 and even 2016. Sure there are some differences between the versions, but they are not so drastic as to really mess you up. :)

Who is the target audience?
  • Anyone who is looking to become fully competent in Excel
  • This class is applicable for any version of Excel 2007, 2010, 2013 (Excel 2010 was used to create the class)
Students Who Viewed This Course Also Viewed
Curriculum For This Course
134 Lectures
12:13:09
+
An Introduction | Meet Dave- Your guide/ trainer/ host for the class
3 Lectures 03:22


Class Files | Please Download To Follow Along With The Lessons
00:28
+
Excel's Fundamentals | The Need to Know Topics
8 Lectures 23:44


The Appearance Of The Mouse Pointer | What Does It Mean?
02:43

How To Add Content To Cells
05:19

Modifying (Editing) Cell Content
04:10

Selecting Cells | Or Chunks of Cells
02:16

How To Maneuver In Excel | Moving Within And Around Sheets
01:59

Practice Adding Content To An Excel File
02:08
+
The Starting Point When Doing Math In Excel
7 Lectures 38:36
How Excel Thinks When It Does Math Calculations
07:19

Understanding Functions | What The Term Means And How Excel Uses Them
06:42

Adding Up Numbers | AKA The Sum Function
06:19

Auto Fill Explained And How Using It Will Save You Time
04:35

The Home Of The Functions | Where Your Math Formulas Live
02:57

How To Calculate The Average Of Some Numbers
06:12

Other Simple Math | Subtract, Multiply and Divide
04:32
+
How To Dress Up Your Data And Make It Look Nice | AKA Formatting
22 Lectures 01:14:06
Overview | What Does It Mean To Format A Spreadsheet
01:49

Changing Fonts
03:07

Changing Cell and Font Color
01:25

Changing Number Formats
02:17

Using the Format Painter
02:56

Understanding Formats As Layers
05:56

Actual Vs. Displayed Numbers
04:13

Insert Rows And Columns
03:28

Insert Cells Into A Spreadsheet
02:24

Deleting Rows And Columns
01:28

The Pesky Pound Sign
03:38

Merge And Center Content Across A Few Columns
02:25

Hide and Unhide Columns
02:09

Insert Sheets Into A Workbook
02:02

Change Worksheet Tab Colors
01:18

How To Move And Copy Worksheets
02:16

Renaming Worksheets
01:07

The Percent Icon | More Than You Might Think
03:40

Aligning Content Within Cells
05:44

Adding Borders To Cells And How Borders Differ From Gridlines
05:01

Slick Formatting With Conditional Formatting And Some Potential Pitfalls As Well
13:21

Dates In Computers | Did You Know They Are Really Serial Numbers
02:22
+
Ok, So You've Typed It, Made It Look Nice, Now How Do You Print It
7 Lectures 27:03
Printing | It's A Bunch Of Moving Parts
00:49

The File, Print Command | A Walkthrough
02:26

Page Break Preview | Your Best Bet To Cure Printing Ailments
12:09

Add Header And Footers For Your Worksheet
04:36

Margins | The Blank Area Around Your Paper
01:06

The Print Area And How It May Save You Some Aggravation With Repetitive Printing
03:06

How To Make Column Heading Repeat When Printing Long Lists Of Data
02:51
+
INTERMISSION: A Look At How Excel Is Built And The Effect On Future Lessons
1 Lecture 01:24
+
Starting Down The Road Of Math | The Heart Of Excel
30 Lectures 03:30:21
Overview of Excel Functions | Getting the Big Picture
00:47

MAX And MIN | Otherwise Known As High And Low
01:55

COUNT And COUNTA | You Can Count On Them To Help
03:08

Understanding the Absolute Reference | It's Just A Fancy "Anchor"
08:58

The Beauty of Named Ranges
10:33

In this segment we will look at three functions- the basic IF Statement, the 'IF AND' and IF OR'. If you are unfamiliar with the AND/OR condition, please make sure you watch the "Advanced Filtering | For When The Basic Filter Won't Cut It" tutorial first, since it provides and in-depth explaination of the AND/ OR condition.

IF Statement Demystified | Examining The IF, IF AND, IF OR
23:47

VLOOKUP Made Simple
16:30

SUMIF and SUMIFS | Adding Things Up That Meet Your Criteria
09:47

COUNT IF | A Twist On The SUMIF
02:37

The Power Of Linking
16:22

Rounding | It A'int What You Think
06:25

3-D Formulas | A Fancy Way To Build Formulas Across Sheets
05:04

DSUM | An Oldie But A Goodie
05:36

IFERROR | A Cool Way To Cover Up Error Messages
04:31

MATCH and INDEX Explained, Then Combined For Some Real Magic
15:54

Math With Text | TRIM
01:43

Math With Text | UPPER
01:03

Math With Text | Concatenation
04:28

Math With Text | PROPER
00:58

Math With Text | LEN
01:39

Math With Text | RIGHT
01:41

Math With Text | LEFT
01:32

Math With Text | "De-concatenation"
04:28

Working With Dates And Time | DATEDIF
03:55

Dates And Time | How Excel Handles Time And Some Hourly Time Calculations
15:22

Mindbender Formula | ARRAY Calculations
09:18

Mindbender Formula | The SUMPRODUCT Function
03:21

Mindbender Formula | The OFFSET Function
10:39

How To Reverse Engineer A Spreadsheet | AKA Auditing
12:31

Creating Dynamic Named Ranges | Some People Like This
05:49
+
List Management: Freeze Panes, Grouping, Sorts, Filters, Subtotals, Pivot Tables
14 Lectures 02:18:29
List Management | How To Avoid Aggravation With The Freeze Panes
09:58

List Management | How To Group Data
03:14

Sorting | How To Alphabetize (Organize) Your Data
09:12

Sorting | Some Cool Tricks To Impress Your Friends
09:50

Filters | How To Play 'Go Fish' On Your List
12:48

Advanced Filtering | For When The Basic Filter Won't Cut It
16:08

Subtotals | Putting Calculations Within Your List
15:51

Pivot Tables | An Introduction
15:40

Pivot Tables | How To Do Math Calculations Within Pivot Tables
07:36

Pivot Tables | Calculated Fields, A Step Beyond Standard Math In Pivot Tables
13:22

Pivot Tables | Creating Charts From Your Pivot Table
03:43

Pivot Tables | Miscellaneous Topics
12:21

Pivot Tables | Troubleshooting And How To Fix Common Errors
04:38

Pivot Tables | Slicers, The Glorified Filter
04:08
+
Charting | Turning Your Data Into A Graph
1 Lecture 11:40
Charting Data In Excel
11:40
6 More Sections
About the Instructor
Dave McCubbin
4.8 Average rating
21 Reviews
402 Students
1 Course
Training Alchemist |Founder of Skootzi

Dave McCubbin has been engaged in computer training over the past 15 years and is the founder and CEO of The People's Trainer.com.  During which time he has been fortunate to work with many great people, and been able to impact them through his unique, laid-back, fun, yet quirky, learning style. He has trained extensively on domestically and internationally, along with personally training over 100,00 people.

He does not believe in overly polished, eloquent presentations. Rather he focuses on a more conversational approach to learning. Subsequently, he does NOT consider himself and expert by any stretch. Why? Simply because that term reeks of arrogance and is not his modus operendi. Instead he views himself as a perpetual apprentice in the computer field and believes there is always something new to be learned, no matter how long you've been doing "it".

True to form, he would like to thank the people that have mentored him throughout the years.