#Microsoft excel data analysis tutorial how to
#Microsoft excel data analysis tutorial software

How many products are sold above the average price? Our data has 13 products sold 14 times each. To view the highest number of products sold, apply the “ Filter by colour” option to display the items. Go to Home > Conditional Formatting > Top/Bottom Rules > Top 10 Items. Which products had more than 10 quantities Sold? We’ll copy and paste our data into another spreadsheet before the conditional formatting to retain the original data for future use. For example, you can highlight all odd numbers from the highest to the smallest. We’ll use Conditional Formatting (CF) for the EDA.Ĭonditional Formatting in Excel allows you to make trends in your data more visible by creating rules that determine how the cells will be formatted and highlighted. Examples of data analysis problems to solve in Excel Exploratory data analysis (EDA)Įxploratory data analysis involves an in-depth investigation of your data to identify anomalies like missing values, discover trends, or draw summaries from columns.Īfter performing an EDA, you can now use your data to create final reports and visualizations.

Go to Table Tools > Design > Table Name.

Use the keyboard shortcut CTRL + T for Windows.

Select any cell in the spreadsheet containing the data.

A table eliminates the need for you to remember which cells contain your data.

#Microsoft excel data analysis tutorial how to

How to approach a data analysis project in Excelīefore starting your data analysis, convert your raw Excel data into a table format. Final thoughts on using Excel for data analysis and visualisation.How to calculate descriptive statistics in Excel.How to create beginner level Excel dashboards.Sales analysis using pivot tables and charts.

Examples of data analysis problems to solve in Excel.

How to approach a data analysis project in Excel.

Here is the Google Spreadsheet link for the data we’ve used. Our tutorial focuses on simple techniques you can use to analyze and visualize data using Excel for Windows, version 2013. You can use it to create, edit, view, share, and manage workbooks, tables, spreadsheets, and dashboards containing your data.

#Microsoft excel data analysis tutorial software

Microsoft Excel is a spreadsheet software usable in Windows, macOS, iOS, and Android.