Microsoft Excel Manual PDF SECTION I: What is 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 ...

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 ...

Version 1

10/20/2015

Training, Evaluation & System Support

www.umw.edu/tess

Microsoft Excel Manual

Companion Manuals:

Commerce Manager Manual

Purpose and Overview

The purpose of this manual is to provide an overview of Microsoft Excel tools and functions which are most useful to improve daily operational efficiency. 2

PURPOSE AND OVERVIEW ................................................................................................................................................................. 1

Table of Contents ........................................................................................................................................................................... 2

SECTION I: WHAT IS EXCEL? ............................................................................................................................................................... 4

WHAT CAN I DO WITH THIS? ......................................................................................................................................................................... 4

SECTION II: CELLS, ROWS, AND COLUMNS ......................................................................................................................................... 4

WHAT IS A CELL? ........................................................................................................................................................................................ 4

WHAT ARE ROWS AND COLUMNS? ................................................................................................................................................................ 4

INSERTING ROWS AND COLUMNS ................................................................................................................................................................... 4

SECTION III: NAVIGATION .................................................................................................................................................................. 6

MOVING BETWEEN CELLS ............................................................................................................................................................................ 6

SELECTING MULTIPLE CELLS ......................................................................................................................................................................... 6

SELECTING ENTIRE ROWS AND COLUMNS ....................................................................................................................................................... 6

SELECTING MULTIPLE ROWS AND COLUMNS ................................................................................................................................................... 6

SECTION IV: FORMATTING ................................................................................................................................................................. 7

CELLS ....................................................................................................................................................................................................... 7

TABLES ..................................................................................................................................................................................................... 8

Choosing a Table Style to Create a Table ......................................................................................................................................... 8

Adjust the Table Style ....................................................................................................................................................................... 9

Creating or Deleting a Custom Table Style ....................................................................................................................................... 9

Removing a Table Style .................................................................................................................................................................. 11

Converting a Table to a Range of Data .......................................................................................................................................... 11

Formatting Table Elements ............................................................................................................................................................ 11

Pivot Tables .................................................................................................................................................................................... 12

CONDITIONAL FORMATTING ....................................................................................................................................................................... 14

Highlight Cells Rules ....................................................................................................................................................................... 14

Greater Than ............................................................................................................................................................................................. 14

Less Than ................................................................................................................................................................................................... 15

Between .................................................................................................................................................................................................... 16

Equal To ..................................................................................................................................................................................................... 16

Text That Contains ..................................................................................................................................................................................... 17

A Date Occurring ....................................................................................................................................................................................... 18

Duplicate Values ........................................................................................................................................................................................ 18

Top/Bottom Rules ........................................................................................................................................................................... 19

Top 10 Items .............................................................................................................................................................................................. 19

Top 10% ..................................................................................................................................................................................................... 20

Above Average .......................................................................................................................................................................................... 21

Data Bars ........................................................................................................................................................................................ 22

Color Scales ..................................................................................................................................................................................... 23

New Rule......................................................................................................................................................................................... 24

Clear Rules ...................................................................................................................................................................................... 25

Manage Rules ................................................................................................................................................................................. 26

SECTION V: SEPARATING TEXT WITHIN A CELL ................................................................................................................................ 27

SECTION VI: SORTING ...................................................................................................................................................................... 28

ALPHABETICAL ......................................................................................................................................................................................... 28

NUMERICALLY ......................................................................................................................................................................................... 29

MULTI-LEVEL SORTING .............................................................................................................................................................................. 29

SORTING BY CELL COLOR ........................................................................................................................................................................... 31

SECTION VII: FILTERS ....................................................................................................................................................................... 34

SECTION VIII: FUNCTIONS AND FORMULAS ..................................................................................................................................... 36

BASIC FUNCTIONS/FORMULAS .................................................................................................................................................................... 36

Sums ............................................................................................................................................................................................... 36

Subtotaling ..................................................................................................................................................................................... 37

One Level Subtotals ................................................................................................................................................................................... 37

Nested Level Subtotals .............................................................................................................................................................................. 39

Removing Subtotals ................................................................................................................................................................................... 42

Average .......................................................................................................................................................................................... 42

Count Numbers ............................................................................................................................................................................... 43

Maximum and Minimum ................................................................................................................................................................ 44

SECTION I: What is Excel?

Microsoft Excel is a spreadsheet application that is commonly used for a variety of uses. At its core, Excel

is a table consisting of rows and columns. Excel is composed of rows and columns and uses a spreadsheet to

display data. Features include: calculation, graphing tools, pivot tables, and a macro programming language

called Visual Basic for Applications.

What can I do with this?

The data within a table can be sorted by any column, which means that the rows can be ordered by last

name or first name alphabetically, by the ID number ascending or descending, by the amount paid

ascending or descending, or by the date. You can also filter the data in the table to have only specific

values show.

SECTION II: Cells, Rows, and Columns

What is a cell?

A cell, outlined in green below, is an individual block within a table in which you can enter values, such

as words or numbers.

What are rows and columns?

Rows, outlined in red below, are a horizontal group of cells. Columns, outlined in blue below, are a vertical group of cells.quotesdbs_dbs7.pdfusesText_5

[PDF] Microsoft Excel Manual SECTION I: What is Excel?

Version 1

10/20/2015

Training, Evaluation & System Support

Microsoft Excel Manual

Companion Manuals:

Commerce Manager Manual

Purpose and Overview

Table of Contents

SECTION I: What is Excel?

What can I do with this?

SECTION II: Cells, Rows, and Columns

What is a cell?

What are rows and columns?