ALOHA! -- CONGRATULATIONS! -- WELCOME!
- START HERE -- ALOHA! -- CONGRATULATIONS! -- DOWNLOAD YOUR WORKBOOK HERE!
- IMPORTANT - Please Start Here! -- This Is The Worlds Easiest Quiz!
Elements of the Excel Screen - Click This Do What?
- Elements of the Excel Screen - Click This Do What? Ever hear of the Ribbon? Tab?
- Did Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?
- Can't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?
- The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?
- Got Skills?
Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!
- Microsoft 365 - The Latest Version
- Open Da Maka-Look At The Ribbon. The Simplest Way To Know The Version You're In.
- Who Made This Workbook? Get Into The File Tab and Learn The Backstage View.
- So What's The Difference?
Saving
- F12 - Save As - I Prefer The "Old School" Save As.
- Saving and Compatibility. What Happened To The Sparklines? Save As What Version?
- Saving and Compatibility
QAT
- The Quick Access Toolbar - QAT - Find The Secret Features Of Excel
- The Secret Features - QAT
Begin With The End In Mind - 7 Steps To Excel Success
- Begin With the End in Mind - 7 Steps To Excel Success
Step 1 - DESIGN - It's So Easy In The 21st Century
- Templates - Learn how to to tame the "World's Most Dangerous Program."
Step 2 - BUILD - Building Your Worksheet
- Five Things That Can Go Into An Excel Worksheet - F2 Is Your Friend
- Minimize Repetition - Learn The Auto Fill Handle.
- Learn How To Create A Create Custom Fill Series - No More Typing That List!
- How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You
- Navigation Shortcuts
- Skill Snack - BUILD
- Insert Rows and Columns Like A Professional
- Selecting Cells And Ranges Like a Professional
- Universal Shortcuts - You Probably Already Know Them And Did Not Realize It.
- Insert A Worksheet, Name It, Rename It, Move It
- Move Worksheets To Another Workbook - Make Worksheet Names Standout With Color
- You Are Getting Good At This!
Step 3 - CALCULATIONS - Add Some Calculations
- Please Excuse My Dear Aunt Sally! - Time To Remember Some 5th or 6th Grade Math.
- Formulas - The Heartbeat Of Excel - The Cells Remain The Same What Changes Is..?
- You Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend
- Example Of The Moment You Realize - It's Time To Start Thinking About Functions
- What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out!
- The Most Basic Function - The AutoSum - So Much More Than Just Sum!
- Skill Snack - CALCULATIONS
- Learn To Delegate To Excel - Just Press Alt+= - The AutoSum - More Than Just SUM
- Quick Overview Of The Insert Function Tool - Your Search Engine For Functions
- Quick Tip - Zoom To Selection
- Introduction to 3D Referencing - Enter Data In One Cell, It Appears In Another
- 3D Referencing In Action
- 3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!
- Practice More 3D Referencing - Did You Know You Can Link Your Workbooks?
- Let's Keep On Learning - CALCULATIONS
Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
- Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A
- Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts
- Formatting Money - Should You Pick The Currency Method Or The Accounting Method?
- Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)
- The Format_Painter
- Let's Keep On Learning - FORMATTING
Step 5 - REPORTING - Garbage In...Garbage Out - What About Charts?
- 7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly
- The 7 Habits of Effective Lists - Quick Skill Snack
- Organize And Display Data - Sort It Out- But Avoid Merged Cells
- Continue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together
- The BIG Sort Buton
- Sometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease
- Skill Snack - REPORTING
- The Filter That Lives A Healthy Lifestyle - Auto Filter
- Want To See What Your Numbers Are Saying? How About A Graphical Representation?
- Visualize Your Data With Charts - Insert Charts And See What Your Numbers Say
- Different Charts For Different Reasons - Change Chart Types - Make Them Pretty
- Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
- Let's Keep On Learning - REPORTING
Step 6 - Printing - Learn Where The "Fit-to-One-Page" Button Is Located
- Print Correctly - Start With a Print Preview - There Is More Than One Way
- Tell Excel What You Want To Print - Set The Print Area
- Now That Excel Knows What To Print Let's Make It All Fit To One Page
- Now That We Can Print Properly - How About Some Headers And Some Footers?
- Let's Keep On Learning - PRINTING
Step 7 - Macros - Delegate to Excel
- What's A Macro?
- Recording Your 1st Macro - Yes, It's That Easy
- Run Your Macro
- Wrap Up
- Let's Keep On Learning - MACROS
ADDITIONAL RESOURCES - Live Workshop Recordings - Shortcuts - And More...
- 200+ Keyboard Shortcuts
- My 15 Favorite Excel Power-Tips: Empower Yourself Get Faster Better Spreadsheets
- 15 More Of My Favorite Excel Power-Tips
- 8 Secrets In Excel (Aloha Friday Live Stream)
- How To Use Excel 3D Referencing To Add (sum) Your Worksheets ??➕?❗??
BONUS SECTION
- Learn More With Mr. Aloha (BONUS LECTURE)
