Searching and Manipulating Data in Excel 2016

Mastering Data Manipulation in Microsoft Excel

Are you a business analyst or a frequent spreadsheet user? Often, you'll be working with existing Excel spreadsheets filled with data, rather than starting from scratch. This course, the second in the Microsoft Excel series at Pluralsight, equips you with the essential skills to effectively search and manipulate data within these workbooks.

This course focuses on practical techniques for working with pre-populated Excel workbooks and worksheets. You'll gain proficiency in:

• Data Validation: Ensure data accuracy and integrity.
• What-If Analysis: Explore different scenarios and their potential outcomes.
• Excel Navigation: Efficiently locate specific data within large spreadsheets.
• Hyperlink Management: Learn to insert and remove hyperlinks for easy access to related information.
• Data Insertion: Master techniques for inserting data into Excel cells, including:
  • Special Paste Options: Paste data with customized settings.
  • Autofill: Quickly populate cells with sequential or patterned data.
  • Cell Insertion & Deletion: Easily add or remove cells to adjust your spreadsheet layout.

By the end of this course, you'll have the hands-on skills and practical knowledge needed to confidently search, manipulate, and analyze data using Microsoft Excel. Enhance your data analysis capabilities and become more efficient with your spreadsheet skills.