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.6 (7 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.
374 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 134
  • Length 12 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 2/2014 English

Course 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. :)

What are the requirements?

  • None. Just a desire to learn and an honest effort

What am I going to get from this course?

  • 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

What 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)

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: An Introduction | Meet Dave- Your guide/ trainer/ host for the class
Dave McCubbin | Background
Preview
01:01
General Course Overview, Structure and Style of the Class
Preview
01:53
Class Files | Please Download To Follow Along With The Lessons
Article
Section 2: A High Level Overview Of All The Bits And Pieces Common To Microsoft Office
Even The Geniuses Start Somewhere
00:51
How to Open Excel/ Other MS Office Programs
Preview
00:40
Getting A Feel For The Excel Environment
Preview
01:15
What Is Thing Called the Ribbon...
Preview
04:10
A Dialog Box Launcher?
Preview
01:08
QAT or Quick Access Toolbar | A Good Place To Store Common Commands
Preview
03:17
Contextual Tabs | Annoying Yet Relevant
Preview
02:09
Backstage View | Sounds Worse Than It Is
Preview
01:24
How to Create A New Excel File
Preview
01:13
How To Save An Excel File
Preview
03:21
How To Close An Excel File
Preview
00:52
Opening An Existing Excel File
Preview
01:09
Cut Copy And Paste
Preview
04:33
The Magical Undo Button
Preview
01:56
How To Search And Find Items
Preview
02:06
Smart Art | An Easy Way To Make Fancy Diagrams
05:49
Adding Shapes Into Your File
04:22
How To Add Cartoons (AKA Clip Art) To Your File
01:47
How To Add A Picture (Read: Real Photograph) To Your File
01:50
Section 3: Excel's Fundamentals | The Need to Know Topics
Square One - Just What Is Excel Anyway?
Preview
02:43
An Overview Of The Excel Environment
Preview
02:26
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
Section 4: The Starting Point When Doing Math In Excel
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
Section 5: How To Dress Up Your Data And Make It Look Nice | AKA Formatting
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
Section 6: Ok, So You've Typed It, Made It Look Nice, Now How Do You Print It
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
Section 7: INTERMISSION: A Look At How Excel Is Built And The Effect On Future Lessons
Take A Breather And A Quick Look Forward
Preview
01:24
Section 8: Starting Down The Road Of Math | The Heart Of Excel
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
23:47

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.

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dave McCubbin, 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.

Ready to start learning?
Take This Course