Excel Hacks - Tips & Tricks

Excel Hacks - Tips & Tricks

Leila Gharani via YouTube Direct link

How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)

24 of 24

24 of 24

How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Hacks - Tips & Tricks

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Fully Dynamic Emails from Excel with a SINGLE FORMULA!
  2. 2 Quick Excel Trick to Unstack Data from one Column to Multiple Columns
  3. 3 Excel Custom Formatting with Thresholds & Icons: Quick & easy
  4. 4 How to Create a Sales Funnel Chart in Excel (Not the "usual" Funnel)
  5. 5 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)
  6. 6 Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
  7. 7 3 Methods to Unhide All Sheets in Excel (& how to hide)
  8. 8 VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)
  9. 9 Convert NUMBERS to WORDS (NO VBA) in Excel
  10. 10 The QUICKEST & EASIEST Way to Work with TEXT in Excel
  11. 11 SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)
  12. 12 Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)
  13. 13 Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)
  14. 14 Mysterious Excel Formula Syntax to Count Text Cells (as NEVER Seen Before)
  15. 15 Excel Hidden Shortcut to Select Data Column including Blanks
  16. 16 Complete: Excel Hidden SHORTCUTS to Select Data Column including Blanks
  17. 17 Excel FILTER Function TRICK for Non Adjacent Columns
  18. 18 6 FREE Add-Ins for Excel to Start Using Now
  19. 19 Excel Hack: Copy Formula Without Changing Cell References (or Without File References)
  20. 20 GUESS what's HIDDEN in Excel? (Cool Trick)
  21. 21 Better Excel Presentations: Increase Font Size of Formula Bar
  22. 22 EASILY UNLOCK Protected Excel Sheets WITHOUT Password
  23. 23 3 EASY Ways to Find and Remove Duplicates in Excel
  24. 24 How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.