This module introduces basic Microsoft Excel. Microsoft Excel is a spreadsheet developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Learning objectives

By the end of this module, you will be able to:

  • Create and format tables, to visually group and analyse data;
  • Create formulas and use built-in functions to perform calculations and solve problems;
  • Create PivotTables and to calculate, summarise, and analyse data for comparisons, patterns, and trends

Audience

This module is an introductory-level course aimed at anyone who is interested in developing skills and knowledge in nutrition information management in humanitarian contexts, and who needs to engage with coordination and humanitarian architecture on this topic. It is part of the recommended learning path for sub-national IMOs aiming to progress to national-level roles.

Length

It should take you about 60 minutes to complete this self-paced course. 

Methodology

This course is composed of a single short self-paced animated module, including various examples and activities. 

Structure

Introduction

Lesson 1: Introduction to Excel
10-20 mins

Lesson 2: Get started with Formulas
10-20 mins

Lesson 3: Make your first Pivot Table
10-20 mins

Lesson 4: Get more out of Pivot Tables
10-20 mins

Summary

Contact details

For technical issues, you can contact https://www.nutritioncluster.net/Ask_question