Menu
Archive for February, 2024
{ 1 Comment }
Get all BOLD text out Excel Cells Automatically
Published on Feb 26, 2024 in Excel Howtos, VBA Macros
Use the getBoldText() function in Excel to extract bolded portion of a cell automatically. Saves you time and helps with data cleaning.
Continue »{ 0 Comments }
How to fix SPILL Error in Excel Tables (3 easy solutions)
Published on Feb 21, 2024 in Excel Howtos, Learn Excel
So you have a SPILL error in your Excel tables? In this quick article, let me show you 3 easy fixes to the problem. Fix 0: See if Excel can auto-fix the formula This is not really a fix. But if you write certain types of formulas in table, Excel will warn you about the […]
Continue »{ 1 Comment }
Loan Amortization Schedule in Excel – FREE Template
Published on Feb 20, 2024 in Financial Modeling, Learn Excel
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.
Continue »{ 0 Comments }
How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]
Published on Feb 14, 2024 in Excel Howtos, Learn Excel
![How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]](https://chandoo.org/wp/wp-content/uploads/2024/02/dependent-drop-downs-in-excel-demo.gif)
Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully dynamic and works across a full column too.
Continue »{ 253 Comments }
VLOOKUP(), MATCH() and INDEX() – explained in plain English
Published on Feb 11, 2024 in Featured, Learn Excel
VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, INDEX and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. Today, […]
Continue »{ 0 Comments }
Beautiful Staff Roster Excel Template [FREE Download]
Published on Feb 6, 2024 in Learn Excel, Templates
![Beautiful Staff Roster Excel Template [FREE Download]](https://chandoo.org/wp/wp-content/uploads/2024/02/STAFF-ROSTER-TEMPLATE.png)
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 […]
Continue »
