In this video we will talk about Pivot Tables, we will go over what PivotTables are, how they look like and then I will show you how to create PivotTables using the Excel’s automated tool and what you can do with them.

In this video I will show you how to create a PivotTable manually by placing the fields on the PivotTable framework, this will give you total control over the creation of your PivotTable.

In this video I will show you how to create a more elaborated PivotTable with different levels of information, make changes to the value settings, and others useful techniques to analyze your data. If you are not familiar with PivotTables, I recommend you watch my video “What is a PivotTable, and how to create one with the automated tool” before watching this video.

In this video we will explore the Lookup family functions. Lookup, VLookup, HLookup and XLookup These group of functions are very popular in Excel because they will help you retrieve information from a reference table or range. I will show you how do they work and how to use the functions.

In this video I will show you how to use the functions SUMIF and SUMIFS. These two functions will help you to add up numbers only if a specific criterion is met.

In this video I will show you how to use the Data validation tools. These group of tools will help you to reduce errors during the capturing of information. They will also help you to limit data entries to specific pre-define values.

In this video I will show you how you can use excel to calculate basis descriptive statistics measures like Number of data points, mean, median, mode, Standard Deviation, Minimum, Maximum and Range

In this video i will show you how to create a shipping report using embedded functions, IF and CONCAT

In this video I will show you how to use the conditional formatting tools These tools provide a visual aid to analyze your data based on the criteria that you set. We will focus on the highlight cell rules like: greater than, less than, between and how manage the rules. add, edit and delete.

In this video i will show you how to set table format to a datasheet without too much effort. I will show you some options and shortcuts

In this video i will show you how to create a chart with secondary axis and combine different types of charts in the same element. this will allow you to have a better visualization of the data you are trying to represent.

In this video I will show you different methods to identify and delete duplicated records from a spreadsheet. We will use conditional formatting, the concat function, and the remove duplicates tool.