Data Analysis and Visualization with Microsoft Excel Course

Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present an

Intermediate

Created by OraDMT Last Updated 12/10/2021 13:27

What's Included

  • 14 Lectures
  • Access on tablet and phone
  • Certificate of completion

Choose Training option

Online Tutorial
Ksh.5,000.00
Online Live Teacher
Ksh.25,000.00
Physical Classroom
Ksh.30,000.00
For In-company, In-campus, Group, Workshop Training

What you'll learn

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas and functions.
  • Analyze data with PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis.
  • Get and transform data.
  • Model and analyze data with Power Pivot.
  • Present insights with reports.

Course Curriculum

Expand all Collapse all

14 Lectures

00:00

Description

Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Instructors

(5.00)

100 Courses

14 Students

1 Reviews

OraDMT

Digital Marketing Training
Welcome to OraDMT – We offer Digital Marketing Training in Kenya. Arm yourself with the essential principles and practices of marketing in this digital economy by enrolling for our Digital Marketing courses or let us implement the strategies for you.

We set the Digital Marketing Standards in Kenya. OraDMT has been offering Digital Marketing since 2015 and we have trained and certified more digital marketers than any other digital marketing institution in Kenya. This year 2020 we are introducing 2 new programmes; Design Thinking and Entrepreneurship.

Other related courses