Thread by @sharyph_

Most data analysis can be done in Excel.

You don't need to be an expert to use this tool as Data Analyst.

Let me show you 5 Excel Data Analysis Techniques in 3 minutes. 👇

1. How to transform or clean up a raw set of data on Excel

This is the first thing you will do once you get a data set.
And this is the most time taken task.

Master Data Analysis on Excel in Just 10 Minutes

2. Sparklines

Sparklines can draw attention to important items such as seasonal changes.

Showing trends in your worksheet data can be useful, especially when you’re sharing your data with other people.

3. Goal Seek

You can Use the Goal Seek If you know the desired output of a formula but not its input value

Ex:
You can use Goal Seek to determine what interest rate you will need to secure in order to meet your loan goal.

How To Use Goal Seek Analysis

4. Using Pivot Table to Summarize Data.

Excel pivot tables help analyze data.
They can quickly summarize and analyze large datasets and display only the information you want.

5. Extract Data from PDFs.

It is a common task for us to extract data from a PDF file to our Excel spreadsheet.
If you want to do it manually, then it will be laborious and time-consuming work.

That's a wrap;

If you enjoyed this thread:

1. Follow me → @sharyph_

2. Like & Retweet the first tweet below 👇to share this with others

https://twitter.com/sharyph_/status/1650764881606455296

If you like this type of content,

You will love my newsletter, AiSuite.

Join for free and get my favorite +200 AI tools.

Categorized in:
→ Coding
→ Copywriting
→ Web Design
→ Productivity
→ Note taking
→ Image & Video
& more..

Join for FREE: aisuite.beehiiv.com/subscribe

Here is the Simplest Data Analyst Path for Anyone

You will get:
✅What to Learn Each Day
✅Exact Lessons to become a DA
✅Technologies you need to Learn
✅Most Frequent Interview Ques

+ Full Python Course

You can get it for $10 today- Normal Price $130
goldsuite.gumroad.com/l/glnjb/10only