Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Excel 101 Handbook
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   14 years ago

This is the full text listing of one of our handbooks. There is a lot more to this handbook. The full-color screen shots have been removed for this page. This text is simply provided so that the search engines will index the course contents. This is so any customer searching for a topic can find what class it's covered in. If you are interested in more about information about our courses, click here for our complete course listing. For details on how to purchase a handbook, visit our handbooks page.







Microsoft Excel 101
Course Handbook Supplement

By Richard Rost



Published By
Amicron Computing
PO Box 1308, Amherst NY 14226 USA
www.599cd.com


First Printing 5/16/2005
Copyright 2005 by Amicron Computing
All Rights Reserved


Welcome

Welcome to the 599CD Microsoft Excel 101 Handbook.

This handbook is designed to be a supplement to the full 599CD video course for Microsoft Excel 101. We recommend you use this handbook to follow along with the class videos. This handbook is not meant as a stand-alone study guide.

We do recommend that you watch the course videos one time through, paying attention to the lessons covered. Follow along with the course videos using this guide. Take notes on the pages where needed. Then, watch the videos a second time, practicing the examples yourself on your computer.


Table of Contents

Welcome 2
Table of Contents 2
1. Introduction 3
2. Parts of the Microsoft Excel Screen 4
3. Entering Data 22
4. Editing Data 26
5. Formatting Our Sheet 30
6. Basic Math 39
7. Functions, part one 50
8. Functions, part two 59
9. Cut, Copy, Paste, AutoFill 65
10. Saving, Loading, Printing 75
11. Review 83




1. Introduction

Welcome to Microsoft Excel 101, brought to you by 599CD.com. I am your instructor, Richard Rost.




Objectives for today’s class:

· Learn about Excel
· Parts of the screen
· Entering and editing data
· Formatting cells
· Math calculations
· Work with functions
· Copy, cut and paste
· Autofill
· Saving and loading workbooks
· Printing

Our goal is to get your up and running quickly. We’ll cover a lot of details in future classes, but for today, we want to get you working with Excel and building your first spreadsheet.

Pre-Requisites: You should be familiar with Windows and have taken at least our Windows 101 courses so that you know how to move around in Windows, and can use your keyboard and mouse. We also recommend Windows 102 or 110, Windows 120, 121, and Word 101. If you’re going to learn both Word and Excel, we recommend learning Word first before learning Excel.

In this class we will be using Microsoft Excel XP and Windows XP for our live-action videos. However, the version of Excel and Windows you have does not matter. Most, if not all of these examples should be applicable regardless of what version of Excel you’re using.


2. Parts of the Microsoft Excel Screen

Let’s begin today’s class by starting Microsoft Excel. From Windows, click on your Start button, then click on All Programs, and then Microsoft Excel.




You will notice Excel starts up, and you should see the user interface as follows:





Across the top of the screen, you will see the Title Bar.




The Title Bar on our screen says “Microsoft Excel – Book 1.” The “Book 1” indicates the name of the current Workbook.

Rick’s Tip: In Excel, you store your data on spreadsheets, and multiple spreadsheets make up a Workbook. You can save your Workbooks with whatever name you’d like, and that name will appear here on the Title Bar.

In the upper-right corner of the screen, you should see the familiar Maximize, Minimize and Close buttons.




As a refresher from our Windows Basics courses, to minimize a window is to send it down to the taskbar (make it small). To maximize a window is to make it fill up the screen, and to close a window is to shut down the application (exit Excel in this case).

If you look carefully, you will notice that there are two sets of minimize, maximize and close buttons.




The set across the top (in line with the Title Bar) is for Microsoft Excel as a whole. These will minimize, maximize, or close Excel. The bottom set of buttons are for the individual Workbooks inside of Excel. We’ll learn how to work with multiple workbooks in a future class. In today’s class we’re going to focus on working with just one workbook.

Below the Title Bar is the Menu Bar.





The Menu Bar has various options on it, such as File, Edit, View, Insert, and so on. To open up one of these menu options, simply click on it to “pull” the menu down.




Below the Menu Bar are the Toolbars.




