Description
Course info
Level
Beginner
Updated
Jul 26, 2019
Duration
1h 12m
Description

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.

About the author
About the author

Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.

More from the author
Recording and Managing Excel Macros
Beginner
32m
Sep 23, 2019
Formatting Excel Worksheets and Cells
Intermediate
1h 28m
Sep 6, 2019
More courses by Pratheerth Padman
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Pratheerth Padman, and welcome to my course, Searching and Manipulating Data in Excel. Currently I'm a freelance data scientist. I used to work in manufacturing, but because of my love for all things data, I completely pivoted to data science. If you were 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 second in the Microsoft Excel series at Pluralsight, is targeted towards. Some of the major topics that we'll cover include working with data tools in Excel such as data validation and what-if analysis, navigating worksheets and workbooks, and entering and manipulating data in Excel. By the end of this course, you'll know how to manipulate, search for, and insert data into Microsoft Excel. There isn't a particular prerequisite before beginning the course, though some fundamental knowledge about data analytics and a basic understanding of Microsoft Excel's interface would be very helpful. I hope you'll join me on this journey to learn how to work with and search for data in Microsoft Excel with the Searching and Manipulating Data in Excel course at Pluralsight.