Data Processing: Excel

Excel        

Open

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

• Excel Basics for OCHA IMOs

Basic Excel Skills

• Good notes and metadata 

• Tables

• Pivot Tables

• Pivot Charts

• Slicers

• Power Query

Excel Formulas

• COUNT, COUNTA, COUNTIF, COUNTIFS

• SUM, SUMIF

• VLOOKUP

• AVERAGEIF

• OFFSET

• MATCH

• MATCH/INDEX

• LARGE

• IF, NESTEDIF