There are normally two different toolbars open side-by-side. The standard and formatting toolbars. They have one-click buttons available on them for commonly-used features, such as creating a new spreadsheet, saving your sheet, printing your sheet, and so on.




Below the toolbars we have the Formula Bar.




The Formula Bar is where you will actually see the Formula that’s stored in a specific cell in your spreadsheet. We’ll learn about cells and formulas (formulae) in a few minutes.




The big region shown here is the Spreadsheet portion of the window. This is where all of your data will be stored.




Spreadsheets are made up of Columns that go vertically…




…and Rows that go horizontally.





This, for example, is Column “C”:




This, is “Row 4”:




Rick’s Tip: You can highlight a specific column or row by clicking on it’s header (the little box that actually contains the letter or number that names the column/row).


Where a column and a row intersect, that is called a Cell.




This, for example, is “Cell C4”:




Rick’s Tip: You will always refer to a cell as Column/Row, never Row/Column. For example, you should never refer to cell “C4” as cell “4C”.

The Name Box will display the name of the currently active (selected) cell.




Notice how the Name Box says “E6” in it.




Rick’s Tip: In later classes, you will learn how you can use this box to actually give names to cells on your own… such as “SalesTotal.”


Notice the Mouse Pointer moving around on the screen. When it’s over the spreadsheet, it appears as a white “plus” sign.




Sometimes the mouse pointer will change, depending on what it’s hovering over. Sometimes it will become an arrow, a double-arrow, or even a black plus sign. We’ll learn more about why this happens later.





There are also two Scroll Bars on the screen, for scrolling up and down our spreadsheet.




You can have a lot more data on a spreadsheet than can be displayed on one screen. You can have thousands of rows and columns of data. You can scroll up and down one row at a time by clicking on the arrowheads at the top and bottom of the vertical scrollbar, respectively.





Likewise, you can go left and right one column at a time by clicking on the arrowheads on the bottom (horizontal) scrollbar.




If you think of the vertical scrollbar as an elevator shaft, you can click inside the shaft (but not on the elevator) to move up and down (or left and right) one whole screen at a time.





You can also click on the elevator box itself and drag it up or down (or left/right for the horizontal scrollbar) to drag it wherever you want to go. This is especially helpful on very large spreadsheets.




A new feature in Excel XP is the Task Pane.





The Task Pane has a listing of common functions on it, such as opening a workbook, creating a new blank workbook, opening a previously accessed workbook, and so on.




As I mentioned earlier, a workbook can be made up of multiple spreadsheets. You can switch between these sheets using the Sheet Tabs found at the bottom of the screen.





You can move between the different sheets by clicking on them. We will spend our time today working with just Sheet1, but in future classes, we’ll learn how to create more sheets, rename them, delete them, and even move them around.




Down at the very bottom of the screen we have the Status Bar. The status bar shows the status of Excel, including various system status options, such as whether or not the Numlock key is on.





For today’s class, there are a couple of things I’d like to do before we get started working on a spreadsheet. The first thing I’d like to do is close the Task Pane. It just takes up too much space on the screen. Right next to where it says “New Workbook” click on the “X” to close the Task Pane.




Now you can see we have much more room to work.





The next thing I’d like to do is fix the toolbars. In earlier versions of Microsoft Excel, there were two distinct toolbars on the screen – and you could easily make them out. They are the Standard Toolbar and the Formatting Toolbar. For some reason, in Excel XP, Microsoft has them laying one on top of the other on the same line, and they’re really hard to work with (Thanks Microsoft!) We’re going to fix them. We’re going to take the Formatting Toolbar and slide it underneath the Standard Toolbar where it belongs.

Move your mouse right on top of that little gray bar just to the left of the word “Arial”. You’ll notice your mouse pointer will change into a four-way arrow.




Now, slowly and carefully click and drag your mouse down. You’ll notice the formatting toolbar will slide down and underneath the standard toolbar. You should now see this:





If you accidentally click and drag your toolbar too far, you’ll notice it “floating” over your spreadsheet, like this:




That’s OK. Just click and drag the title bar of the little window and drag it back up where it belongs.

