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

Microsoft Excel Data Manipulation, Presentation, and Analysis

Amber Israelsen, Ben Howard, Eugene Meidinger, Pratheerth Padman, and Carlos Gutierrez

Microsoft Excel offers a robust array of data munging and analytics tools. This skill will help you use these tools to their greatest effect as you collect, explore, analyze, visualize, and communicate your data using Microsoft Excel.

What You'll Learn

Loading data into Excel from external sources

Exploring your data with PivotTables

Visualizing your data with PivotCharts

Formatting Excel objects

Creating calculated cell values and formulas

Distributing your Excel workbooks

Enroll now

Or start your subscription today

And complete this course over a free trial

Help others find this collection page by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Nine courses

Loading Data into Excel 2016

(0 hours)

In this course, you'll learn the basics of Microsoft Excel, including its components and how to load data from various sources. You'll start by getting introduced to Excel itself and its components, then move on to importing data from various sources into Excel.

View more details for this course

Searching and Manipulating Data in Excel 2016

(1 hours)

If you often encounter pre-filled Excel workbooks, the ability to search and manipulate data is essential. This course covers data validation, what-if analysis, navigating worksheets, inserting hyperlinks, and managing data in cells.

View more details for this course

Formatting Excel 2016 Worksheets and Cells

(1 hours)

In this course, we will discuss changing the appearance of Microsoft Excel worksheets or workbooks. We will focus on customizing the appearance of sheets and books and the tools that help us achieve that.

View more details for this course

Calculating Cell Values with Formulas

(1 hours)

In this course, Calculating Cell Values with Formulas, you'll learn to implement various types of functions and formulas to perform calculations, logical and statistical operations, reference dates and times, and look up data in Excel. You'll also explore techniques to troubleshoot and audit these formulas, such as tracing precedents and dependents, and monitoring cells and formulas with Watch Window.

View more details for this course

Summarizing and Organizing Data in Excel

(1 hours)

A practical course exploring Excel features that allow you to organize, summarize, analyze, and visualize data. Quickly learn to turn data into insightful tables and charts.

View more details for this course

Displaying Tables with Excel

(1 hours)

This course explores Excel Tables, explaining how to use them to quickly gain insights into data. The course discusses what tables are, why you should use them, how to set them up, and then how to manipulate the data in them.

View more details for this course

Charting Data with Excel

(1 hours)

It is often difficult to read and understand complex data by looking at a big table of numbers. Using Excel's charting tools, you will learn how to transform data into compelling visuals and uncover the important insights.

View more details for this course

Visualizing Data with PivotCharts

(1 hours)

This course explores Excel PivotCharts that display a visual representation of PivotTables. The course shows you how to choose a PivotChart, select the data to visualize, and modify the look and feel of the chart to meet your requirements.

View more details for this course

Distributing Excel Workbooks

(1 hours)

Before sharing Excel workbooks, check print settings, export options, security, and accessibility to ensure readability and understanding.

View more details for this course

Save this collection

Save Microsoft Excel Data Manipulation, Presentation, and Analysis to your list so you can find it easily later:

Save

Time

11 hours

Via

Pluralsight

Institution

Instructors

Amber Israelsen

Ben Howard

Eugene Meidinger

Pratheerth Padman

Carlos Gutierrez

Share and help others discover this collection.

Facebook

Link

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.