{"id":11764,"date":"2022-01-03T15:40:55","date_gmt":"2022-01-03T14:40:55","guid":{"rendered":"https:\/\/careerfoundry.inbearbeitung.de\/en\/?p=11764"},"modified":"2023-05-16T14:50:44","modified_gmt":"2023-05-16T12:50:44","slug":"data-analysis-in-excel","status":"publish","type":"post","link":"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/data-analysis-in-excel\/","title":{"rendered":"10 Essential Excel Features For Data Analysts (and How to Use Them)"},"content":{"rendered":"

Spreadsheets are still in style! <\/strong>The use of electronic spreadsheets date back to 1979 and are still one of the most popular ways to review and manipulate data. <\/span><\/p>\n

Today, Microsoft\u2019s ubiquitous spreadsheet program Excel has over 750 million users and is used in some of the largest companies worldwide. I personally use Excel almost every day because it can sometimes lead to quicker results than spinning up Python or loading the data into a database.\u00a0<\/span><\/p>\n

One of the reasons Excel is so popular is because it is jam-packed with features and functions that can be used to <\/span>clean<\/span><\/a>, aggregate, pivot, and graph data. In this article, we\u2019ll go over the 10 features and functions for using data analysis in Excel I think every analyst needs to know:<\/span><\/p>\n

    \n
  1. Pivot tables and pivot charts<\/span><\/a><\/li>\n
  2. Conditional formatting<\/span><\/a><\/li>\n
  3. Remove duplicates<\/span><\/a><\/li>\n
  4. XLOOKUP<\/span><\/a><\/li>\n
  5. IFERROR<\/span><\/a><\/li>\n
  6. MATCH<\/span><\/a><\/li>\n
  7. COUNTBLANK<\/span><\/a><\/li>\n
  8. DAYS and NETWORKDAYS<\/span><\/a><\/li>\n
  9. RANK<\/span><\/a><\/li>\n
  10. SUMPRODUCT<\/span><\/a><\/li>\n<\/ol>\n

    You can click any of the features to skip ahead to them.<\/span><\/p>\n

    Before we get started\u2026<\/span><\/h3>\n

    In order to show the power of data analysis in Excel, we need some data to play around with and graph.<\/span> I am using the Customer Personality Analysis dataset from Kaggle in these examples.<\/span><\/a> You can download it to follow along.<\/span><\/p>\n

    \"Customer<\/p>\n

    … and, if you want to watch along…<\/span><\/h3>\n

    Here’s our very own senior data scientist, Tom, explaining these functions in a video:<\/p>\n