Course Overview:

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.

Learning Objectives

In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

  • 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.

Target Audience

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis Tool Pak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel

Meet Our Instructor

Why Choose Us?

Hands-On Virtual Lab

Hands-on experience on New Horizons’ Labs to make your software training courses even more interactive and engaging.

Guaranteed-to-Run

Guarantee to run for all courses

Certifications​

Industry-recognized certification to add to your workforce values.

Why Choose Us?

Cost Effective

We create innovative training solutions that works for your business and we’ll account for the results.

Reliable

Low downtime and high efficiency of On-site and Virtual-Live Online Training

Course Customization

Course content and learning method are customized to match to your company’s goals

Official Training Partners

Get Free Consultation Now

Testimonials

What Clients Say

Imanche Victor AdeniyiATC Nigeria
Read More
I am satisfied with the training offered here and the instructor. I look forward to having another training session with New Horizons.
Christian UdehAMCON
Read More
The Excel training was well laid out and the facilitator was very versed, he used multiple scenarios to explain the concept. I am very glad to have chosen New Horizons for this training.
Hammed MuritalaMIS, IITA
Read More
The training is very excellent and it will help me to identify and resolve some database problems.
Iroegbu BrightSAIPEM
Read More
The course was helpful, interactive to know the fitment of business with IT service.
Vihishima J. TIOM
Read More
The course was well taught and well understood.
Previous
Next

Trending Courses

Top Certification Exmas