Data Analysis

Articles About Data Analysis and Statistics with Excel

Nowadays, 90% of job postings about Data Analysis require excellent spreadsheet skills. So this generally results that the primary tool of many data analyst is Microsoft Excel. In fact, it’s truly amazing how much science you can do with it!

Explore this category to learn a lot of tips, real-life examples, mathematical solutions, data visualization methods, dashboards and graphs in Excel!

How-to-prevent-data-inconsistency-in-excel

How to Prevent Data Inconsistency Problems in Excel Workbook?

Excel data inconsistencies can occur from cell to cell. It can seem exactly the same but not always. Check this guide to learn more!

Can-excel-use-python

Can Excel Use Python?

In this blog post, you will learn why you -as a Microsoft Excel user- should know Python and detailed comparisons of the two software.

How-to-calculate-z-score-in-excel

How to Calculate Z Score in Excel?

In this blog post you'll learn about how to calculate Z-Score in Excel with AVERAGE and STDEV. S or STDEV. P formulas with examples!

Can-excel-generate-random-numbers

Can Excel Generate Random Numbers?

Check this guide to learn more about RAND & RANDBETWEEN Formulas, running simulations in Excel and how to generate numbers in an easy way!

Can-excel-make-venn-diagram

Can Excel Make Venn Diagrams?

Create, customize your Venn diagram in Excel with a few clicks. Check this guide to learn about SmartArt, Shapes and more!

How-to-normalize-data-in-excel

How to Normalize Data in Excel?

In this blog post, you'll learn about how to normalize data in Excel with step-by-step instructions, charts and real-life examples!

How-to-calculate-standard-deviation-in-excel

How to Calculate Standard Deviation in Excel

The standard deviation shows how consistent are values in data set. Check this guide to learn how to calculate standard deviation in Excel.

Can-excel-analyze-data

Can Excel Analyze Data?

Excel is more than calculations or keeping records; learn how can excel analyze data and make analyzing data processes easier.

Can-excel-be-used-as-a-database-cover

Can Excel be Used as a Database?

Excel as your main database can come with some disadvantages as well as its advantages. In this blog post these are going to be detailed.

Go back to FAQ Center

Search