We may earn an affiliate commission when you visit our partners.

Excel 2013

An Analytics Superhub

Andrew Brust

A look at the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, "Data Explorer" and "GeoFlow," as well as an investigation into how to use these tools together.

This course goes through how to use Excel as an analytics client for BI and Big Data. With coverage applicable to several versions of Excel, but with emphasis on the new capabilities of Excel 2013, the content includes details on, and numerous demos of, the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, and preview add-ins code-named "Data Explorer" and "GeoFlow." This course provides great detail on each tool and shows how they can be used in combination, as well as, with data from HDInsight/Hadoop; Microsoft's Big Data Platform. Tie-ins to SharePoint are discussed and integration with Office 365 is demoed.

Enroll now

Or start your subscription today

And complete this course over a free trial

What's inside

Syllabus

Introduction

Excel as a BI Tool

Data Management and Modeling: Core Excel and the Excel Data Model

Data Management and Modeling: PowerPivot

Data Discovery and Visualization: Power View

Data Acquisition: "Data Explorer"

Mapping: "GeoFlow"

How SharePoint Ties In

Wrap-Up

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Deeply explores Excel's analytics capabilities including PowerPivot, Power View, and 'Data Explorer.'

Taught by Andrew Brust, an experienced data analyst

Covers a wide range of topics essential for data analysis in Excel, including data management, modeling, visualization, and acquisition

Provides numerous demos and hands-on exercises to reinforce learning

Suitable for learners with some prior knowledge of Excel and data analysis concepts

Focuses on Excel 2013, which may not align with the latest version of Excel

Save this course

Save Excel 2013: An Analytics Superhub to your list so you can find it easily later:

Save

Activities

Coming soon We're preparing activities for Excel 2013: An Analytics Superhub. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Excel 2013: An Analytics Superhub will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use their technical expertise in organizing, analyzing, and interpreting data to help businesses make informed decisions. This course helps build a foundation in data analysis by teaching students how to use Excel as a BI tool, manage and model data using core Excel and the Excel Data Model, and visualize data using Power View. These skills are essential for Data Analysts who need to be able to work with large datasets and communicate their findings effectively.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts use data to help businesses improve their operations. They may work with data to identify trends, develop strategies, or make recommendations. This course can be helpful for Business Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Business Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use data to make investment decisions. They may work with data to value companies, analyze financial statements, or develop investment strategies. This course can be helpful for Financial Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Financial Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers use data to understand consumer behavior and trends. They may work with data to identify target markets, develop marketing campaigns, or evaluate the effectiveness of marketing efforts. This course can be helpful for Market Researchers who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Market Researchers who need to communicate their findings to stakeholders.

See salaries and explore the career path for Market Researcher

Operations Research Analyst

Operations Research Analysts use data to improve the efficiency of business operations. They may work with data to identify bottlenecks, develop scheduling systems, or design new products. This course can be helpful for Operations Research Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Operations Research Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Operations Research Analyst

Data Scientist

Data Scientists use data to build predictive models and solve business problems. They may work with data to identify trends, develop algorithms, or create data visualizations. This course can be helpful for Data Scientists who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Data Scientists who need to communicate their findings to stakeholders.

See salaries and explore the career path for Data Scientist

Statistician

Statisticians use data to collect, analyze, and interpret data. They may work with data to design experiments, develop statistical models, or make predictions. This course can be helpful for Statisticians who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Statisticians who need to communicate their findings to stakeholders.

See salaries and explore the career path for Statistician

Quantitative Analyst

Quantitative Analysts use data to develop and implement financial models. They may work with data to value companies, analyze financial statements, or develop investment strategies. This course can be helpful for Quantitative Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Quantitative Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries use data to assess risk and uncertainty. They may work with data to develop insurance policies, pension plans, or investment strategies. This course can be helpful for Actuaries who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Actuaries who need to communicate their findings to stakeholders.

See salaries and explore the career path for Actuary

Risk Analyst

Risk Analysts use data to identify, assess, and manage risk. They may work with data to develop risk management plans, conduct risk assessments, or implement risk mitigation strategies. This course can be helpful for Risk Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Risk Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Risk Analyst

Fraud Analyst

Fraud Analysts use data to detect and investigate fraud. They may work with data to identify fraudulent transactions, develop fraud detection systems, or implement fraud prevention strategies. This course can be helpful for Fraud Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Fraud Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Fraud Analyst

Data Engineer

Data Engineers use data to design, build, and maintain data systems. They may work with data to develop data pipelines, create data warehouses, or implement data governance strategies. This course can be helpful for Data Engineers who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Data Engineers who need to communicate their findings to stakeholders.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators use data to design, build, and maintain databases. They may work with data to create database schemas, optimize database performance, or implement database security measures. This course can be helpful for Database Administrators who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Database Administrators who need to communicate their findings to stakeholders.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts use data to protect information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. They may work with data to identify security vulnerabilities, develop security plans, or implement security measures. This course can be helpful for Information Security Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Information Security Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Information Security Analyst

Software Engineer

Software Engineers use data to design, build, and maintain software systems. They may work with data to develop software requirements, create software designs, or implement software code. This course may be helpful for Software Engineers who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Software Engineers who need to communicate their findings to stakeholders.

See salaries and explore the career path for Software Engineer

Reading list

We've selected 12 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Excel 2013: An Analytics Superhub.

Power Pivot and Power BI