Save For Later

Microsoft Excel Data Manipulation, Presentation, and Analysis

Save For Later

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
  • OpenCourser is an affiliate partner of Pluralsight and may earn a commission when you buy through our links.

    From Pluralsight
    Hours 15
    Instructors Pratheerth Padman, Ben Howard, Carlos Gutierrez, Amber Israelsen, Eugene Meidinger
    Language English
    Subjects IT & Networking

    Similar Courses

    Sorted by relevance

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Microsoft instructor $62k

    Excel Reporting Developer $68k

    Excel/Access DTS Developers $78k

    Microsoft CSR $81k

    Excel VBA Developer $82k

    Excel/Access DTS Developer $83k

    Tutor - Accounting/ Excel /ESL $87k

    Microsoft Access Programmer $96k

    SDE in Microsoft $106k

    SDE @ Microsoft 5 $110k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Courses in this Paths

    Listed in the order in which they should be taken

    Starts Course Information

    On Demand

    Loading Data into Excel

    This is the first course on the Microsoft Excel Data Manipulation, Presentation, and Analysis path and as such this assumes no technical knowledge about excel. First, you'll start...

    Pluralsight

    Save

    On Demand

    Searching and Manipulating Data in Excel

    If you're a business analyst or even a regular spreadsheet user, rather than creating a spreadsheet from scratch, you'll mostly encounter them already filled with plenty of data....

    Pluralsight

    Save

    On Demand

    Formatting Excel Worksheets and Cells

    In the 3rd course in the Excel series, we will be handling the look and feel of an excel worksheet/workbook. Here, we’ll be concentrating on how we want the sheets and books to...

    Pluralsight

    Save

    On Demand

    Calculating Cell Values with Formulas

    The power and capabilities of Microsoft Excel stem primarily from the things it can do with functions and formulas. As such, learning how to implement, debug, and monitor them...

    Pluralsight

    Save

    On Demand

    Summarizing and Organizing Data in Excel

    Microsoft Excel is the world’s foremost desktop application for storing, organizing, and manipulating data. This course teaches you how you can use the features of Excel to...

    Pluralsight

    Save

    On Demand

    Displaying Tables with Excel

    Learning how to effectively communicate and display data in Excel is challenging. In this course, Displaying Tables with Excel, you will gain the ability to find insightful...

    Pluralsight

    Save

    On Demand

    Charting Data with Excel

    Data is an increasingly important part of our organizations, and it's critical that you learn how to effectively communicate and visualize this information. In this course,...

    Pluralsight

    Save

    On Demand

    Exploring Data with PivotTables

    Learning how to summarize and analyze large and complex sets of data, and communicating the results, can be a daunting process. In this course, Exploring Data with PivotTables,...

    Pluralsight

    Save

    On Demand

    Visualizing Data with PivotCharts

    A picture is worth a thousand words, and PivotCharts are no exception, providing a neat way of visualizing the data from a corresponding PivotTable. In this course, Visualizing...

    Pluralsight

    Save

    On Demand

    Formatting Excel Objects

    Microsoft Excel is one of the most commonly-used tools in business today. Whether running calculations, creating reports, or keeping things organized, skills in this area will be...

    Pluralsight

    Save

    On Demand

    Distributing Excel Workbooks

    By default, Excel Workbooks are not ideal for sharing. In this course, Distributing Excel Workbooks, you will learn how to create and share clean and secure workbooks. First, you...

    Pluralsight

    Save

    Pluralsight

    From Pluralsight
    Hours 15
    Instructors Pratheerth Padman, Ben Howard, Carlos Gutierrez, Amber Israelsen, Eugene Meidinger
    Language English
    Subjects IT & Networking

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Microsoft instructor $62k

    Excel Reporting Developer $68k

    Excel/Access DTS Developers $78k

    Microsoft CSR $81k

    Excel VBA Developer $82k

    Excel/Access DTS Developer $83k

    Tutor - Accounting/ Excel /ESL $87k

    Microsoft Access Programmer $96k

    SDE in Microsoft $106k

    SDE @ Microsoft 5 $110k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Similar Courses

    Sorted by relevance