Document with Pen

MANAGEMENT SPREADSHEETS

Management Spreadsheets

The Management Spreadsheets module covers the advanced skills required to use the versatile options of spreadsheets to supply reports, offer applied mathematics or mathematical analysis, and manage knowledge additionally effectively and profitably. The benefits of empiric decision-making are unit wide recognised. Every kind of organisation wants staff in the United Nations agency area unit ready to use spreadsheets effectively – not only for storing tabular knowledge, except for the subtle means that spreadsheets are often wont to validate, interpret, and give info.

Exhibited Document Flags

LEARNING OUTCOMES

  • Understand advanced formatting options, including conditional formatting and customised formatting.

  • Recognise which functions to use in formulas, and troubleshoot errors.

  • Identify the correct chart to display a specific data set, and create or edit such a chart.

  • Know how to analyse, validate, audit, and protect data.

  • Understand time-saving features such as linking data, paste special, filters, and macros.

BENEFITS

  • Perceive which capacities to utilize in equations, and troubleshoot mistakes.

  • Know how to dissect, approve, review, and secure information.

  • Get it time-saving highlights such as connecting information, glue extraordinary, channels, and macros.

SYLLABUS