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.
Duration: 4 weeks
6 credit hours/week
Certificate on Completion
Register for the course
[forminator_form id=”493″]
Online course is self paced
Click Buy now to begin the online class or book for a Live class by filling form above.
