This workshop is for those who already use Excel and are comfortable with its basic functions.
Dates
This is a 2 days course. Staff can choose one of the following sessions:
- 1st session: March 11 - 12
- 2nd session: March 26 - 27
Learning objectives and course prerequisites:
Learning Objectives
|
What you must know before the course
|
At the end of the workshop, you will be able to: • Handle several work books and create formulas between them • Build advanced formulas using some of the most useful build-in functions • Use VLOOKUP+MATCH – functions when you want to look up values in big data lists • Handle formulas which return errors • Use conditional formatting as a tool to highlight desired key figures or figures that meet your criteria • Create an overview of, and make calculations on long lists, ex. using functions such as Subtotals, SUMIFS • Create and manage PivotTables.
|
- Use the Excel formatting features
- Know calculation operators and calculation rules
- Build your own formulas
- Use the basic build-in functions - ex. Autosum, Statistical functions and Logical functions (the If function)
- How to use relative or absolute cell references in formulas – using $-signs
- Using names in formulas
- Creating, managing and entering data in multiple sheets
- How to create and edit different chart types based on your data
- Creating lists - sorting lists - filtering data
- Creating tables and using tables styles.
|
If you are in doubt and need advice on assessing your level, please contact us at sd.events@unicef.org
Click the button "Join the activity" to sign-up