Skip to main content
AmigoFish

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.

Watch on YouTube

Not rated yet

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

Back to MyOnlineTrainingHub Ā· Report a problem