Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

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

  • No labels