Excel/Sheets | Data Management

"Hello guys! This section is dedicated to hard skills regarding data management (Excel or Google Sheets knowledge, using charts). I hope it brings you optimization on your job so you can make more and faster impact with AIESEC! See you!"

Magnum

MC OD Data Specialist 19|20

There is a spreadsheet where all formulas were practiced and everthing was recorded.

Also, you can check some cool basic tips and tricks about dragging cells with formulas, references from other tabs, manage errors and use time-related formulas.

Basic Level Formulas

Formulas here

SUM, SUMIF

AVERAGE, AVERAGEIF

COUNT, COUNTA

COUNTIF

COUNTBLANK

Check the spreadsheet for details

Basic+ Level Formulas

Formulas here

IF, IFS

SUMIFS, COUNTIFS

AVERAGEIFS

Check the spreadsheet for details

Formulas here

UNIQUE

COUNTUNIQUE

COUNTUNIQUEIFS

RANK

RANK + COUNTIF

(rank without repeat)

Check the spreadsheet for details

Medium Level Formulas

Formulas here

VLOOKUP

HLOOKUP

"smart" VLOOKUP

(with cells as index)

Check the spreadsheet for details

Formulas here

IMPORTRANGE

IMPORTHTML

Check the spreadsheet for details

Using Charts/Graphics

What's here

Types of charts

How to customize charts

on Google Sheets

Check the Exercise block at the bottom of this page.

What to manage | by function

Use the arrows to slide through the pages.

Check here the routine of data management for all areas of the LCs.

EXERCISE!!!

We had a session about Data Management on FunCo 2019, that has some cool exercises for ou to practice your knowledge. Click on the image to check the materials of this session! 

Slide1.PNG
 

This site is for internal use only. If you want to learn more about our products and services, refer to our website: aiesec.pl

If you have any inputs to improve or fix the HUB, please leave them in the following link: http://bit.ly/polandhubfeedback