Rick’s Tip: Yes, manipulating the position of the toolbars is more of an Intermediate topic, but I really like to use the buttons on these toolbars, so I think it’s necessary to show you how to do this now!


3. Entering Data

In this lesson we will begin by entering some text into a spreadsheet. We will pretend we’re working for a fictional company called PCResale.NET (a reseller of new and used computers). We’ll enter some data into a sales summary sheet. We want to be able to track sales by month for each of our sales reps.

First, make sure cell A1 is selected. You’ll notice a little black box around the selected cell. Go ahead and type in the words “Sales Rep”. When you’re done, press ENTER. This will move us down to the next row.




TIP: If you are entering data into columns (vertically) you can use the ENTER key or the DOWN ARROW key to move down to the next row. If you want to enter data across in the same row, you can use the TAB key or the RIGHT ARROW key to move right to the next column.


Let’s go ahead now and enter in the names of our sales reps. Type in the name of each rep, pressing ENTER after each one.




Now we need to get up to the top of the next column so we can enter in their sales data. You can do this with either the keyboard or the mouse. To use the mouse, you simply click once on the cell you wish to highlight.





Using the keyboard you can simply use the ARROW KEYS to move the focus (selected cell) around. Remember the arrow keys from our Windows 101 class?




Now, let’s enter in the header for the next column. In cell B1 type in the abbreviation for January, “Jan”, and press the TAB key.




RICK’S TIP: Yes, for those of you who are English majors, I know you should put the comma inside the closed quotes in the above example, however, I don’t want you typing the comma into your Excel sheet, so I’ve put it outside the quotes. It’s my own style! J

Now type in “Feb”, “Mar”, and “Apr”, pressing TAB between each one.




Now, move to cell B2 (using the keyboard or mouse – your choice). Go ahead and type in some numbers. The data doesn’t matter… you can type in whatever values you want.





4. Editing Data

Now that we know how to get data into our sheet, let’s see how we can edit that data. Let’s say I made a mistake. February’s sales for Alex should be 62, not 65. How can we change it? There are several ways to edit the data in a cell. I’m going to show you a few different ways, you don’t have to remember them all. Just remember the method(s) you would like to use. The easiest way to change data is to simply type over it. Move your focus to the cell C3 using the keyboard or mouse, and then type the number “62” into that cell.




This will replace the data in that cell with whatever you type in.

The next way you can change the cell is to use the Formula Bar. When you click on a cell, notice its value shows up in the Formula Bar. You can take your mouse, click there, and edit the data right in the Formula Bar. This is really handy once we start working with large formula or functions.




You can also edit a cell by double-clicking on the cell itself. This will put you into EDIT mode, and you can edit the cell data right in place on the spreadsheet.




TIP: For you keyboard freaks out there (like me) you can also press the function key F2 to go into edit mode.
You can also delete information by pressing the DELETE key on your keyboard. For example, if you want to delete “Pat” you can just click there and press DEL on your keyboard. This will clear the contents of that cell.




If you realize you want that data back, you can use the UNDO feature to bring it back. Undo reverses the last action you took. You can press CTRL-Z on your keyboard for Undo, or you can click on the Undo button.






Next to the Undo button is the Redo button, which reverses the Undo.




You can use the Undo and Redo buttons together to step back and forth between your last couple of commands or typing steps. For a more in-depth lesson on Undo, see our Microsoft Word 101 class.


5. Formatting Our Sheet

Now that we know how to get data into our sheet and edit that data, let’s see how we can make our spreadsheets look more professional. The first thing I want to change is the horizontal cell alignment. Notice how the headings, “Jan”, “Feb” and so on do not line up perfectly over the numbers. By default, text will line up to the left side of a cell, while numbers and dates will line up to the right side.

First, we need to select (highlight) the cells we want to change. This will involve selecting multiple cells. Click and drag your mouse over cells B1 through E1. In other words, move your mouse over cell B1, click and hold the mouse button down, then drag your mouse to the right until it’s over cell E1. Now, let the mouse button go. That’s how you click-and-drag to select multiple cells.

