Excel Data Analysis - Microsoft Excel Step-By-Step

Our discussion in this app will include, but not be limited to:

*Best Way to Analyze Data in Excel

*How to Analyze Sales Data in Excel

*Analyzing Data Sets with Excel

*Data Segregation with Excel

*The Importance of Data Reporting

*How to Analyze Data in Excel: Simple Tips and Techniques

Introduction to Data Analysis Using Excel

Excel provide commands, functions and tools that make your data analysis tasks easy. You can avoid many time consuming and/or complex calculations using Excel. In this tutorial, you will get a head start on how you can perform data analysis with Excel. You will understand with relevant examples, step by step usage of Excel commands and screen shots at every step.

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills.

Microsoft Excel is one of the most widely used tools in any industry. While some enjoy playing with pivotal tables and histograms, others limit themselves to simple pie-charts and conditional formatting. Some may create an artwork out of the dull monochrome Excel, while others may be satisfied with its data analysis. In this discussion, we will make a deep delving analysis of Microsoft Excel and its utility. We will focus on how to analyze data in Excel, the various tricks, and techniques for it. The discussion will also explore the various ways to analyze data in Excel.

We will discuss the different features of Excel (much of which are unexplored to the mass), functions, and best practices.

Introduction to Data Analysis using Excel

What You Will Learn

Create flexible data aggregations using pivot tables

Represent data visually using pivot charts

Calculate margins and other common ratios using calculation on pivot table

Filter data using slicers in multiple pivot tables

Create aggregate reports using formula based techniques

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. In this app, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.

You should have a basic understanding of creating formulas and how cells are referenced by rows and columns within Excel to take this app. If required, you can can find many help topics on Excel at the Microsoft Office Support Site. You are welcome to use any supported version of Excel you have installed in your computer, however, the instructions are based on Excel 2016. You may not be able to complete all exercises as demonstrated in the lectures but workarounds are provided in the lab instructions or Discussion forum. Please note that Excel for Mac does not support many of the features demonstrated in this app.

After taking & download this app you’ll be ready to continue to our more advanced Excel app, Analyzing and Visualizing Data with Excel.