MS Excel for Data Analysis
65.2K subscribers
310 photos
1 video
3 files
358 links
Learn Basic & Advaced Ms Excel concepts for data analysis

Learn Tips & Tricks Used in Excel

Become An Expert

Use The Skills Learnt Here In Your Career

For promotions: @love_data
Download Telegram
🧑‍💼 Interviewer: What's the difference between VLOOKUP and HLOOKUP in Excel?

👨‍💻 Me: VLOOKUP searches vertically down columns (great for column-based data like employee lists), while HLOOKUP searches horizontally across rows (ideal for row-based setups like category headers).

Key Differences:
VLOOKUP: Looks for a value in the first column of a range, returns from the same row in a specified column—syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Use for vertical data; e.g., find salary by ID in a table.
HLOOKUP: Looks for a value in the first row of a range, returns from the same column in a specified row—syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]). Use for horizontal data; e.g., pull metrics by month across a header row.

📌 Example:
Vertical sales table (IDs in col A, amounts in B): VLOOKUP(ID, A:B, 2, FALSE) gets amount.
Horizontal (months in row 1, sales in row 2): HLOOKUP("Jan", 1:3, 2, FALSE) gets Jan sales.

💡 VLOOKUP's more common (90% of lookups), but both support exact (FALSE) or approx (TRUE) matches—switch to XLOOKUP in modern Excel for bidirectional flexibility!

💬 Tap ❤️ for more!
8🥰1
Excel Checklist for Data Analysts 📀🧠

1️⃣ Excel Basics 
Formulas & Functions (SUM, IF, VLOOKUP, INDEX-MATCH) 
Cell references: Relative, Absolute & Mixed 
Data types & formatting

2️⃣ Data Manipulation 
Sorting & Filtering data 
Remove duplicates & data validation 
Conditional formatting for insights

3️⃣ Pivot Tables & Charts 
Create & customize Pivot Tables for summaries 
Use slicers & filters in Pivot Tables 
Build charts: Bar, Line, Pie, Histograms

4️⃣ Advanced Formulas 
Nested IF, COUNTIF, SUMIF, AND/OR logic 
Text functions: LEFT, RIGHT, MID, CONCATENATE 
Date & Time functions

5️⃣ Data Cleaning 
Handling blanks/missing values 
TRIM, CLEAN functions to fix data 
Find & replace, Flash fill

6️⃣ Automation 
Macros & VBA basics (record & edit) 
Use formula-driven automation 
Dynamic named ranges for flexibility

7️⃣ Collaboration & Sharing 
Protect sheets & workbooks 
Track changes & comments 
Export data for reporting

8️⃣ Data Analysis Tools 
What-if analysis, Goal Seek, Solver 
Data Tables and Scenario Manager 
Power Query basics (optional)

9️⃣ Dashboard Basics 
Combine Pivot Tables & Charts 
Use form controls & slicers 
Design interactive, user-friendly dashboards

🔟 Practice & Projects 
Analyze sample datasets (sales, finance) 
Automate monthly reporting tasks 
Build a portfolio with Excel files & dashboards

💡 Tips:
⦁ Practice with real datasets to apply functions & Pivot Tables
⦁ Learn shortcuts to boost speed
⦁ Combine Excel skills with Python & SQL for powerful analysis

Excel Learning Resources: 
https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

Double Tap ♥️ For More
24🥰2👏2
The program for the 10th AI Journey 2025 international conference has been unveiled: scientists, visionaries, and global AI practitioners will come together on one stage. Here, you will hear the voices of those who don't just believe in the future—they are creating it!

Speakers include visionaries Kai-Fu Lee and Chen Qufan, as well as dozens of global AI gurus from around the world!

On the first day of the conference, November 19, we will talk about how AI is already being used in various areas of life, helping to unlock human potential for the future and changing creative industries, and what impact it has on humans and on a sustainable future.

On November 20, we will focus on the role of AI in business and economic development and present technologies that will help businesses and developers be more effective by unlocking human potential.

On November 21, we will talk about how engineers and scientists are making scientific and technological breakthroughs and creating the future today!

Ride the wave with AI into the future!

Tune in to the AI Journey webcast on November 19-21.
4👍1👏1
Complete Roadmap to Learn Excel 📊

Phase 1: Basics (1 Week)
🔹 Understand Excel interface & workbook basics
🔹 Learn cell references (relative, absolute)
🔹 Basic formulas: SUM, AVERAGE, COUNT, MIN, MAX
🔹 Formatting cells: fonts, colors, borders

