✅ 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!
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
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.
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
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
❤15👍2