In this course, Visualizing Data with PivotCharts, you will gain the skills to quickly produce charts to a professional standard, which neatly summarize the associated PivotTable, allowing you to visualize the data and spot any trends within it. 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.Ī picture is worth a thousand words, and PivotCharts are no exception, providing a neat way of visualizing the data from a corresponding PivotTable. This will include learning to paste data with special paste options, filling cells with autofill and inserting and deleting cells themselves. In the last module, we’ll be dealing with how to insert data into excel cells. We’ll also talk a bit about inserting and removing hyperlinks. Here we’ll learn methods that help us search the required data and navigate to it. The second module deals with navigating an excel worksheet/workbook. Here we’ll deal with things like data validation and conducting what-if analysis. 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.

It then becomes imperative that you understand how to search and manipulate data within these.Īnd helping you do that is exactly what this course - the 2nd in the Microsoft Excel series at Pluralsight - is targeted towards. 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.

Data analysis excel