Advanced Excel & Macros
Basics – Sort, Filter, Dates, Shortcuts
Lookups (VLOOKUP, 2D, 3D, reverse)
Pivot Tables & Macros in-depth
Logical functions – IF, SUMIFS, COUNTIFS
Advanced – INDIRECT, OFFSET
Multi-variable What if Analysis
… and many more tricks
Advanced PowerPoint & Charts
Basics – Pictures, Shapes, Text
Speed Shortcuts & Slide Master
Creative Shapes & Diagrams
Button triggered Animation
Charts – Waterfall, Combo
… and many more tricks
Other Productivity Tools
MS Access & SQL
MS Word, Outlook
PMP – Project Management
… and many more
Learn Excel Online For Free with Case Studies
Learn Advanced Excel Courses | Microsoft Certified Center
MS Office Courses
Advanced Excel, PPT, Outlook, Word, Access and many more
What People Say
This is the How-to-Make-the-Most Guide from Yoda Learning You’ve Been Looking For!
If you desire to become faster and better at office applications, (You can learn Excel, PowerPoint, Word, Excel VBA, Access, Visio, Outlook… ) but don’t know where to start, this page is for you.
For me and Yoda Learning community (We all call ourselves Yoda), we focus on helping each other with one goal – How can I get things done in the least possible time a.k.a. smarter-faster-better.
I teach a top-down and results-first approach designed for Knowledge Professionals. This is unlike most academic textbooks and university courses.
Access my best free tutorials on the blog or take the next step with my paid training material to make you HERO at your office
You may be feeling overwhelmed. You may have a lot of questions. I created this page for you. It is your starting point.
What to Expect?
We assume that you’re opened Excel, PowerPoint or Word once in your life, so we won’t take you through basics (like auto sum or drawing a rectangle or changing the font of the text). I’m listing down few of Excel Modeling and Office Productivity Essentials based on your interest area. If it Wows you, keep on reading or come back here
Office Productivity Essential #1: Video Tutorials
We’ve built 1,000+ office productivity hacks microlearning videos. I say microlearning because these videos are ~3-5 minute long which are produced to give you highest RoI per minute. Take look at few of our video tutorials here:
- Convert 1D VLOOKUP to 2D VLOOKUP
- How to Google Search and Edit VBA code to get work done
- Waterfall or Brdige Chart in PowerPoint
- How to write Email Subject Lines
Office Productivity Essential #2: #AskYoda Webinars
Solve your queries on Dynamic Dashboard, Building Simple models, Automation Techniques, Presentation Secrets & many more…
What’s in this for you?
- Solution to Real-life problems using Office Tricks. Who knows -You are living with a similar problem all your life
- Learn Industry Best Practices from Office Experts (Trained 10,000+ professionals at PwC, JP Morgan, Nestle, KPMG, over last 5 years)
- Master New Features of the Software that increases your speed by 4X (Hint: You’ve been ignoring these all your life)
Office Productivity Essential #3: God-Mode Tutorials on Productivity hacks
We’ve handpicked few of our most read blogs for you. It is a mix of Excel, PPT, VBA Macros Applications. You may also choose to go a particular category of tutorials to make the most out of it. Don’t try to read all these in one particular day. You can join our mailing list and we will keep you updated when we publish something exciting.
- Tricks of Text to Columns
- How to unprotect Excel sheet
- Create Magnifying Glass effect in PowerPoint
- SmartArt in PowerPoint
- ULTIMATE Excel Shortcuts (without going through lengthy blogs or videos)
Office Productivity Essential #4: LinkedIn Community
I want to hear your stories. I want to know how else I can help you. I want the Yoda Learning experience to be our experience, together. That’s how we all learn and grow together, including me.
Join this community to discuss and stay updated with what we learn together.