Introduction to Excel

Introduction to Excel

• Explore the screen

• Name box – how to move with the name box

• Name ranges

• Sheets – add sheets

• Change order – rename sheets

• Moving around the sheet

• Fill handle – creating a series

• Auto Sum

• Create a basic formula

• Absolute reference

• Average

• Max

• Minimum

• Inserting columns and rows

• Copy the entire sheet

• Linking data from two sheets

• Select and move a group of cells

• Wrap text

• Insert function

• Conditional formatting

• Inserting tables

• Creating charts