A one-page Pregnancy Week-by-Week Tracker in Google Sheets: 14 columns, four of them calculated, a Current Week card and four charts. A personal organiser for the 40 weeks – not a medical record and not medical advice.
Author: PK
Meet PK, the founder of NeotechNavigators.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your data analysis skills to the next level!
Veterinary Services Dashboard in Google Sheets
A page-by-page walkthrough of the Veterinary Services Dashboard in Google Sheets – seven tabs, 18 pivot-driven charts, 16 slicers and a 500-visit data model for revenue, utilisation and service mix across a practice group.
Mental Health Services Dashboard in Google Sheets
A 7-tab Google Sheets reporting template for mental health services: 16 KPI cards, 18 charts, 15 slicers and a 520-row session log. Operations reporting only, not a clinical tool.
Python Matplotlib: Line, Bar and Pie Charts Step by Step
Python Matplotlib is the standard library for charts. With a few lines you can draw line, bar and pie charts from lists or pandas DataFrames, label them, style them and save them as PNG files for reports and slides. This chapter builds each chart type step by step using the sales data from the pandas […]
Python pandas: Read and Write Excel and CSV Files
The pandas Excel and CSV functions, read_csv(), read_excel(), to_csv() and to_excel(), move data between files and DataFrames in one line each. This chapter loads a sales file, fixes dates and types on the way in, writes a multi-sheet Excel report with ExcelWriter, combines monthly CSV exports and polishes the workbook with openpyxl. Install pandas and […]
Python Classes and Objects: __init__, self and Methods
Python classes and objects let you bundle data and the functions that work on it into one named thing. A class is the blueprint (Employee, Invoice, Product); an object is one concrete instance built from it. The __init__ method sets up each new object, self refers to the object being worked on, and methods are […]
Python Cheat Sheet: Syntax Reference on One Page
This Python cheat sheet puts the syntax from all 48 chapters of the course on one page: variables, strings, collections, control flow, functions, classes, files and pandas basics. Each table shows the statement, a short business-flavoured example and the result, and links to the chapter that explains it. Bookmark it and keep it open while […]
Python pandas Basics: DataFrames, Filtering and GroupBy
Python pandas is the library for working with tables of data. Its DataFrame holds rows and columns like a spreadsheet, and with a few methods you can filter, sort, group and pivot thousands of rows in seconds. This chapter builds a small sales DataFrame and uses it to learn selection, filtering, new columns, groupby() and […]
Python CSV Files: Read and Write with the csv Module
Python CSV handling uses the built-in csv module to read and write comma-separated files, the plain-text format that Excel, Google Sheets, banks and almost every business system can export. reader and writer work with lists, DictReader and DictWriter work with dictionaries keyed by column name, and dialect options handle semicolons, quotes and other regional quirks. […]
Python Projects for Beginners: 10 Projects with Code
These Python projects for beginners are ten small, complete programs that each solve a real office task: invoices, deadlines, expenses, exchange rates, a sales chart and an AI meeting summary. Every project is under 30 lines, runs on Python 3.12, prints a result you can check, and lists the course chapters it uses so you […]