
Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.
Continue »
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.
Continue »
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.
Continue »
Hi everyone…
Let me start by wishing you all a very happy holiday season and stellar start to 2023. Here is our annual holiday card.
[pictured left to right: Nishanth (son), Jo (wife), Nakshu (daughter) and Chandoo (me)]
Continue »![Range Lookup in Excel – How to lookup the pricing tier? [Formulas]](https://chandoo.org/wp/wp-content/uploads/2010/06/range-lookup-excel.png)
Excel formula to get a match from a given value in excel when you have start and end values in lookup table. This technique is useful for looking up a matching price from a pricing tier table or date in a range of start and end dates.
Continue »
You open an Excel file and some cells show #### instead of the value. Here is a quick fix.
Continue »How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)

Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.
Continue »