Part 3 of 3 in the Excel 2007 series. In this Excel 2007 training course, you'll learn everything from using the basic tools to the most advanced techniques, like tracking expenses, budgeting goals, and creating keyword lists.
Part 3 of 3 in the Excel 2007 series. In this Excel 2007 training course, you'll learn everything from using the basic tools to the most advanced techniques, like tracking expenses, budgeting goals, and creating keyword lists. This in-depth course is recommended for both beginners and experienced users.
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.
Templates Hi, welcome to TrainSignal. I'm Bill, and this lesson is Templates. In this lesson, we're going to go ahead and discuss templates. We'll talk about what a template is, a lot of people have the wrong idea about this. We'll use a template, we'll show you where they live on your computer, and we'll go ahead and download and install some. From there, we're going to create our own. We'll build one out of an already-existing workbook, we'll go ahead and protect our template, and then finally save it as a template.
PivotTables Hi welcome to TrainSignal. My name is Bill and this lesson is Pivot Tables. In this lesson we're going to go ahead and teach you how much fun you can have with a pivot table. We're going to first talk about what are they? We'll look at how we use them and what exactly we want them to do for us. Then we'll go ahead and we will create one together, and then I'll show you some more things that you can have them do for you. We'll look at formatting them and then we're going to go ahead and end up with talking about pivot charts. So why don't we go ahead and jump right into it.
Collaboration Hi, welcome to TrainSignal. I'm Bill and this lesson is about collaboration. Here we're going to go ahead and talk about teamwork. We're going to take a look at protecting and sharing workbooks across our network. We'll go ahead and track changes made by multiple users, then we'll look at merging documents and a little bit of a different situation then on our network. And lastly we'll look at comments, inserting them and hyperlinks as well. Why don't we get on to our Excel and get started.
Macros Hi welcome to TrainSignal. I'm Bill and this lesson is macros. In this lesson we're going to go ahead and explore the wonderful world of macros. We're going to take a look at using them, what they do, what they are, and we'll also address some security concerns. From there we're going to go ahead and create a couple. We'll build some from scratch, we'll take a look at using the macro recorder. Beyond that we're going to go ahead and take a look at shortcuts, buttons to enable our macros when we want them. Now we'll take a brief look at the Macro Editor and I'll discuss that more when we get there. And lastly, saving a workbook that has macros. Lots of fun things, so why don't we go ahead and get started
Printing Hi welcome to TrainSignal. I'm Bill and this lesson is printing, getting it on paper. In this lesson we're going to go ahead and start by reviewing our documents. We're going to go ahead and take a look at Print Preview, we'll zoom in on things, a few things to go ahead and get yourself so that you're looking at the document, the actual way it's going to print. Then we'll work on page layout. How many times have you gotten not exactly what you're looking for when you've printed your documents out? We're going to go ahead and fix a lot of those problems, show you some really good things you can do. Next we'll talk about headers and footers, putting those repeating areas on our documents and then when we're finally ready to print, a couple last things to make sure everything is exactly where we want it. So why don't we get started.