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.........................................................................................................................................................................
Status Bar Modes...............................................................................................................................................................
Keyboard Navigation......................................................................................................................................................
Ribbon...............................................................................................................................................................................
Clipboard........................................................................................................................................................................
Formatting Cells.............................................................................................................................................................
Cells Structures..................................................................................................................................................................
Inserting.........................................................................................................................................................................
Deleting..........................................................................................................................................................................
Cell Size (Row Height/Column Width)............................................................................................................................
Fill Handle..........................................................................................................................................................................
Building an Equation..........................................................................................................................................................
Type in the exact cell address........................................................................................................................................
Use the mouse to point to the cell address...................................................................................................................
Mathematical Operations..............................................................................................................................................
AutoSum........................................................................................................................................................................
Exercise 1: Customers......................................................................................................................................................1
Resizing Columns.........................................................................................................................................................1
Freeze Panes (Lock Titles to Top of Page)....................................................................................................................1
Format......................................................................................................................................................................... 1
Exercise 2: Quarter Total.................................................................................................................................................1
Fill Handle.................................................................................................................................................................... 1
Format......................................................................................................................................................................... 1
Chart............................................................................................................................................................................ 1
Exercise 3: Items by Quarter............................................................................................................................................1
Insert Rows.................................................................................................................................................................. 1
Merged Title.................................................................................................................................................................1
Fill Handle Across.........................................................................................................................................................1
Total Row (AutoSum)...................................................................................................................................................1
Exercise 4: Sales Report...................................................................................................................................................1
Format......................................................................................................................................................................... 1
Math............................................................................................................................................................................ 1
Grand Total.................................................................................................................................................................. 1
,
, 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.........................................................................................................................................................................
Status Bar Modes...............................................................................................................................................................
Keyboard Navigation......................................................................................................................................................
Ribbon...............................................................................................................................................................................
Clipboard........................................................................................................................................................................
Formatting Cells.............................................................................................................................................................
Cells Structures..................................................................................................................................................................
Inserting.........................................................................................................................................................................
Deleting..........................................................................................................................................................................
Cell Size (Row Height/Column Width)............................................................................................................................
Fill Handle..........................................................................................................................................................................
Building an Equation..........................................................................................................................................................
Type in the exact cell address........................................................................................................................................
Use the mouse to point to the cell address...................................................................................................................
Mathematical Operations..............................................................................................................................................
AutoSum........................................................................................................................................................................
Exercise 1: Customers......................................................................................................................................................1
Resizing Columns.........................................................................................................................................................1
Freeze Panes (Lock Titles to Top of Page)....................................................................................................................1
Format......................................................................................................................................................................... 1
Exercise 2: Quarter Total.................................................................................................................................................1
Fill Handle.................................................................................................................................................................... 1
Format......................................................................................................................................................................... 1
Chart............................................................................................................................................................................ 1
Exercise 3: Items by Quarter............................................................................................................................................1
Insert Rows.................................................................................................................................................................. 1
Merged Title.................................................................................................................................................................1
Fill Handle Across.........................................................................................................................................................1
Total Row (AutoSum)...................................................................................................................................................1
Exercise 4: Sales Report...................................................................................................................................................1
Format......................................................................................................................................................................... 1
Math............................................................................................................................................................................ 1
Grand Total.................................................................................................................................................................. 1
