pub » Page 4 of 71 » excelguru.io

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.

PivotTable Slicers and Timelines in Excel tutorial showing interactive filters date analysis and dashboard reporting

PivotTable Slicers & Timelines: Interactive Dashboards Made Easy

Turn static PivotTable reports into interactive Excel dashboards with Slicers and Timelines. This practical tutorial explains how to add visual filters to PivotTables, filter data by categories, and use Timelines to quickly analyse dates and time periods. Learn how to connect Slicers to multiple PivotTables, create cleaner reports, and give users an easier way to explore large datasets without changing formulas. Ideal for Excel users, analysts, accountants, finance professionals, managers, and anyone who wants to build more interactive reports and dashboards.

Excel PivotTable tutorial showing how to add custom formulas calculated fields and custom calculations for advanced data analysis

PivotTable Calculated Fields: Add Custom Formulas Inside PivotTables

Go beyond the standard calculations available in Excel PivotTables by adding custom formulas for more flexible analysis. This practical tutorial explains how to create calculated fields and custom calculations inside PivotTables, build metrics based on your data, and extend PivotTable reports beyond simple sums and counts. Learn how custom formulas can help with profitability analysis, performance reporting, financial metrics, percentage calculations, and business intelligence. Ideal for Excel power users, analysts, accountants, finance professionals, auditors, and anyone who wants more control over PivotTable calculations.

Cost Per Hire Calculator

Understand how much your recruitment process really costs with this free Cost Per Hire Calculator. Calculate the average cost of hiring an employee by considering recruitment advertising, agency fees, sourcing expenses, interview costs, onboarding expenses, and other hiring related costs. The calculator helps HR and finance teams evaluate recruitment efficiency, compare hiring channels, control recruitment budgets, and make better workforce planning decisions. Ideal for HR professionals, recruiters, finance teams, managers, business owners, and organizations looking to measure and optimize recruitment costs.

Executive Summary Dashboard

See the bigger picture without digging through dozens of spreadsheets with this free Executive Summary Dashboard Excel Template. Bring important business KPIs, financial results, operational metrics, targets, trends, and performance indicators into one clear dashboard. The template helps executives and managers quickly identify what is performing well, where results are falling behind, and which areas may require attention. Ideal for business leaders, executives, managers, finance teams, analysts, and organizations that need a simple Excel based solution for management reporting and performance monitoring.

Employee Turnover Cost Calculator

Understand the financial impact of employee turnover with this free Employee Turnover Cost Calculator. Estimate the costs associated with recruiting replacements, hiring, onboarding, training, lost productivity, and other expenses related to employee departures. The calculator helps HR and finance teams quantify turnover costs and better understand the financial impact of employee retention challenges. Ideal for HR professionals, finance teams, managers, business owners, and organizations that want to measure turnover costs and support better workforce planning.

Loan amortization schedule in Excel showing loan payments principal interest remaining balance and repayment progress

How to Build a Loan Amortization Schedule in Excel (Free Tool)

See exactly where your loan payments go with this practical guide to building a loan amortization schedule in Excel. Learn how to calculate periodic payments, separate principal and interest, track the remaining loan balance, and visualize how debt decreases over time. The tutorial also explains how Excel formulas can automate the schedule and help you understand the total interest paid over the life of a loan. Ideal for borrowers, finance professionals, accountants, students, analysts, and anyone who wants a clear Excel based method for understanding loan repayment.