Microsoft Excel Manual
Microsoft Excel 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.
Version 1 10/20/2015 Training, Evaluation & System Support umw.edu/tess
Companion Manuals: Commerce Manager Manual
1
Table of Contents
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
2
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
3
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.
This is a row
This is a cell This is a column
Inserting rows and columns
To Add a Row: 1. Select the entire row below where you want to add the new row.
4
2. Right click, select Insert. To Add a Column
1. Select the column to the right of where you want to add the new column
2. Right click, select Insert.
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to achieve highlight and font color change in a cell
- conditional formatting in microsoft excel
- conditional formatting
- conditional formatting various conditional formatting options
- microsoft excel manual
- 224 2008 proc report in color what s your style
- how to color your report
- 315 2013 reading an excel spreadsheet with cells
- how to apply conditional formatting to a cell
- excel formatting best practices in financial models important
Related searches
- microsoft excel 2010 manual pdf
- microsoft excel 2016 manual pdf
- microsoft excel manual 2010
- microsoft excel training manual pdf
- excel manual guide
- excel manual pdf
- microsoft excel 2013 manual pdf
- microsoft excel manual pdf
- microsoft excel help excel 2016
- microsoft excel online download excel 2010
- microsoft excel training tutorials excel 2016
- free microsoft excel manual pdf