We may earn an affiliate commission when you visit our partners.
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
  • This collection is no longer available.

    Share

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

    What's inside

    Three courses

    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.

    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.

    Distributing Excel Workbooks

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

    Save this collection

    Save Microsoft Excel Data Manipulation, Presentation, and Analysis to your list so you can find it easily later:
    Save
    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.

    © 2016 - 2025 OpenCourser