Learn Excel, VBA and Power BI
Free, Step by Step
A free 12-module Excel course, 100+ formula guides, pivot table and VBA tutorials, 1,400+ Power BI dashboard walkthroughs and downloadable practice files. Everything is written by PK, an Excel expert with 15+ years of experience, and backed by video on YouTube.
๐ The free Excel course: 12 modules, beginner to advanced
Every tutorial on this site arranged in the order a beginner should learn it. Each module is a set of short written chapters with screenshots, and most include a practice file.
Level 1 ยท Basics
Level 2 ยท Formulas and data rules
Level 3 ยท Visualisation and analysis
Level 4 ยท Automation
๐ Free Excel dashboards with video
Nine complete dashboards you can download and rebuild step by step. They form module 11 of the course.
๐ ๏ธ VBA tools and automation projects
Free add-ins to use today, and hundreds of VBA projects with source code to learn from.
PK’s Utility Tool V3.0 (Free)
A free Excel add-in with dozens of one-click helpers for formatting, clean-up and navigation.
Download free โData Entry Forms in VBA
Step-by-step projects: user forms, validation, search and edit, all with downloadable files.
Browse projects โ300+ VBA Automation Tutorials
Inventory, attendance, billing, reporting and utility macros explained line by line.
Browse tutorials โReady-made VBA Management Systems
Restaurant, hospital, dental clinic, GST billing, attendance and 190+ more, with full source code.
See on NextGenTemplates โ๐ฅ Learn on YouTube: free video tutorials
Step-by-step video walkthroughs on Excel, VBA, Power BI, dashboards, charts and infographics, in English and Hindi.
Video playlists on this site: Charts and Infographics ยท Excel Functions ยท Dashboards ยท VBA ยท Power BI ยท Excel Games
๐ฅ RECOMMENDED ยท INSTANT DOWNLOAD
Need a ready-made template? Visit NextGenTemplates.com
Why build from scratch? NextGenTemplates.com is our template store with the largest collection of Excel, Power BI and Google Sheets templates anywhere, built by the same team behind this site. Every file comes with a video tutorial.
๐ KPI Dashboards
585+ KPI dashboards for HR, finance, sales, manufacturing, healthcare and more.
๐ Calendars, Checklists and Trackers
Planners, schedules and trackers for every team, in Excel, Sheets and Word.
๐ ๏ธ VBA Management Systems
190+ ready-to-use systems: restaurant, hospital, dental clinic, GST billing and more.
โก Instant download after checkout ยท ๐ One-time payment ยท ๐ฅ Video demo included ยท ๐ฌ Support on WhatsApp and email
๐ฐ Latest tutorials
New dashboard builds and tutorials are published every week.
Donation Box Collection Data Entry System in Excel
A macro-enabled workbook with a six-field VBA form, automatic record IDs, stat cards and editable lists.
Read more โConcrete Contractor KPI Dashboard in Power BI
14 KPIs scored against target with MTD and YTD traffic lights.
Read more โInsulation Contractor KPI Dashboard in Power BI
13 productivity, material, quality, financial and safety KPIs, MTD and YTD.
Read more โDigital Asset Custodians Dashboard in Power BI
Assets under custody, wallet mix, cold storage share and settlement flow across five pages.
Read more โDevOps Teams Dashboard in Power BI
Deployment frequency, lead time and change failure rate with 25 KPI cards and 80+ DAX measures.
Read more โDigital Signature Services Dashboard in Excel
A five-page Excel dashboard for e-signature operations with 19 charts and a completion gauge.
Read more โNeed a custom dashboard or team training?
We build custom Excel, VBA, Power BI and Google Sheets tools for businesses, and run tailored training for individuals and teams, online and in person.
๐ง info@nextgentemplates.com ยท WhatsApp +91-8077090260 (chat only)
๐จโ๐ป About PK: An Excel Expert
PK is a Microsoft Certified Professional with over 15 years of experience in Excel, VBA, Power BI and data visualisation. Based in New Delhi, India, PK runs one of the largest Excel learning ecosystems online: this site, a 300K+ subscriber YouTube channel, and NextGenTemplates.com, a store of 7,000+ professional templates. Whether you are writing your first VLOOKUP or building an enterprise dashboard, the free course above is the place to start.