TIP: We covered clicking and dragging in our Windows 101 class.

Your sheet should now look something like this, with the cells B1 through E1 highlighted.




This is what’s called a Range of cells, from B1 to E1. This can be written as B1:E1.
Now, come up to your toolbar and click on the Align Right button. This will move all of the text to the right side of the cell.




Notice there are also buttons to align the text to the left and to center the text.





Next, I’d like to make the header row across the top stand out a little more. Let’s select cells A1:E1.




Let’s click on the Bold Text button.




To turn the Bold text off, just click on the “B” button again. The same works for Italics or Underline. Go ahead and try them. When you’re done, leave the text Bold.

You can also change the Font using the font drop-down box.




You can change the font size with the font size drop-down box.




Again, we did a lot more with these in our Word 101 class. I recommend watching that class if you need to go over these topics in detail. The features are almost identical in box programs.

I’m going to make my text Arial, 12 point.




Now, notice how the text in cell A1 is too big to fit in that cell. We need to somehow make column A wider. Take your mouse and move it over the border between the column headers for columns A and B. Notice how it turns into a double-arrow.





Now, click and drag your mouse to the right. Notice the column gets wider.




The same trick also works for rows.




COOL TRICK: To make a column resize itself to automatically fit the widest data in that column, just double-click on that spot (the line between the column headers where you resize it). See the video for an example.

Next, let’s change the color of the text. Again, highlight A1:E1. Notice the paint can on the toolbar. If you hold your mouse over it, it says “Fill Color (Yellow).” If you click on the paint can, you get the color that’s under the can – in this case, yellow. Go ahead and click on it.




If you don’t want yellow, you can click on the little down-arrow next to the paint can to open up the color palette. You can then choose from a wide variety of colors.





I’m going to select light blue. Notice light blue is now the color “in” the paint can.




The same trick applies for the foreground color using the “Font Color” button.





Since a red font with a blue background looks nasty, I’ll go with a dark blue foreground color.





6. Basic Math

In this lesson we’re going to learn how to use Excel to perform basic math calculations. For now, let’s move to a different worksheet. Click on the Sheet 2 tab.




We’re going to learn addition, subtraction, multiplication, division, and exponentiation.





First, let’s add two numbers together. Let’s type in two numbers in cells A1 and A2.




In cell A3 we’re going to type in: =A1+A2





Then press ENTER. You will now see the calculated value in cell A3.




Notice if the data changes, the calculations are automatically updated. If I change cell A1 to 48, notice that the value in A3 changes to 73.





Now, click on cell A3. Notice that the spreadsheet shows the calculated value, however the formula itself shows up in the Formula Bar.




Let’s try subtraction. In cell A4, type in: =A3-25





When I press ENTER, I get the number 48 which is 25 less than whatever value is in A3. You can use real numbers or cell values in your formula.




Let’s try multiplication. For multiplication you use the asterisk (*) symbol. In cell A5 type in: =A2*4





When you press ENTER you’ll notice the answer appears in cell A5.




For division, we use the forward slash ( / ) symbol. It’s the one that leans forward. In cell A6, type in =A5/5





And you’ll see the answer for that appears when you hit ENTER.




Exponentiation is when you raise a number to a power. You probably won’t use this as much as the others, but it’s handy to know. Use the carat symbol ( ^ ) for exponentiation. In cell A7 type in: =A6^2





This will raise the value in A6 to the 2nd power.




Let’s delete the values in A5 through A7. Highlight them and hit DELETE.





OK, now I want to add all of the cells from A1 through A4 together. In cell A5 type in: =A1+A2+A3+A4




Notice you can use capital or lowercase letters. Press ENTER and you’ll see the result.





Let’s DELETE that value. Now, instead of the SUM of those numbers, let’s figure out the AVERAGE of those numbers. To average a group of numbers, you add them all up and then divide by the number of values – in this case four of them. So, in cell A5, type in: =A1+A2+A3+A4/4




Now press ENTER. Oh… wait a minute. That’s definitely not the average.





