_Excel is one of the main tools used in data analysis.
With Excel, you can manipulate data, summarize it with pivot tables, visualize it, and perform quick statistics to summarize it.
Mostly excel is used for small data sets not that huge, though it allows you to perform all function of data transformation on it.
Here is the Interface of excel work book...
Basically, it's a 2019 excel version
1. Excel Skills to learn...
- _Perform data cleaning by removing blank spaces as well as incorrect and outdated information
- Format and adjust data using conditional formatting Perform data calculations using formulas
- Organize data using sorting and filtering.
- Create visualizations using graphing and charting.
- Calculate, summarize, and analyze data using pivot tables.
- Aggregate data for Analysis.
1.Basic Formatting and Sum Function
Here will learn more about formatting data, being one of the processes of cleaning data sets using excel and sum function.
Some of the formatting functions include:
- Conditional formatting.
- Format as table.
- Sort and filter.
- Find and select.
For Sum function see below.
2.Max, Min, and Avg Functions
- Excel has many built-in functions, or predefined formulas, that are used to perform both simple and complex calculations. Five basic, built-in functions we will cover are Sum, Average, Count, Max, and Min.
Step 1: Add a New Worksheet
Click the plus “+” button at the bottom left of the workbook screen to add a new worksheet.
Right click the new Sheet2 and rename it “Functions.”
Step 2: Explore the Excel Function Library
Click on the Formulas tab in the toolbar to view the types of built-in functions in the Function Library group.
You may have to expand the toolbar by clicking the down arrow at the far right of the tool bar to see the Function Library group.
Click the dropdown arrow under the AutoSum Function. Note the five basic functions in this subgroup are as follows:
-Average: averages the numeric values in the referenced cells
-Count Numbers counts how many referenced cells there are
-Max: returns the highest numeric value in the set of referenced cells
*MAX-
*MIN
*Average
*Count
These are some of the basic concepts of excel.
Diving deeper into excel is where you find more complex functions as ;vlook-up, xlook-up, hlook-up,,,among others.
Again, pivots tables and dashboards lie as some of the other
functions which can be performed on excel.
On my next post ,i will share more on my data manipulation with excel,from cleaning to dashboards using large data set.
See you on the next.
Min: returns the lowest numeric value in the set of referenced
cells
Step 3: Using the SUM function
.
- Aggregate data for analysis_
Top comments (0)