These Excel Tricks Make Ordinary Users Look Like Data Wizards

Data Analysis and Visualization Hacks in Excel Let’s explore 2 amazing data analysis and visualization hacks in Excel. Quick Analysis and Ideas. Very often when working with data, you will receive an Excel workbook and have no idea what the data is about. Or, what stories are hidden within it. To perform a detailed analysis, […]

3 Excel Hacks You need to know

There are so many Excel Hacks, picking 3 for this article was hard. Over the last 5 years, Excel has been developing at a rapid pace. New releases have seen some lovely goodies for everyone. Microsoft has added new features and functions. While they have also improved on some others. If you are a beginner […]

Encrypt and Decrypt Caeser Cipher in Excel using Power Query

Over the last few months, I have found myself interested in cryptography. Cryptography is the art of writing and solving clues. Often solving clues involves decrypting some sort of hidden message. Encrypting and decrypting messages is a lot of fun. A cipher is a series of steps taken to encrypt or decrypt a message that […]

Excel 101 – Getting Started with Excel 365

Everyone must start somewhere and getting started with Excel 365 will be made easy with this massive article.  Grab your coffee and get ready to learn Excel in a practical way. If you have every wondered how to use an Excel Spreadsheet and how you can learn to use Excel quickly then you have come […]

The Secret Power of SUMPRODUCT in Excel

SUMPRODUCT in Excel works by multiplying value pairs together and then adding the results together.  However, SUMPRODUCT is a function that accepts arrays, making it a very powerful function beyond its basic use. In this video, you will learn the secret power of SUMPRODUCT as we work through 5 different examples Basic traditional use SUMPRODUCT […]

Tips for Analyzing Categorical Data in Excel

It is often necessary to analyze different data types in Excel, including analyzing categorical data in Excel. Having opened up some blog posts to questions from you, the reader and Excel learner, Jeff sent me on this question: ” I am new to Excel and using it to start my learning journey in basic data […]

Excel’s Map Charts

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 […]

The CHOOSE function in Excel

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 […]