Path icon Learning Paths
Skills

Microsoft Excel Data Manipulation, Presentation, and Analysis

  • Number of Courses11 courses
  • Duration15 hours
  • Skill IQ available Skill IQ

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.

Courses in this path

Beginner

Load data into an Excel workbook, and learn how to search and manipulate data in Excel.

Loading Data into Excel 2016

  • by Pratheerth Padman
  • 48m Duration
  •  (226)

Searching and Manipulating Data in Excel 2016

  • by Pratheerth Padman
  • 1h 11m Duration
  •  (123)

Intermediate

Format worksheets and cells, and create calculated cells using Excel formulas.

Formatting Excel 2016 Worksheets and Cells

  • by Pratheerth Padman
  • 1h 27m Duration
  •  (164)

Calculating Cell Values with Formulas

  • by Pratheerth Padman
  • 1h 24m Duration
  •  (179)

Advanced

Summarize and visualize your data with tables and charts, and share your workbooks with others.

Summarizing and Organizing Data in Excel

  • by Ben Howard
  • 1h 3m Duration
  •  (145)

Displaying Tables with Excel

  • by Ben Howard
  • 1h 34m Duration
  •  (140)

Charting Data with Excel

  • by Carlos Gutierrez
  • 1h 39m Duration
  •  (77)

Exploring Data with PivotTables

  • by Ben Howard
  • 1h 40m Duration
  •  (126)

Visualizing Data with PivotCharts

  • by Ben Howard
  • 1h 18m Duration
  •  (84)

Formatting Excel Objects

  • by Amber Israelsen
  • 1h 15m Duration
  •  (68)

Distributing Excel Workbooks

  • by Eugene Meidinger
  • 1h 30m Duration
  •  (35)

Learn with the best

Pratheerth Padman
Pratheerth Padman
Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.
Ben Howard
Ben Howard
Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 14 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.
Carlos Gutierrez
Carlos Gutierrez
Carlos Gutierrez is a Software Engineer working in the highly competitive world of professional motorsports. His career is focused on data analysis and application development for technical collaboration and decision making. Carlos uses SQL Server, .NET Framework, WPF, UWP, Office 365, R and Azure to build end-to-end solutions for a fast paced, dynamic industry.
Amber Israelsen
Amber Israelsen
Amber has been a software developer and technical trainer since the early 2000s. In recent years, she has focused on teaching AI, machine learning, AWS and Power Apps, teaching students around the world. She also works to bridge the gap between developers, designers and businesspeople with her expertise in visual communication, user experience and business/professional skills. She holds certifications in machine learning, AWS, a variety of Microsoft technologies, and is a former Microsoft Cer... more
Eugene Meidinger
Eugene Meidinger
Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.

Join our learners and upskill
in leading technologies