As an Excel beginner, or even an Excel intermediate, everything you could possibly want to learn in Excel is covered on the internet. Youtube, Podcasts, Instagram and even TikTok - you can learn about Excel anywhere, and everywhere! So, why are so many people frustrated with Excel? Fundamentally, what's missing, and how might 30 Day Excel Analyst help fill that gap?
What is this course all about? View the first Video Here
Well, I can't promise to alleviate all your frustration with Excel! (As we'll learn, a degree of frustration with Excel is natural ... and even helpful.) But, I can provide something different, and something you don't see much on the myriad of online platforms: a long-term, strategic perspective and a roadmap for improvement.
There are plenty of technical explanations available online. And, don't worry, there is a technical component to this programme. But, at Tiger, we say 'Don't Be A Technique Collector, Be A Value Creator'. In other words, focus on actual problems, and learn what you need to help people using Excel in the real world - including yourself. Let that be the guiding principle for your learning, rather than the latest Excel formula release. Seriously, it won't 'change everything'!
What might change everything, however, is a change in mindset towards Excel learning. In 30-Day Excel Analyst, I invite you to view Excel as a skill. A skill you have to apply in an ever-changing business and data environment. As we'll discover - it's difficult and there are rarely singular best solutions and 'right' answers. But that's ok, In fact, it's a realisation that, like me, you mind find liberating ...
With this in mind, I'll walk you through an Excel toolkit based on my experience of consulting to individuals and organisations across the world over the past decade, whilst building a YouTube channel of over 90 000 subscribers. I'll try to summarise what organisations actually use Excel for, then look at the problems you're likely to encounter, and the tools you'll need to help. These extend beyond Excel since, as a value creator, contextual understanding and project management skills are just as important as the technical aspect.
We'll focus relentlessly on the Excel 'metaskills' - competencies such as the ability to 'debug' Excel formulae that are the real keys to Excel learning. We'll explore the technical aspects of Excel practice through four key skill areas: data management, data analysis, modelling and automation. Though the emphasis is not technical, I will demonstrate the main techniques in Excel, and signpost you to follow-up resources to build your skills and confidence. We'll make reference to three learning outcomes - technical, project / contextual and career. In other words - can you get Excel to work, can you get it to work to create real-world value and, can you get it to work for YOU in the broader context or YOUR career?
Over time, we'll develop what all aspiring Excel analysts really need: a framework for helping people in the real world and an overview of what they need (and don't need) to know.
We'll do all of this (I hope!) in 30 sessions of approximately 30 minutes, delivered live and available on replay in perpetuity for ongoing reference.
Ready to transform your analytical skillset in 30 days? It's a privilege to be your guide - welcome to 30 Day Excel Analyst!
FOLLOW UP RESOURCES
Session 2: 4 Ways To Get Better At Excel Today! (THE EXCEL METASKILLS)
Session 3: How Do Companies ACTUALLY Use Excel In 2023?
Session 4: Excel Simplified: The Things You NEED To Know In Excel (and what you can ignore)
Session 5: How To Collect Data With Excel In 2023 (Without Annoying Your Coworkers!)
Session 6: Power Query For Beginners
Session 7: STOP Fixing Data In Excel! START Using Excel Data Validation Like A Pro ...
Session 8: Top 10 Excel Formulae For Cleansing Your Data QUICKLY And EFFICENTLY In Excel
Session 9: How To Do A Basic Data Analysis In Excel (CHART INCLUDED!)
Session 10: My QUICK And EASY Method For Building An Interactive Dashboard In Excel
Session 11: Why You Should Learn Excel’s Data Analysis Formulae (EXCEL PIVOT TABLE ALTERNATIVE!)
Session 12: How To Create BEAUTIFUL Charts In Excel
Session 13: What's An Excel 'Model'? (AND 5 EXCEL MODEL-BUILDING FORMULAE!)
Session 14: The Secret To Smooth Formula-Building In Excel (EXCEL MODELLING FOR BEGINNERS!)
Session 15: Build This BEGINNER EXCEL MODEL With Me In Around 15 Minutes!
Session 16: How To Create BEAUTIFUL Visualisations For Excel Models
Session 17: THE BASICS OF EXCEL VBA EXPLAINED (For Beginners!)
Session 18: Frustrated With Recorded Macros In Excel VBA? HERE'S HOW TO IMPROVE THEM
Session 19: 5 ESSENTIAL Excel VBA Beginner Techniques
Session 20: How Automate Manual Work In Excel With Loops In Excel VBA
Session 21: How To Generate UNLIMITED Random Data In Excel (CLICK OF A BUTTON!)
Session 22: SAVE TIME IN EXCEL With These 23 Excel Keyboard Shortcuts (WINDOWS PC)
Session 23: 5 Formatting Principles For Better Excel Spreadsheets
Session 24: 4 Worksheets To Include In ALL Your Excel Files (GENERIC EXCEL SHEET ROLES!)
Session 25: What's The Difference Between An ANALYST And A CONSULTANT? And Why Does It Matter For YOUR Career?
Session 26: 4 NON-EXCEL Tools To Help You Create Better Spreadsheets
Session 27: How Can DRAWING Help You Create Better Excel Spreadsheets?
Session 28: How Should You Manage An Excel Development Project? (4 STEPS!)
Session 29: How To Make Excel Your Career (IN FOUR STEPS!)
Session 30: Can You Become An Excel Analyst In 30 Days? (COURSE OVERVIEW)