This lecture will show what a well-formed list is and teach you about the two important characteristics of a well-formed list.

By ensuring your list complies to basic standards you will find your list is easier to manage. Activities such as sorting, filtering, grouping and Pivot Tables are less time consuming and more accurate.

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this lesson you will learn to identify intrinsic data groups as well as derive hidden groups using data mining formulas.

Business decisions are often based on group analysis: how many, average, highest, lowest. There are also range and date comparison made to learn from past and plan for the future, as well as make sound decisions for the here and now.

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this lesson you will learn to identify intrinsic data groups as well as derive hidden groups using data mining formulas.

Business decisions are often based on group analysis: how many, average, highest, lowest. There are also range and date comparison made to learn from past and plan for the future, as well as make sound decisions for the here and now.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This demonstration will show how you can quickly create and adjust a Pivot Table. You will learn to use the four main ‘pivot’ areas and how to produce basic reports from the Pivot Table.

A Pivot Table is a tool for quick data analysis based on groups. Once a well-formed list has been created and groups identified, a Pivot Table can display aggregates quickly. The resulting data set can then be used as a basis for charts and reports. This demo will illustrate the analysis power of a well-formed list and a Pivot Table based on that list.

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this lecture I will show you the basics of creating a chart using a Pivot Table data set.

Charts are used to display data in a graphical way. The purpose of a chart is to deliver a message to your audience. The data sometimes can speak for itself, but there are times when a carefully selected and well-formatted chart can enhance your data message.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This video will demonstrate the use of functions designed to produce aggregates similar to what a Pivot Table does. We will start with the basic SUM function, then introduce you to SUMIF and SUMIFS. These functions can conditionally sum data lists.

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this lesson we will learn to use database functions. DSUM, DAVERAGE, DCOUNTA, DMIN, DMAX.

The purpose of the database functions are very similar to the purpose of a pivot table: to produce aggregates.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This video demonstrates the use of Excel's Goal Seek tool. It is designed to help us play "what-if" with the precedent values that feed a dependent formula.

There are times when we know what the result of a formula needs to be, but we are getting something other than what we want. By using the Goal Seek tool, we can tell Excel what our formula value needs to be, then point to the precedent cell and instruct Excel to find the correct value.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This video will introduce you to the Scenario Manager which helps us store and retrieve multiple values for a range of cells.

By using the Scenario Manager we can avoid the common practice of duplicating sheets or workbooks to store different scenarios of our data. Allowing us to create as many scenarios and we need, the Scenario Manager is the perfect tool for on-going "what-if" analysis.

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this demonstration you will learn to filter Pivot Tables with data Slicers which are interactive filters designed to make data presentation and analysis easier and faster.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This demonstration will show you how to use Excel's Advanced Filter tools. Although most of us know how to Excel's Auto-Filter features, few have discovered Advanced Filters.

Advanced filtering allows us to see the criteria as well as use OR/AND operators in our list filtering. One added benefit of Advanced filtering: we can filter or data without altering our original data set.

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this demonstration you will learn to use Conditional Formatting based on values in your data set.

Excel has many pre-built conditional formats available, which can be used as they are, or we can modify them to meet our specific needs. Conditional formats are dynamic, adjusting as the data in the sheet is modified, and graphically appealing making our large data sets more readable.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This short video will introduce you to SharePoint and how Excel lists can be used to create and populate collaborative lists stored in Microsoft SharePoint.

SharePoint is a collaborative work environment accessed primarily through a web browser allow quick sharing and collective content management by teams or departments. Where you have people and work to do, SharePoint is a great solution for collecting, storing and sharing business data, much of which can come from Microsoft Excel.

This is a brief demonstration of Excel and SharePoint integration. If you would like to learn more about this integration and SharePoint, look for my Udemy courses that are coming in the very near future.

Visit www.tomvorves.com for questions and links to other classes on Udemy

Watch my SharePoint introduction videos on Udemy: https://www.udemy.com/sharepoint-2013-introduction/

In this video I will introduce you to Microsoft PowerPivot 2013. PowerPivot gives us the ability to create advanced Pivot Tables based of multiple data sets, create relationships between these data set and pull data from many different data sources. PowerPivot is a data management tool that runs along side of Microsoft Excel.

This is a brief demonstration of PowerPivot. If you would like to learn more about this great data analysis tool, look for my Udemy courses that are coming in the very near future.

Visit www.tomvorves.com for questions and links to other classes on Udemy

Using PowerPivot I will demonstrate the use of a simple Key Performance Indicator (KPI).

This is a brief demonstration of KPIs. If you would like to learn more about this great data analysis tool, look for my Udemy courses that are coming in the very near future.

Visit www.tomvorves.com for questions and links to other classes on Udemy

This bonus video will help you learn to use a very popular and useful function called VLookup ("V" stands for vertical).

When you have to lists that need to be combined into one, VLookup can help. We don't always have the luxury of having two lists that can be simply copied and pasted together. There are mismatched records, discrepancies, or simply missing data from one or both lists. VLookup will take a common field found in both lists and find matches in both lists and return a value from the matching record.

Visit www.tomvorves.com for questions and links to other classes on Udemy

Allow me to introduce you to VLookup's big brother, Index/Match!

Watch this video and learn the power of Index/Match, the perfect alternative to VLookup WITHOUT the limitations of VLookup.  Enjoy

Visit www.tomvorves.com for questions and links to other classes on Udemy

In this video, I will demonstrate a cool technique of Conditional Formatting that will get you started down the road of Advanced Conditional Formatting using formulas.  Very cool

How about a quick overview of PowerPivot? PowerPivot is Excel's awesome data analysis tool set.  What you will learn in this short free video is just one of many powerful things you can do with PowerPivot: A VLookup Alternative. 

Now don't think this is all PowerPivot can do... This is simply one thing that I can show you in just a few minutes..

Enjoy