Excel Data Entry Forms
Using Excel’s forms you can make your life easier. How? Forms can help you reduce the number of […]
data
Relationships and the Data Story
When we describe and present the data we are telling a story or narrative. Quantitative stories are always […]
Pivot Table Sales Data Example
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]
Excel Power Pivot Introduction
What is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […]
Excel Power Query Data Type Error
Sometimes when you bring in data into the Power Query Editor, you experience data type errors. Here below […]
Excel Power Query Fill Down
Are you using Power Query to import data into Excel and finding that one of your columns is […]
Get Data From the Web Into Excel
You can get data from a web page and import it into Excel. It’s easy. You might want […]
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel’s New Data Types
If you have Microsoft 365 (formerly Office 365) you can use Excel’s new data types to create Excel […]
What is a Data Analyst?
According to Coursera, a data analyst “gathers, cleans, and studies data sets to help solve problems”. Data analysis […]
Excel Dynamic Data Validation
What do we mean by dynamic data validation? Suppose we are asking users to enter a product (or […]
Excel Data Validation
Data validation allows you to limit or restrict the values that a particular cell will accept. It allows […]