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.



More Ways to Learn Microsoft Excel

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

$30

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

$25 monthly

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

Free

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

$25 monthly

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

$20 monthly
Offers paid add-ons

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

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

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

Free

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

$50

See all resources for Microsoft Excel