The post Learn Advanced Excel – 3 Month Roadmap with Resources appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>I have always had a fascination with Mandelbrots, since I was introduced to them in High School in the late 1970’s. With the advent of personnel computers, I could then program my own Mandelbrot plots in Quick Basic, before some of the highly optimised Fractal Programs popped up in the mid 80’s, my favorite at the time was Fractint.

I wrote my first Excel Mandelbrot program in the late 1990’s, using VBA. But it was in a business meeting in the early 2000’s where I had questioned the need to get develop and application, where I questioned “Why do that, when we could easily do that in Excel”. The salesman gave me a spiel about why you couldn’t do that do that in Excel, with me retorting “You can do anything in Excel”. He immediately responded “You can’t make a Mandelbrot in Excel without using VBA”.

**Challenge accepted !**

That night over dinner, I had a light bulb moment and 20 minutes later the proof of how to develop a Mandelbrot in Excel was defined and working. I was recognized for that effort by **John Walkenbach** in his 2007 Excel Bible.

A Mandelbrot is a contour plot of the count of the escape iterations of the formula Z^{2}=Z^{2}+1

Areas shaded black, the iterations never escape a predefined value, areas of similar color outside the black area, take a similar number of iterations, before exceeding that predefined value, ie: escaping the Mandelbrot. Mandelbrots are fascinating constructs with many one remarkable feature of the Mandelbrot being that it has a defined area, but an infinite length boundary.

The Mandelbrot is calculated by solving the equation Z^{2}=Z^{2}+1

Z is calculated via a formula that is recursive, ie: it feeds on its previous values.

This value of Z is equal to a previous value of Z via some function, in this case Z^{new2}=Z^{old2}+1

Z is also a complex number, which is typically shown as Z = X + Yi, where i is the square root of -1

The Mandelbrot equation can be solved in the real / orthogonal plain using X & Y values iteratively.

My first post at Chandoo.org in 2009 was a discussion of how to use the Excel Data Table function which included a section on Iterative Functions and Fractals. https://chandoo.org/wp/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/.

The Mandelbrot is the calculation of a solution to the equation, Z^{2}=Z^{2}+1.

This can be performed on the orthogonal X-Y plane, where the X & Y values form the starting location for a solution, which is then iterated through the formula, keeping count of the number of iterations to achieve or exceed a predefined limit.

You can read about the math required in the Computer Drawings section of https://en.wikipedia.org/wiki/Mandelbrot_set

You can follow along using the Mandelbrot file using the link below

Effectively you need to have 3 loops inside each other, which can be done within Excel with a bit of thinking and smart use of Excel Functions.

We can use the Rows of a worksheet to do the iterations of one set of starting X & Y values. The other two loops that feed the initial X and Y values are souced iteratively using a Data Table function. that will be described in a section below

This is shown below:

1 – Starting coordinates, X & Y values, these will be updated via a 2 dimensional Data Table

2 – Transfer starting values into the iteration area

3 – The starting values become the old X & Y Values

4 – Calculate the new X & Y values using the formula

Xnew = Xold^{2} – Yold^{2} +Xorig

Ynew = 2 x Xold x Yold +Yorig

5 – Calculate the Rsq value, or the distance of the new point from the origin

Rsq = Sqrt( Xnew^{2} + Ynew^{2} )

6 – If the RSq value (7) is not greater than the Escape Value (8) repeat steps 3, 4 & 5 above

7 – When the Rsq value (7) is greater than the Escape value (8) stop iterations and determine the count in this example it is 8

So we have determined the Count value 8 for our starting position of x=-1.0, y=0.4

you can examine the table of Xold and Yold values above and see how they change over the various iterations.

Once the Rsq value is greater than 4, subsequent iterations can never be less than 4 and the iterations have escaped the Mandelbrot, in this case in 8 steps.

This is shown graphically

We now need to do that for each set of x, y coordinates in the range x = -2 to 1, y= -1.5 to 1.5

To achieve this we can setup a 2 Dimensional Table, and then use the **Excel, Data Table **function to feed the results into the Xorig and Yorig positions.

This is shown below

**1** – A 2 dimensional data area, yellow, is setup. the column headers contain the x coordinates from -2 to 1 and the row headers contain the y coordinates from -1 to 1.

The Excel Data Table function is used to put the Column & Row headers in order into the Xorig and Yorig positions

ie: The Data Table is setup using the **Data, What If Analysis, Data Table** menu and entering the cell references for the Xorig and Yorig cells

**2** – The Data Table function iterates through every cell within the Data Table, Yellow, area sending the Row and Column headers values to the Xorig and Yorig cells **$F$10** and **$F$11 **respectively

**3** – The Data Table function recalculates the worksheet and sends the Count, 2 in this case, back to the Data Table Upper Left cell **H222**.

**4** – The Data Table function then stores that value in the Data Table position at the intersection of the Column and Row ie: **Cell J225**

The data Table function continues iterating through each of the yellow cells, repeating steps 1 to 4 above.

Once the Data Table function has completed iterating through the Mandelbrot data table area you can zoom in on parts of the table and can see they contain the Counts of the escape iterations as defined above

You can start to visualise the shape of the contours of the Count by following areas of constant values

However Excel has some charts that are suitable for displaying contour data, the **Surface, Contour chart** type.

The Mandelbrot calculated and displayed above conforms to the maths described in the Computer drawings section of the https://en.wikipedia.org/wiki/Mandelbrot_set post. But I had always wondered whether Excel could calculate the Mandelbrot directly using complex maths.

Excel contains a number of native functions that handle complex numbers, ie:

You can read more about the Excel use of complex numbers at:

**COMPLEX()** – Converts the component values of a complex number to a complex number

**IMSUM()**– Sums or adds up complex numbers

**IMPOWER() **– Calculates the complex number raised to some power

**IMABS() **– Calculates the absolute value of an complex number, ie the square root of the complex numbers components squared

https://best-excel-tutorial.com/59-tips-and-tricks/213-complex-numbers

I had always wondered whether we could use the Complex math functions within Excel to calculate the Mandelbrot directly.

Well wonder no more, the answer is **Yes** it can.

You can follow along using the Complex Mandelbrot file from the link below

By using the Excel Complex functions, the math is simplified at the expense of speed.

The Excel complex functions are incredibly slow compared to the native excel functions which in most parts are highly optimised for speed.

Lets examine how this Mandelbrot works using the Excel’s complex functions

The first thing to note is that we now do not require the Xold, Xnew, Yold and Ynew columns

The data is all contained within the z column, and each row uses the previous row for it’s iteration calculations.

Using the same inputs as above x = -1.0 and y = 0.4, these are stored in **G12:G13 **respectively.

Cell E18 converts the Xorig and Yorig values into a complex number using the formula:

E18: =COMPLEX(G12, G13)

Excel displays complex numbers as a text string, ie: Cell E18: displays **-1+0.4i** representative of the complex format of **-1x +0.4y **starting position of the selected Mandelbrot cell

The values in the range **E18:E200 **are complex numbers, but Excel displays them as a text string and stores the complex number components in the background.

E19: calculates the sum of the power of the previous number and adds it to the original number using the formula:

E19: =IMSUM( IMPOWER(E18, $G$7), $E$18)

This is using IMSUM() to add the result of the squaring of the previous complex number E18 and the starting value, also in E18.

The squaring is done using IMPOWER(E18,$G$7), where E18 is the number being squared and $G$7 has the value 2 in it

E20: similarily has

E20: =IMSUM( IMPOWER(E19, $G$7), $E$18)

This is using IMSUM() to add the result of the squaring of the previous complex number E19 IMPOWER(E19, $G$7) and the starting value, in E18.

This is repeated below for the iterations

The Rsq value is calculated using the formula in F18

F18: Checks that the Absolute value of the complex number is not greater than the Iteration Escape value using the function

F18: =IF(IMABS(E18) > $G$9, 0, IMABS(E18))

In this case we can use the complex function IMABS() to calculate the Rsq value and check that against our escape iteration limit from Cell $G$9.

The rest of the calculations and function of the Mandelbrot are the same as the original version described above.

The final result is a Mandelbrot Chart shown:

You can manually zoom in on areas of the Mandelbrot by changing the starting coordinates

It isn’t difficult to see that this can be updated by using a simple macro and the Double Click event, where a user can double click on a cell within the Mandelbrot, and the macro transfers these coordinates into the cells above using a 10:1 or other predefined zoom factor

I hope you have enjoyed this introduction to iterative functions within the Excel worksheet and a foray into complex numbers

I have demonstrated that Excel can compute and display a Mandelbrot or in fact any iterative function without the use of Visual Basic on the Excel worksheet.

Excel has tools that allow multi-dimensional iterations within the worksheet space. This opens up the use of Excel for complex financial and other modelling analysis in multiple dimensions.

Excel can do all this using Real or Complex numbers.

Have you used complex numbers or iterative functions in Excel ? Let us know in the comments below.

The post The Excel Mandelbrot appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>Here is a fabulous New Year gift to you. A free 2023 Calendar & Activity planner made entirely in Excel. This dynamic calendar workbook lets you:

- See the calendar for entire year in a single view
- Dynamic
*any month*calendar with detailed plan view - Automatic updation of holidays, weekends and activities
- Snapshot of upcoming activities
- Fully customizable – start on any day, any weekend, custom holidays
- Optimized for screen and print outs

Click the below button to download the free 2023 calendar template.

This calendar is compatible with Excel 365. It uses modern dynamic formula techniques to automatically generate the calendar, planner and month views.

If you have an older version of Excel (such as 2019 or 2016, 2013) then please use this alternative version.

The calendar & planner file has 4 tabs.

**Calendar tab:**See the 12-month calendar view + upcoming activities in this page. It also highlights any holidays, weekends and planned activities on the calendar in a different color.**Any month tab:**This page lets you see the calendar for any specific month in a detailed view. You can change the month from cell C3 and the calendar updates automatically. The calendar shows date, any activities planned in a neat grid view.**Planner tab:**Use this tab to set up your activities. Whatever items you list here will automatically show up on the calendar & any month tabs.**Customizations tab:**Do you want to change the way your week begins? Need to add some holidays or change the icons? Use the customizations tab.

The calendar workbook has two main components.

- Calendar
- Planner

To generate the calendar, I am using the *dynamic array functionality *of Excel 2023. We can use the SEQUENCE function to create all the dates in any given year.

For example, =SEQUENCE(365,,DATE(2023,1,1)) generates all the 365 dates in the year 2023.

I then used the same logic to generate monthly calendars for all the 12 months and adjusted them based on the week start option.

Once the monthly calendars are generated, then I highlighted the weekends, holidays and activities using conditional formatting.

You can set up any number of activities in the planner table. I am then using FILTER function to filter out the activities for a given day and show them next to the calendar date.

Also, if “highlight activities” is enabled, then I am highlighting the calendar cells in a different color.

In the 12-month calendar view, I am showing upcoming 10 activities using FILTER function too.

If you want to learn more about the calculations and set up of this workbook, please refer to these articles + videos.

- Dynamic array functions in Excel – introduction to FILTER, SEQUENCE etc.
- Conditional formatting to highlight values in Excel
- Data validation to select a month in Excel cell
- Excel tables – How to create a simple tracker in Excel
**Video**: How to use FILTER function in Excel

The post FREE Calendar & Planner Excel Template for 2023 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>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)]

2022 has been a phenomenal year for me both personally and professionally. It brought so much positivity, energy and love. I want to take a moment to thank some of the key people who inspired, helped or contributed to my mission this year.

**Thank you**: for reading, watching, purchasing or listening to my work. You continue to inspire me and energize me.**My family:**for being the absolute bedrock of my support. You always encourage me to experiment, have fun and be myself. Thank you**Our staff:**Thanks to Ravindra, Pothi & Soumita for all the AWESOME work you have done this year.**Our forum members:**You selflessly answer questions and help people do great things at their work. Thank you.- Vena: for working with me this year on various events and sponsoring my channel. Special thanks to Zach and Siobhan for all the awesome work you have done.
- Global Excel Summit: for inviting me again in 2022 to speak and share some of my knowledge with your members. You also taught me many things. Thanks to Tea Kuseva for your tireless work behing scenes.
- Bulgaria Excel Days: for having me at the BEST conference ever. You have inspired me to work hard and party harder. Thank you Boriana & team for the amazing experience.
**Mentors & Teachers:**This year I learned from 100s of people thru platforms like YouTube & Podcasts. Some of the key individuals that shaped my thought and action this year are,- Adam Saxton from Guyinacube
- Wheezy Waiter, Ali Abdaal, Simone Giertz, Nikhil (CaptainSinbad) Govind Vasanta and Rajesh Vaidhya
- Oz du Soliel, Jon Peltier, Gasper Kamensek, Ken Puls & Reza Rad

**Sponsors:**This year I had the fortune of working with some amazing brands & companies. I want to shout out to BrightData, Vena and ZebraBI for the love and support you have shown.**Companies:**- Big thanks to Microsoft for making such awesome software – Excel & Power BI
- YouTube for making a platform thru which I share and connect with millions around the world
- WordPress for coolest blogging platform
- Elementor, Wishlist, e-junkie, stripe, convertkit, epidemicsound, unsplash, pexels, mediavine and aws for helping me run my little kingdom without hassles
- Camtasia & Adobe for your marvelous software that helps me create videos for my audience

**Philip Wiest**for answering student questions during my Power BI Day event.

We (Jo, kids & I) are traveling to India for the Christmas & New Year break. I will not be posting any new videos or articles until 1st week of January. If you send me an email or leave a comment I will not be replying to it until much later. Stay safe and have fun. See you in 2023.

The post Merry Christmas & Happy New Year 2023 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post Range Lookup in Excel – How to lookup the pricing tier? [Formulas] appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>You open an Excel file and some cells show #### instead of the value. Here is a quick fix.

- Just make the columns wider

Even after making the columns wide-enough, sometimes Excel can show ### in cells. This can happen if you have dates in the cells and some of the are negative (or after 31 December year 9,999).

See below demo:

Excel cannot process negative dates or dates before year 1900. In most situations, a negative date could be just a formula or data entry error. So go ahead and apply the necessary data adjustments.

Sure. You can use IFERROR function in Excel to show an alternative result when the original values is error. To use this:

=IFERROR(your original value or formula, “alternative result”)

For example:

=IFERROR(AVERAGEIFS(A1:A10, B1:B10, “England”), “No result”)

The above formula tries to calculate the average of A1:A10 where B1:B10 is “England”. If there is an error, it will print “No result”.

See these pages to learn more about common errors with Excel.

- Excel formulas showing as Text and not calculating
- A handy guide to common Excel errors
- Use IFERROR to stop errors in your workbook
- 10 important Excel functions you should learn

The post #### in Excel cell appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post Holiday Sale is on, Save 20% on your favorite Excel / Power BI courses appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>I have been working with SharePoint a lot these days. A LOT!!!

One thing that frustrates me all the time is that there is no *easy *way to connect to a single SharePoint file from Power Query. *Until now, that is.*

The other day I learned a handy little trick from Jo (my beautiful and insanely talented wife). So here we go.

I have a file in SharePoint (as shown below) and want to link it to Power Query (either in Excel or in Power BI).

When I use the Share > Copy Link approach I can’t get the file to open thru Power Query. You can see the **Unable to Connect **error message when I try this option below:

So the normal fix for this has been,

- Open a
**SharePoint Folder connection** - In Power Query filter down to the single file I need
- Apply any transformations
- Finally load

So this is the trick Jo told me.

- Click on the ? (three dots menu) next to your file in SharePoint
- Go to Details
- This opens a panel on the right-hand side of the screen
- Scroll down and locate the “path” and copy the path
- Now use this path in Power Query (from web option)
- BOOM! You get the data straight away.

*Here is a quick demo of the solution:*

We can use Power Query to connect and get all sorts of data into either Excel or Power BI. If you are new to Power Query or need a proper introduction, check either of below resources.

The post How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. Download it today.

**Download the Excel workbook (Excel 365 version)**

Don’t have Excel 365? Use the **Non 365 version here**.

**Group & Knockout Stage Views**

Two separate tabs provide clear view of the schedules & results from Group Stage & Knock out stage of the football worldcup. They will auto-update whenever you refresh the workbook.

**Fantasy View (set your own Group Stage Winners)**

Pick your own winners for each of the 48 group stage matches and then see how that pans out at the knock-out stages (bracket view) with this cool Fantasy view. Switch between Fantasy and actual standings anytime.

**Match Schedules:**

The workbook also provides match schedules (dates & times as per local Qatar timezone) and quick access links to the match report.

**Refreshable Scores & Group Standings:**

The workbook is refreshable. If you hit CTRL ALT F5 (or Data ribbon > Refresh All), the group standings, points etc. will automatically update. The workbook uses Power Query in Excel to connect to Wikipedia page and fetch standings & results.

I plan to make a video explaining the process if time permits. But here is the quick run-down of the process:

- All the data comes from 2022 FIFA World Cup page on Wikipedia.
- I am using Power Query (Data Ribbon) to fetch the relevant tables from the Wikipedia page.
- Once the data is loaded to Excel, I created two different views, one for group stage and another for knock-out (elimination) stage.
- Here I am using either Dynamic Array formulas (such as FILTER & SORT) or good old INDEX MATCH formulas to get the correct values.
- In a separate tab, I have the schedule of all the 48 games. Here you can also specify the winners in a
*fantasy column.* - I used Data Validation to let you (users) select whether you want to view
*fantasy view or actual view.* - I applied conditional formatting to change color of the
**bracket view**if fantasy results are shown.

As this workbook relies on the Wikipedia page, if something changes there, the workbook can break. I will check the file once every few days and fix any known problems. Comeback to this page and download latest version if possible.

If there are any issues with the file, please post a comment so I can fix them.

**Alternative trackers:**

Try the Spreadsheet tracker from Spreadsheet1.com as well.

These kind of files are a great little project to build up your Excel skills. I suggest reading up below pages to learn some of the skills:

- Power Query – for connecting and getting data from anywhere (including web)
- Dynamic Array formulas – for calculating results dynamically
- Data Validation – for collecting user inputs
- Conditional Formats – for changing colors automatically
- FIFA 2018 Worldcup Tracker (another workbook to try and learn)

The post FIFA 2022 World Cup Schedule & Results – Excel [FREE Download] appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>Time for a quick but very handy Excel FORMULA trick.

You have two tables. ORDERS & PRODUCTS. You want to see all the orders if the product name is mentioned in the other table. Thanks to the new FILTER() function in Excel, we can do this easily now.

For the purpose of this example, assume you have a table named **orders** and another table named **products**.

Here is the formula to fetch all orders for the products listed in the other table.

`=FILTER(orders, COUNTIFS(products, orders[Product]))`

**How does this formula work?**

This is a two-part puzzle.

Let’s look at the COUNTIFS portion first:

`COUNTIFS(products, orders[Product])`

This formula returns an array of 1s & 0s

- It will be 1 whenever the orders[Product] matches one of the products table items.
- Else it will be 0
- The size of this array will be same as orders table. So if orders table has 100 rows, then you will get 100 ones or zeros here.

The NEW FILTER() function in Excel can take a list or table and filter it based on a criteria.

So, for example, =FILTER(orders, orders[Product]=”Milk Bars”) would filter all rows where the product names is **Milk Bars**.

The trick is to use COUNTIFS output (which will be a bunch of 1s & 0s) as the criteria for FILTER. When Excel sees these 1s&0s, it’s going to include the rows with 1 & exclude the rows with 0.

Thus, producing the relevant orders for us.

Here is a quick demo of the formula in action:

While this is a great technique, if you have large amounts of data then the formula could be slow. In such cases, I recommend using Power Query to handle the job. We can use **inner join **in Power Query merge operation to filter one table by merging it with another table.

**For more on Power Query, please read this article**.

If you need a sample file to practice this formula, click here and download it.

I have been using the FILTER(… COUNTIFS()) approach for quick scenarios and Power Query Merge option for more complicated situations. What about you? How are you solving this problem? Please share your thoughts or questions in the comments section.

The post Filter one table if the value is in another table (Formula Trick) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post Which Excel Formulas should you learn first? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post Mortgage Calculator with Extra Payments – Excel Download appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post Learn SQL for Data Analysis in one hour appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work to next level. In this easy tutorial, learn how to set up and work with tooltips in Power BI.

**Power BI Tooltip**

A quick demo

Create a visual on the page where you want your tooltip. Let’s say you want to show the headcount by department in a column chart, like below:

? Tip: New to Power BI? Try this getting started tutorial first.

Insert a new Power BI report page. Click anywhere on the page and go to “format page” area, in the format pane.

Setting up a tooltip page

- Click on the “format” options
- Go to “Canvas settings”
- Set the page type as “tooltip” from “16:9”

On this “new” page, just add whatever visuals, images & textboxes you want to show. For example, I want to show gender & employee type distribution. So I added those visuals.

? Tip: Make sure you give your “tooltip” page a name.

Go back to the report page. Select your main visual. Then link it to the tooltip page using below steps.

- Go to “format” and “general”
- Select the “tooltip” area.
- Set the type to “Report page”
- Select the page from the list of pages.

*Voila*! Your tooltip is now set up.

- You can put
*anything*on the tooltip page and it will show up. For example, here is a. It has page background color, DAX measure (with SELECTEDVALUE) to show the department name in the heading.*fancy tooltip*

- Don’t show too much detail or tables in tooltips. As tooltips are
*ephemeral*it is a good idea to keep them simple. - You can customize the tooltip size! When creating the tooltip page (step 2), you can use “Custom” as page size and set up a different size or shaped tooltip.
- Use tooltips to show helpful hints or messages. You can get creative with tooltips by linking them to a card or table visual to show help messages, explanations or other useful text. See this demo:

So what are you waiting for? Give them a try.

If you need a hand with the tooltips, here is my sample Power BI workbook.

Want to learn Power BI? Check out below articles + videos.

- Introduction to Power BI and your first project (article + files)
- Getting started with Power BI (video + files)
- How to use Power Query (article, 4 practical examples + files)
- Full course on Power BI

The post How to create interactive tooltips in Power BI (step by step) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post How to learn Python as an “Excel person”? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post Can you split “The Hangover” expenses? [Excel Homework] appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post What is LAMBDA? 4 Practical examples to REALLY understand it appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>Do you want a stylish, interactive and useful monthly calendar & planner template? Then please use below link to download it. A new year gift to you from Chandoo.org ?

- Works for any month of the year 2022
- Big cells with enough space to jot down notes when printed
- Works in any version of Excel

- A customizable data entry worksheet for activities + events by date
- A set of icons to tag activities
- Works for any month
- Needs Excel 365

I made a video explaining the calendar + planner logic, formulas and construction. Please watch it here.

- Annual calendar (works for any year)
- Todo list template
- Project Plan template
- Project management templates (paid)

The post FREE 2022 Calendar & Monthly Planner Printable Template appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>Hello readers & fans,

On behalf of my family, our staff, volunteers & well-wishers, Let me **wish you a very happy Christmas & prosperous new year 2022**. Here is a small holiday card from Chandoo.org HQ.

**About this year’s card: **(From left: Nishanth, Jo, Nakshu & Chandoo) We went to the beautiful Queenstown this October to celebrate my 40th (XL Birthday!!!) and took this picture just before a sunset. The kids are now taller than mum and as tall as me. We will be taking family pictures sitting down from now on, so that they don’t look like giants. ?

2021 has been a very positive and inspiring year for me. I found a renewed sense of mission to learn, grow & share with the world. Even though I did not blog much this year, I have been *very active *on YouTube, building a community of Excel / Power BI learners. I want to take a minute to acknowledge some of the people & organizations that helped me this year.

- You – for reading my articles, watching the videos or learning from a course. Thank you for making me your learning partner.
- My family – for supporting & loving me all this while. My kids & Jo also played an important role in filming or giving feedback on my videos.
- Microsoft – for creating Excel & Power BI.
- YouTube – for providing an awesome platform to learn & share
- My teachers – too many to name, but thanks for guiding and inspiring me. Some quick shout outs
- YouTube & Video related: Dusty Porter, Tim & team at Video Creators
- Life & Inspiration: Wheezy Waiter, Ali Abdaal, Simone Giertz, ElectroBoom

- Conference & events: This year I had the fortune of presenting virtually at many meetups and events. Special thanks to Vena Corp & Global Excel Summit.
- My staff – Ravindra & Pothi for keeping the gears turning and helping me focus.
- My customers – thanks to more than 1,200 people who bought a course, template, e-book or live cohort membership this year and supported me.
- My Supporters – Thanks for more than 145 people who donated a superchat / supersticker during my YouTube live streams this year.
- Our forum regulars & mods – thanks for taking time to help and share your knowledge.
- Blog & channel friends – for recommending & sending people my way. Big thanks to Bill Jelen, Danielle, Ken Puls, Alan Murray, Sumit Bansal & Boriana for sharing a few tips on the channel
- Software providers – for helping me run the site & channel. Big thanks to WordPress, Elementor, Stripe, E-junkie, PayPal, Wishlistmember, KnownHost, ConvertKit, Amazon, Gmail, Techsmith, EpidemicSound, Unsplash, Pexels & Pixabay

We (Jo & I) are taking some time off the work and traveling with kids to South Island on a road trip. We will be visiting Christchurch & Kaikoura for 10 days. I will be sipping beer on the beaches or going for a swim between now & 4th of Jan.

Once again, I wish you a very happy Christmas & a prosperous New Year 2022.

The post Merry Christmas & Happy New Year 2022 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>The post How to write complex Excel formulas (hint: it’s a lot like LEGO) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

]]>