How to compare two Excel sheets using VLOOKUP? [FREE Template]
You are the boss of ACME Inc. And one day, both of your accounts receivables team members Sara and James come to you with two versions of the customer payment data. How do you compare these two Excel sheets and reconcile the data? In this article, let me explain the step by step process.
Loan Amortization Schedule in Excel – FREE Template
Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.
Beautiful Staff Roster Excel Template [FREE Download]
Do you want to manage your staff’s allocations, shift schedules and view the results in a 4 week grid fashion (like below)? Then you are going to love my FREE Staff Roster Excel Template. What can you do with this template? Template Compatibility This template is designed to work with modern Excel only. You need […]
FREE Calendar & Planner Excel Template for 2024
Here is a fabulous New Year gift to you. A free Calendar & Activity planner made entirely in Excel. A fully customizable and flexible calendar for all your planning needs.
FREE Calendar & Planner Excel Template for 2023
Here is a fabulous New Year gift to you. A free Calendar & Activity planner made entirely in Excel. A fully customizable and flexible calendar for all your planning needs.
How to create a fully interactive Project Dashboard with Excel – Tutorial
Do you manage projects? You are going to LOVE ? this one. In this in-depth tutorial, learn how to create a fully interactive & dynamic Excel Project Management dashboard. Sample files & video instructions are also provided.
How to embed Excel files, calculators on your website? – Step by step instructions
Here is an awesome way to enhance your website and impress clients. Embed an Excel calculator on your webpage. Check out below demo and if this is what you want, read on.