pub » Page 6 of 69 » excelguru.io

Power Query web scraping in Excel tutorial showing website data import HTML tables data transformation and automatic refresh

IMPORTXML (Google Sheets) Equivalent in Excel: Power Query Web Scraping

Turn websites into structured Excel datasets with Power Query web scraping. This practical tutorial shows you how to connect Excel to web pages, identify and import HTML tables, transform and clean the extracted data, and load it into a worksheet for analysis. You’ll also learn how to refresh web data automatically, handle changing page structures, combine imported information with other datasets, and troubleshoot common web-import issues. Ideal for Excel users, analysts, researchers, accountants, business professionals, and anyone who needs to collect web-based data without manually copying and pasting.

Salary Breakup Calculator for calculating basic salary allowances deductions gross salary and take-home pay

Salary Breakup & CTC Structure Generator

Break down your salary into its key components with this free Salary Breakup Calculator. Enter your salary details to estimate basic pay, allowances, deductions, gross salary, and net or take-home salary in a clear, structured format. The calculator can help employees, HR professionals, payroll teams, and finance staff understand how compensation is distributed and how different salary components affect overall pay. Ideal for reviewing salary offers, preparing payroll calculations, comparing compensation structures, and understanding the relationship between gross and take-home pay.

Debt Snowball Tracker

Pay off your debts one balance at a time with this free Debt Snowball Tracker Excel Template. Organize credit cards, loans, and other debts, record outstanding balances, minimum payments, interest rates, and extra payments, and prioritize debts from the smallest balance to the largest. The tracker helps you monitor each payoff milestone, roll freed-up payments into the next debt, and visualize your progress toward becoming debt-free. Ideal for individuals, families, students, and anyone who wants a simple Excel-based system for following the debt snowball repayment strategy.

SQRTPI function in Excel tutorial showing square root of pi calculations and mathematical formulas

SQRTPI: Square Root of (Number * π) – Niche But Useful

Learn how to use Excel’s SQRTPI function to calculate the square root of a number multiplied by π. This practical tutorial explains the function syntax, how SQRTPI differs from the SQRT function, and how to use it in mathematical, statistical, engineering, and scientific calculations. Explore practical examples, common errors, and related Excel functions for working with square roots and π. Ideal for students, engineers, analysts, researchers, and advanced Excel users working with mathematical and technical calculations.

Debt Payoff Tracker

Take control of your debt with this free Debt Payoff Tracker Excel Template. Track credit cards, loans, and other debts, including outstanding balances, interest rates, minimum payments, extra payments, due dates, and payoff progress. Use the tracker to organize multiple debts, monitor balances over time, estimate payoff timelines, and stay motivated as you work toward becoming debt-free. Ideal for individuals, families, students, and anyone looking for a simple Excel-based tool to manage debt and build a clear repayment plan.

Margin of Error Calculator for calculating sampling uncertainty using sample size confidence level and statistical data

Margin of Error Calculator — Survey Confidence Interval & Sample Size

Calculate the margin of error for a sample with this free Margin of Error Calculator. Enter your sample size, confidence level, and relevant statistical inputs to estimate the range of uncertainty around a sample estimate. Margin of error is commonly used in surveys, polls, research studies, quality control, and statistical analysis to understand how closely a sample result may represent a population value. Ideal for students, researchers, statisticians, analysts, survey professionals, and anyone working with sample data and confidence intervals.

Percent Error Calculator for comparing experimental and accepted values and measuring percentage error

Percent Error Calculator — Measured vs. Theoretical Value

Measure the accuracy of an experimental or calculated result with this free Percent Error Calculator. Enter the experimental value and accepted or theoretical value to quickly determine the percentage error. The tool is useful for laboratory experiments, scientific measurements, engineering calculations, quality control, research, and comparing observed results with expected values. Ideal for students, teachers, researchers, scientists, engineers, and anyone who needs a quick way to measure the difference between an observed value and a reference value.

IMSUM function in Excel tutorial showing complex number addition real and imaginary components and technical calculations

IMSUM & Complex Number Functions: Engineering Calculations Made Simple

Learn how to use Excel’s IMSUM function to add two or more complex numbers in a single formula. This tutorial explains the IMSUM syntax, complex number formats, real and imaginary components, practical examples, and common errors. You’ll also learn how IMSUM works with Excel’s other complex-number functions for electrical engineering, mathematical modelling, signal analysis, and technical calculations. Ideal for students, engineers, researchers, analysts, and advanced Excel users working with complex numbers and scientific calculations.

Interquartile Range Calculator for calculating Q1 Q3 and IQR to measure the middle 50 percent spread of a dataset

Interquartile Range Calculator — IQR, Quartiles & Box Plot Values

Calculate the interquartile range of a dataset quickly with this free Interquartile Range Calculator. Enter your numerical data to find the first quartile (Q1), third quartile (Q3), and IQR, which represents the spread of the middle 50% of observations. The calculator is useful for understanding data variability, comparing distributions, identifying potential outliers, and creating box plots. Ideal for students, teachers, researchers, statisticians, analysts, and anyone who needs a quick way to measure the spread of numerical data.

Bessel functions in Excel tutorial showing BESSEL.J BESSEL.Y BESSEL.I and BESSEL.K calculations for engineering and scientific analysis

BESSEL Functions: Bessel Functions for Physics & Engineering

Learn how to use Excel’s Bessel functions for advanced mathematical, engineering, and scientific calculations. This tutorial explains the BESSEL.J, BESSEL.Y, BESSEL.I, and BESSEL.K functions, including their syntax, practical examples, and differences between the various types of Bessel functions. Discover how these functions can be applied to wave equations, heat transfer, vibration analysis, signal processing, and other technical models. Ideal for engineers, physicists, researchers, mathematicians, students, and advanced Excel users working with numerical and scientific calculations.

Pay check Budgeting

Take control of your money one pay check at a time with this free Pay check Budgeting Excel Template. Plan income for each pay period, allocate money toward bills, expenses, savings, and financial goals, and track how much remains available after each pay check. This pay check-based budgeting approach makes it easier to manage irregular expenses, avoid overspending, plan upcoming bills, and maintain a clear view of your cash flow. Ideal for employees, families, students, and anyone who wants a simple Excel-based system for managing money between pay checks.

Excel CONVERT function tutorial showing unit conversions for length weight temperature volume area speed and other measurements

CONVERT Function: Master Unit Conversions in Excel (Miles, Kg, °C, etc.)

Master unit conversions in Excel with the powerful CONVERT function. This practical tutorial shows you how to convert measurements between different units, including length, distance, weight, mass, temperature, time, area, volume, speed, pressure, energy, and other common measurement categories. Learn the correct unit codes, understand how the function works, avoid common conversion errors, and automate repetitive calculations directly in your spreadsheet. Ideal for students, engineers, analysts, accountants, scientists, and Excel users who regularly work with measurements and mixed units.