Featured Shortcuts - The Newest Lectures And Discussion Answers - Featured Here!
- SHARE A Workbook and MERGE Shared Workbooks Using A Secret Tool!
- Open a NEW Workbook, and Easily Duplicate a Worksheet
In The Beginning... Some Quick Tips, And Basic Elements Of The Excel Screen
- HONE YOUR SKILLS - 4 Shortcuts in 17 Seconds!
- CTRL+A - Instantly Select Your Desired Range Of Data Like a Pro!
- GO HERE - Learn The Proper Terminology - Basic Elements Of The Screen-PART 1
- NOW HERE - Learn The Proper Terminology - Basic Elements Of The Screen - PART 2
Let's Get Back To The Basics
- Use The Clear Format Tool Like A Professional!
- FORMATTING SHORTCUTS-You ever have to Bold, Underline, Italicize, Strikethrough?
- UNIVERSAL SHORTCUTS - They work in just about every program you work with!
Entering and Editing Data
- Where Are You? An Easy Push-up For Your Brain To Get It Warmed Up And Ready.
- TOP SECRET! - Ever Hear Of Secret Features In Excel? - Well, Meet The QAT
- Text To Columns- That's Nice, I'll take Care Of It! - Separate Text into Columns
- What's The Difference? - Are You Really In Excel 2013? Can You Tell The Version?
- Quickly Insert Rows And Columns
- Quickly Insert BLANK Rows In Between Cells - I Call It "Sorting Them In"
- Go To Special - Find Blank Rows and Delete. Find Specific Text and Delete Row.
- Did You Say Go To Special Again?! - Here Is Another Twist To Removing Blank Rows
- Speed Up Your Data Entry - Data Validation, VLOOKUP, Format As Table, Date Stamp
- TRANSPOSE Your Data - Copy Vertical Data Range And Paste It Horizontally!
Words In Excel? Yikes! - Make It Work With Easy Text Functions
- I Gotta Change The Case! - UPPER_LOWER_PROPER
- CONCATENATE - Join The Contents Of Cells Into One Cell - Words Into Sentences
- EXCEL is for math. When you use text you have to use TEXT functions like these.
Auto Fill Magic
- ID Columns - Quick Tip On Organizing Your Data - Keep Your Stuff In Order!
- Imagine Your First Drop-Down And A Bunch More Stuff
Calculations - Using FUNCTIONS and Building Formulas Like a Professional User!
- F4 To Anchor- This Is Going To Change Your Life - Make A Cell Reference Absolute
- Date & Time Function. This Is Only One Of Many Ways - So Easy!
- VLOOKUP - Looking For Something Over There And You Want The Answer Over Here?
- Build A Mini-Dashboard Using The PivotTable Wizard! The What Wizard? PivotTable!
- MAGICAL PIVOTTABLE - Slice And Dice Your Data Like A Rocket Scientist On Charts
- With over 300 functions in Excel it's hard to learn how, when, and which to use.
- Tired Of Seeing #N/A In Your Empty Cells? - Check Out The IFNA Function in 2013
Working With Other Documents And Saying This Will Make You Sound Smart.
- I Forgot To SHARE The Workbook! How Can I Merge The Two Versions I Now Have?
- For Your Charts Only - F11 And The Little Known Att+F1
- Let Excel Tell You What It Likes Best - The Quick Analysis Tool - Recommended!
- Can't figure out which chart to use? Where to put the total? Put the chart here!
Z-STUFF The French Section - No Specific Category For These Goodies - More Stuff
- Quick Steps To Record A Macro - Downloadable GIF
- 200 Excel 2013 Shortcuts For You To Print Out And Share
- 7 Steps To Worksheet Success - It's Gotta Be Right! (rough cut edit)
Video Answers
- This is for you Kanishk.
Here Are The Announcements - Good Stuff In Here!
- Great News! New office hours and Habit #2 - 12/03/2015
BONUS SECTION
- My 30 Favorite Excel Power-Tips ⚡⚡⚡ (01/08/2021)
- 8 Secrets In Excel (Aloha Friday Live Stream)
- How To Use Excel 3D Referencing To Add (sum) Your Worksheets ??➕?❗??
