Section 1 skills analyzing data using excel
This presentation is the property of its rightful owner.
Sponsored Links
1 / 42

SECTION 1 SKILLS Analyzing Data Using Excel PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on
  • Presentation posted in: General

SECTION 1 SKILLS Analyzing Data Using Excel. 1.1 Start Microsoft Excel 2013 1.1 The Excel Screen 1.1 Open a Workbook 1.1 Save a Workbook 1.1 Print a Workbook 1.2 Start a New Workbook 1.2 Enter Labels and Values 1.2 Use Fill Options 1.3 Perform Calculations Using Formulas

Download Presentation

SECTION 1 SKILLS Analyzing Data Using Excel

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


Section 1 skills analyzing data using excel

SECTION 1 SKILLSAnalyzing Data Using Excel

1.1Start Microsoft Excel 2013

1.1The Excel Screen

1.1Open a Workbook

1.1Save a Workbook

1.1Print a Workbook

1.2Start a New Workbook

1.2Enter Labels and Values

1.2Use Fill Options

1.3Perform Calculations Using Formulas

CHECKPOINT 1

1.4Use the SUM Function

1.5Copy Formulas

1.6Test the Worksheet

1.6Improve the Worksheet Appearance

1.6Sort

CHECKPOINT 2

1.7Use Help

1.8Preview a Worksheet

1.8Change Page Orientation

1.8Print a Worksheet

1.9Display Formulas

1.9Navigate a Worksheet

CHECKPOINT 3


Start microsoft excel 2013

Start Microsoft Excel 2013

To open Microsoft Excel 2013:

  • At the Windows 8 Start screen, click the Excel 2013 tile.

Excel 2013 tile


The excel screen

The Excel Screen

Collapse the Ribbon button

Title bar

tabs

Quick Access toolbar

ribbon

dialog box launcher

Formula bar

group

Name box

column

active cell

scroll box

cell pointer

worksheet area

row

vertical scroll bar

sheet tabs

horizontal scroll bar

Status bar


Excel screen features

Excel Screen Features


Excel screen features continued

Excel Screen Features…continued


Excel screen features continued1

Excel Screen Features…continued


Open a workbook

Open a Workbook

To open a workbook:

  • Click the FILE tab.

  • Click the Open option.

  • Click the desired location in middle panel of backstage area.

  • Click the Browse button.

  • At the Open dialog box, navigate to the desired folder.

  • Double-click the desired file.

Navigation pane

Content pane


Save a workbook

Save a Workbook

To save a workbook with a new name:

  • Click the FILE tab.

  • Click the Save As option.

  • Click the desired folder in the Save As backstage area.

  • Type the new workbook name.

  • Click Save or press Enter.

Save As dialog box


Print a workbook

Print a Workbook

To print a workbook:

  • Click the FILE tab.

  • Click the Print option.

  • Click the Print button.

Print button


Start a new workbook

Start a New Workbook

To start a new workbook:

  • Click the FILE tab.

  • Click the New option.

  • Click the Blank workbook template.

Blank workbook template


Enter labels and values

Enter Labels and Values

  • A label is an entry in a cell that helps the reader relate to the values in the corresponding column or row.

    • Labels are generally entered first when creating a new worksheet since they define the layout of the data in the columns and rows.

    • By default, Excel aligns labels at the left edge of the column.

  • A value is a number, formula, or function that can be used to perform calculations in the worksheet.

    • By default, Excel aligns values at the right edge of the column.

  • Take a few moments to plan or sketch out the layout of a new worksheet before entering labels and values.

  • Decide the calculations you will need to execute and how to display the data so that it will be easily understood and interpreted.


Enter labels and values continued

Enter Labels and Values…continued

Enter button

Cancel button

Entry appears in the Formula bar and in the active cell.


Enter labels and values continued1

Enter Labels and Values…continued

long label


Use fill options

Use Fill Options

To use the fill handle:

  • Click the desired cell to make the cell active.

  • Point at the fill handle. The cell pointer changes from the large white cross to a thin black cross.

  • Hold down the left mouse button.

  • Drag the pointer as desired.

  • Release the left mouse button.

fill handle


Use fill options continued

Use Fill Options…continued

Auto Fill Options button


Use fill options continued1

Use Fill Options…continued

Auto Fill Options button


Use fill options continued2

Use Fill Options…continued

To use the fill feature on a range:

  • Select the desired range.

  • Click the HOME tab.

  • Click the Fill button in the Editing group.

  • Click the desired option at the drop-down list.

Fill button

selected range


Perform calculations using formulas

Perform Calculations Using Formulas

  • A formula is entered into a cell to perform mathematical calculations in a worksheet.

  • All formulas in Excel begin with the equals sign (=) as the first character.

  • After the equals sign, the cell addresses that contain the values you want to calculate are entered between mathematical operators.

  • The mathematical operators are:

    • + (addition)

    • – (subtraction)

    • * (multiplication)

    • / (division)

    • ^ (exponentiation)


Perform calculations using formulas continued

Perform Calculations Using Formulas…continued

To enter a formula:

  • Activate the cell in which you want the result placed.

  • Type =.

  • Type the first cell address.

  • Type the operator symbol.

  • Type the second cell address.

  • Continue Steps 3-5 until finished.

  • Press Enter or click the Enter button.

formula


Perform calculations using formulas continued1

Perform Calculations Using Formulas…continued

To enter a formula using the pointing method:

  • Activate the cell in which you want the result placed.

  • Type =.

  • Click the first cell.

  • Type the operator symbol.

  • Click the second cell.

  • Continue Steps 3-5 until finished.

  • Press Enter or click the Enter button.

