4 Worksheets To Include In ALL Your Excel Files (GENERIC EXCEL SHEET ROLES!)
Вставка
- Опубліковано 26 сер 2024
- “Structure determines behaviour” is an aphorism I first heard on my Masters degree. Since then, I’ve adapted the phrase slightly since it succinctly sums up my experience of developing Excel files. “Structure determines programmer behaviour!”
🔥30 DAY EXCEL ANALYST PLAYLIST
tinyurl.com/44...
🔥FIRST VIDEO IN THE COURSE
ua-cam.com/users/li...
💻DOWNLOAD THE RESOURCES
tinyurl.com/2t...
Yes, if your Excel file is effectively structured, the development process is generally smooth. The opposite applies if you’re dealing with sub-optimal structure - your Excel file might drive you mad! This is why structure determines programmer behaviour. The fact is, it doesn’t matter how good you are at Excel formulae, Power Query or VBA; if you cannot structure an Excel file effectively, you will always feel stressed when building a spreadsheet.
In this session, I talk you through what I consider to be effective Excel file structure. We’ll explore the topic on two levels: worksheet layout and overall file structure. By the end of the session, you should be able to plan the structure of an Excel file with confidence - which could have a profound effect on your work as an Excel analyst. Welcome back to 30 Day Excel Analyst!
FOLLOW UP RESOURCES
🔥30 DAY EXCEL ANALYST PLAYLIST
tinyurl.com/44...
🔥MAKE EXCEL BEAUTIFUL: 14 EXCEL FORMATTING TIPS
• 14 Excel Formatting Ti...
🔥UNDERSTAND A COMPLICATED EXCEL SPREADSHEET IN 3 STEPS
• Understand Complex Exc...
🔥THE 72 THINGS YOU NEED TO KNOW IN EXCEL
• The 72 Things You Need...
🔥STOP FILTERING EXCEL
• Don't Use Excel Filter...
🔥LEARN EXCEL VBA WITH THIS 5-HOUR WALKTHROUGH PROJECT
• Learn Excel VBA From B...
🔥LET’S TALK ABOUT WHY YOU ARE BAD AT EXCEL
• Let's Talk About Why Y...
🔥READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY
tinyurl.com/2p...
🔥30 DAY EXCEL ANALYST PLAYLIST (COMPLETE COURSE!)
tinyurl.com/4439xtnb
Just wanted to say I’ve been a follower for a while but never had a need for using excel in my personal or professional life. I’ve always been interested in upskilling excel and will binge your courses soon.
Thank you for the videos and knowledge!
It's a pleasure and thank you for letting me know. These videos will be ready on replay when you have the time to binge! The playlist is in the video description of course.
Great guidance cheers Chris
Thanks, Marcus!
Very useful info here! I have not been following this series yet….this is the first video I’ve watched so now got to go back and start with the first one. It’s so nerdy how much I love excel! 😄 Thanks for doing these videos. You’re an excellent teacher!
Thank you very much! All the videos are available on replay - good luck.
This is very helpful video... I’ve been working in excel for quite longer already, this is to verify that some I am doing correctly and some I need to improve base on your recommendations which is highly more efficient. Thank you very much for sharing your ideas.
Thank you very much - do check out the other videos in this couse for more. Good luck!
@@TigerSpreadsheetSolutions surely will do. Already subscribed and will be monitoring for any updates from your channel.