Part 3 of 3 in the Excel 2010 series. This course will help you learn all the features in Excel 2010. You'll learn how to take advantage of the ribbon interface, utilize formulas, make references and functions, and create charts and PivotTables. This course is recommended for anyone wanting an in-depth look at Excel 2010.
Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.
Define Data as a Table Hi. Welcome to TrainSignal. My name is Bill and this lesson is, Define Data as a Table. In this lesson, as you've probably already guessed, I'm going to show you how to define data as a table. We'll teach you how to add a total row to that table, I'm going to show you how to expand your table, and a little bit about formatting that table, and lastly, we'll show you how to convert that table back into a range. Some really great stuff, so why don't we get started.
Introduction to Charts Hi. Welcome to TrainSignal. My name's Bill and this lesson is Introduction to Charts. In this lesson I'm going to talk you about what is a chart. We'll take a look at chart components like series name, series values, and category labels, and we're going to take a quick look at different types of charts. Column, line, and pie being the three most popular and the ones that we will discuss in much greater detail in further lessons, and we'll take a look at a few others, so let's go ahead and let's jump right in.
Create a Pie Chart Hi. Welcome to TrainSignal. My name's Bill, and this lesson is, Create a Pie Chart. In this lesson I'm going to show you how to insert a pie chart into your Excel workbooks, choose the chart type. We'll also take a look at chart design options, some chart layout options, and chart formatting options. Lots of great things. The pie chart is one of my favorites, so let's go ahead and let's have some fun shall we? We have here a very simple table, it's 12 months' worth of expenses data. We have how much we have spent on different expenses throughout the year for our company, and we'd like to chart them. We want to know what percentage of our whole expenses budget, how much we've spent, goes to each one of these expenses, so to do that we're going to create a pie chart, and we're going to simply click and drag to select the total column here. We're going to select those totals because that's what we want to chart.
Using Sparklines Hi. Welcome to TrainSignal. My name's Bill, and this lesson is Using Sparklines. In this lesson I'm going to, and you've probably already guessed, show you how to create and use sparklines. sparklines are a neat little feature, a cool charting tool that has been added to Excel 2010. There are three different types of sparklines, a line, a column, and a win/loss sparkline. I'm going to show you how to use and create all of those. I'm going to show you some different options that you have when creating sparklines, and show you how to do some basic formatting things with sparklines. Sparklines are a nice little thing. They're a great feature. I'm very excited to show you how to use them, so why don't we go ahead and just jump right in.
Introduction to PivotTables Hi. Welcome to TrainSignal. My name's Bill, and this lesson is Introduction to PivotTables. In this lesson we're going to ask the question, what exactly is a PivotTable, and I'm going to tell you. I'm also going to tell you why do we use a PivotTable, we'll take a look at one, and I'll show you briefly how to manipulate the data in it. Basically, in this lesson we're going to go ahead and work through kind of getting you familiar with a PivotTable, and what it can do, and in a future lesson I'm going to show you how to actually create a PivotTable, and do a lot more things with it, so let's go ahead and let's get started. What exactly is a PivotTable? A PivotTable is a tool that's used to analyze large amounts of data. You could have a worksheet with, you know, a couple hundred thousand cells filled with data and you've got to wade through there and find that one thing or that one trend. That can be a daunting task without something like a PivotTable to help you. The PivotTable compresses the data into small tables that are easily managed with the use of filters, and if you don't understand what I'm talking about hang in there with me because I am going to show you all of this in great detail in this lesson and in the next couple. PivotTables are very, very flexible. They're able to go ahead and do a lot of things with that data. So why do we use PivotTables? We use them to organize our data, to summarize our data, so that we can analyze our data. Alright, enough of this theory, let's go ahead and let's take a look at a PivotTable.
Creating a PivotTable Hi. Welcome to TrainSignal. My name is Bill and this lesson is Creating a PivotTable. Alright, we've finally gotten to my favorite part of the course I think, Creating PivotTables. I saved the best for last. In this lesson we're going to show you how to create a PivotTable and I will teach you about the report filter, column labels, row labels, values. We'll also take a look at styles and style options. A lot of work, a lot of fun stuff we're going to go ahead and do with our PivotTables, so let's just dive right in.
More Fun With PivotTables Hi. Welcome to TrainSignal. My name is Bill and this lesson is More Fun With PivotTables. In this lesson I'm going to show you some PivotTable options that you have available to you. I'll show you how to sort your PivotTable. We're going to talk about calculated fields, how to create fields of data that don't exist. I'm going to teach you how to show your value as different things, and I'm going to teach you about the slicer. The slicer is a new feature to Excel 2010 and it's a great way to make using PivotTables really easy, simple, and fun. Lastly, we're going to show you how to show report pages. This is very, very popular, it's one of those things that I always enjoyed doing. Alright gang, we've got lots of fun stuff coming up, so why don't we just get down to it.
Create a PivotChart Hi. Welcome to TrainSignal. My name is Bill and this lesson is Create a PivotChart. In this lesson I'm going to show you how to insert a PivotChart and manipulate the fields. We'll take a look at field buttons, which are available on our chart. I'm going to show you your PivotChart tools, the slicer, yes the slicer is back, and show you how to create a PivotChart from a PivotTable. Now, at this point, I'm going to ask you if you haven't watched my lessons on creating a PivotTable that you go ahead and watch that first because we're not going to explain how the PivotTable works. I'm just going to go ahead and show you how to use a PivotChart the same way you would go ahead and use a PivotTable, so go ahead and watch, at the very least, my overview on PivotTables okay? Alright, let's go ahead and let's get started.