Part 1 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.
Saving a File Hi, welcome to TrainSignal. My name is Bill and this lesson is Saving a File. In this lesson, we're going to learn about the difference between Save and Save as. We'll show you how to save a file that you've just created or ones that you have gone ahead and made changes to. I can also save a copy of a file in a different location if I want. We'll also talk about the difference between the different file formats, the. xlsx extension and the. xls file extension. I'm going to talk to you about the Compatibility Checker and what it does, and we'll look at the Compatibility Mode for use with older Excel files. We've got a lot of work to do so let's get started.
The Interface Hi, welcome to TrainSignal. My name is Bill and this lesson is The Interface or Where is Everything? In this lesson, we're going to discuss the interface. The ways to get around and find things in Excel. We'll take a look at the ribbon and along with that, we'll talk about the dialog box launcher and what that is. We'll show you the mini-toolbar. And we'll talk about contextual tabs. From there, we'll go ahead and we'll take a look at the backstage view. This is new to 2010. And I'll teach you how to customize the ribbon, also a new feature in 2010. Lastly, we'll take a look at the Quick Access Toolbar.
Number Formatting Hi! Welcome to TrainSignal. My name's Bill, and this lesson is Number Formatting. In this lesson, obviously, we're going to talk about number formatting, but we'll get a little bit more specific than that. We'll talk about the difference between currency versus the accounting style of formatting. We'll also show you how to format dates, format numbers as percentages, we'll take a look at some special formats that Excel already has for us, and create our own custom formats. Let's get started.
Alignment Hi. Welcome to Train Signal. My name's Bill and this lesson is Alignment. In this lesson, we're going to talk about the alignment tab. We'll be looking at Merge and Center. I'll show you how to change the orientation of the text in your cells. We'll talk about alignment: left, center, right, top, middle, and bottom. Then I'm going to show you how to wrap text and create a new line or place a line break in a cell. What do you say we get going?
Conditional Formatting Hi, welcome to TrainSignal. My name's Bill and this lesson is Conditional Formatting. In this lesson, I'm going to be telling you about conditional formatting, whereby if a cell meets a particular condition, we want to format it in this manner. We'll look at highlighting cells rules, we'll look at top to bottom rules, we'll examine data bars, color scales and icon sets. It's a lot of fun stuff guys so let's go ahead and let's jump right in.
Page Layout Hi, welcome to TrainSignal. My name's Bill, and this lesson is page layout. In this lesson, I'm going to show you how to zoom in and out on your worksheets and use different page views. I'm going to show you how to set the margins on your worksheets, how to change the orientation, how to select the size of the page, how to set a print area, and how to use print titles. Lots of fun stuff, so why don't we jump right in.
Printing Worksheets Hi, welcome to TrainSignal, my name is Bill, and this lesson is Printing Worksheets. In this lesson I'm going to talk to you about print preview, we'll take a look at how it's different from our previous versions, I'm going to show you how to use scale to fit, so that you can get your documents on fewer sheets, we'll take a look at inserting page breaks, and I'll examine some other printing options that you have. Let's get started. Okay, in this lesson we're going to pick up right where we left off in our previous lesson, and if you haven't watched the previous lesson, Page Layout, I would suggest you go ahead and watch that first, it's short, go ahead and take a look at it before we go here.