pub » Page 2 of 69 » excelguru.io

Excel PivotTables tutorial showing percentage values running totals and rankings for data analysis and reporting

Show Values As: Percentage, Running Total & Ranking in PivotTables

Learn how to use Excel PivotTables to display values as percentages, calculate running totals, and rank items within your reports. This practical tutorial explains how to change value display settings, compare contributions, track cumulative performance, and identify top and bottom performers without changing the underlying data. Ideal for Excel users, analysts, accountants, finance professionals, and anyone who uses PivotTables for business reporting and data analysis.

LAMBDA Function in Excel tutorial showing custom reusable formulas parameters and spreadsheet automation

LAMBDA Function: Create Your Own Custom Reusable Formulas in Excel

Learn how to use the LAMBDA function in Excel to create your own custom reusable formulas without VBA. This practical tutorial explains how to define LAMBDA functions, use parameters, simplify repeated calculations, combine LAMBDA with other Excel functions, and build more efficient spreadsheet solutions. Ideal for Excel users, analysts, finance professionals, accountants, and anyone who wants to create flexible and reusable formulas.

Excel Camera Tool tutorial showing dynamic dashboard snapshots linked worksheet ranges and interactive reports

Excel Camera Tool: Dynamic Dashboard Snapshots

Learn how to use the Excel Camera Tool to create dynamic snapshots of worksheet ranges and display them in dashboards. This practical tutorial explains how linked image snapshots update automatically when source data changes, helping you create flexible dashboards, reports, and presentation ready views. Ideal for Excel users, analysts, finance teams, managers, and anyone who wants to build more dynamic and visually engaging Excel dashboards.

Merge vs Append in Power Query Excel tutorial showing table joins row combinations and data transformation

Merge vs Append in Power Query: Combining Tables Explained

Understand when to use Merge and Append in Excel Power Query to combine and organize data efficiently. This practical tutorial explains how Merge joins tables using matching columns, while Append combines rows from multiple tables into one dataset. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone working with Power Query for data preparation and reporting.

Power Query Parameters Excel tutorial showing dynamic query inputs data transformation and automated data refresh

Power Query Parameters: Build Dynamic, Reusable Data Connections

Learn how to create and use parameters in Excel Power Query to make data transformation workflows more flexible and reusable. This practical tutorial explains how parameters can control query inputs, filter data, customize file paths, support dynamic transformations, and simplify recurring data refreshes. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone who wants to build more efficient Power Query workflows.

Cashflow Dashboard

Monitor business cash flow with this free Cash Flow Dashboard Excel Template. Track cash inflows, cash outflows, net cash flow, opening and closing balances, income sources, expense categories, monthly trends, and key financial metrics in one clear Excel dashboard. Ideal for business owners, finance teams, accountants, managers, start-ups, and small businesses that need a simple way to monitor liquidity, understand cash movement, and support better financial planning.

Import data from folder with Power Query Excel tutorial showing file combination data transformation and automated reporting

Import Data from Folder with Power Query: Combine Multiple Files Instantly

Learn how to import and combine data from multiple files stored in a folder using Excel Power Query. This practical tutorial explains how to connect to a folder, combine files, transform imported data, handle consistent file structures, and refresh the query when new files are added. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone who wants to automate repetitive data import and reporting tasks.

Power Query Conditional Columns Excel tutorial showing rules and logic for transforming and categorizing data

Power Query Conditional Columns: IF Logic Without Excel Formulas

Learn how to create and use conditional columns in Excel Power Query to transform and organize data more efficiently. This practical tutorial explains how to apply logical conditions, create custom results, categorize records, handle multiple criteria, and automate repetitive data transformation tasks. Ideal for Excel users, data analysts, accountants, finance professionals, and anyone working with Power Query for data preparation and reporting.

Budget Vs. Actual Variance Dashboard

Compare planned budgets with actual results using this free Budget vs Actual Variance Dashboard Excel Template. Track budget amounts, actual spending, favourable and unfavourable variances, variance percentages, departments, categories, and key financial performance metrics in one clear Excel dashboard. Ideal for finance teams, accountants, managers, business owners, and organizations that need to monitor spending, identify budget gaps, and improve financial planning and decision making.

Grouping data in Excel PivotTables tutorial showing date number and category grouping for analysis and reporting

Grouping Data in PivotTables: Dates, Numbers & Custom Groups

Make large datasets easier to understand by grouping data in Excel PivotTables. This practical tutorial shows you how to group dates into months, quarters, and years, group numbers into useful ranges, and organize related items into custom categories. Learn how PivotTable grouping can simplify complex datasets, reveal trends, improve reporting, and make dashboards easier to analyse. Ideal for Excel users, analysts, accountants, auditors, finance professionals, and anyone who works with PivotTables and large datasets.

Breakeven Analysis Dashboard

Know exactly when your business starts making money with this free Break Even Analysis Dashboard Excel Template. Analyse sales revenue, fixed costs, variable costs, profit, break even points, contribution margins, and sales targets in one clear dashboard. Visualize how changes in pricing, costs, and sales volume can affect profitability and identify the level of sales needed to cover your total costs. Ideal for business owners, entrepreneurs, finance teams, accountants, managers, analysts, and anyone who wants a practical Excel based tool for profitability analysis and financial planning.

Prorated Salary Calculator

Calculate salary for a partial working period with this free Prorated Salary Calculator. Enter the salary amount, applicable working days, and the period worked to estimate the appropriate prorated pay. The calculator can be useful when an employee joins or leaves during a month, takes unpaid leave, or works only part of a payroll period. Ideal for employees, HR professionals, payroll teams, accountants, and businesses that need a quick and organized way to estimate salary adjustments for partial periods.