Data Analytics Using Excel

What is Data Analytics using MS Excel

Microsoft Excel is the basics and foundation of Data Analytics. The first tool to learn in Data Analytics is Data Analytics using MS Excel. This is a fundamental area in data analytics and the most widely used tool for Data Analytics in the industry.

Enroll in this course to learn Data Analytics using Excel. Understand several phases of a Data Analytics project, and different Excel functions that support employing data to work with different tasks for informed business decisions. This course will equip you as you begin your Data Analytics journey.

In this course you will learn

1. Introduction to Excel Application Environment
2. Formatting Data in Excel
3. Excel Formulas and their Types
4. Types of Cell Referencing used in Excel Formulas
5. Creating Formulas with Excel Mathematical Operators and Functions.
TEMPLATE DESIGNS IN EXCEL
6. Creating and Automating Invoice, Payroll Analysis, School Academic Results, Amortization and Promotion Schedule Templates in Excel.
7. Creating Functions in Excel.
a. SUM
b. AVERAGE
c. IF, Nested IF
d. COUNT, COUNTA
e. VLOOKUP and HLOOKUP
f. AND and OR
DATA ANALYTICS USING EXCEL
8. Statistic and Hypothesis Testing Principles and Excel’s Data Analysis Tools pack for Data Analytics.
9. Formula Auditing, Data Validation and Formula Evaluation Skills.
10. Creating and Edit Charts (Graphs).
11. Creating Pivot Tables for Analyzing Data for a CHI Square Test.
12. Analyzing Data for Descriptive Statistics, Correlation, Covariance and T.
13. Analyzing Data for Simple Linear Regression Test, Rank and Percentile.
14. Analyzing Data for Multiple Linear Regression Test, and ANOVA

Offline Classes are done at our center in Port Harcourt.

Myteacher Institute Tessy school junction Rumuagholu off Rumuokoro flyover Port Harcourt

Duration: 4 weeks

6 credit hours/week

Certificate on Completion