Advanced Excel - Top 10 Excel Tips & Formulas (Excel 2010)
Master Advanced Excel Techniques. Solve Complex Problems Fast. Learn Advanced Excel Skills to Save Time and Impress.Watch Intro
Are you a business professional, who uses (or will be using Excel) on a daily basis?
The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast
This is How:
- Use my top 10 Excel tips to save time
- Learn the top 10 Excel Formulas for quick and dynamic analysis
The top 10 will increase your awareness of the most useful Excel features to work faster and smarter.
Why is this important?
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.
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.
PLEASE NOTE: THIS COURSE IS FILMED ON EXCEL 2010
- 7 hours of video content
- Workbooks to follow along
- Complete solutions
- Lots of challenges to test your knowledge
- Full life-time access
- Our friendly teaching assistants to help you out when you get stuck
I use excel for long but with this course I immediately learned new things. Yes filling the GAPs is very important to improve.
- Abbas Mahamat
My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. 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.
Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases.
Take this course to get a head start!
BONUS 1: Excercise Workbook helps you practice what you learnt. Answers are included in case you get stuck.
BONUS 2: Detailed PDF document of the top 10 Tips and Formulas for your quick reference anytime.
BONUS 3: Download the videos most relevant for your work and refer to them anytime you need.
Leila is the best teacher I ever attended! Course topics are very interesting also for "advanced" Excel users.
- Renato Vianello
Strong overview of functions you use every day in Excel. Several examples and exercises to practice.
- Craig Johnson
My courses & tutorials are for ambitious beginners and professionals who want to upgrade their data analysis skills. If you hate doing things manually, you’ll love my approach.
I don’t just want to show you solutions to specific problems, but to teach you to find solutions to ALL your future data analysis problems.
On my YouTube channel, I share Office Productivity tips & tricks based on questions I get from our online community & professionals at my training sessions.
I am a Certified Microsoft Excel Expert and was given the Microsoft MVP award in 2017. I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature - these include SAP BW and Oracle HFM.
My background is: Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. My passion is teaching and solving difficult Excel problems. I am also addicted to learning and enjoy taking online courses on a variety of topics.
I founded my online learning company, XelPlus, in 2015. Our aim is to help you gain the knowledge you need so you can create useful tools, solve problems and get more done.
Let's start now.
PreviewOverview of Top Excel Tips (2:19)
StartTip 1 - Become Faster with Excel's Keyboard Shortcuts (9:35)
StartTip 2 - Master the Simpler Tasks: Part 1 (18:12)
StartTip 2 - Master the Simpler Tasks: Part 2 (9:23)
StartTip 3 - Quickly Navigate Larger Files (11:38)
StartTip 4 - Inspect Workbooks for Hidden Information (10:00)
StartTip 4 BONUS - Unhide Hidden Names with VBA
StartTip 5 - Use Protection Appropriately (16:36)
StartQUIZ 1 - Top 5 Tips (Don't Skip)
StartTip 6 - Import Text, CSV & Web Data Properly (11:55)
StartTip 7 - Audit & Debug Formulas (8:41)
StartTip 8 - Improve Presentation with Customized Number Formatting (17:23)
StartTip 9 - Solve Problems With Goal Seek (6:33)
StartTip 10 - Use Excel PivotTables for Super Fast Analysis (16:20)
StartTip 10 - PivotTables: Calculated Fields, Slicers & Helpful Tricks (16:16)
StartTip 10 - PivotTables: Valuable Design Tips (23:12)
StartQUIZ 2 - Top 10 Tips (Don't Skip)
StartBonus Tip - Methods to Speed up Your Excel Files (5:36)
StartBonus Tip - The Possibilities & Limitations of Excel (6:48)
StartPDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail)
PreviewOverview of Top Excel Formulas (3:26)
StartFormula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Criteria (14:03)
StartFormula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple (12:00)
StartFormula 3 - IFERROR for Credible Reports (5:53)
StartFormula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups (11:27)
StartFormula 5 - INDEX & MATCH for Flexible Lookups (16:23)
StartFormula 5 - INDEX & MATCH for Complex Real-Cases (18:45)
StartQUIZ 3 - Top 5 Formulas (Don't Skip)
StartFormula 6 - The Most Useful Text Functions (12:38)
StartFormula 6 - Advanced TEXT functions (17:27)
StartFormula 7 - Excel's Top Date Functions (20:24)
StartFormula 8 - OFFSET for Dynamic Calculations (14:47)
StartFormula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank (15:26)
StartFormula 10 - SUMPRODUCT For the Gurus (14:55)
StartQUIZ 4 - Top 10 Formulas (Don't Skip)
StartPDF to Download: Top 10 Excel FORMULAS to Work Smarter
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 Advanced Excel course, is because there are many advanced Excel users who are unaware of key features & formulas in Excel. 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.
Differentiation factor #2
Learn by doing - This Advanced 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 can then do an exercise from the Excel Exercise workbook 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.