Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview         


          Excel is an incredibly powerful tool and basic proficiency is critical for all OCHA IMOs, regardless of profile.  Excel is used by IMOs for data collection, processing, analysis and in the creation of graphics for the dissemination of information. There are many videos and websites from basic to advanced Excel, it is recommended that all IMOs take the time to become proficient in Excel 

Guidance


Basic Excel Skills


  • Good notes and metadata 

  • Tables

  • Pivot Tables

  • Pivot Charts

  • Slicers

  • Power Query

Excel Formulas


  • COUNT, COUNTA, COUNTIF

  • SUM, SUMIF

  • VLOOKUP

  • AVERAGEIF

  • OFFSET

  • MATCH

  • MATCH/INDEX

  • LARGE

  • IF, NESTEDIF

Outputs/Resources


  • Excel is fun! - YouTube channel with 2,500 how-to videos with a wide range of excel tutorials from beginner to advanced

  • Excel Training 101 - Simple easy to follow instructions and videos on a wide range of Excel basic functions