Dashboards and data summaries are an essential part of the workplace. Whether they be for weekly updates or executive level presentations, having a classy and functional approach to visualising data will not only save you time, but allow you to effectively communicate through graphics.
Read MoreXLOOKUP is a new function Microsoft has begun to integrate into their 365 subscription platform. This function looks to replace the likes of VLOOKUP and the INDEX/MATCH format. How does it hold up in comparison? Is it worth upgrading to Microsoft365? Download a free Excel workbook to test out the differences between all three functions!
Read MoreThe IF function is one of the first that many people learn. It can be even more powerful when used with a more intricate decision logic structure!
Read MoreConditional formatting has many uses, one which is often not explored to its fullest potential is the highlight duplicate values format.
Read More