Spreadsheet Software: Microsoft Excel

Basic Understanding    

Define Spreadsheet Application: It is an application which uses formulas to perform mathematical calculations. It could also be used for graphing data. 


Tool Information Pages (TIP) are intended to be an introduction to various technology tools and their specific implementation here at the University. The tabs "Basic Understanding" and "Pros and Cons" describe and define each tool in its generic form. Starting with "Basic Operation," it becomes specific to the UM option and highlights a bulleted list of concepts that would roughly correspond to that level of operational understanding. Faculty may use these lists to help identify their level of understanding of a given tool, especially in conjunction with ETS training offerings or requests.

For further information, please contact:
Rosalia Reyes-Webb
Learning Technology Specialist
Educational Technology Services

Basic Operation

File Management
•    How to create new workbooks and open existing ones
•    How to save workbooks
Worksheet Formatting
•    Modifying Cells, Columns, and Rows
•    Sorting Data
•    Modifying page orientation, scale, margins, print titles, and page breaks

Intermediate Operation

Worksheet Basics
•    Working with more than one worksheet.
•    Naming, Adding Color to Tabs, (Adding, Deleting, and Copying Worksheets), 
•    Freezing Columns and Rows
Formatting Tables
•    Adding Rows and Columns
•    Pre-defined Styles
Basic Formulas
•    Become familiar with common functions like sum, average, product, and count
•    Utilizing Auto-Sum and Insert Functions
•    Also learn how to search and find functions
•    Creating a basic function
•    Finding the function library

Advanced Operation

Reviewing and Sharing Notebooks
•    Tracking Changes
•    Adding and Deleting Comments
•    Adjusting how changes are viewed
•    Finalizing and Protecting your Workbook
Working with Charts
Creating Pivot Tables
Working with SparkLines
Using Conditional Formating
Using What-If Analysis