Phase 2: Data Handling (1-2 Weeks)
🔹 Sorting & filtering data
🔹 Using Tables for dynamic ranges
🔹 Conditional formatting to highlight data
🔹 Data validation (drop-down lists, restrictions)

Phase 3: Formulas & Functions (2-3 Weeks)
🔹 Logical functions: IF, AND, OR, NOT
🔹 Lookup functions: VLOOKUP, HLOOKUP, INDEX & MATCH
🔹 Text functions: CONCATENATE, LEFT, RIGHT, MID, LEN
🔹 Date & time functions

Phase 4: Data Analysis Tools (2 Weeks)
🔹 Pivot Tables & Pivot Charts
🔹 What-If Analysis: Goal Seek, Data Tables
🔹 Charts: bar, line, pie, combo charts
🔹 Introduction to Power Query for data transformation

Phase 5: Advanced Excel (Ongoing)
🔹 Advanced formulas: ARRAY formulas, INDIRECT, OFFSET
🔹 Macros & VBA basics for automation
🔹 Power Pivot & DAX basics
🔹 Dashboard creation & dynamic reporting

💡 Practice with real datasets for best results!

Tap ❤️ for the detailed explanation!
56
Tune in to the 10th AI Journey 2025 international conference: scientists, visionaries, and global AI practitioners will come together on one stage. Here, you will hear the voices of those who don't just believe in the future—they are creating it!

Speakers include visionaries Kai-Fu Lee and Chen Qufan, as well as dozens of global AI gurus! Do you agree with their predictions about AI?

On November 20, we will focus on the role of AI in business and economic development and present technologies that will help businesses and developers be more effective by unlocking human potential.

On November 21, we will talk about how engineers and scientists are making scientific and technological breakthroughs and creating the future today! The day's program includes presentations by scientists from around the world:
- Ajit Abraham (Sai University, India) will present on “Generative AI in Healthcare”
- Nebojša Bačanin Džakula (Singidunum University, Serbia) will talk about the latest advances in bio-inspired metaheuristics
- AIexandre Ferreira Ramos (University of São Paulo, Brazil) will present his work on using thermodynamic models to study the regulatory logic of transcriptional control at the DNA level
- Anderson Rocha (University of Campinas, Brazil) will give a presentation entitled “AI in the New Era: From Basics to Trends, Opportunities, and Global Cooperation”.

And in the special AIJ Junior track, we will talk about how AI helps us learn, create and ride the wave with AI.

The day will conclude with an award ceremony for the winners of the AI Challenge for aspiring data scientists and the AIJ Contest for experienced AI specialists. The results of an open selection of AIJ Science research papers will be announced.

Ride the wave with AI into the future!

Tune in to the AI Journey webcast on November 19-21.
2👎1🔥1
Basic Shortcuts

Ctrl + A = Select All
Ctrl + C = Copy
Ctrl + X = Cut
Ctrl + V = Paste
Ctrl + Z = Undo
Ctrl + Y = Redo
Ctrl + S = Save
Ctrl + P = Print
Ctrl + O = Open File
Ctrl + N = New File
Ctrl + W = Close Window
Ctrl + Q = Quit Application
9👍3🔥2
Excel Formulas every data analyst should know
13👍1
Excel Text Functions Cheatsheet 🧠📝

1️⃣ UPPER → =UPPER(A1)
🔹 Converts text to uppercase

2️⃣ LOWER → =LOWER(A1)
🔹 Converts text to lowercase

3️⃣ PROPER → =PROPER(A1)
🔹 Capitalizes the first letter of each word

4️⃣ CONCAT / TEXTJOIN → =CONCAT(A1, B1) or =TEXTJOIN(" ", TRUE, A1:A3)
🔹 Joins text values

5️⃣ LEFT / RIGHT → =LEFT(A1, 5) / =RIGHT(A1, 3)
🔹 Extracts specific number of characters from the start or end

6️⃣ MID → =MID(A1, 3, 4)
🔹 Extracts text starting at a position

7️⃣ LEN → =LEN(A1)
🔹 Counts characters in a cell

8️⃣ FIND / SEARCH → =FIND("a", A1) / =SEARCH("a", A1)
🔹 Finds the position of a character

💬 Double tap ❤️ for more!
9👍2
Quick Excel Cheatsheet! 📊

Basic Formulas
1. Add: =A1+B1
2. Subtract: =A1-B1
3. Multiply: =A1*B1
4. Divide: =A1/B1
5. Average: =AVERAGE(A1:A10)
6. Sum: =SUM(A1:A10)

Logical Functions
1. IF: =IF(A1>10, "Yes", "No")
2. AND: =AND(A1>5, B1<10)
3. OR: =OR(A1=1, B1=2)
4. EXACT (case-sensitive match): =EXACT(A1, B1)

