excel
Data Model Examples in Excel
Do you want to work with a few small & sample data models in Excel to practice the […]
Pivot Table Sales Data Example
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]
Power Pivot Kevin Cookie
Let’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […]
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’s VSTACK Function
Combining or appending data from multiple sheets is a common task in Excel. We’ll show you how you […]
Excel Unique Function
The Excel UNIQUE function gives you all of the distinct values of a given range. All you need […]
Excel Spilled Ranges
What is an Excel spilled range? First of all, a range in Excel is a collection of two […]
Excel Add or Remove Table Rows and Columns
Rows If you have an Excel table, you can easily add rows to that table. One way is […]
Power Query Transform Phone Number
Do you need to split a column of imported Excel telephone number data into two columns so that […]