Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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. :)
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: An Introduction | Meet Dave- Your guide/ trainer/ host for the class|
Dave McCubbin | BackgroundPreview
General Course Overview, Structure and Style of the ClassPreview
Class Files | Please Download To Follow Along With The Lessons
|Section 2: A High Level Overview Of All The Bits And Pieces Common To Microsoft Office|
Even The Geniuses Start Somewhere
How to Open Excel/ Other MS Office ProgramsPreview
Getting A Feel For The Excel EnvironmentPreview
What Is Thing Called the Ribbon...Preview
A Dialog Box Launcher?Preview
QAT or Quick Access Toolbar | A Good Place To Store Common CommandsPreview
Contextual Tabs | Annoying Yet RelevantPreview
Backstage View | Sounds Worse Than It IsPreview
How to Create A New Excel FilePreview
How To Save An Excel FilePreview
How To Close An Excel FilePreview
Opening An Existing Excel FilePreview
Cut Copy And PastePreview
The Magical Undo ButtonPreview
How To Search And Find ItemsPreview
Smart Art | An Easy Way To Make Fancy Diagrams
Adding Shapes Into Your File
How To Add Cartoons (AKA Clip Art) To Your File
How To Add A Picture (Read: Real Photograph) To Your File
|Section 3: Excel's Fundamentals | The Need to Know Topics|
Square One - Just What Is Excel Anyway?Preview
An Overview Of The Excel EnvironmentPreview
The Appearance Of The Mouse Pointer | What Does It Mean?
How To Add Content To Cells
Modifying (Editing) Cell Content
Selecting Cells | Or Chunks of Cells
How To Maneuver In Excel | Moving Within And Around Sheets
Practice Adding Content To An Excel File
|Section 4: The Starting Point When Doing Math In Excel|
How Excel Thinks When It Does Math Calculations
Understanding Functions | What The Term Means And How Excel Uses Them
Adding Up Numbers | AKA The Sum Function
Auto Fill Explained And How Using It Will Save You Time
The Home Of The Functions | Where Your Math Formulas Live
How To Calculate The Average Of Some Numbers
Other Simple Math | Subtract, Multiply and Divide
|Section 5: How To Dress Up Your Data And Make It Look Nice | AKA Formatting|
Overview | What Does It Mean To Format A Spreadsheet
Changing Cell and Font Color
Changing Number Formats
Using the Format Painter
Understanding Formats As Layers
Actual Vs. Displayed Numbers
Insert Rows And Columns
Insert Cells Into A Spreadsheet
Deleting Rows And Columns
The Pesky Pound Sign
Merge And Center Content Across A Few Columns
Hide and Unhide Columns
Insert Sheets Into A Workbook
Change Worksheet Tab Colors
How To Move And Copy Worksheets
The Percent Icon | More Than You Might Think
Aligning Content Within Cells
Adding Borders To Cells And How Borders Differ From Gridlines
Slick Formatting With Conditional Formatting And Some Potential Pitfalls As Well
Dates In Computers | Did You Know They Are Really Serial Numbers
|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
The File, Print Command | A Walkthrough
Page Break Preview | Your Best Bet To Cure Printing Ailments
Add Header And Footers For Your Worksheet
Margins | The Blank Area Around Your Paper
The Print Area And How It May Save You Some Aggravation With Repetitive Printing
How To Make Column Heading Repeat When Printing Long Lists Of Data
|Section 7: INTERMISSION: A Look At How Excel Is Built And The Effect On Future Lessons|
Take A Breather And A Quick Look ForwardPreview
|Section 8: Starting Down The Road Of Math | The Heart Of Excel|
Overview of Excel Functions | Getting the Big Picture
MAX And MIN | Otherwise Known As High And Low
COUNT And COUNTA | You Can Count On Them To Help
Understanding the Absolute Reference | It's Just A Fancy "Anchor"
The Beauty of Named Ranges
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
SUMIF and SUMIFS | Adding Things Up That Meet Your Criteria
COUNT IF | A Twist On The SUMIF
The Power Of Linking
Rounding | It A'int What You Think
3-D Formulas | A Fancy Way To Build Formulas Across Sheets
DSUM | An Oldie But A Goodie
IFERROR | A Cool Way To Cover Up Error Messages
MATCH and INDEX Explained, Then Combined For Some Real Magic
Math With Text | TRIM
Math With Text | UPPER
Math With Text | Concatenation
Math With Text | PROPER
Math With Text | LEN
Math With Text | RIGHT
Math With Text | LEFT
Math With Text | "De-concatenation"
Working With Dates And Time | DATEDIF
Dates And Time | How Excel Handles Time And Some Hourly Time Calculations
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.