This video is a tutorial that explains how to create a smart, dynamic personal accounts manager using Microsoft Excel and pivot tables. The trainer in the video provides step-by-step instructions, starting with creating a chart of accounts and defining income statement and balance sheet categories. The trainer then goes on to explain how to freeze…
The video is a tutorial on how to create a relational data model using Microsoft Excel. The tutorial begins with an introduction to the concept of a data model and proceeds to show how to convert Excel sheets into tables before defining relationships between the tables to create a data model. The speaker emphasizes the…
This video is a tutorial on how to use Excel’s slicer tool to filter data quickly and easily. The video starts with an introduction to the purpose of slicers, which is to filter data to find specific information quickly. The presenter then goes on to demonstrate how to use slicers on a table of sample…
The video explains how to use different what-if analysis tools in Excel to forecast profits based on historical data and sales values. The tools used in this video include Scenario Manager, Goal Seek, Data Table, and Forecast Sheet. The video starts by creating a new column and using the average formula to calculate the average…
The video is a tutorial that guides the viewer through the process of creating an animated GPS route on a 3D map using Microsoft Excel. The presenter explains that to design this visualization, three columns are required: GPS coordinates in latitude and longitude, and a time column. To begin, the presenter suggests downloading GPS data…
This video is a tutorial on how to create a 3D map using Microsoft Excel. The presenter begins by stating that the information will be presented using Microsoft Excel 3D maps, and a picture background map will be used to display sensor data. The video provides step-by-step instructions for creating the 3D map. First, the…
Today we will show you how to add serial numbers to identical items without sorting the data, using the countifs function.
MS Excel files are containers (like compressed folders) that contain several XML files with data that you see in MS Excel spread sheets. You can view the raw XML files by opening Excel files as zip or rar files in any compression utility.
In this video, the speaker explains how to unpivot data in Microsoft Excel and Power BI. The data used in the video is world population data downloaded from the World Bank, which is already pivoted, but not in the form of an Excel pivot table. The speaker wants to convert this data into an unpivoted…
The video explains how to design a break-even decision model in Microsoft Excel to determine whether it is more cost-effective to manufacture a product or outsource it. The model is created by comparing the total costs associated with both manufacturing and outsourcing the product. The model takes into account the number of units, fixed costs,…