Excel Analytics - Data Analysis with Pivot-Tables and Charts

Published 2022-06-10
Platform Udemy
Rating 4.55
Number of Reviews 12
Number of Students 580
Price $49.99
Instructors
Moustafa Ahmed Abd El-Azim
Subjects

Go to Udemy

Learn How to Perform Data Analysis and Data Visualization from A to Z with Microsoft Excel, Pivot-Table and Pivot-Chart.

Microsoft Excel is a remarkable tool that's useful to many businesses around the world and it is one of many tools in Microsoft 365 Office which includes other tools such as Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, and Microsoft Word however don't be mistaken for Google Sheets as it is a similar tool to Excel

Many do use Microsoft Excel in Data Analysis due to its easy-to-understand environment and spreadsheet capabilities, Moreover, It has many great features such as Pivot-Tables and Pivot-Charts which are 2 great tools to analyze data and visualize data.

In addition to its function collections that exceed 400+ functions, Excel Formulas are great as they help in executing easy and complex operations which can be great in achieving the job and saving time.



You will learn many excel formulas during the course starting with Data Cleansing formulas such as TRIM, UPPER, lower, and more to more advanced formulas such as IF, Count, LOOKUP Family, and More.


During the course you will learn the whole process of Data Analysis from A to Z and apply Excel Training through Quizzes and Practice Tests:


1- Data

Data Analysis surely starts with Data, Hence, During Section 1, You will learn

2- Data Cleansing

Data Cleansing is the process of clearing a dataset from any duplicates, blanks, or inconsistencies and making sure your dataset contains quality data

3- Data Manipulation

Data Manipulation is the process of manipulating data to extract relevant and key information from your dataset

4- Analyze Data

Stage 4 is analyzing data using Pivot-Tables to gain more insights by creating a pivot table based on different rows/columns/filters and calculations

5- Data Visualization

Finally Data Visualization, This is the final stage where you get to present your insights and analysis using Charts and Graphs, Charts are important as each Chart Type could identify hidden patterns and trends


This course is complete as you will get to learn all that you need to get hands dirty in the field of Data Analysis, You will obtain the important intellectual and technical skills to start your first project.


No Experience is required.

Go to Udemy