Lookup Functions
1. VLOOKUP: =VLOOKUP(A1, Table, 2, FALSE)
2. HLOOKUP: =HLOOKUP(A1, Table, 2, FALSE)
3. XLOOKUP: =XLOOKUP(A1, Range1, Range2)

Counting & Data Types
1. Count numbers: =COUNT(A1:A10)
2. Count non-empty: =COUNTA(A1:A10)
3. Count blanks: =COUNTBLANK(A1:A10)
4. Is number: =ISNUMBER(A1)
5. Is text: =ISTEXT(A1)

React ❤️ for more
16👍2
Sometimes reality outpaces expectations in the most unexpected ways.
While global AI development seems increasingly fragmented, Sber just released Europe's largest open-source AI collection—full weights, code, and commercial rights included.
No API paywalls.
No usage restrictions.
Just four complete model families ready to run in your private infrastructure, fine-tuned on your data, serving your specific needs.

What makes this release remarkable isn't merely the technical prowess, but the quiet confidence behind sharing it openly when others are building walls. Find out more in the article from the developers.

GigaChat Ultra Preview: 702B-parameter MoE model (36B active per token) with 128K context window. Trained from scratch, it outperforms DeepSeek V3.1 on specialized benchmarks while maintaining faster inference than previous flagships. Enterprise-ready with offline fine-tuning for secure environments.
GitHub | HuggingFace | GitVerse

GigaChat Lightning offers the opposite balance: compact yet powerful MoE architecture running on your laptop. It competes with Qwen3-4B in quality, matches the speed of Qwen3-1.7B, yet is significantly smarter and larger in parameter count.
Lightning holds its own against the best open-source models in its class, outperforms comparable models on different tasks, and delivers ultra-fast inference—making it ideal for scenarios where Ultra would be overkill and speed is critical. Plus, it features stable expert routing and a welcome bonus: 256K context support.
GitHub | Hugging Face | GitVerse

Kandinsky 5.0 brings a significant step forward in open generative models. The flagship Video Pro matches Veo 3 in visual quality and outperforms Wan 2.2-A14B, while Video Lite and Image Lite offer fast, lightweight alternatives for real-time use cases. The suite is powered by K-VAE 1.0, a high-efficiency open-source visual encoder that enables strong compression and serves as a solid base for training generative models. This stack balances performance, scalability, and practicality—whether you're building video pipelines or experimenting with multimodal generation.
GitHub | GitVerse | Hugging Face | Technical report

Audio gets its upgrade too: GigaAM-v3 delivers speech recognition model with 50% lower WER than Whisper-large-v3, trained on 700k hours of audio with punctuation/normalization for spontaneous speech.
GitHub | HuggingFace | GitVerse

Every model can be deployed on-premises, fine-tuned on your data, and used commercially. It's not just about catching up – it's about building sovereign AI infrastructure that belongs to everyone who needs it.
3
Excel Roadmap for Beginners (2025) 📊🧠

1. Understand What Excel Is
⦁ Powerful spreadsheet tool for data entry, calculations, and analysis
⦁ Types: Desktop app, Excel Online, integration with Microsoft 365 Copilot

2. Learn the Interface Basics
⦁ Ribbons, tabs, cells, rows/columns
⦁ Navigation: Zoom, freeze panes, basic formatting (bold, colors)

3. Master Data Entry & Formatting
⦁ Enter text/numbers, dates, currency
⦁ Align text, borders, conditional formatting

4. Learn Core Formulas & Functions
⦁ Basic: SUM, AVERAGE, MIN/MAX, COUNT
⦁ Logic: IF, AND/OR
⦁ Lookup: VLOOKUP, INDEX-MATCH

5. Work with Tables & Sorting
⦁ Create tables, sort/filter data
⦁ Remove duplicates, text to columns

6. Practice with Charts & Visuals
⦁ Bar/line/pie charts, sparklines
⦁ Format axes, add labels

7. Use Pivot Tables & Slicers
⦁ Summarize data dynamically
⦁ Group by dates/categories, calculate totals

8. Work on Projects
⦁ Budget tracker spreadsheet
⦁ Sales dashboard
⦁ Simple inventory list

9. Learn Basics of Data Analysis
⦁ What-If analysis, goal seek
⦁ Basic stats: Mean, median via functions

10. Bonus Skills
⦁ Power Query for cleaning data
⦁ Macros/VBA intro (optional)
⦁ Copilot AI for smart suggestions

💬 Double Tap ♥️ For More
13👍2