Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
OCHA Knowledge Base
/
Data Processing: Excel
Updated 16 Aug 2022

    Data Processing: Excel

    Excel        

    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

    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

    • EXCELJET - with 500 formulas and 101 functions

     

    Copyright | Terms of Use | Privacy

    OCHA's Knowledge Base
    IM Toolbox
    • Learning Opportunities
      Learning Opportunities
       This trigger is hidden
    Results will update as you type.
    • IM Overview
    • OCHA IM Unit
    • Documenting Data and Standards
    • Common Operational Datasets (CODs) and Dashboard
    • Common Operational Datasets (CODs)
    • Technology: Tools, Software, Platform
      • Data Collection Tools
      • Data Processing: Excel
        • Power Query for Excel
        • HXL - Humanitarian Exchange Language
      • Mapping
      • Visualization
      • Platforms
      • Data/File Sharing
      • Social Media
      • Messaging Apps
    • IM Products
    • Coordination
    • Humanitarian Programme Cycle (HPC)
    • Types of Humanitarian Responses
    • Best Practices - Field Information Management
    • Learning Opportunities
    • Videos
    • Field Information Services (FIS) Team
    • Glossary
    • Gallery
      You‘re viewing this with anonymous access, so some content might be blocked.
      {"serverDuration": 9, "requestCorrelationId": "db050ebf109a4da1861d9a93d7848e49"}