Searching and Manipulating Data in Excel 2016 from Pluralsight

If you always find yourself encountering pre-filled Excel workbooks, the skill to search and manipulate data within them is crucial. With topics like data validation and what-if analysis, teaching you those skills is what this course aims to achieve.

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. It then becomes imperative that you understand how to search and manipulate data within these.

And helping you do that is exactly what this course - the 2nd in the Microsoft Excel series at Pluralsight - is targeted towards.

In the first two modules, we’ll mostly deal with how to work and manipulate an excel workbook/worksheet that already contains the required data. Here we’ll deal with things like data validation and conducting what-if analysis.

The second module deals with navigating an excel worksheet/workbook. Here we’ll learn methods that help us search the required data and navigate to it. We’ll also talk a bit about inserting and removing hyperlinks.

In the last module, we’ll be dealing with how to insert data into excel cells. This will include learning to paste data with special paste options, filling cells with autofill and inserting and deleting cells themselves.

When you're finished with this course, you'll have the skills and the practice required to search and manipulate spreadsheet data with Microsoft Excel.

What's inside

Syllabus

Course Overview

Working with Data in Excel

Navigating Worksheets and Workbooks

Entering and Manipulating Data in Cells

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches methods for working with existing Excel workbooks, which is valuable in many industries

Explores data validation and what-if analysis, which are essential skills for business analysis

Taught by Pratheerth Padman, an expert in Microsoft Excel

Develops skills for searching, navigating, and manipulating data in Excel spreadsheets

Suitable for both beginners and experienced spreadsheet users

Covers essential Excel functions, such as data entry, autofill, and cell insertion/deletion

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Searching and Manipulating Data in Excel 2016 with these activities:

Data Input and Manipulation in Excel

Show steps

Develop your skills in entering and modifying data within Excel cells, providing you with a solid foundation for data management.

Show steps

Enter data into cells using various methods.
Edit and modify cell values as needed.
Utilize formulas and functions to perform calculations on data.

Excel Workbook and Worksheet Navigation

Show steps

Enhance your proficiency in navigating Excel workbooks and worksheets, ensuring you can efficiently locate and access data.

Show steps

Utilize keyboard shortcuts and commands to navigate the workbook.
Employ the Find and Replace feature to locate specific data.
Manage multiple worksheets within a single workbook.

Excel Data Validation Exercises

Show steps

Build experience using Microsoft Excel functions to apply data validation rules to cells, helping you master this key aspect of data manipulation.

Browse courses on Data Validation

Show steps

Identify the cells requiring data validation.
Choose and apply appropriate data validation rules.
Test the effectiveness of your data validation rules.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Excel Collaboration and Discussion

Show steps

Engage with fellow learners to discuss Excel concepts, exchange ideas, and troubleshoot challenges, fostering a collaborative learning environment.

Browse courses on Collaboration

Show steps

Join or create a study group.
Contribute to discussions and ask questions.
Review and provide feedback on others' work.

Inserting and Deleting Cells in Excel

Show steps

Master the techniques of inserting and deleting cells in Excel, empowering you to organize and manage your data effectively.

Browse courses on Microsoft Excel

Show steps

Insert new cells in specific locations.
Delete unwanted cells to streamline your data.
Adjust row and column dimensions to accommodate cell changes.

Excel Project: Data Analysis Report

Show steps

Apply your newfound skills to a practical project, where you'll analyze data using Excel functions and present your findings in a comprehensive report.

Browse courses on Data Analysis

Show steps

Define the problem and gather relevant data.
Clean and organize the data.
Analyze the data using formulas and functions.
Create charts and graphs to visualize the results.
Write a report summarizing your findings.

Excel Workshop: Advanced Features

Show steps

Enhance your Excel proficiency by attending a workshop focused on advanced features, enabling you to unlock the full potential of this powerful tool.

Browse courses on Advanced Features

Show steps

Register for the workshop.
Attend the workshop and participate actively.
Practice the techniques learned.

Career center

Learners who complete Searching and Manipulating Data in Excel 2016 will develop knowledge and skills that may be useful to these careers:

Business Analyst

A Business Analyst, who often has experience in consulting, researches business problems and needs, and then provides solutions usually in the form of technology changes. The Excel skills required to find and manipulate data are a cornerstone of a business analyst's skillset, since understanding data is essential to building solutions for businesses. Indeed, this course on Searching and Manipulating Data in Excel 2016 may help one become a Business Analyst by providing the foundational skills one needs to qualify for entry-level roles.

