chirayu
Well-Known Member
Hi All,
In my department I'm the only data guy. My department is Training team (for those of you who don't know). So sometimes I am also expected to take Excel classes (even though I was hired to create reporting solutions and analysis only). I am by no means a certified professional. All my knowledge is hand on. So I'm just uploading some of the resources I use to teach people some of the content.
It covers the following content
In my department I'm the only data guy. My department is Training team (for those of you who don't know). So sometimes I am also expected to take Excel classes (even though I was hired to create reporting solutions and analysis only). I am by no means a certified professional. All my knowledge is hand on. So I'm just uploading some of the resources I use to teach people some of the content.
It covers the following content
- SUM, SUMIF, SUMIFS
- COUNT, COUNTA, COUNTIF, COUNTIFS
- CONCATENATE, TRIM
- LOOKUP, VLOOKUP, HLOOKUP
- MIN, MAX, RANK
- INDEX(MATCH
- IF, IF(AND, IF(OR, IF(AND(OR, IF(OR(AND, Nested IF
- Form Controls - Combo Box, Checkbox, Option button, Scroll bar, List box