Part 2 of 3 in the Excel 2010 series 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.
Introduction to Formulas Hi, welcome to TrainSignal, my name is Bill and this lesson is Introduction to Formulas. In this lesson, I'm going to be talking to you about the order of operations and we're going to have plenty of examples so that we all are on the same page, we all understand exactly what the order of operations is. Then we're going to look at building a formula in Excel, we'll just use a couple of basic examples and we'll learn the difference between values and a reference. We've got a lot of great things coming up in this lesson so why don't we just get started?
Relative, Absolute, & Named References Hi, welcome to TrainSignal, my name's Bill, and this lesson is Relative, Absolute & Named References. In this lesson, we're going to go over relative reference, we already talked about this before in a previous lesson, but we're going to go into it a little bit more detail, kind of refresh your memory, if you've already forgotten. I'm going to talk about an absolute reference, we're going to show you what that is, and talk about how important this can be in a lot of the functions that you're going to do with Excel. We'll take a look at a 3d reference, 3d reference, no you don't need special glasses, it's going to be pretty cool. We'll take a look at naming ranges, and I'm going to show you, just because I like you guys so much, a really cool and efficient way of handling data, grouping your worksheets, alright. It's a lot of fun stuff, why don't we go ahead and get right to it.
Logical Functions Hi, welcome to Train Signal. My name is Bill and this lesson is: Logical Functions. In this lesson, we're going to, as you probably guessed already. Discuss a couple of the Logical Functions, primarily we're going to concentrate on the IF function. I'll show you how to use it in the basic sense. Then we're going to go ahead and teach you how to create a Nested IF, how to use Nested IF functions, and lastly, we're going to combine our conditions using the IF function with the AND. Lots of fun stuff, so why don't we go ahead and just get started.
Lookup Functions Hi, welcome to TrainSignal. My name's Bill and this lesson is Lookup Functions. In this lesson we're going to teach you how to do a VLOOKUP and an HLOOKUP. VLOOKUP and a HLOOKUP, you're going to find out, are basically the same thing. It's the same function, the only difference is with the VLOOKUP, Excel will look for the information vertically in a column, whereas the HLOOKUP will look for information horizontally in a row. And you know the drill, so let's get started.
Combine and Separate Text Hi, welcome to TrainSignal. My name's Bill and this lesson is Combine and Separate Text. In this lesson, I'm going to go ahead and show you how to concatenate text and don't get scared. Concatenate is just a fancy way of saying join. We're going to join text strings together and we're going to convert text to columns. This is a really great feature. Something that I get asked about quite a bit. I'm going to show you how to use it with a Delimited file and how to convert that text to columns using a Fixed Width. Lots of fun. Let's go ahead and get started.
View Separate Data Simultaneously Hi, welcome to TrainSignal. My name's Bill and this lesson is View Separate Data Simultaneously. In this lesson, I'm going to teach you how to use a split screen and also how to create workspaces. We'll take a look at workspaces with multiple workbooks, which will allow you to look at several workbooks at the same time. And, workspaces with multiple worksheets. This will allow you to view several worksheets from a single workbook at the same time. A lot of fun stuff so why don't we go ahead and just get right to it.
Sorting Hi, welcome to TrainSignal, my name's Bill, and this lesson is sorting. In this lesson, I'm going to show you how to organize your data using the quick sort, we'll be able to sort through data quickly, I know, pretty obvious, we're going to show you how to create custom sorts, so that you can sort by multiple criteria, and lastly, I'm going to show you how to sort and apply subtotals to different categories of your data. A lot of great stuff, so why don't we get started.
Filtering Hi, welcome to TrainSignal, my name's Bill, and this lesson is Filtering. In this lesson I'm going to show you how to use the Auto Filter, how to go ahead and filter your data so that you can hide the things you don't want to see, and see only the things that you want to see. We'll show you how to use a custom auto filter, whereby we will show you things like number filters, date filters, and text filters, and finally, lastly, but not least of course, the big, bad, scary Advanced Filter, and no, don't worry, it's not big, bad and scary, it is pretty cool, and once you get used to using it, you're going to find it's a really, really great tool. So lots of great stuff coming up gang, so let's go ahead and let's jump right in.