Although almost all my blog posts have some or the other companion file (which is downloadable), but I am exclusively creating this page for some of the rich guides (pdfs) and resources that I have published over time.
I’ll make sure to keep updating the list so be sure to bookmark this page!
happy downloading 😀
E-books and Guides
- Excel & PowerPoint Smart Tips e-books
- Ultimate Vlookup Guide
- Improve the Look and Feel of your Dashboards
- Advanced Excel Ebook (+ Practice Files)
- Download Power Query Tip Card
- DAX and Data Modeling Tip Cards
- Pick up the Right Chart – Game
- Pick up the Right Chart – Solutions
- Pick up the Right Chart – Guide
Short & Long courses
- Mastering DAX Course (Paid) – A comprehensive course to learn DAX step by step and solve real time problems in Power BI.
- Power Query Course (Paid) – Learn to automate simple to complex repetitive tasks using Power Query in Excel or in Power BI.
- Master Excel Step by Step (Paid) – An easy to follow, step by step course to help you build rock solid skills in MS Excel
- Business Intelligence Dashboards using Excel (Paid) – Learn to make Beautiful, Interactive and Insightful Business Dashboards using Excel
- Excel in 2 Mins (Videos) – I often record videos on my phone and share them with my friends about some nifty excel tricks, these are far from sophisticated but they are quick and fun.
- Classy Power Point Animations and Speed Tricks – Incidentally one other skills that I’m good at is PowerPoint. This short course will teach you how to work fast with PowerPoint. And instead of using random (and stupid) animations, how can you make them classier and improve the message and comprehension of your presentation.
- Download Classy PPT Samples – Download a couple of classy sample presentations and peruse over design, look n feel, the use of animations and story boarding. You’ll learn a lot better once you see a good presentation rather following the archaic “5 words on a slide” rules.
- Pivot Table Short Course – In this 2 hour course on Pivot tables I’ll cover almost all important aspect about Pivot Tables.
- My Webinars – are a great place to learn about Modern Excel – Power Query, DAX and Power BI
Dashboard and Visualizations
- You can download all my Excel Dashboards here
- You can see all my Power BI / Power Pivot Dashboards here
- I am sure, I must have forgotten to link some or the other dashboard kept in some nook and corner. Please browse around honey 🙂
I have created a few interesting paid and free templates
- Learning & Development Dashboard– Paid
- Recruitment Dashboard – Paid
- Invoice and Payment Management Tracker – Paid
- Calendar Dashboard
- Paytm Dashboard
- How to Master Keyboard Shortcuts -Reading
- 100+ Excel Shortcuts
- PowerPoint Shortcuts
- Ctrl Alt and Shift Shortcuts in PowerPoint
- Excel Shortcuts for Mac Users
- VBA Shortcuts
- Financial Modeling Shortcuts
- Fill Handle Shortcuts – Reading
- DAX (Power BI) Keyboard Shortcuts
Formulas & Functions
Let me know if you have any problems with any of the downloads and of course drop in a comment for your feedback