Analyzing and Visualizing Data with Excel

Description

Microsoft Excel is one of the most widely used solutions for analyzing and visualizing data. Beginning with Excel 2010, new tools were introduced to enable the analysis of more data, resulting in less time spent creating and maintaining the solutions and enabling a better understanding of what the data means. This better understanding is facilitated by improved visualizations and more sophisticated business logics.

Do you want to take your advanced Excel skills to the next level? Are you exploring new ways to get and transform your data and create visualization? Check out this practical new course, taught in short, lecture-based videos, complete with demos, quizzes, and hands-on labs, and skill up on many of the built-in business intelligence (BI) tools and features in Excel. ​Learn how to present the most relevant data with dynamic reports and presentations, as expert Dany Hoter walks you through all the important details.

In this course, get an introduction to the latest versions of these new tools in Excel 2016. See how to import data from different sources, create mashups between data sources, and prepare the data for analysis. After preparing the data, learn about how business calculations—from simple to more advanced—can be expressed using the DAX calculation engine. And see how these different technologies work together inside Excel. Learn how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and consumed on mobile devices.



Have you tried this resource?

Help someone out by sharing your thoughts!

Write a review

Have questions about K-12 education?

Ask our community of thousands of teachers, homeschoolers, and parents! Or see recently-asked questions.

Ask a Question

More Ways to Learn Microsoft Excel

$30

Excel 2016 Bible

7th - College | Book, ebook/Kindle

The complete guide to Excel 2016, from Mr. Spreadsheet himself. Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel...

$25 monthly

Excel 2016 Essential Training


7th - College | Online class

Start mastering Excel, the world’s most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple...

1
Free

Excel Tutorials


College | Online resource

Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to...

$25 monthly

The 5-Day Excel Challenge


7th - College | Online class

Take this fun and fast 5-day Excel challenge to test and build your Excel skills. The challenges are based on the questions that Excel expert Dennis Taylor encounters most often, and they grow...

$20 monthly
Paid add-ons

Improve Your Microsoft Excel Skills


College | Online class

Improve Your Microsoft Excel Skills Increase the number skills you have and improve your spreadsheet expertise by expanding your use of the versatile features in Microsoft Excel. Learn how to work...

Free

PRDV004: Spreadsheets


College | Online class

This course will provide you with a comprehensive introduction to spreadsheets. The course is designed for first-time users with very little or no exposure to the subject. For this course, you will...

Free

Mastering Data Analysis in Excel


College | Online class

In business, data and algorithms create economic value when they reduce uncertainty about financially important outcomes. This course teaches the concepts and mathematical methods behind the most...

Free

MrExcel.com

High School - College | Online resource

A resource collection and online community dedicated to Excel since 1998, the MrExcel.com community answers 30,000 Excel-related questions per year on their message boards, and offers seminars and...

$50

Excel for Finance


College | Online class

THROUGH THIS ONLINE COURSE, YOU’LL… Benefit from expert advice, in simple language, from an accomplished financial analyst Discover which Excel functions financial experts use daily (and which ones...

Free

Excel 2016 Tutorial


6th - College | Online resource, Online video/YouTube

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial. Excel 2016 Basics 1 Getting Started with Excel...


See all resources for Microsoft Excel

Links to supporting retailers are recognized and built automatically, so we can provide you with truly unbiased listings.
We receive a small share of sales from those links to help us keep this service free for all learners. Thanks for your support!

Frequently Asked Questions

What is Analyzing and Visualizing Data with Excel by Microsoft?

Analyzing and Visualizing Data with Excel is a learning resource for Microsoft Excel. It is available in the following format(s): Online class. It is suited for 7th - College students.

What grade level is Analyzing and Visualizing Data with Excel by Microsoft appropriate for?

It is designed for 7th - College students, but could be useful for students of other ages as well; please look at the description and images to determine suitability.

How much does Analyzing and Visualizing Data with Excel by Microsoft cost?

It is free!