excel things
Well, my boss asked me to put together an excel training class for our office and this is what I've come up with so far.
Do any of y'all have any suggestions about what else I might what to cover, or regarding my classification for some tasks as "beginner" vs. "intermediate"? I'm running out of ideas that don't involve macros, and I don't really think much about excel qualifies as "intermediate".
"spacebe" (my kingdom for a cyrilc font type)
Beginner:
Cell formatting -font type, cell color, data display (dates, $, etc)
how to change the size of the row/column
How rows, columns and cells are referenced
Visual shortcuts for cell location, formula typing, etc.
What is a formula, and how do you write them;
How to reference a cell or group of cells in a formula and why
how to select multiple cells with the ctrl button
How to separate groups of cell references in a formula
How to tell what cells are referenced in a formula
What is a function
The auto-sum button
How to copy formulas into other cells or adjacent cells
How to edit cell information/formulas
How to auto-populate months, dates, or times, etc in many cells
How to navigate through the cells w/ a keyboard
How to sort data
How to insert a row/column
How to hide a row/column - what this does
Explanation of different error codes (####,#REF!, etc)
Intermediate:
How to insert a chart based on data
What the different types of charts are for
How to set print titles for a multiple page spreadsheet
Cell formats: merge cells, borders, cell type, cell color
Conditional formats for cells
Cell comments (notes)
Freeze panes
How to fix a cell reference in a formula and why
How to “name” a cell as a way to fix it in a formula
The function wizard
=if() formula
Quick visuals for sums/ave/count - and how to set it
Setting/viewing page breaks
Referencing information on another sheet/document
Keyboard shortcuts
Auto-filters