🧵 10 Basic Excel Formulas Everyone Needs to Know 👇

🔵 SUM =SUM(A1:A10) — Adds values.
🔵 AVERAGE =AVERAGE(A1:A10) — Finds average.
🔵 COUNT =COUNT(A1:A10) — Counts numbers.
🔵 COUNTA =COUNTA(A1:A10) — Counts non-empty cells.
🔵 IF =IF(A1>10, "Yes", "No") — Conditional result.
🔵 MIN =MIN(A1:A10) — Smallest value.
🔵 MAX =MAX(A1:A10) — Largest value.
🔵 VLOOKUP =VLOOKUP(B1, A1:D10, 2, FALSE) — Looks up value.
🔵 & =A1 & " " & B1 — Joins text.
🔵 LEN =LEN(A1) — Counts characters.

#ExcelTips

If you want to be an Advanced Excel User, do this...

1. Autofit All Columns Alt + H + O + I
2. Flash Fill - CTRL+E
3. Pivot Table - Alt + N + V
4. Conditional Formatting - Alt + H + L
5. Auto Spell - F7

#Excel

5 Must-Have Excel Skills for Professionals

1. Pivot Table
2. Xlookup
3. Pivot Charts
4. Flash Fill
5. Quick Analysis

#Excel

✅ Learn New Skills FREE 🔰

1. Web Development ➝
◀️ https://t.iss.one/webdevcoursefree

2. CSS ➝
◀️ https://css-tricks.com

3. JavaScript ➝
◀️ https://t.iss.one/javascript_courses

4. React ➝
◀️ https://react-tutorial.app

5. Data Engineering ➝
◀️ https://t.iss.one/sql_engineer

6. Data Science  ➝
◀️ https://t.iss.one/datasciencefun

7. Python ➝
◀️ https://pythontutorial.net

8. SQL ➝
◀️  https://t.iss.one/sqlanalyst

9. Git and GitHub ➝
◀️ https://GitFluence.com

10. Blockchain ➝
◀️ https://t.iss.one/Bitcoin_Crypto_Web

11. Mongo DB ➝
◀️ https://mongodb.com

12. Node JS ➝
◀️ https://nodejsera.com

13. English Speaking ➝
◀️ https://t.iss.one/englishlearnerspro

14. C#➝
◀️ https://learn.microsoft.com/en-us/training/paths/get-started-c-sharp-part-1/

15. Excel➝
◀️ https://t.iss.one/excel_analyst

16. Generative AI➝
◀️ https://t.iss.one/generativeai_gpt

17. Java
◀️ https://t.iss.one/Java_Programming_Notes

18. Artificial Intelligence
◀️ https://t.iss.one/machinelearning_deeplearning

19. Data Structure & Algorithms
◀️ https://t.iss.one/dsabooks

20. Backend Development
◀️ https://imp.i115008.net/rn2nyy

21. Python for AI
◀️ https://deeplearning.ai/short-courses/ai-python-for-beginners/

Join @free4unow_backup for more free courses

Like for more ❤️

ENJOY LEARNING👍👍

Mastering Excel can feel like a superpower for any aspiring data analyst.

This versatile tool lets you organize, analyze, and visualize data with ease—giving you a strong foundation in data analysis.

Explore this Excel Cheatsheet to help you get started.

Like if it helps ❤️

Many people pay too much to learn Excel, but my mission is to break down barriers. I have shared complete learning series to learn Excel from scratch.

Here are the links to the Excel series

Complete Excel Topics for Data Analyst: https://t.iss.one/sqlspecialist/547

Part-1: https://t.iss.one/sqlspecialist/617

Part-2: https://t.iss.one/sqlspecialist/620

Part-3: https://t.iss.one/sqlspecialist/623

Part-4: https://t.iss.one/sqlspecialist/624

Part-5: https://t.iss.one/sqlspecialist/628

Part-6: https://t.iss.one/sqlspecialist/633

Part-7: https://t.iss.one/sqlspecialist/634

Part-8: https://t.iss.one/sqlspecialist/635

Part-9: https://t.iss.one/sqlspecialist/640

Part-10: https://t.iss.one/sqlspecialist/641

Part-11: https://t.iss.one/sqlspecialist/644

Part-12:
https://t.iss.one/sqlspecialist/646

Part-13: https://t.iss.one/sqlspecialist/650

Part-14: https://t.iss.one/sqlspecialist/651

Part-15: https://t.iss.one/sqlspecialist/654

Part-16: https://t.iss.one/sqlspecialist/655

Part-17: https://t.iss.one/sqlspecialist/658

Part-18: https://t.iss.one/sqlspecialist/660

Part-19: https://t.iss.one/sqlspecialist/661

Part-20: https://t.iss.one/sqlspecialist/662

Bonus: https://t.iss.one/sqlspecialist/663

I saw a lot of big influencers copy pasting my content after removing the credits. It's absolutely fine for me as more people are getting free education because of my content.

But I will really appreciate if you share credits for the time and efforts I put in to create such valuable content. I hope you can understand.

You can join this telegram channel for more Excel Resources: https://t.iss.one/excel_analyst

