Map charts can be used to visually display values and category’s across the geographical area. These charts can be worldwide, and they can also be much closers such as your state, county or city. In Office 365 or Excel 2019, you now have the option to use Map visualizations to view your geographical data. How […]
Learn how to create a funnel chart in excel to display data of decreasing size
The Z-Score is used to compare items with different units of measurements. In Excel Z-scores can be quickly calculated using Standardize
The CHOOSE function in Excel is very versatile. It can be used as a lookup and it can be combined with many other functions that make it extremely useful. “Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index […]
Excel is an amazing tool that can do so much, from keeping basic lists to more complex data analysis and visualizations. In this article today you are going to learn 4 Excel tips that will make your life easier and you more efficient in Excel. In this article we are going to look at Simple […]
For years now Accountants and bookkeepers around the globe have used Excel as their Spreadsheet tool of choice. It offers massive flexibility, speed and is as accurate and reliable as the users. But to this day, some Excel users never go beyond the basic totting and cross totting of rows and columns. Excel has come […]
BEST SELLING COURSE The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the […]
The SWITCH function in DAX can be used to replace nested IF statement. It is both easier to read and easier to write. SWITCH was introduced in PowerBI in Nov 2016 and it is also available in updated versions of Excel 2016 By the end of this article and examples you will Understand the syntax […]
In a previous article we covered The Basics of VLOOKUP. VLOOKUP is a very versatile function that can be combined with other functions. When you learn to combine VLOOKUP with with other functions it makes it super powerful. In this article we will look at combining VLOOKUP with TEXT functions. Lets quickly refresh some basics […]
To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it. However sometimes this data might require a little manipulation to be fully understood and analysed in Excel. In this article you […]