ExcelGuru

pub » Page 13 of 70 » excelguru.io

Auto generate formatted Excel reports from raw data tutorial showing Power Query PivotTables automated reporting and formatted dashboards

How to Auto-Generate Formatted Excel Reports From Raw Data (Free Python Tool)

Transform raw data into professional Excel reports automatically with built-in Excel tools and automation techniques. This tutorial explains how to import and clean raw data, apply transformations with Power Query, summarize information using PivotTables and formulas, apply consistent formatting, and refresh reports with a single click. Ideal for analysts, finance teams, managers, operations professionals, and Excel users who want to eliminate repetitive reporting tasks and create reliable, presentation-ready reports.

Merge multiple Excel and CSV files tutorial showing Power Query folder import data consolidation and automated refresh

How to Merge Multiple Excel & CSV Files Into One (Free Tool + Steps)

Combine multiple Excel workbooks and CSV files into a single dataset with Power Query. This tutorial explains how to import files from a folder, merge data automatically, transform and clean records, handle different file structures, refresh combined data, and create scalable reporting workflows. Ideal for Excel users, analysts, accountants, operations teams, and business professionals who regularly consolidate data from multiple sources.

Blood Sugar Log Excel Template for tracking glucose readings testing times meals medications insulin and daily health records

Blood Sugar Log

Monitor blood glucose levels with this free Blood Sugar Log Excel Template. Record testing dates and times, blood sugar readings, meal information, medications or insulin doses, physical activity, symptoms, and personal notes in one simple Excel file. Ideal for individuals managing diabetes, caregivers, healthcare professionals, and anyone who needs an organized way to maintain accurate blood glucose records and identify trends over time.

Production Log Excel Template for tracking production dates batches quantities operators machine status and output records

Production Log

Monitor daily production activities with this free Production Log Excel Template. Track production dates, batch numbers, products, quantities produced, machine or production line details, operators, downtime, quality checks, shift information, and remarks in one simple Excel file. Ideal for manufacturers, factory supervisors, production managers, operations teams, and small businesses that need an easy way to maintain accurate production records and improve operational efficiency.

Many-to-many relationships using bridge tables in Excel tutorial showing Power Pivot data model relationships and bridge tables

Many‑to‑Many Relationships Using Bridge Tables

Understand how to handle many-to-many relationships in Excel Data Models using bridge tables. This tutorial explains why bridge tables are needed, how to create relationship tables, configure Power Pivot relationships, avoid duplicate results, and build accurate PivotTables and reports. Ideal for Excel users, BI professionals, analysts, finance teams, and anyone working with complex relational datasets in Power Pivot.

Read data from SQL Server in Excel tutorial showing database connections Power Query SQL queries and data refresh

Read Data from SQL Server (Database Connection)

Connect Excel directly to SQL Server and work with live database data. This tutorial explains how to create a SQL Server connection, authenticate securely, import tables or custom queries, transform data with Power Query, refresh connections automatically, and build reports from database records. Ideal for analysts, database administrators, developers, finance teams, and business professionals who need to analyse SQL Server data in Excel.

Transform JSON data into Excel tables tutorial showing Power Query JSON import nested data expansion and table transformation

Transform JSON Data into Tables

Convert JSON data into organized Excel tables with Power Query. This tutorial explains how to import JSON files or API responses, expand nested objects and arrays, transform data into tabular format, clean and reshape records, and load the results into Excel for analysis. Ideal for Excel users, analysts, developers, data professionals, and Microsoft 365 users working with web services, APIs, or structured data sources.

Send Excel reports via email on a schedule tutorial showing Power Automate Outlook scheduled workflows and automated report delivery

Send Excel Report via Email on Schedule

Automate recurring report distribution by scheduling Excel reports to be emailed automatically. This tutorial explains how to create a scheduled Power Automate flow, attach Excel workbooks or reports, configure Outlook email actions, define recipients, set delivery frequency, and monitor workflow execution. Ideal for analysts, managers, finance teams, HR professionals, and Microsoft 365 users who want to eliminate manual report sharing and ensure timely communication.

Add a row to an Excel table on form submission tutorial showing Microsoft Forms Power Automate Excel tables and automated workflows

Add Row to Excel Table on Form Submission

Automate data collection by adding a new row to an Excel table whenever a form is submitted. This tutorial explains how to connect form responses to Excel, configure automated workflows, map form fields to table columns, handle new records, and maintain structured datasets with minimal manual effort. Ideal for Microsoft 365 users, HR teams, administrators, educators, and business professionals who want to streamline data entry and automate reporting.

Package Returns Tracker Excel Template for tracking returned orders refund status courier details return dates and replacement requests

Package & Returns Tracker

Manage product returns and refunds with this free Package Returns Tracker Excel Template. Track order numbers, returned items, return reasons, courier details, shipment dates, refund status, replacement requests, completion dates, and notes in one simple Excel file. Ideal for online shoppers, eCommerce sellers, small businesses, and customer service teams that need an easy way to monitor return requests and ensure every case is resolved.

Wine Cellar Inventory Excel Template for tracking wine collections vintages bottle quantities storage locations values and tasting notes

Wine Cellar Inventory

Organize your wine collection with this free Wine Cellar Inventory Excel Template. Track wine names, wineries, vintages, grape varieties, bottle quantities, storage locations, purchase dates, purchase prices, tasting notes, drinking windows, and inventory status in one simple Excel file. Ideal for wine collectors, enthusiasts, restaurants, hospitality businesses, and anyone who wants an easy way to manage and monitor their wine cellar.

Book Lending Tracker Excel Template for tracking borrowed books borrowers lending dates return dates status and reminders

Book Lending Tracker

Keep track of books you’ve lent to friends, family, or colleagues with this free Book Lending Tracker Excel Template. Record book titles, authors, borrowers, lending dates, expected return dates, actual return dates, lending status, reminders, and notes in one simple Excel file. Ideal for personal libraries, schools, book clubs, offices, and anyone who wants an easy way to manage borrowed books and avoid losing track of their collection.