The problem is that we have to remember our order of operations from high-school math. Remember multiplication and division are calculated before addition and subtraction. So we need to rewrite our formula with some parentheses. Try this instead: =(A1+A2+A3+A4)/4




Now it looks like we have the right average.





7. Functions, part one

In this lesson we’re going to learn about functions. In the previous lesson, we added up and averaged only four values. The method we used was acceptable for this. However, what if we have to add up a whole column of, say, 500 numbers. It would be very time consuming to type in that large of a formula.

A function is a special formula that’s built into Excel that does complex math (or some other feature) for you. You’ll use functions to simplify complicated tasks, like calculating the average of a long column of numbers.

One of the most popular functions (one that you’ll be using quite a lot) is the SUM function. You can think of a function like a little box. In this case, the SUM function is a little blue box with a hole on the top and another hole on the side. You are going to dump a bunch of numbers in the hole on the top…





Then, you shake the box up, and out of the hole on the side, the correct answer (the SUM of these numbers) it spit out…




Let’s try using the SUM function to add up cells A1 through A4. So first DELETE the formula we have in cell A5. Then, type this in: =SUM(A1:A5)





When I press ENTER, notice I have the correct answer.




Let’s try another one. This time in cell A6, type in: =SUM(A1:A5)





Press ENTER and you will see the SUM of this whole range of numbers.




Now, in addition to the little blue SUM function box, we also have another function called AVERAGE. Picture AVERAGE as a little green box. Again, throw in a bunch of numbers in the top, shake up the box, and the average function will spit out a value.





Instead of the SUM of the numbers, however, you’re given the AVERAGE of the numbers.




Delete the values in cells A5 and A6. In cell A5, type in: =AVERAGE(A1:A4)




TIP: Yes, you have to type out the whole word “AVERAGE”. You cannot abbreviate it.

Notice the correct answer is now in cell A5.




