Excel Level I: Fundamentals

Introduction

Interface

• Provides a brief description of the user interface for Microsoft Excel

Data Entry

• Examines and describes multiple means of entering data

Rows & Columns

• Insert, delete, hide, and group rows and columns

Worksheets

• Manage elements of worksheets

Formulas

Autofill

• Explores Excel's amazing ability to predict and extrapolate patterns

Calculations

• Perform mathematical expressions and review the Order of Operations rule

AutoSum Functions

• Review the five key functions: Sum, Average, Max, Min, and Count Numbers

Absolute Reference

• Changing a cell reference into a constant, which is necessary for certain calculations

True or False

• Tests to see whether criteria is true/false

Text Functions

• Introduces functions used to modify text in Excel

Multi-Input Functions

• More advanced functions that require more than one input

Formatting

Formatting

• The addition of effects to an Excel document to provide visual instruction

Conditional Formatting

• Apply a predetermined format based on specified rules