Your shopping cart

  • Home
  • Data Analysis and Visualization with Microsoft Excel

Data Analysis and Visualization with Microsoft Excel

Overview

Technology has become ingrained in both daily life and business, as has the data it gathers and makes available. Because cloud computing offers a wealth of computational power and storage, enabling companies of all kinds to collect and store data, the era of "big data" has taken off. Effectively using that data can give you a competitive edge and timely insights. Finding problems, insights, and opportunities through data analysis is becoming essential to many employment tasks. In addition to conducting analysis, data analysts in all professions need to be able to effectively communicate and display their findings in ways that are visually appealing. Excel® from Microsoft is made specifically for this use.Excel has the ability to connect to a large number of data sources, carry out thorough data analysis, and produce a variety of strong visualizations supported by data to display trends, insights, and generate reports. When using Excel for data analysis, these features allow users to transform data into deliberate action. 

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

Recommended
  • Excel 2019: Level 1

Data Analysis Fundamentals

  • Introduction to Data Science
  • Create and Modify Tables
  • Sort and Filter Data

Visualizing Data with Excel

  • Visualize Data with Charts
  • Modify and Format Charts
  • Apply Best Practices in Chart Design

Analyzing Data with Formulas and Functions

  • Analyze Data with Formulas and Named Ranges
  • Analyze Data with Functions
  • Implement Data Validation, Forms, and Controls
  • Create Conditional Visualizations with Lookup Functions

Analyzing Data with PivotTables

  • Create a PivotTable
  • Analyze PivotTable Data

Presenting Visual Insights with Dashboards in Excel
  • Visualize Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel

Creating Geospatial Visualizations with Excel

  • Create Map Charts in Excel
  • Customize Map Charts in Excel

Performing Statistical Analysis

  • Visualize Trendlines and Sparklines with Excel
  • Analyze Data with the Data Analysis ToolPak            
  • Getting and Transforming Data
  • Connect to Data with Queries
  • Clean and Combine Data
  • Shape and Transform Data

Modeling and Analyzing Data with Power Pivot

  • Install Power Pivot in Excel
  • Create Data Models with Power Pivot
  • Create Power Pivots
  • Perform Advanced Data Analysis and Visualization

Presenting Insights with Reports (Optional)

  • Plan a Report
  • Create a Report

Request More Information
StudentsFeedback
Emanuel Paun

United State

Mohammad was an amazing professor. I do not have a strong networking background and Mohammad was very patient in teaching me the basics in topics like wireless. The way he taught (hands on/labs) really helped solidify everything we learned through the 5 days of classes. I have nothing but positive feedback for the way he taught these course and his personality was amazing. 10/10 professor.

Shreyas Deshpande

India

The training helped me connect dots and taught me a lot new concepts as well. The instructor is very knowledgeable in the subject and the demonstrations are very helpful for me to understand issues, and related solutions. I really appreciate and enjoyed the lectures and learning from instructor. Thank you very much!

Yeiner Carrillo

United State

The  BGP class was very interactive and pleasant, I personally liked the instructor's methodology. Thankyou 

James Ferrell

United State

Very cordial and great expertise,Courteous, knowledgeable, detail orientated Mohammed was an awesome instructor. very knowledgeable. 

Jason Pope

United State

The instructor was an outstanding; very personable and presented the material well. I liked the fact that he worked with us on the daily schedule which helped us take care of some crucial tasks here at the end of the year.

Paul Martinez

United State

Mohammed was great, super flexible and took my pervious experience into account. His adaptability made the learning sessions engaging, and his consideration of my background knowledge significantly enhanced the learning process. Overall, a fantastic experience with a teacher who understands how to make learning both effective and enjoyable."

Asadullah Osmani

Afghanistan

Gurfan, is a very Knowledgeable instructor and delivered the material professionally and was welling to explain and help with questions during the session.Great instructor vert knowledgeable and knew the topic very well and he very knowledgeable , i do recommend others to take courses with him.

Pramod Vidwat

India

Has a good knowledge on the subject and more important we had a lot of labs to practice and get the concepts cleared.

Helder

Mozambique

Is a great instructor, explains very well about the classes, very attentive, dynamic and very motivated, I learned a lot from him and I always hope to count on him during my I.T. careers, he is a excellent teacher.

Hirofumi Takemi

Japan

It was an excellent course and I was very lucky to have you as my trainer. Thanks a lot. Hope to see you again somewhere sometime.

Stevenson Kiteculo

Africa

What to say about the coach, I don't know where to start but I tell you, you have a big picture in your company, he helped me even in having motivation that everything is possible when you believe. He is a great teacher and a great person congratulations on you having him.It was a great pleasure to have you as a teacher, in fact he marked my life and I really want to be able to count on your future help, especially the teacher because thanks to him I was able to motivate myself and smile thinking about a great career all this was possible thanks to the efforts , attention and dedication he had to help me thank you very much

Mark Powell

United States

I learned a lot. His method of teaching and the way he made sure I understand everything will prove well for me passing my test.

Emmanuel A Bankole

Angola

I really appreciate this training, it has really impacted great knowledge and you are cool and perfect instructor if I have to be honest.