pub » Page 5 of 69 » excelguru.io

Office Scripts in Excel tutorial showing TypeScript automation for worksheets data formatting formulas and repetitive tasks

Office Scripts: Automate Excel with TypeScript

Automate repetitive Excel tasks with Office Scripts and TypeScript. This practical tutorial introduces you to Excel’s modern scripting capabilities, showing how to record and write scripts, manipulate worksheets and ranges, format data, create formulas, and automate common spreadsheet workflows. Learn how TypeScript-based Office Scripts can replace repetitive manual steps, standardize processes, and make Excel automation more scalable and consistent. Ideal for Excel power users, analysts, finance teams, developers, and professionals who want to automate Excel tasks without relying on traditional VBA macros.

ABC Analysis Dashboard

Identify your most important inventory items with this free ABC Analysis Dashboard Excel Template. Classify products into A, B, and C categories based on inventory value or contribution, and use the dashboard to analyse item rankings, cumulative percentages, stock value, and category distribution. The template helps you focus purchasing, stock control, cycle counting, and inventory management efforts on the products that have the greatest financial impact. Ideal for inventory managers, procurement teams, warehouse professionals, retailers, supply chain analysts, and businesses looking for a practical way to prioritize inventory decisions.

Full and Final Settlement Calculator for calculating employee salary leave pay deductions gratuity and final settlement amounts

Emergency Fund Tracker

Calculate an employee’s full and final settlement with this free Full and Final Settlement Calculator. Estimate key components such as unpaid salary, leave encashment, deductions, gratuity or other applicable payments, and the final amount payable when an employee leaves a company. The calculator helps organize settlement calculations in one place and can be useful for HR teams, payroll professionals, finance departments, and employees reviewing their final dues. Ideal for simplifying exit calculations, checking settlement components, and preparing a clearer breakdown of final employee payments.

Full & Final Settlement Calculator (India)

Excel tutorial showing how to create custom Ribbon tabs buttons groups and shortcuts for a personalized workflow

VBA: Create Custom Ribbon Tab & Buttons (RibbonX)

Make Excel work the way you want by creating your own custom Ribbon tabs and buttons. This step-by-step tutorial shows you how to customize the Excel Ribbon, create dedicated tabs and groups, add frequently used commands, and organize tools for faster access. Learn how custom Ribbon layouts can streamline repetitive workflows, improve productivity, and make specialized Excel workbooks easier to use. Ideal for Excel power users, analysts, developers, trainers, and professionals who want to build a more efficient and personalized Excel interface.

Supplier Performance Scorecard

Measure supplier performance with this free Supplier Performance Scorecard Excel Template. Evaluate vendors across key criteria such as delivery performance, product or service quality, pricing, responsiveness, reliability, and service levels. Record supplier scores, track KPIs, compare vendors, identify underperforming suppliers, and use performance trends to support better procurement decisions. Ideal for procurement teams, supply chain managers, purchasing professionals, operations teams, and businesses that need a structured way to monitor and improve supplier performance.

Sinking Funds Tracker

Stop letting large upcoming expenses turn into financial surprises with this free Sinking Funds Tracker Excel Template. Create separate savings funds for expenses such as annual bills, insurance, travel, gifts, vehicle repairs, home projects, and other planned purchases. Track your target amounts, deadlines, regular contributions, current balances, and remaining amounts in one organized Excel file. The template makes it easier to break large expenses into manageable savings goals and stay on track throughout the year. Ideal for individuals, families, students, and anyone who wants a simple Excel-based system for planning future expenses and building financial stability.

Timesheet Calculator for calculating work hours overtime breaks and total employee working time

Timesheet & Work Hours Calculator

Calculate working hours quickly and accurately with this free Timesheet Calculator. Enter start and end times, breaks, and work periods to determine total hours worked and identify overtime. The calculator is useful for tracking employee attendance, preparing payroll, reviewing timesheets, estimating labor costs, and managing work schedules. Ideal for employees, freelancers, managers, HR teams, payroll professionals, and small businesses that need a simple way to calculate and verify working hours.

Inventory Dashboard

Get a clearer view of your inventory with this free Inventory Dashboard Excel Template. Monitor stock levels, inventory value, product movement, purchases, sales, reorder points, low-stock items, and other key inventory KPIs in one organized dashboard. Use the visual summaries to identify stock shortages, excess inventory, fast-moving products, and purchasing trends so you can make better inventory decisions. Ideal for inventory managers, retailers, warehouse teams, procurement professionals, small businesses, and operations teams that want a simple Excel-based inventory reporting solution.

Overtime Pay Calculator

Calculate your potential overtime earnings with this free Overtime Pay Calculator. Enter your regular hourly rate, overtime hours worked, and applicable overtime multiplier to estimate your overtime pay and total earnings. The calculator makes it easier to understand how additional working hours affect your income and can help employees, managers, HR teams, and payroll professionals perform quick overtime calculations. Ideal for comparing regular and overtime earnings, reviewing payroll figures, estimating labour costs, and planning compensation.

50 Excel keyboard shortcuts printable cheat sheet for faster spreadsheet navigation editing formatting and productivity

50+ Excel Keyboard Shortcuts Every Pro Should Know (Printable Cheat Sheet)

Stop reaching for the mouse every few seconds. This practical Excel keyboard shortcuts guide covers 50 essential shortcuts that can dramatically speed up everyday spreadsheet work. Learn shortcuts for navigating large worksheets, selecting and editing data, copying and pasting, formatting cells, working with formulas, managing rows and columns, inserting data, and quickly accessing important Excel features. The guide also includes a printable cheat sheet so you can keep your most useful shortcuts close at hand. Ideal for Excel beginners, power users, analysts, accountants, students, and professionals who want to work faster and more efficiently.

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.