Class 2 Excel

Items to cover: 1. hiding columns/rows 2. information messages (green) 3. adding comments (red) 4. fill 5. various tools – error checking speech tracking changes goal seeking formula auditing 6. Sorting 7. Filtering 8. More functions and formulas 9. A credit card expenses example 10. Creating charts 11. using charts in Word and...

Class 1 Excel

We talked about: 1. What would you use Excel for? 2. How to navigate? 3. Used a specific example (04calcgrades) to discuss: editing inserting rows and columns copying and pasting (including formulas) inserting functions use the AVERAGE and MEAN functions to calculate average test scores use the LEN, FIND, LEFT and RIGHT funtions to help separate a first and last name from a cell which contain the complete name 4. How to...

-Excel Curriculum

1. Excel Basics a. The Excel screen b. Workbooks, worksheets, cells 2. Working with Workbook Files a. Creating an empty workbook b. Opening a workbook c. Saving a workbook d. Closing a workbook e. Using a workbook template f. Deleting a workbook g. Creating multiple windows for a workbook 3. Working with Worksheets in a Workbook a. Worksheets b. Manipulating your worksheet c. Moving around in a worksheet d. Moving a...