Let’s try another one. In cell A6, type in: =average(




Notice how I used lowercase letters. Excel doesn’t care about upper v. lowercase in your function names. Stop typing with the open-parenthesis.

Now, use your mouse and click-and-drag to select the cells A1 through A4.




Notice how the cell range is automatically typed in for you as you select it with the mouse. This is a big time-saver if you don’t like typing. Now, you don’t have to close your parentheses (even though it’s a good idea to get in the habit of doing so). Press ENTER.




Notice the correct answer is in cell A6.

There are three other functions I’d like to teach you today. They all work the same, but perform different tricks.

· MAX will return the largest value in a range of cells
· MIN will return the smallest value in a range of cells
· COUNT will return the number of values in a range of cells

For example, =MAX(A1:A5) will return the largest value in that range.




In this case, the answer is 73.





The MIN value would be 25. The COUNT(A1:A5) will return 5, because there are five numbers in that range (a total of five items, it doesn’t matter what their values are).




As you can see…




Of these five functions (sum, average, max, min, and count) you will probably use SUM and AVERAGE the most. You may use max, min, and count occasionally. There are dozens of other functions, and we will learn about them in future classes, as we progress.

8. Functions, part two

Now that we know how to use functions, let’s return to Sheet1 to put some real functions in our spreadsheet.




Let’s begin by totaling up the sales for each month. Click in cell A6 and type in: Total





In cell B6 type in our function: =SUM(B2:B6)




Press ENTER for the answer.




TIP: If you have an older version of Excel (like 97 or 2000) you may not see the little colored boxes pop up that highlight the ranges. This feature was added in Excel XP (2002) and I think it’s a good addition.

We can do the same thing for February’s sales…




This time, I’ll press TAB instead of ENTER. This will move me to the RIGHT one cell instead of down when I’m done entering in my formula.





Let’s go ahead and finish by typing in the functions for March and April…




Now, let’s get a total for each sales rep. Come over the cell F1 and type in “Total”.





Notice when I press ENTER, Excel automatically formats this cell with the foreground and background colors of the other header cells. Excel assumes I’m typing in the header for a new column.




Let’s type in the SUM function for cell F2: =SUM(B2:E2)





Press ENTER to move down to the next row. Go ahead and type in the functions for cells F3 through F6.




Now we have a complete spreadsheet with sums for all of our various months and sales reps. I’ll add some bolded text for the grand total in cell F6.





9. Cut, Copy, Paste, AutoFill

In the previous lesson, we typed in functions for each of our months and sales reps. It wasn’t so bad because we only had four sales reps, and only four months. What happens if you have 200 sales reps and 12 months of data? I don’t want to be typing in functions all day. One thing we can do is copy and paste our formula from one cell to another. Let’s DELETE everything from C6 over to F6.




Now, click on cell B6.





On your toolbar, find the COPY button.




Click on it and notice how you get the “dancing ants” effect (you just have to see it – watch the video) around the cell you have highlighted. This indicates that the cell was just copied.





Now, click on cell C6, which is where we want the copy to go. Then, click on the PASTE button on your toolbar.




Now, notice that a copy of the function was brought over, but Excel recognized that you were copying a function, so it auto-magically changed the function for you! It assumed you wanted to SUM the values in the new column, so it changed your function from SUM(B2:B5) to SUM(C2:C5). This is a very powerful feature! We can do the same thing for column D.




TIP: Notice as long as you still have the “dancing ants” around cell B6, it’s still selected for the copy operation. You don’t have to keep clicking COPY. You can just PASTE again.

We can continue for columns E and F. The dancing ants should stay put until you copy or cut something else, hit ESCAPE on your keyboard, or do some other operation like saving your sheet.




We talked a lot about cut, copy, and paste in our Word 101 class. Remember, CUT is just like COPY except that it will remove the original data from the first cell. I recommend you watch Word 101 if you want to learn more about cut, copy, and paste.

Now, this method works OK if you only have a handful of cells you want to paste functions in. What if you’ve got a whole column of, say, 200 values. There’s an even easier way to copy formula like this. We can use a neat tool called AutoFill.

Once again, let’s delete everything from C6 over to F6.





Now, click on cell B6.




Now, carefully move your mouse pointer over that little dot in the bottom-right corner of the cell.




Notice how your mouse pointer changes from a WHITE plus to a BLACK plus sign.

Now, with the BLACK plus sign, click and drag your mouse out to the right, all the way out to column F.




When you release the mouse button, you will see that Excel auto-magically copies and pastes the function from B6 into all of those cells, changing them just as before. This is the power of AutoFill.





You can also do the same thing in columns. Delete F3 through F6, and try AutoFilling the function from F2 down the column…




When you release the mouse button, you will have your values.




Don’t forget you have to use the BLACK plus!

Let me show you two mistakes that people make when using AutoFill. Again, I’ll DELETE cells C6 through F6. The first mistake is that people only click and drag using the WHITE plus. This only highlights the cells, it does not invoke the AutoFill function. You’ve got to use the BLACK plus.




The second mistake is that people click and drag on the BORDER of the cell. They don’t quite get to the little AutoFill dot.





This will, unfortunately, MOVE the cell, not invoke AutoFill.




If you grab the border of the cell anywhere but on the AutoFill dot (called the AutoFill Handle) it will move the cell, just as if you were cutting and pasting it.

In our next class, Excel 102, I will show you a bunch of additional cool tricks you can do with AutoFill, but here’s a quick preview. Delete cells C1 through E1.





Click on cell B1 that says “Jan” and AutoFill it across to the right.




When you let go of the mouse, notice that Excel knows the months!





10. Saving, Loading, Printing

Let’s go ahead and save our work. Click on the SAVE button on your toolbar.




This will bring up the Save As dialog box.




Excel wants to save our workbook in the My Documents folder. That’s a good thing.

At the bottom of this window it says “File name” and the name given is “Book1”.




Let’s change the filename to “Sales Figures 2002” – or whatever else you want to call it.




Now, press ENTER or click on SAVE.




The workbooks is saved to your hard drive. Notice how the name of the book now appears on the Title Bar.





I’m now going to shut down Excel. Close Excel using the “X” button in the upper-right corner.




Now, there are several ways to open up your workbook to get back to your spreadsheet. Go ahead and click on the Windows Start button, and then Microsoft Excel.




Notice on the Task Pane you see the recently accessed spreadsheets. Ours is on top of the list.





Click on it, and the book opens up.




That’s one way to get to your sheet. Another way would be to click on the link that says “More workbooks…”




Or click on the little yellow folder on the toolbar that says “Open” if you hold your mouse over it.





This will bring up the Open dialog box. Simply double-click on your spreadsheet from your My Documents folder (or navigate to a different folder). You can alternatively click on the Open button.




Another way to open up a recently-used workbook is to click on the File option from the Menubar.





Come down to the very bottom of the File menu, you will see the last four (or less) workbooks you accessed. Just click on one here to open it.




Finally, from Windows itself (outside of Excel) you can also click on your Start button and then come up to your My Documents item to access your spreadsheet files from here.





You may even have a My Recent Documents folder (depending on your version of Windows).




Now let’s take a quick look at how to print our sheets. We’re going to cover printing spreadsheets in a lot more detail in future classes. For today, I just want to show you the basics. First, I just want to warn you that the Print button on the toolbar is evil. It will send your spreadsheet right to your default printer without giving you any options or warning…




…which is fine for the second (or later) time you want to print. But for the first time you print a spreadsheet, you might want to select your printer, change some options, and so on. So instead of clicking on the printer button, click on File > Print. (That’s File from the Menubar, followed by the Print option).





This will bring up the Print dialog box and will give you some options. You can select some options, like what printer you want to use, how many copies you’d like, what pages you’d like to print, and so on.




Again, we’ll discuss a lot of these options in future classes. When you’re ready to print, click on the OK button, and the print “job” is sent to your printer. Click Cancel to abort.




You can also select whether to print the Active Sheet, a specific Selection, or the Entire Workbook.


11. Review

Review topics.

· Entering Data
· Editing Data
· Formatting
· Basic Math
· Functions: Sum, Average, Max, Min, Count
· Cut, Copy, Paste
· AutoFill
· Saving & Loading
· Printing



Tell us what you think. Log on to www.599cd.com/Survey and take a short survey about this course.


RICK’S NOTE: I really do enjoy getting surveys from you! Make sure you visit the web page above and fill out the survey for this class. Let me know if I’ve moved too fast, and whether or not I covered material that was helpful to you!


Take your skills check quiz at www.599cd.com/Test. If you pass, you can print out a Certificate of Completion.

What’s next? Visit www.599cd.com for our complete list of courses.

Need Help? Visit www.599cd.com/TechHelp for technical assistance.

Make sure you’re on our Mailing List. Go to www.599cd.com/MailingList for details.

Contact Us. If you have any questions, go to www.599cd.com/Contact for information on how you can contact us by phone, email, or live online chat.



Don’t forget to visit our User Message Forums online at: www.599cd.com/Forums. You can chat with our instructors, other users, and even Richard too. You can ask us all of your questions, get answers, and tell us what you thought of our class.



This course, handbook, videos, and other materials are copyright 2002, 2003, 2004, 2005 by Amicron Computing. All rights reserved. No portion of this course, handbook, videos, or other course materials may be reproduced, copied, edited, or otherwise distributed without the express written permission of Amicron Computing. Amicron Computing shall not be held liable for any errors or omissions in this document.

This document may not be used as part of a training course without express, written permission from Amicron Computing and the purchase of an Instructional License. For details, contact:

Amicron Computing
PO Box 1308
Amherst NY 14226 USA
www.599cd.com








What’s Next?

Coming up in Excel 102:

· More data editing tips and tricks
· Page setup including headers, footers, and page numbers
· Charting and Graphing
· Sorting data
· More with AutoFill
· Building a Calendar
· Formatting Cells

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

11/30/2021Import Multiline Cells
11/11/2021Link to Excel
11/11/2021Read Write Excel Data
11/10/2021Excel Moving Average
9/11/2021Circular References
8/25/2021Stock History
8/23/2021Concatenation
8/17/2021Flash Fill
8/5/2021Stock Portfolio
8/4/2021Stock Portfolio
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: excel handbook  PermaLink