ACL-ITTC-DS-02: Data Analytics with Excel
Course Description
This course serves as an introductory course on the application of Microsoft Excel to Data Analytics for people who may be interested in the seeking a career in this fast growing field. The course introduced participants to the formulas and functions in Excel that can be applied to Data Analytics.
The training course will be a combination of PowerPoint presentations and practical interactive sessions.
Course Content
- Introduction to Data Analytics
- Getting Familiar with EXCEL
- Basic Formulas & Functions in EXCEL
- Introduction to Statistics in EXCEL
- Handling Data in EXCEL
- Cleaning and Wrangling Data in EXCEL
- Data Analytics in EXCEL (Filtering, Sorting and Pivot Tables)
- Data Visualization (Charts and Graphs) in Excel
- Data Analytics Project
Learning Level
Beginner
Who Should Attend
Anybody seeking a career in Data Analytics, or will like to apply data analytics to their businesses.
Pre- requisites
- Basic knowledge of Microsoft Applications including Excel
- Qualification: OND and above
- Working Laptop with Microsoft Excel 2010 and above.
Course Cost
N40,000 per participant (on site) and N30,000 per participant (online)
Duration
3 Weeks (2 days per week, 4hrs per day)