Zenler Player
Your course is loading. Hang tight.
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Back to curriculum
0% Complete
0% Complete
Unleashing AI in Excel: Mastering LABS.GENERATIVEAI for Enhanced Data Tasks
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
Use The Clear Format Tool Like A Professional!
FORMATTING SHORTCUTS - You ever have to Bold, Underline, Italicize, Strike-through?
UNIVERSAL SHORTCUTS - They work in just about every program you work with!
Excellent Habit - Format As Table And Insert A Total Row In Seconds!
How To Make An Easy Data Entry Form
(QUIZ) 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!
Learn How To Use Worksheet Cell Protection In Excel
Create A Drop-down List From Data On Another Excel Worksheet
Learn How To Make A Dependent Drop-down List
Add Color To Your Drop-down Lists In Excel!
Excel 365 Function: ARRAYTOTEXT - Live Stream Recording
Introducing Dynamic Arrays with TEXTJOIN and TEXSPLIT
I Gotta Change The Case! - UPPER_LOWER_PROPER
CONCATENATE - Join The Contents Of Cells Into One Cell - Words Into Sentences
(QUIZ) EXCEL is for math. When you use text you have to use TEXT functions like these.
ID Columns - Quick Tip On Organizing Your Data - Keep Your Stuff In Order!
Imagine Your First Drop-Down And A Bunch More Stuff
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
(QUIZ) 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
XLOOKUP - How To Use The XLOOKUP Function
XLOOKUP - How To Use The [match_mode] And The [search_mode] Arguments
XLOOKUP - How To Use The XLOOKUP To Replace VLOOKUP, HLOOKUP and INDEX and MATCH
Level Up Your Excel Lookup Skills with VLOOKUP, XLOOKUP & Spilled Arrays
Take Your Excel Lookups to Pro Level with Named Ranges & Nested Formulas
Open a NEW Workbook, and Easily Duplicate a Worksheet
SHARE A Workbook and MERGE Shared Workbooks Using A Secret Tool!
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!
(QUIZ) Can't figure out which chart to use? Where to put the total? Put the chart here!
Excel Conditional Formatting - Combine Icons and Databars In One Cell ✅ (Live)
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)
338 EXCEL KEYBOARD SHORTCUTS - 2022
227 MAC OS EXCEL KEYBOARD SHORTCUTS - 2022
Featured Shortcuts - The Newest Lectures And Discussion Answers - Featured Here!
Unleashing AI in Excel: Mastering LABS.GENERATIVEAI for Enhanced Data Tasks
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, Strike-through?
UNIVERSAL SHORTCUTS - They work in just about every program you work with!
Entering and Editing Data
Excellent Habit - Format As Table And Insert A Total Row In Seconds!
How To Make An Easy Data Entry Form
(QUIZ) 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!
Learn How To Use Worksheet Cell Protection In Excel
Data Validation - Let's Make Some Drop-down Lists
Create A Drop-down List From Data On Another Excel Worksheet
Learn How To Make A Dependent Drop-down List
Add Color To Your Drop-down Lists In Excel!
Words In Excel? Yikes! - Make It Work With Easy Text Functions
Excel 365 Function: ARRAYTOTEXT - Live Stream Recording
Introducing Dynamic Arrays with TEXTJOIN and TEXSPLIT
I Gotta Change The Case! - UPPER_LOWER_PROPER
CONCATENATE - Join The Contents Of Cells Into One Cell - Words Into Sentences
(QUIZ) 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
(QUIZ) 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
XLOOKUP - How To Use The XLOOKUP Function
XLOOKUP - How To Use The [match_mode] And The [search_mode] Arguments
XLOOKUP - How To Use The XLOOKUP To Replace VLOOKUP, HLOOKUP and INDEX and MATCH
Level Up Your Excel Lookup Skills with VLOOKUP, XLOOKUP & Spilled Arrays
Take Your Excel Lookups to Pro Level with Named Ranges & Nested Formulas
Working With Other Documents And Saying This Will Make You Sound Smart.
Open a NEW Workbook, and Easily Duplicate a Worksheet
SHARE A Workbook and MERGE Shared Workbooks Using A Secret Tool!
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!
(QUIZ) Can't figure out which chart to use? Where to put the total? Put the chart here!
Make It Pretty - Look at all those colors - Cool!Untitled Section
Excel Conditional Formatting - Combine Icons and Databars In One Cell ✅ (Live)
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)
338 EXCEL KEYBOARD SHORTCUTS - 2022
Preview
227 MAC OS EXCEL KEYBOARD SHORTCUTS - 2022
Preview
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson