Excel infographics for XLOOKUP Part 1

Purpose of this Excel Infographics for XLOOKUP Infographics (information + graphics) use visuals and text to highlight key information and ideas. The overall goal of infographic creation is to convey complex information in a simplified and in a compact manner. Using this teaching format, we can learn Excel formula like XLOOKUP quickly. What is XLOOKUP Use the XLOOKUP function […]

Excel Infographics for VLOOKUP

This is an infographic on the Excel function VLOOKUP. VLOOKUP is a super useful function when you need to find things in a table or a range by row.

Great Art Pixelated with Excel VBA

pixilated art excel vba

You can create beautiful pixelated artworks with this Excel VBA application! There are creative ways to use it. Create unique avatars for Zoom meetings or WhatsApp!

Do it in Excel: Ring charts are better Pie charts

Data

Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented by this person called William Playfair in 1801.