Microsoft Excel for Beginners
,
, Microsoft Excel for Beginners
2.0 hours
This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to
create reports that need calculations and charts. In this workshop we will learn how to move
around and work inside the spreadsheet.
Vocabulary .................................................................................................................................................... 1
Status Bar Modes .......................................................................................................................................... 1
Keyboard Navigation ................................................................................................................................. 2
Ribbon ........................................................................................................................................................... 2
Clipboard ................................................................................................................................................... 2
Formatting Cells ........................................................................................................................................ 3
Cells Structures ............................................................................................................................................. 4
Inserting .................................................................................................................................................... 4
Deleting ..................................................................................................................................................... 5
Cell Size (Row Height/Column Width) ...................................................................................................... 5
Fill Handle ..................................................................................................................................................... 6
Building an Equation ..................................................................................................................................... 6
Type in the exact cell address ................................................................................................................... 6
Use the mouse to point to the cell address .............................................................................................. 7
Mathematical Operations ......................................................................................................................... 7
AutoSum.................................................................................................................................................... 7
Exercise 1: Customers ................................................................................................................................... 8
Resizing Columns ...................................................................................................................................... 8
Freeze Panes (Lock Titles to Top of Page) ................................................................................................. 8
Format ....................................................................................................................................................... 9
Exercise 2: Quarter Total ............................................................................................................................ 10
Fill Handle................................................................................................................................................ 10
Format ..................................................................................................................................................... 10
Chart ........................................................................................................................................................ 10
Exercise 3: Items by Quarter ....................................................................................................................... 11
Insert Rows.............................................................................................................................................. 11
Merged Title ............................................................................................................................................ 11
Fill Handle Across .................................................................................................................................... 11
Total Row (AutoSum) .............................................................................................................................. 11
Exercise 4: Sales Report .............................................................................................................................. 12
Format ..................................................................................................................................................... 12
Math ........................................................................................................................................................ 12
Grand Total ............................................................................................................................................. 12
Updated: 1/16/2018
,
, Microsoft Excel for Beginners
2.0 hours
This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to
create reports that need calculations and charts. In this workshop we will learn how to move
around and work inside the spreadsheet.
Vocabulary .................................................................................................................................................... 1
Status Bar Modes .......................................................................................................................................... 1
Keyboard Navigation ................................................................................................................................. 2
Ribbon ........................................................................................................................................................... 2
Clipboard ................................................................................................................................................... 2
Formatting Cells ........................................................................................................................................ 3
Cells Structures ............................................................................................................................................. 4
Inserting .................................................................................................................................................... 4
Deleting ..................................................................................................................................................... 5
Cell Size (Row Height/Column Width) ...................................................................................................... 5
Fill Handle ..................................................................................................................................................... 6
Building an Equation ..................................................................................................................................... 6
Type in the exact cell address ................................................................................................................... 6
Use the mouse to point to the cell address .............................................................................................. 7
Mathematical Operations ......................................................................................................................... 7
AutoSum.................................................................................................................................................... 7
Exercise 1: Customers ................................................................................................................................... 8
Resizing Columns ...................................................................................................................................... 8
Freeze Panes (Lock Titles to Top of Page) ................................................................................................. 8
Format ....................................................................................................................................................... 9
Exercise 2: Quarter Total ............................................................................................................................ 10
Fill Handle................................................................................................................................................ 10
Format ..................................................................................................................................................... 10
Chart ........................................................................................................................................................ 10
Exercise 3: Items by Quarter ....................................................................................................................... 11
Insert Rows.............................................................................................................................................. 11
Merged Title ............................................................................................................................................ 11
Fill Handle Across .................................................................................................................................... 11
Total Row (AutoSum) .............................................................................................................................. 11
Exercise 4: Sales Report .............................................................................................................................. 12
Format ..................................................................................................................................................... 12
Math ........................................................................................................................................................ 12
Grand Total ............................................................................................................................................. 12
Updated: 1/16/2018