See salaries and explore the career path for Business Analyst

Data Analyst

A Data Analyst extracts meaning from data, by cleaning it, and then presenting it in useful ways, often via dashboards and visualizations. Data Analysts are also often tasked with managing databases. The skills taught in this course may help a prospective Data Analyst by giving them experience with the data cleaning and processing needed for the role.

See salaries and explore the career path for Data Analyst

Financial Analyst

A Financial Analyst analyzes financial data to assess risks and make recommendations to companies. The Excel skills taught in this course are essential for performing these tasks. Furthermore, this course teaches data validation, a skill used to ensure that data used in analysis is accurate.

See salaries and explore the career path for Financial Analyst

Management Consultant

A Management Consultant provides advice to businesses on how to improve their performance. This involves analyzing data, identifying problems, and developing solutions. The Excel skills taught in this course are essential for performing these tasks.

See salaries and explore the career path for Management Consultant

Operations Analyst

An Operations Analyst is tasked with finding ways to improve the efficiency of a business's operations. They may collect and analyze data, and then make recommendations to management. The Excel skills taught in this course may help an aspiring Operations Analyst by equipping them with skills they can use to analyze and present data used by management to make decisions.

See salaries and explore the career path for Operations Analyst

Project Manager

A Project Manager plans and executes projects, and ensures that they are completed on time and within budget. This often involves managing budgets and resources. The Excel skills taught in this course may be helpful to aspiring Project Managers by equipping them with skills they can use to manage project budgets.

See salaries and explore the career path for Project Manager

Quality Assurance Analyst

A Quality Assurance Analyst tests software and other products to ensure that they meet quality standards. This often involves analyzing data and identifying defects. The Excel skills taught in this course may be helpful to aspiring Quality Assurance Analysts by equipping them with skills they can use to analyze and present data used in defect tracking and reporting.

See salaries and explore the career path for Quality Assurance Analyst

Risk Analyst

A Risk Analyst identifies and assesses risks for a company. This may involve analyzing data and developing risk mitigation plans. The Excel skills taught in this course may be helpful to aspiring Risk Analysts by equipping them with skills they can use to analyze and present risk data.

See salaries and explore the career path for Risk Analyst

Sales Analyst

A Sales Analyst analyzes sales data to identify trends and develop sales strategies. This often involves analyzing data and developing reports. The Excel skills taught in this course may be helpful to aspiring Sales Analysts by equipping them with skills they can use to analyze and present sales data.

See salaries and explore the career path for Sales Analyst

Statistician

A Statistician collects, analyzes, interprets, and presents data. This often involves using statistical software and developing statistical models. The Excel skills taught in this course may be helpful to aspiring Statisticians by equipping them with skills they can use to clean and prepare data for statistical analysis.

See salaries and explore the career path for Statistician

Systems Analyst

A Systems Analyst analyzes and designs business systems. This may involve collecting and analyzing data, and developing system specifications. The Excel skills taught in this course may be helpful to aspiring Systems Analysts by equipping them with skills they can use to analyze and present data used in system design.

See salaries and explore the career path for Systems Analyst

Web Analyst

A Web Analyst analyzes website traffic and user behavior to identify trends and develop website improvement strategies. This often involves analyzing data and developing reports. The Excel skills taught in this course may be helpful to aspiring Web Analysts by equipping them with skills they can use to analyze and present website data.

See salaries and explore the career path for Web Analyst

Compliance Analyst

A Compliance Analyst ensures that a company complies with laws and regulations. This may involve analyzing data and developing compliance reports. The Excel skills taught in this course may be helpful to aspiring Compliance Analysts by equipping them with skills they can use to analyze and present compliance data.

See salaries and explore the career path for Compliance Analyst

Data Engineer

A Data Engineer designs and builds data pipelines and data warehouses. This may involve collecting and cleaning data, and developing data models. While completing this course may not be sufficient preparation for working as a Data Engineer, it may be helpful by providing students with foundational Excel skills.

See salaries and explore the career path for Data Engineer

Data Scientist

A Data Scientist uses data to solve business problems. This may involve collecting, analyzing, and interpreting data, and developing machine learning models. While completing this course may not be sufficient preparation for working as a Data Scientist, it may be helpful by providing students with foundational Excel skills.

See salaries and explore the career path for Data Scientist