Jan 16, 2019

Microsoft Excel Data Analysis Tutorial

Excel is a robust, highly adaptive program for organizing and analyzing your data. It's such a commonly used spreadsheet program that knowing the basics of Excel data analysis is helpful in nearly all career fields as well as your personal life for budgeting, accounting, and planning. Excel analytics training is highly useful and accessible. Review the data analysis basics you can teach yourself to use with Excel.

Excel Data Analysis Training Basics

  • Sort and Filter: Arrange data across columns and filter it to make calculations.
  • Charts and Tables: Create visuals of your data by converting it to pie charts, treemaps, pivot tables, and over a dozen more configurations.
  • What-If Analysis: Make projections and predictions by trying out different scenarios with your data.
  • Solver: Use this Excel add-in to perform problem-solving functions that help you make important decisions based on your data.

Using the Excel Analysis Toolpak

Adding Microsoft's Analysis ToolPak to your Excel program lets you develop complex statistical or engineering analyses. It converts the data you input and the parameters you set into output tables by applying engineering or statistical macro functions that perform complex calculations. The Toolpak includes 15 options for data analysis, such as calculating coefficients between two measurement variables, predicting values using exponential smoothing, and determining the equality of means by applying a two-sample t-Test. You can also create output graphs like histograms or rank and percentile tables.

Access these tools through the Data tab of your Excel program, then click Data Analysis in the Analysis group. If you don't see the Data Analysis command, download the free Analysis TookPak.

Learn Excel Data Analysis through Udacity's Business Analytics Nanodegree Program

The Business Analytics Nanodegree program from Udacity is for anyone in nearly any field looking to gain or improve data skills. In this program, you learn how to use Excel, SQL, and Tableau to analyze data after collecting and organizing it. As part of the three-month program, you learn how to use Excel data analysis to complete a data analysis group project. This is where you get a chance to conduct a survey in the real world. Then, you clean up the data, adjust it, analyze it through statistics and visualizations, and present your findings.

The Excel Fundamentals course is another component of the Business Analytics Nanodegree program, and it's specifically devoted to helping you learn how to use Microsoft Excel for data analysis. It covers the basics of Excel and the ways to use formulas and functions in Excel, including pivot tables, vlookups, and visualization creation.