Microsoft Excel 2013 Fundamentals Manual PDF

Microsoft Excel 2013 Fundamentals Manual

3 mars 2015 This manual provides instructions with the fundamental spreadsheet features of. Microsoft Excel 2013. Topics covered in this document will help ...

Microsoft Excel Manual

SECTION I: What is Excel? Microsoft Excel is a spreadsheet application that is commonly used for a variety of uses. At its core Excel.

Microsoft Excel 2013 Fundamentals Manual

3 mars 2015 This manual provides instructions with the fundamental spreadsheet features of. Microsoft Excel 2013. Topics covered in this document will help ...

EXCEL BASICS: MICROSOFT OFFICE 2013

Microsoft Excel is an example of a program called a “spreadsheet.” Spreadsheets are used to organize real world data such as a check register or a rolodex.

Excel 2013 Core: Advanced

Shelley Fishel. Excel 2013 Core. Advanced Shelley and her team have worked hard to achieve accreditation by the Learning and Performance Institute.

Microsoft Excel 2013 Step by Step

28 mars 2013 Please tell us what you think of this book at http://www.microsoft.com/learning/booksurvey. Microsoft and the trademarks listed at http://www.

Microsoft Excel 2013 - Complete (Shelly Cashman Series)

Cengage Learning is an independent entity from the Microsoft. Corporation and not affiliated with Microsoft in any manner. For product information and

Read PDF New Perspectives Microsoft Excel 2013 Solution Key

il y a 7 jours A new Troubleshoot case problem enhances analytical skills while a new tutorial on Managing Your Files helps readers navigate Windows 8.

Excel 2013

http://www.stpacs.com/userfiles/8/Classes/727/excel2010intro.pdf Step (4 :)Search for Microsoft Excel 2013 from the submenu and click it.

Bookmark File PDF Excel 2013 Bible John Walkenbach ? - covid19

Advanced Excel Reporting for Management Accountants Neale Blackwood Beginning with an introduction to array formulas this manual examines topics such ...

Microsoft Excel 2013 Fundamentals Manual

Computing Services and Systems Development

Phone: 412-624-HELP (4357)

Last Updated: 03/03/15

Welcome

Microsoft Excel 2013 Fundamentals

Workshop

Wednesday, December

5, 2012

Faculty and Staff Development Program

File: Microsoft Excel 2013 Fundamentals

Page 2 of 52 03/03/15

Technology Help Desk

412 62

4-HELP [4357]

technology.pitt.edu

Microsoft Excel 2013

Fundamentals Workshop

Overview

This manual provides instructions with the fundamental spreadsheet features of

Microsoft Excel

2013
. Topics covered in this document will help you become more proficient with the Excel application. Specific focuses include building spreadsheets, worksheet fundamentals, working with basic formulas, and creating charts.

I. Introduction 4

a. Launch Excel b. Window Features c. Spreadsheet Terms d. Mouse Pointer Styles e. Spreadsheet Navigation f. Basic Steps for Creating a Spreadsheet II.

Enter and Format Data 9

a. Create Spreadsheet b. Adjust Columns Width c. Type Text and Numbers d. Undo and Redo e. Insert and Delete Rows and Columns f. Text and Number Alignment g. Format Fonts h. Format Numbers i. Cut, Copy, and Paste Text j. Print Spreadsheet k. Exit Excel

III. Basic Formulas 17

a. Create Formula b. Basic Steps for creating formulas c. AutoSum d. Borders and Shading e. Manual Formula

File: Microsoft Excel 2013 Fundamentals

Page 3 of 52 03/03/15

IV. Formula Functions 22

a. Sum b. Insert Function c. Average d. Maximum e. Minimum f. Relative versus Absolute Cell g. Payment (Optional Exercise)

V. Charts 32

a. Enter Data b. Create a Chart c. Change Chart Design d. Change Chart Layout e. Add Chart Title f. Change Data Values g. Create Pie Chart h. Print Chart

VI. Sort and Filter 39

a. Sort Data b. AutoFilter c. Custom Filter

VII. Additional Features 43

a. Auto Fill b. Named Ranges c. Freeze Panes d. Auto Format e. Page Setup f. Page Breaks g. Display Formulas h. Range Finder

VIII. Help and Tutorial 52

File: Microsoft Excel 2013 Fundamentals

Page 4 of 52 03/03/15

I. Introduction

Microsoft Excel is a powerful electronic spreadsheet program you can use to automate accounting work, organize data, and perform a wide variety of tasks. Excel is designed to perform calculations, analyze information, and visualize data in a spreadsheet. Also this application includes database and charting features.

A. Launch Excel

To launch Excel for the first time:

1. Click on the Start button.

2. Click on All Programs.

3. Select Microsoft Office from the menu options, and then click on Microsoft

Excel 2013.

Note: After Excel has been launched for the first time, the Excel icon will be located on the Quick Launch pane. This enables you to click on the Start button, and then click on the Excel icon to launch the Excel spreadsheet. Also, a shortcut for

Excel can be created on your desktop.

File: Microsoft Excel 2013 Fundamentals

Page 5 of 52 03/03/15

B. Window Features

The purpose of the window features is to enable the user to perform routine tasks related to the Microsoft applications. All the Office applications share a common appearance and similar features. The window features provide a quick means to execute comma nds. Here are some pertinent

Excel features:

2. Title Bar

9. Ribbon

3. File Tab

5. Cell

6. Cell Range

10. Formula Bar

11. Worksheet

8. New Sheet

7. Status Bar

12. View Options

4. Name Box

1. Quick Access Toolbar

C10quotesdbs_dbs7.pdfusesText_5

[PDF] Microsoft Excel 2013 Fundamentals Manual

Computing Services and Systems Development

Phone: 412-624-HELP (4357)

Last Updated: 03/03/15

Welcome

Microsoft Excel 2013 Fundamentals

Workshop

Wednesday, December

5, 2012

Faculty and Staff Development Program

File: Microsoft Excel 2013 Fundamentals

Page 2 of 52 03/03/15

Technology Help Desk

412 62

4-HELP [4357]

Microsoft Excel 2013

Fundamentals Workshop

Overview

Microsoft Excel

Table of Contents

I. Introduction 4

Enter and Format Data 9

III. Basic Formulas 17

File: Microsoft Excel 2013 Fundamentals

Page 3 of 52 03/03/15

IV. Formula Functions 22

V. Charts 32

VI. Sort and Filter 39

VII. Additional Features 43

VIII. Help and Tutorial 52

File: Microsoft Excel 2013 Fundamentals

Page 4 of 52 03/03/15

I. Introduction

A. Launch Excel

To launch Excel for the first time:

1. Click on the Start button.

2. Click on All Programs.

3. Select Microsoft Office from the menu options, and then click on Microsoft

Excel 2013.

Excel can be created on your desktop.

File: Microsoft Excel 2013 Fundamentals

Page 5 of 52 03/03/15

B. Window Features

Excel features:

2. Title Bar

9. Ribbon

3. File Tab

5. Cell

6. Cell Range

10. Formula Bar

11. Worksheet

8. New Sheet

7. Status Bar

12. View Options

4. Name Box

1. Quick Access Toolbar