Table of Contents

About Neotech Navigators

Neotech Navigators is a free tutorial library for data analytics and office automation — Google Sheets, SQL, Power BI and HTML dashboards — written and tested by PK, a Microsoft Certified Professional with more than 15 years of hands-on industry experience.

OUR MISSION

Practical data skills, explained step by step, free for everyone.

Most tutorials show you a formula and stop. We show you the real business problem, build the solution in the actual tool, and give you the finished file. Every guide on this site is written for working professionals — analysts, managers, small-business owners and students — who need something they can use today.

The library currently holds 2,000+ tutorials: 880+ Google Sheets templates, dashboards and KPI scorecards, 80+ browser-based HTML dashboards, a Power BI and Power Query series, MS Word and PowerPoint guides, and SQL from Scratch, a free 31-chapter course with a live editor and a final quiz.

No login, no paywall, no locked chapters. Reading is free; if you want a professionally finished version of a template, it lives on our store, NextGenTemplates.com.

2,000+

Free tutorials

SQL course chapters

297K+

YouTube subscribers

15+

Years of experience

PK (Priyendra Kumar)

Founder, author and editor — PK: An Excel Expert

I am PK, based in New Delhi, India. For over 15 years I have worked in data analysis, reporting, data visualization and process automation in corporate environments, building the kind of dashboards, trackers and management systems that teams actually run on.

I am a Microsoft Certified Professional and the creator of PK-AnExcelExpert.com, one of the longest-running Excel and VBA tutorial blogs, and of the YouTube channel @PK-AnExcelExpert (297K+ subscribers). Neotech Navigators is where I publish everything beyond Excel — Google Sheets, SQL, Power BI and web dashboards — with video walkthroughs on @NeotechNavigators.

✅ Microsoft Certified Professional🎓 15+ years in data & automation🌎 New Delhi, India🎥 297K+ YouTube subscribers

HOW WE WORK

Every tutorial is built, tested and kept honest.

Built in the real tool. Screenshots, formulas and code come from working files, not mock-ups. If a dashboard is shown, the file behind it exists.
Tested before publishing. Formulas, DAX measures and SQL queries are run against sample data; the expected output is shown alongside.
Written by a practitioner. Content is authored and edited by PK — not scraped, not outsourced, not auto-generated filler.
Kept current. When Google Sheets, Power BI or SQL engines change behaviour, affected tutorials are revised. Found an error? Tell us and we will fix it.
Transparent about what is free. Tutorials and lite templates are free. Premium templates are sold on NextGenTemplates and are always labelled as such.

WHAT WE COVER