VLOOKUP(), MATCH() and INDEX() – explained in plain English
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, […]
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.
Speed up your Excel Formulas [10 Practical Tips]
Excel formulas acting slow? Today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster.
1. Use tables to hold the data
2. Use named ranges & named formulas
3. Use Dynamic Array formulas
4. Sort your data
5. Use manual calculation mode
… and more. Read on to learn these top 10 tips & ideas to improve performance of your excel formulas.
A clever technique to simplify your long, nested IF formulas
Recently I used an elegant and smart technique to simplify lengthy nested IF formulas and made them 80% shorter. In this article, let me explain the process and share the results.
Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)
Create a beautiful & fully interactive todo list with Excel using this tutorial (or download the free todo list template). Impress everyone.
Learn Advanced Excel – 3 Month Roadmap with Resources
Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.
The Excel Mandelbrot
This post examines the implementation of the Mandelbrot Function within Excel without the use of VBA code. It explores how this is done using Real and Complex numbers.