slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Excel 2007 ® Business and Personal Finances PowerPoint Presentation
Download Presentation
Excel 2007 ® Business and Personal Finances

Loading in 2 Seconds...

play fullscreen
1 / 40

Excel 2007 ® Business and Personal Finances - PowerPoint PPT Presentation


  • 101 Views
  • Uploaded on

Excel 2007 ® Business and Personal Finances. How can Microsoft Excel 2007 help you to be more productive?. 1. Lesson 1: Excel Basics.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Excel 2007 ® Business and Personal Finances' - denver


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Excel 2007® Business and Personal Finances

How can Microsoft Excel 2007 help you to be more productive?

slide2

1.

Lesson 1: Excel Basics

Spreadsheets in Excel can help you organize and track inventory and sales in business, course schedules and budgets at school, and personal finances at home.

slide3

Lesson 1: Excel Basics

View This Presentation to Answer the Following Questions:

• What are the parts of the Excel screen?

• How can I create and close workbooks?

• How do I name and save a workbook?

• How can I insert and edit cell contents?

• How do I calculate a sum?

• How can I print a worksheet?

• What vocabulary words should I review?

slide4

2.

Lesson 1: Excel Basics

Spreadsheets are used to maintain schedules, track expenses, and manage large-scale projects in a variety of careers.

slide5

Lesson 1: Excel Basics

Computer software engineers and programmers use spreadsheets to analyze problems, write programs, and create software.

Credit analysts and financial managers use a wide range of spreadsheet functions to input and assess credit histories,

financial portfolios, and budgets.

slide6

3.

Lesson 1: Excel Basics

The Excel screen contains

Office Button

Quick Access Toolbar

Title bar

Scroll bars

Start Button

Status bar

slide7

4.

Lesson 1: Excel Basics

At the top of the screen is the Ribbon.

The Ribbon

contains tabs and

buttons.

slide8

5.

Lesson 1: Excel Basics

The tabs display buttons, also known as commands.

Buttons are organized into groupsthat relate to a specific activity, such as formatting and editing text.

Pointing your cursor at a button makes ScreenTips appear, showing you the button’s name.

slide9

6.

Lesson 1: Excel Basics

More commands are available in dialogboxes located within the groups.

Use the Dialog Box Launcherto open a group’s dialog box.

slide10

7.

Lesson 1: Excel Basics

There are several ways to change the appearance of the screen.

Another way to see more of the screen is to minimize the Ribbon.

Decrease the zoom percentage to see more of a worksheet at once.

Increase the zoom percentage to make everything appear larger.

slide11

8.

Lesson 1: Excel Basics

An Excel file is called a workbook.

A workbook contains one or more sheets called worksheets, also known as spreadsheets.

A worksheet contains data such as numbers and formulas.

slide12

Lesson 1: Excel Basics

To create a new workbook, start Excel.

When you launch Excel, a new workbook appears automatically.

slide13

9.

Lesson 1: Excel Basics

When you create a new workbook, it contains threeworksheets.

Click the sheettabsto move from one worksheet to another.

slide14

10.

Lesson 1: Excel Basics

A folderhelps you organize your files so you can find them quickly.

One way to create a new folder is to use the Save As dialog box.

slide15

11.

Lesson 1: Excel Basics

To save a file, click the OfficeButton and choose Save As.

In the dialog box that opens, key in the file name and click Save.

Name your file in the File Name Box.

slide16

Lesson 1: Excel Basics

To open an existing workbook, you need to know the name of the file and in which folder it was saved.

When working with others, give your files appropriate names—your files should be logical to everyone you work with.

slide17

Lesson 1: Excel Basics

Tech Check

How can you reveal the name of a button or command?

Answer:

Point your cursor at a button to makes ScreenTips appear, which show you the button’s name.

slide18

Lesson 1: Excel Basics

Tech Check

How can you create a new folder?

Answer:

One way to create a new folder is to use the Save As dialog box.

slide19

Lesson 1: Excel Basics

Tech Check

How do you move up and down or left and right in a document?

Answer:

Use scroll bars to move horizontally and vertically in a document.

slide20

Lesson 1: Excel Basics

Academic Skills Check

How could spreadsheet skills improve your chances of obtaining a higher salary?

Answer:

Many high-paying jobs in the computer industry, including computer programmers and computer software engineers, use spreadsheet skills in their work.

slide21

Lesson 1: Excel Basics

Academic Skills Check

How can you make it easier for others to find files you’re working on together?

Answer:

To make it easier for others to find files, make your file and folder names and structures logical.

slide22

12.

Lesson 1: Excel Basics

Worksheets are made up of boxes called cells that are organized into horizontal rows and vertical columns.

Cell

You can insert or edit data directly into the cell or by using the formula bar.

slide23

13.

Lesson 1: Excel Basics

A cell is named by its cell reference, or its column letter and row number.

For example, cell A1 is in column A, row 1.

slide24

14.

Lesson 1: Excel Basics

If you change your mind or make a mistake while working with Excel, choose Undo. This will undo, or reverse, your last action.

To revert to the original choice, choose Redo.

slide25

15.

Lesson 1: Excel Basics

To calculate a sum in Excel 2007, use a formula.

A formula is an equation that begins with an equal sign (=) and includes values or cell references.

slide26

16.

Lesson 1: Excel Basics

The formula bar displays the formulas and contents of selected cells.

Formulas allow you to perform different actions, such as adding a column of numbers.

slide27

17.

Lesson 1: Excel Basics

To print your worksheet, click the Print button to open Printdialog box.

The Print dialog box allows choose the printer, the number of copies that will print, and where the document will print.

slide28

18.

Lesson 1: Excel Basics

Use Help to find answers to any questions you have about using Excel.

Click the Help button to open Help window, and search for a topic.

slide30

Lesson 1: Excel Basics

Tech Check

How can you make everything in a worksheet appear larger or smaller?

Answer:

To change the size of things in a worksheet, choose the Zoom option.

slide31

Lesson 1: Excel Basics

Tech Check

How can you reverse your last action in Excel if you make a mistake?

Answer:

To reverse your last action, choose Undo.

slide32

Lesson 1: Excel Basics

Vocabulary Review

workbook

An Excel file that contains one or more worksheets.

slide33

Lesson 1: Excel Basics

Vocabulary Review

worksheet

A sheet of cells organized into rows and columns, sometimes also called a spreadsheet.

slide34

Lesson 1: Excel Basics

Vocabulary Review

sheet tab

A small tab at the bottom of a worksheet that allows you to move from one worksheet to another within the same workbook.

slide35

Lesson 1: Excel Basics

Vocabulary Review

ScreenTip

A description that appears when you point to a button.

slide36

Lesson 1: Excel Basics

Vocabulary Review

cell

The intersection of a row and a column in a table or worksheet.

slide37

Lesson 1: Excel Basics

Vocabulary Review

cell reference

The column letter and row number of a cell.

slide38

Lesson 1: Excel Basics

Vocabulary Review

formula

An equation containing values, cell references, or both.

slide39

Lesson 1: Excel Basics

Vocabulary Review

group

An organized set of commands that relates to a specific activity.

slide40

Lesson 1: Excel Basics

Vocabulary Review

Quick Access Toolbar

An organized set of commands that relates to a specific activity.