[PDF] [PDF] Microsoft Excel 2013 Fundamentals Manual - Pitt IT

[PDF] Microsoft Excel 2013 Fundamentals Manual - Pitt IT

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

[PDF] Microsoft Excel 2013 Step by Step - Microsoft Press Store

28 mar 2013 · Microsoft Press books are available through booksellers and distributors worldwide Part of the Microsoft Office 2013 suite of programs, Microsoft Excel 2013 is a full-featured Publish As PDF Or XPS dialog box, 417

[PDF] Excel 2013

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

[PDF] Microsoft Excel 2013 A Beginners Guide - University of Reading

Starting Excel To start up the program: 1 Click on the Windows Start button 2 Choose All Programs then Microsoft Office 2013 followed by Excel 2013

[PDF] Microsoft Excel 2013 An Intermediate Guide - University of Reading

50 records · Log into an IT Lab PC as usual and start up Excel 2013: 1 Click on the Start button, choose All Programs then Microsoft Office 2013 and Excel 2013

[PDF] Excel 2013 Core: Advanced

Specifically when analysing data You will learn how to: • Use Conditional Logic in a formula – IF statements • Use the SumIF and CountIF functions

[PDF] Microsoft EXCEL

Microsoft Excel 2013, Microsoft Excel 2010 (Windows) Microsoft Excel to use another file type, such as a PDF or Excel 97-2003 workbook It's easy to export 

[PDF] Preview Advanced Excel Tutorial (PDF Version) - Tutorialspoint

Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013 It has plenty of 

[PDF] Advanced Microsoft Excel 2013 - PDFDirectorycom

Microsoft Excel is program designed to efficiently manage spreadsheets and analyze data It contains both basic and advanced features that anyone can learn

[PDF] advanced excel tutorial pdf 2016

[PDF] advanced excel tutorial pdf download

[PDF] advanced excel tutorial pdf with examples

[PDF] advanced excel tutorial pdf with examples 2013

[PDF] advanced excel tutorial point pdf

[PDF] advanced excel tutorialspoint pdf

[PDF] advanced excel vba book pdf

[PDF] advanced excel vba pdf download

[PDF] advanced excel vba pdf free download

[PDF] advanced features of powerpoint

[PDF] advanced filter app for android

[PDF] advanced financial management course

[PDF] advanced financial management meaning

[PDF] advanced financial management notes pdf cpa

[PDF] advanced financial management past papers

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.

Table of Contents

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