Solver also adjusts the decision variable cells’ values to work on the limits on constraint cells. This thereby helps in producing the desired result for the objective cell. What-If Analysis is the process of changing the values to try out different values (scenarios) for formulas.

You can add notes and highlights, plus learn on the go with the Pearson+ mobile app. Listen on the go with the audiobook feature, available for most titles. Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.


From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs. This 3-hour course is intended for Microsoft Excel users who already have some experience of basic PivotTables. Excel has always been the workhorse of the Redmond company, more than Windows itself. The usefulness of spreadsheets is indisputable, and Microsoft has brought functionality and usability to the highest levels. This course presents information and skills that are appropriate for users of either the Office 2021 or Office 365 applications.

Microsoft Excel 2019. Data Analysis Lessons

Now through May 31, save up to 70% on learning resources for developers. You can sort your Excel data by multiple columns or even a single column. A simple Excel graphic may convey more information than a page of statistics. Conditional formatting in Excel allows you to highlight cells with a certain color based on the value of the cell.

TITLE: Learning Excel: Data Analysis

Harness the power of advanced PivotTable features and create PivotCharts to gain a competitive edge. Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel. The tutorial has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner. This Data Analytics Bootcamp course teaches you the basic concepts of data analysis and statistics to help data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data to present your findings using executive-level dashboards.

The course also does not require you to perform any software downloads or installations. All that is required is a device with a modern web browser, and the ability to use (or create) a Microsoft account to access Excel online at no-cost. Although the hands-on labs steps are specifically related to using ‘Excel for the web’, if you already have the full desktop version of Excel, you should be able to use that to follow along quite easily with the labs. This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.

Interested in this course for your business or team?

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and a competitive advantage. Channels is a specialized platform full of video explanations, solutions, and practice problems created to help you prep for exams. Channels are built with your course in mind, so you can learn what’s being covered in your class.

Microsoft Excel 2019. Data Analysis Lessons

Upon successful completion of this course, you will be able to create and develop Excel® worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot. Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources. When sorting data in a spreadsheet, you may rearrange the data to rapidly discover values.

Leave a Comment