-
Elements of the Excel Screen - Click This Do What?
5 Lessons-
PreviewElements of the Excel Screen - Click This Do What? Ever hear of the Ribbon? Tab?
-
StartDid Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?
-
StartCan't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?
-
StartThe Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?
-
StartQuiz 2 - Got Skills!
-
-
Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!
4 Lessons -
Begin With The End In Mind - 7 Steps To Excel Success
1 Lesson-
PreviewBegin With the End in Mind - 7 Steps To Excel Success
-
-
Step 1 - DESIGN - It's So Easy In The 21st Century
1 Lesson-
StartTemplates - Learn how to to tame the "World's Most Dangerous Program."
-
-
Step 2 - BUILD - Building Your Worksheet
12 Lessons-
StartFive Things That Can Go Into An Excel Worksheet - F2 Is Your Friend
-
StartMinimize Repetition - Learn The Auto Fill Handle.
-
StartLearn How To Create A Create Custom Fill Series - No More Typing That List!
-
StartHow Many Rows and Columns In Excel? Select All And The Name Box Will Tell You
-
StartNavigation Shortcuts
-
StartQuiz 6 - BUILD
-
StartInsert Rows and Columns Like A Professional
-
StartSelecting Cells And Ranges Like a Professional
-
StartUniversal Shortcuts - You Probably Already Know Them And Did Not Realize It.
-
StartInsert A Worksheet, Name It, Rename It, Move It
-
StartMove Worksheets To Another Workbook - Make Worksheet Names Standout With Color
-
StartQuiz 7 - You Are Getting Good At This!
-
-
Step 3 - CALCULATIONS - Add Some Calculations
15 Lessons-
StartPlease Excuse My Dear Aunt Sally! - Time To Remember Some 5th or 6th Grade Math.
-
StartFormulas - The Heartbeat Of Excel - The Cells Remain The Same What Changes Is..?
-
StartYou Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend
-
StartExample Of The Moment You Realize - It's Time To Start Thinking About Functions
-
StartWhat Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out!
-
StartThe Most Basic Function - The AutoSum - So Much More Than Just Sum!
-
StartQuiz 8 - Skill Snack - CALCULATIONS
-
PreviewLearn To Delegate To Excel - Just Press Alt+= - The AutoSum - More Than Just SUM
-
StartQuick Overview Of The Insert Function Tool - Your Search Engine For Functions
-
PreviewQuick Tip - Zoom To Selection
-
StartIntroduction to 3D Referencing - Enter Data In One Cell, It Appears In Another
-
Start3D Referencing In Action
-
Start3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!
-
StartPractice More 3D Referencing - Did You Know You Can Link Your Workbooks?
-
StartQuiz 9 - Let's Keep On Learning - CALCULATIONS
-
-
Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
6 Lessons-
StartWhy Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A
-
StartLet's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts
-
StartFormatting Money - Should You Pick The Currency Method Or The Accounting Method?
-
StartAlignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)
-
StartThe Format_Painter
-
StartQuiz 10 - Let's Keep On Learning - FORMATTING
-
-
Step 5 - REPORTING - Garbage In...Garbage Out - What About Charts?
13 Lessons-
Start7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly
-
StartQuiz 11 - Quick Skill Snack - The 7 Habits of Effective Lists
-
StartOrganize And Display Data - Sort It Out- But Avoid Merged Cells
-
StartContinue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together
-
StartThe BIG Sort Buton
-
StartSometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease
-
StartQuiz 12 - Skill Snack - REPORTING
-
StartThe Filter That Lives A Healthy Lifestyle - Auto Filter
-
StartWant To See What Your Numbers Are Saying? How About A Graphical Representation?
-
StartVisualize Your Data With Charts - Insert Charts And See What Your Numbers Say
-
StartDifferent Charts For Different Reasons - Change Chart Types - Make Them Pretty
-
StartSparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
-
StartQuiz 13 - Let's Keep On Learning - REPORTING
-
-
Step 6 - PRINTING - Learn Where The "Fit-to-One-Page" Button Is Located
5 Lessons-
StartPrint Correctly - Start With a Print Preview - There Is More Than One Way
-
StartTell Excel What You Want To Print - Set The Print Area
-
StartNow That Excel Knows What To Print Let's Make It All Fit To One Page
-
StartNow That We Can Print Properly - How About Some Headers And Some Footers?
-
StartQuiz 14 - Let's Keep On Learning - PRINTING
-

What People Are Saying About Us
5
Top Rated
Keanna Balmores
Learning Excel from the Kaua'i Boy!!
Billy is an awesome Excel coach! Ive taken two courses with him and learned so much. The way he explains the methods and vocabulary of Excel was easy to retain. I've used the knowledge I gained in these courses to exceed standards in my workplace.
Isabella Eickenhorst
Awesome
What a great course
Jennifer Villanueva Villanueva
Awesome excel class
I have the bare minimum computer skills and I was able to take so much from this class. The classes are upbeat and lively. Billy makes excel fun to learn and is always there to support you along the way!
Rate this course