Searching and Manipulating Data in Excel
Microsoft Excel Data Manipulation, Presentation, and Analysis,
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.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 1.2 hours |
Starts | On Demand (Start anytime) |
Cost | $35/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Pratheerth Padman |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | IT & Networking |
Tags | Data Professional |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Microsoft instructor $62k
Excel Reporting Developer $68k
Excel/Access DTS Developers $78k
Microsoft CSR $81k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Microsoft Access Programmer $96k
SDE in Microsoft $106k
SDE @ Microsoft 5 $110k
Microsoft Active Directory/Microsoft Exchange Administrator. $114k
Microsoft Active Directory/Microsoft Exchange Administrator. $114k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 1.2 hours |
Starts | On Demand (Start anytime) |
Cost | $35/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Pratheerth Padman |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | IT & Networking |
Tags | Data Professional |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course