PK: An Excel Expert | Free Excel, VBA and Power BI Tutorials

๐Ÿ“Š 300K+ YouTube Subscribers ๐Ÿ† Microsoft Certified Professional ๐ŸŽ“ Teaching Excel online since 2018

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.

300K+YouTube subscribers
500+Free tutorials
7,000+Ready-made templates
10,000+Happy customers

๐Ÿ“Š Free Excel dashboards with video

Nine complete dashboards you can download and rebuild step by step. They form module 11 of the course.

โšก

Quick Dashboard

Your first dashboard in under an hour.

๐Ÿ†

Performance Dashboard

Employee KPIs against targets with interactive controls.

๐Ÿ’ฐ

Sales Dashboard

Product-level revenue, comparisons and trends.

โš™๏ธ

Process Dashboard

Multi-metric KPIs with sparklines and quarterly charts.

๐ŸŽฏ

Incentive Dashboard

Payouts on five parameters, per employee.

๐ŸŒ

Zonal Dashboard

Region-wise comparison with form controls.

๐Ÿ˜Š

C-SAT Dashboard

Customer satisfaction down to employee level.

๐Ÿ“‹

Project Management

Gantt timeline, milestones, resources and risk.


๐Ÿ› ๏ธ 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.

Google Sheetsand Power BINeoTech Navigators โ†’
DemosTemplate walkthroughsNextGen Templates โ†’

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.

7,000+Templates
3,000+Excel templates
1,100+Power BI dashboards
1,100+Google Sheets

๐Ÿ“Š KPI Dashboards

585+ KPI dashboards for HR, finance, sales, manufacturing, healthcare and more.

$24.99 $17.99
Browse KPI dashboards โ†’

๐Ÿ“… Calendars, Checklists and Trackers

Planners, schedules and trackers for every team, in Excel, Sheets and Word.

$9.99 $4.99
Browse calendars โ†’

๐Ÿ› ๏ธ VBA Management Systems

190+ ready-to-use systems: restaurant, hospital, dental clinic, GST billing and more.

$34.99 $24.99
Browse VBA systems โ†’

โšก 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.