Where many people are familiar with Pivot Tables, most have never heard of the unpivot feature, and yet it has been included into Excel for years now! It is part of the suite of tools available through Power Query, and it is easier (and more useful) to use than you might initially expect.
Read MoreWhat is a process? what is a workflow? how are they different? and how are they similar? Let’s dive in to find out why people often use these terms interchangeably, and how we can use them to better how we work on a daily basis. Hint: It’s easier than it may seem!
Read MoreDashboards 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 MoreCapterra is a software solutions comparison tool. In short - this means that when you are debating between two pieces of software for your business, they should be your first stop! With user reviews, first time software selection guides, and synopsis and comparison tools, Capterra is a fantastic website for anyone who is in the market for a new piece of software.
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 Camera Tool within Excel is one of the most hidden features available in the program. It can’t be found on any standard toolbar, yet it is extremely powerful! Capture portions of a spreadsheet and display them anywhere you want without having to worry about other users modifying your data.
Read MoreOne hidden gem of a tool in Excel allows you to see the formulas and outputs of cells across sheets, making work and validation easier than ever before!
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 MoreOften times what people may describe as being a problem, is really only scratching the surface of what is going on. Learn how to dig deep, and really find out what’s wrong.
Read MoreThis lesser known tool can simplify the extraction of valuable information for massive data sets all within seconds, and according to your needs.
Read More