Excel: Top 10 Tips to Become Better in Excel
- 1x (Normal)
What You Will Learn2:40
Tip 1 - Use Keyboard Shortcuts9:08
Tip 2/1 - Master the Simpler Tasks18:12
Tip 2/2 - Master the Simpler Tasks9:11
Tip 3 - Quickly Navigate Larger Files11:23
Tip 4 - Inspect Workbooks Before Distributing9:47
Tip 5 - Use Protection Appropriately16:24
Tip 6 - Import Text, CSV & Web Data Properly11:15
Tip 7 - Audit & Debug Formulas6:19
Tip 8 - Customized Number Formatting Tricks17:10
Tip 9 - Solve Problems With Goal Seek6:11
Tip 10 - Speed up Your Excel Files5:29
About This Class
Do You Want to Improve Your Excel Skills? To Become more confident and Advanced in Excel?
This course is your starting point! You will gain new knowledge that will help you save time when you work in your Excel files. If you are already advanced in Excel, this course will allow you to "fill in the gaps".
The top 10 will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.
Audience for this course:
Specifically designed for people using Excel on the Job. Advanced Excel skills are highly relevant in business. No matter which role you’re currently in or you’re planning to take on. Whether you’ll be in Finance, consulting, IT, in project management, your advanced Excel skills will set you apart from the competition.
What is the difference between an Advanced Excel and Average Excel user?
An advanced Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation. Advanced Excel users, always find the optimal solution for every task, and they find it fast!
What differentiates this Excel course from the others?
The reason I created this specific Top 10 Tips Excel course, is because there are many advanced Excel users who are unaware key features. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.
Differentiation factor #1
Focus - The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel. If you are currently advanced in Excel, you might have missed some of these features.
Differentiation factor #2
Learn by doing - This Excel course is well structured and organized. You can download my Excel Demo workbook which I use to demonstrate each feature and practice along with me. You also have an exercise book to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered.
Differentiation factor #3
Engaging - I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later.
The videos are filmed using Excel 2010, but the techniques I show you apply to older as well as future versions of Excel.
Class Projects 1 See All
9 of 9 students recommendSee All
Excellent tips, highly informative. Thank you very much Leila as always for your efforts.
I found the class quite insightful and very nicely done. I would recommend this course for anyone who looks in Excel and would like to understand and use some of it's more advanced features.
I help companies use Excel better to improve their reports by providing customized training sessions, Dashboard Training and Enhanced Visualization Techniques. I also help improve processes, by designing interfaces and tools with VBA for Excel.
I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature. Aside from onsite training, I offer comprehensive Excel online courses.I am also a Certified Microsoft Excel Expert and have a Masters degree in economics from University of Toronto.
I place great value on keeping my training sessions not only informative but also interesting. With technical topics like Excel, students learn the most when they attempt to solve a problem on their own. They are most engaged when they make mistakes and attempt to fix these. For this reason, I make sure to include enough examples and exercises for students to download and work with.
I look forward to having you in my class.