7 Excel Tricks You'll Wish You'd Learned on Day One
From MyOnlineTrainingHub Ā· Ā· 14 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Excel tricks that work for any job: beginner, intermediate, and advanced. š©āš« Get the Data Analyst Fast Track course: https://bit.ly/jobskills26course ā¬ļø Download the example file here and follow along: https://bit.ly/jobskills26yt
š©āš« Get my Excel & Power BI courses: https://bit.ly/jobskills26courses ā¬ļø Download the automated invoice template: https://bit.ly/3MMRmWZ
Stop doing repetitive spreadsheet tasks the hard way! In this video, we cover 7 practical Excel techniques that solve common workplace headaches, from making your formulas and charts expand automatically with Ctrl + T to building interactive slicers and dynamic auto-adjusting print areas.
LEARN MORE ===========
š° EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
šÆ FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
š¬ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
ā² TIMESTAMPS ============== 0:00 Excel tricks you'll need at any job 0:54 Convert data to an Excel Table (Ctrl + T) 3:02 Interactive visual slicers for tables 5:36 Focus Cell row & column highlighter 6:15 Flash Fill to split & format data (Ctrl + E) 6:57 Fill blank cells fast (Go To Special) 7:40 Data validation & custom input guidance 9:57 Dynamic print ranges for invoices & PDFs 14:22 Excel functions you'll need at any job
#Excel #ExcelForWork #ExcelTricks