marquee


Checkpoint 1

CHECKPOINT 1

  • This is what the intersection of a column with a row is called.

    • fill handle

    • pointer

    • insertion point

    • cell

  • This is the name of the small green square that displays at the bottom right corner of the active cell.

    • fill handle

    • pointer

    • insertion point

    • cell

Answer

Answer

Next Question

Next Question

  • By default, values are aligned at what edge of the column?

    • left

    • right

    • top

    • bottom

  • Always type this symbol before entering a formula.

    • asterisk (*)

    • plus sign (+)

    • equals sign (=)

    • minus sign (-)

Answer

Answer

Next Question

Next Slide


Use the sum function

Use the SUM Function

To enter the SUM function:

  • Activate the cell in which you want the result placed.

  • Click the AutoSum button in the Editing group on the HOME tab.

  • Press Enter, or drag to select the correct range and press Enter.

    OR

  • Drag to select the range of cells to be summed, including the result cell.

  • Click the AutoSum button.

SUM function

SUM function


Copy formulas

Copy Formulas

To copy a formula:

  • Activate the source cell.

  • Click the Copy button.

  • Select the destination cell(s).

  • Click the Paste button.

marquee

Paste Options button


Copy formulas continued

Copy Formulas…continued

fill handle


Test the worksheet

Test the Worksheet

To test the worksheet:

  • Enter proof formulas.

proof formula


Improve the worksheet appearance

Improve the Worksheet Appearance

Labels do not align directly over values.

Decimal places are not consistent.


Improve the worksheet appearance continued

Improve the Worksheet Appearance…continued

To format a range to the accounting number format:

  • Select the desired range.

  • Click the Accounting Number Format button in the Number group on the HOME tab.

Accounting Number Format button

ScreenTip


Improve the worksheet appearance continued1

Improve the Worksheet Appearance…continued

To align labels at the right:

  • Select the desired range.

  • Click the Align Right button in the Alignment group on the HOME tab.

  • Click in any cell to deselect the range.

Align Right button


Improve the worksheet appearance continued2

Improve the Worksheet Appearance…continued

To rotate text in cells:

  • Select the desired range.

  • Click the Orientation button in the Alignment group on the HOME tab.

  • Select the desired option.

Orientation button


Section 1 skills analyzing data using excel

Sort

To sort a range:

  • Select the range.

  • Click the Sort & Filter button in the Editing group on the HOME tab.

  • Click Custom Sort at the drop-down list.

  • At the Sort dialog box, click the down-pointing arrow at the right of Sort by in the Column section and then select the desired column at the drop-down list.

Sort & Filter button

Sort dialog box


Checkpoint 2

CHECKPOINT 2

  • Use this built-in function to add a range of values.

    • ADD function

    • SUM function

    • TOTAL function

    • RANGE function

  • Excel uses up to how many decimal places when calculating values?

    • 1

    • 5

    • 10

    • 15

Answer

Answer

Next Question

Next Question

  • This is a temporary storage location used when copying.

    • Clipboard

    • Copyboard

    • Storageboard

    • Tempboard

  • This button is used to rotate text within cells.

    • Orientation

    • Rotate

    • Angle

    • Text

Answer

Answer

Next Question

Next Slide


Use help

Use Help

To use Help with F1:

  • Point to a button.

  • Press the F1 function key.

  • Scroll down the Help window and click the subtitles to read the information available.

  • Close the Excel Help window.

ScreenTip

Help window

Help subtitles


Use help continued

Use Help…continued

To use Help with the Help button:

  • Click the Microsoft Excel Help button.

  • Type a word or phrase in the Search text box.

  • Click the Search button or press Enter.

  • Click the desired hyperlink.

  • Read the information that displays in the window.

  • Close the Excel Help window.

Search text box


Use help continued1

Use Help…continued

Home

Keep Help on Top

Back

Use Large Text

Forward

Print


Preview a worksheet

Preview a Worksheet

To preview a worksheet:

  • Click the FILE tab.

  • Click the Print option.

Pages indicator


Change page orientation

Change Page Orientation

To change the page orientation:

  • Click the FILE tab.

  • Click the Print option.

  • Click the orientation gallery in the Settings category.

  • Click the desired orientation.

Page Orientation gallery


Print a worksheet

Print a Worksheet

To print a worksheet:

  • Click the FILE tab.

  • Click the Print option.

  • Click the Print button.

Print button


Display formulas

Display Formulas

To display formulas:

  • Click the FORMULAS tab.

  • Click the Show Formulas button in the Formula Auditing group.

Show Formulas button


Navigate a worksheet

Navigate a Worksheet

To go to a specific cell:

  • Click the Find & Select button.

  • Click Go To.

  • Type the cell address at the Go To dialog box.

  • Click OK.

Find & Select button

Go To dialog box


Navigate a worksheet continued

Navigate a Worksheet…continued


Checkpoint 3

CHECKPOINT 3

  • Pressing this function key is one way to access the Help window.

    • F1

    • F2

    • F3

    • F4

  • To display formulas, click the Show Formulas button on this tab.

    • FORMULAS

    • HOME

    • INSERT

    • VIEW

Answer

Answer

Next Question

Next Question

  • In this orientation, the page is printed on paper taller than it is wide.

    • scenic

    • landscape

    • portrait

    • design

  • Pressing these keys will move the insertion point to A1.

    • Alt + Page Down

    • Alt + Page Up

    • Ctrl + End

    • Ctrl + Home

Answer

Answer

Next Question

Next Slide


  • Login