• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Practice Materials

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
  • 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
Also added the materials from my previous post for Scroll bar graph tutorial & Gauge graph from 2D pie tutorial
 

Attachments

  • Excel Session Materials.zip
    839.7 KB · Views: 146
Back
Top