PDF MS Excel 2013 Basics

[Pages:27]MS Excel 2013 Basics



Contents

Open Excel/Start Screen......................................................................1 File Menu options............................................................................. 1-2 Save a Workbook.................................................................................2 Print a worksheet/workbook .................................................................3 Blank worksheet...................................................................................4 Navigating through sheets ...................................................................4 Zoom tool.............................................................................................4 Page Layout views...............................................................................4 Excel info .............................................................................................5 QAT .....................................................................................................5 To insert a worksheet...........................................................................5 Tab (Ribbons) .................................................................................. 5-6 Creating a worksheet ...........................................................................7 Working with formulas...................................................................... 7-9 Spell check a worksheet ......................................................................9 Create an address list ........................................................................10 Sort a list............................................................................................11 Filter a list .................................................................................... 11-12 Filtering numbers ...............................................................................13 Create a pie chart ........................................................................ 14-16 Print Preview......................................................................................15 Changing the appearance of a pie chart ............................................15 Adding data labels to a pie chart ........................................................16 Arrange the info on the page..............................................................17 Renaming the worksheet ...................................................................18 Using the Average Function...............................................................18 Adding gridlines when printing ...........................................................19 Print in Landscape view .....................................................................19 Keyboard Shortcuts............................................................................20 Insert a cell.........................................................................................21 Insert a Row/Column/Worksheet........................................................21 Select an entire worksheet.................................................................21 Select an entire range ........................................................................22 Change the order of the worksheets ..................................................22 Remove a worksheet .........................................................................22 Edit a cell entry ..................................................................................22 Cut and move contents of a cell .........................................................22 Move from the first cell in a row...last cell in a row.............................22

Move from the first cell in a column...last cell in a column .................22 What does #### mean? .....................................................................22 Add a period after a number ..............................................................23 Hide/unhide a column ........................................................................23 Break up a long line of text.................................................................23 Freeze/unfreeze panes ......................................................................23 Changing the total, by editing a number.............................................23 Formatting a row/column....................................................................24 Using AutoFill.....................................................................................24 To bypass the Start screen ................................................................24 Getting Help.......................................................................................24

Open Excel Start Screen

1. Double-click on the Excel icon on your computer's Desktop or click on Start, All Programs, Microsoft Office, and on Excel 2013.

2. Double-click on Blank workbook. FILE is BACK! The round Office button is gone. To get to options like Open, Save, Save as, Print, etc., click on File in the upper left corner.

File menu options This looks a bit different, but on the left are the familiar choices. You can also see details about the spreadsheet you're working on.

? Boone County Public Library -

JU 10/13

1

File/Open recent

Open recently saved files by clicking on the file on the right or navigate to a file or folder.

Save a Workbook Save, save, and save again! It's important to save often, so you don't lose your work by accident. Do this in the beginning and then click on the Save icon button on the QAT, if it's there or on File and on Save or use Ctrl+S.

1. The first time you save, click on File and then on Save as (or use F12).

2. Choose where you want to save it ? probably the Desktop, a specific folder, or a flash drive. Insert the flash drive first into a USB port on the computer. To find a specific folder or location, click on the Browse button.

3. Type in a workbook name, since Excel will name it Book 1. Save it as an Excel 97-2003 Workbook (*.xls), if not using Excel 2013 to open the file. If you are using Excel 2013, you can save it as an Excel Workbook.

4. Click on Save.

? Boone County Public Library -

JU 10/13

2

Print a worksheet/workbook Click on File, and on Print. You can also access Print by using the Ctrl+P shortcut. Notice Print Preview is shown on the right.

You have lots of options here. You can change the printer, if necessary by clicking on the down arrow under Printer. The default should be the printer nearest you.

The default choice under Print range is All, but you can change it to Current page or specific pages, such as 1-5 or 1, 5, 10

Under Print what, you can choose a selection or range, Active sheet, or Entire Workbook (all worksheets in the workbook), etc.

You can also print multiple pages by typing a number in the window next to Number of copies under Copies.

When you've made all the necessary selections, click on Print.

? Boone County Public Library -

JU 10/13

3

Blank spreadsheet

File button Name box Active cell

Row headings

Formula bar

Column headings Scroll bars

Active sheet Status bar

Navigating through sheets in a Workbook To get to the beginning of a group of spreadsheets, hold down Ctrl and click on the

left arrow.

Add a new worksheet

Previous Nex t

Zoom tool Click and drag on the pointer to decrease or increase the screen view.

Normal Page Layout Page Break Preview

Page Layout views Normal is the default. To see what a complete page will look like, if you print it, click on Page Layout view and then back on Normal view.

? Boone County Public Library -

JU 10/13

4

Excel info Calibri is the default font style and the font size is 11. Click on the File button for standard options like New, Open, Save, Print, etc. Excel has 1,048,576 rows and 16,384 columns. Each cell has a cell address, the combination of the column letter and row number, such as A1.

Quick Access Toolbar (QAT) You can add more options, if desired. Click on the down arrow and click on the options you want to appear.

Insert a worksheet Click on the Insert Worksheet button next to the Worksheet tabs at the bottom or use the Shift+F11 key. To delete a worksheet, right-click on the worksheet tab and click on left-click on Delete.

Home tab The Home ribbon has the basic formatting options, such as font style and size, alignment, cell color, font color, number and formatting styles, adding and removing cells, AutoSum, filtering, and more. The Home groups are Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.

? Boone County Public Library -

JU 10/13

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download