Part 1 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 1 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.
Introduction to Excel 2007 Hi, welcome to Train Signal. My name's Bill and this course is Excel 2007. This first section is our introduction, who, what, and why. First thing I'm going to do is tell you a little about myself. Then we're going to talk about who you are, who should be taking this class, what kinds of things you're looking for. Then we're going to go and talk about this course, exactly what things are we going to show you, what are we talking about, give you a little brief run-down of each. Next, we have a scenario that will be running throughout the entire video. And then we're going to go ahead and take a very quick look at keyboard shortcuts. I have a list in here for you to study, print out, do whatever you need with. Then we're going to go ahead and look at what we learned. This will be the same format that we will follow throughout all of the sections of this course, so let's go and let's get started.
Welcome to Excel Hi, welcome to TrainSignal. I'm Bill, and this lesson is a Welcome to Excel. We're going to go exploring. I'm going to show you around the application, get you comfortable with it, kick the tires, show you where things are and how to find them. We're going to start with the ribbon. The ribbon contains all of our commands, the things that we want Excel to do for us. We'll look at the Office Button, the Quick Access Toolbar, the Dialog Box Launcher and our Contextual tabs. Then we're going to go ahead and look at navigation, getting around in Excel. It has a lot of real estate to get through, and I want us to be a little bit more comfortable with getting from here to there. We'll use scroll bars, keyboard commands and the Go To menu. So why don't we go ahead and get started?
Entering and Editing Data Hi, welcome to TrainSignal. I'm Bill, and this lesson is entering and editing data. In this lesson, we're going to go ahead and get started with creating our first spreadsheet. We'll talk about entering data. We'll edit it, cut, copy, and paste it, undo and redo. Undo is one of my favorites. We'll show you how to insert rows and columns, also how to delete them. Width and Height, adjusting the width and height of your columns and rows. Find and Replace when we want to go ahead and change data in our cells. Working with ranges. We'll show you how to select ranges and we'll show you a few shortcuts to do that. Auto Fill. Auto Fill will fast become one of your favorites. Your best friend. We're going to show you how to auto fill with text, with numbers, and I'm even going to show you how to create custom lists. This is something that's going to save you a lot of time down the road.
Calculations Hi, welcome to TrainSignal I'm Bill, and this lesson is Calculations. We're going to go ahead in this lesson and learn how to calculate with some simple formulas in Excel. We're first going to talk about the order of operations. Then we're going to move into basic formulas, adding, subtracting, those kinds of things. Then we'll look at functions. There are over 200 functions in Excel. Now, don't panic, we're not going to look at all of them. We're going to go ahead and look at a few of the basic ones. From there, we'll go to absolute reference. This is going to be something that'll be really important to us a little bit later on. And then finally, Save versus Save As. And with Excel 2007, we now have a different file format. And we'll talk a little bit more about what that means.
Multiple Worksheets Hi, welcome to TrainSignal. I'm Bill, and this lesson is multiple worksheets. This lesson, as the name suggests, is working with multiple worksheets. We'll show you how to handle several worksheets at once. We'll also help you get them a little bit more organized. We're going to start with what is a worksheet? A worksheet versus a workbook, we'll talk about the difference. You may have heard me use those terms from time to time, and now we'll talk about them in great detail. I'll show you how to add a new worksheet. From there we're going to go ahead and look at 3D reference. A 3D reference makes it possible to link worksheets together. I'll show you how to rename them, move them and copy them to other workbooks or other places in our workbook, add data to our worksheets, this is actually going to be kind of cool, rearrange worksheets, moving them around, and workspaces. I'll show you how to handle several worksheets at one time. We're going to start with workbook versus worksheet. What is a worksheet? What is a workbook? Think of a workbook as a notebook, a file folder, something that has a lot of pages, something that you can take pages out of, add pages to. Every workbook has worksheets, the individual pages.
Basic Formatting Hi, welcome to TrainSignal. I'm Bill, and this lesson is Basic Formatting. In this lesson, we're going to examine different types of formatting. We're going to go ahead and examine numbers. We'll take a look at currency versus accounting formats, we'll look at date formats, and I'm going to show you how to format a cell with percentage. Next, we'll take a look at texts and all the things you can do with it. We'll look at different fonts, font size, font styles, color; and I'm even going to show you how to wrap text. Lastly, we're going to take a look at cells. I'm going to show you how to merge and center. We'll fill our cells to highlight them, we'll talk about borders and border styles. And lastly, I'm going to show you some fun things you can do with your alignment.
Organization Hi, welcome to TrainSignal. My name is Bill, and this lesson is, Organization. In this lesson we're going to go ahead and show you how to get organized, we're going to teach you better ways to look at your data, and we're also going to go ahead and teach you how to find things a little bit easier in your data, show you ways to organize it. We're going to start by freeze panes and split screen, these will help you look at your data a little bit better. Sorting, we're going to go ahead and break our data up into groups so that it is easier for us to find what we're looking for, make a little bit more sense out of it. Filtering, filtering will enable us through a series of filters to hide the data that we don't need to see, so that we can more closely concentrate on the data we do need to see. And lastly we'll go ahead and we'll talk about converting our data into tables.