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 is a tutorial on creating a simple relational database in Microsoft Access. The video starts by introducing the objective of the exercise, which is to convert product, sales person, order type, and orders data in Microsoft Excel into a Microsoft Access relational database. The video then proceeds to explain how to create a…
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.
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,…
Conditional formatting in Microsoft Excel is a useful tool for highlighting and visualizing data based on specified conditions. There are several predefined rules, such as “Greater Than”, “Less Than”, “Between”, “Equal To”, “Text That Contains”, “A Date Occurring”, “Duplicate Values”, “Top 10 Items”, “Bottom 10 Items”, “Above Average”, “Below Average”, “Data Bars”, “Color Scales”, and…
In this video, we will show you how to use the fill features in MS Excel. These features allow you to quickly fill a range of cells with a series of data or a repeated value. This can be especially useful, when you need to enter a large number of similar values, or when you…
In this video, we will show you how to use lookup functions, and what is the difference between various lookup functions provided by MS Excel. #vlookup #vlookupformula #vlookupinexcel #vlookupfunction #xlookup #hlookup