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 […]
Blog
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel Protect Sheet
Do you have an Excel template for others to fill out and you want to make sure that […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]
Create a Pivot Table from Multiple Sheets using Power Query
Do you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […]
Excel’s AGGREGATE Function
The AGGREGATE function allows you to summarize values and gives you the ability to ignore values such as […]
Excel’s New Data Types
If you have Microsoft 365 (formerly Office 365) you can use Excel’s new data types to create Excel […]
Excel’s Stockhistory Function
What is the STOCKHISTORY function in Excel? The STOCKHISTORY function retrieves historical data about a financial instrument and […]
Excel Dashboard Introduction
Dashboards are a favorite topic in Excel for many people, including me. This post is just an introduction […]
Excel Map Charts
Excel has the ability to create a chart that is a geographic map showing your data. As a […]
What is a Data Analyst?
According to Coursera, a data analyst “gathers, cleans, and studies data sets to help solve problems”. Data analysis […]
Excel’s VSTACK Function
Combining or appending data from multiple sheets is a common task in Excel. We’ll show you how you […]