Python Learning Series: https://t.iss.one/sqlspecialist/615

Complete SQL Topics for Data Analysts: https://t.iss.one/sqlspecialist/523

Complete Power BI Topics for Data Analysts: https://t.iss.one/sqlspecialist/588

I'll now start with learning series on SQL Interviews & Tableau.

Thanks to all who support our channel and share the content with proper credits. You guys are really amazing.

Hope it helps :)

Roadmap to learn EXCEL

Step 1 - Master Basic Formulas
Step 2 - Data Visualization
Step 3 - Pivot Tables and Analysis
Step 4 - Advanced Functions
Step 5 - Automation with Macros
Step 6 - Power Query and Power Pivot
Step 7 - Collaboration and Sharing
Step 8 - Excel Tips and Tricks

.....read more

#excel

🚀 10 Must-Know Excel Shortcuts to Save Hours!

1. CTRL + A – Select all data
2. CTRL + C & CTRL + V – Copy & paste
3. CTRL + Z & CTRL + Y – Undo & redo
4. CTRL + Arrow Keys – Jump to data edges
5. ALT + E + S + V – Paste Special
6. CTRL + SHIFT + L – Toggle filters
7. CTRL + T – Create table
8. F2 – Edit cell
9. CTRL + ; – Insert today’s date
10. ALT + = – Auto-sum selected cells

#excel

Hi guys,

Many people charge too much to teach Excel, Power BI, SQL, Python & Tableau but my mission is to break down barriers. I have shared complete learning series to start your data analytics journey from scratch.

For those of you who are new to this channel, here are some quick links to navigate this channel easily.

Data Analyst Learning Plan 👇
https://t.iss.one/sqlspecialist/752

Python Learning Plan 👇
https://t.iss.one/sqlspecialist/749

Power BI Learning Plan 👇
https://t.iss.one/sqlspecialist/745

SQL Learning Plan 👇
https://t.iss.one/sqlspecialist/738

SQL Learning Series 👇
https://t.iss.one/sqlspecialist/567

Excel Learning Series 👇
https://t.iss.one/sqlspecialist/664

Power BI Learning Series 👇
https://t.iss.one/sqlspecialist/768

Python Learning Series 👇
https://t.iss.one/sqlspecialist/615

Tableau Essential Topics 👇
https://t.iss.one/sqlspecialist/667

Best Data Analytics Resources 👇
https://heylink.me/DataAnalytics

You can find more resources on Medium & Linkedin

Like for more ❤️

Thanks to all who support our channel and share it with friends & loved ones. You guys are really amazing.

Hope it helps :)

Here are some Excel shortcuts that are commonly used by data analysts:

1. Ctrl + C: Copy
2. Ctrl + V: Paste
3. Ctrl + X: Cut
4. Ctrl + Z: Undo
5. Ctrl + Y: Redo
6. Ctrl + S: Save
7. Ctrl + F: Find
8. Ctrl + H: Replace
9. Ctrl + Arrow Keys: Navigate to the edge of data
10. Ctrl + Shift + Arrow Keys: Select data range
11. Ctrl + Home: Go to cell A1
12. Ctrl + End: Go to last cell with data
13. Ctrl + Shift + L: Toggle filters
14. Alt + ; : Select visible cells only
15. F2: Edit active cell
16. Ctrl + Shift + Enter: Enter an array formula
17. Ctrl + D: Fill down
18. Ctrl + R: Fill right
19. Ctrl + 1: Format cells dialog box
20. Ctrl + Shift + 1, 2, 3, etc.: Apply different number formats

These shortcuts can significantly increase your efficiency when working with Excel as a data analyst.

One of the very important tool that a data analyst must be aware of is Excel

Me: = 4/5

Excel: = ok yeah I got you 4/5/2024

Me: No I mean like make it a percent with 2 decimal places

Excel: yeah ok like 8000%

Me: No I mean like 80%

Excel: Oh like $80

Me: I'll just do it myself

5 Most Used Excel Functions by Data Analysts

🧵⬇️

1️⃣ VLOOKUP / XLOOKUP:

VLOOKUP is used to look up values in a table or range by row, making it useful for merging datasets or retrieving specific data.

XLOOKUP (newer and more versatile) allows searching both horizontally and vertically and supports approximate matches.

Like for more ✅

2️⃣ INDEX-MATCH:

The INDEX-MATCH combination is often preferred over VLOOKUP for more flexibility. INDEX retrieves a value from a specified cell range, while MATCH identifies its position. Together, they allow more complex lookups, especially when the lookup column isn’t the leftmost column.

Most Used Excel Functions

3️⃣ SUMIF / SUMIFS:

SUMIF and SUMIFS allow summing values based on single or multiple conditions, making it easy to analyze specific segments of data, such as summing revenue by region or time period.

Most Used Excel Functions

4️⃣ COUNTIF / COUNTIFS:

COUNTIF and COUNTIFS are similar to SUMIF but are used for counting cells that meet specific criteria. These functions are helpful for calculating frequencies, such as counting occurrences of a certain value in a dataset.

Most Used Excel Functions