A LIGHT GUIDE THROUGH EXCEL FOR A DATA ANALYST

HEY.
They say as an data analyst starting with excel is the easiest and first way to begin your journey in your aspiring field. With this guide it will help you ease your learning in excel.
Feeling overwhelmed , confused and don't know where to start learning ?.Keep calm
On this article will focus mostly on simple areas that are quick to learn as you progress and are mostly inquired when working with data in excel as a data analyst.

starting off this are shortcuts you can use to help you maneuver through and help you to be more efficient while learning your way through MICROSOFT Excel.

__FILE SHORTCUT

1. New ctrl + N
2. Open ctrl + O
3. Save workbook ctrl + S
4. Save as F12
5. Go to next workbook ctrl + Tab ten
6. Close file ctrl+ F4
7. Close all open excel files Alt + F4

_DATA EDITING SHORTCUTS _

1. Fill down from cell above Ctrl + D
2. Fill right from cell left Ctrl + R
3. Find and replace Ctrl + F
4. Filter data Ctrl + Alt + L

**Functions in excel
_Aggregate functions
Sum - Sum is used to calculate the total number of data in given set.

Average - Average is used to calculate the arithmetic mean of a given set in excel.

Max - Max is used to show the highest value in a given data set.

Min - AS opposed to to max this is used to show or highlight the lowest number.

Count - For count it is used to show the the total numeric values in a cell.

Count A -This is used to show the total number of cells that are not blank. They can either be numeric values or texts.

_logical function_
logical Functions are used to automate decision making

_*if* function_
The if function is made of 3 parts
I).A condition.
II). What to do if the condition is met.
III). What to do if the condition is not met.

_look up functions_
I). V-Lookup function -is used to search for values in a vertical order.
The v-lookup function may be slow when used in large data sets.
II).horizontal Lookup -H-lookup is used to retrieve information from a table by searching for values in a row.

Conditional Formatting
Conditional Formatting is used to highlight cells with important values or to be able to see trends in a given data by using bars, icon or different colors to easily visualize it.

NOTE: The condition for the cell was to highlight the performance score that is greater than 4.

**
PIVOT TABLES

**

A pivot table is used for organizing, summarizing and for analysis of complex data sets.
It can also be used to create reports or help give insights .
Slicers in pivot tables are used to filter data and actively interact with the data.
How to create a pivot table and slicer

In your dataset you go to to insert pivot table. A new sheet will be created like shown above. On your right you can use the pivot table fields to insert your data of choice into rows, filters, values and column to summarize it.

To insert a slicer .

click in the pivot table created.
Then go to insert tab and and toward the far right you will see slicer click on it.
The slicer will give you options depending on your dataset. choose the slicers you prefer and insert
to refresh the slicer or delete it.You can double click on the slicer created and opt for the remove or delete menu given.

Happy learning.