Microsoft Excel for Finance & Data Analytics

Essential Excel Functions for Data Analysts 🚀 1️⃣ Basic Functions SUM() – Adds a range of numbers. =SUM(A1:A10) AVERAGE() – Calculates the average. =AVERAGE(A1:A10) MIN() / MAX() – Finds the smallest/largest value. =MIN(A1:A10) 2️⃣ Logical Functions IF() – Conditional logic. =IF(A1>50, "Pass", "Fail") IFS() – Multiple conditions. =IFS(A1>90, "A", A1>80, "B", TRUE, "C") AND() / OR() – Checks multiple conditions. =AND(A1>50, B1<100) 3️⃣ Text Functions LEFT() / RIGHT() / MID() – Extract text from a string. =LEFT(A1, 3) (First 3 characters) =MID(A1, 3, 2) (2 characters from the 3rd position) LEN() – Counts characters. =LEN(A1) TRIM() – Removes extra spaces. =TRIM(A1) UPPER() / LOWER() / PROPER() – Changes text case. 4️⃣ Lookup Functions VLOOKUP() – Searches for a value in a column. =VLOOKUP(1001, A2:B10, 2, FALSE) HLOOKUP() – Searches in a row. XLOOKUP() – Advanced lookup replacing VLOOKUP. =XLOOKUP(1001, A2:A10, B2:B10, "Not Found") 5️⃣ Date & Time Functions TODAY() – Returns the current date. NOW() – Returns the current date and time. YEAR(), MONTH(), DAY() – Extracts parts of a date. DATEDIF() – Calculates the difference between two dates. 6️⃣ Data Cleaning Functions REMOVE DUPLICATES – Found in the "Data" tab. CLEAN() – Removes non-printable characters. SUBSTITUTE() – Replaces text within a string. =SUBSTITUTE(A1, "old", "new") 7️⃣ Advanced Functions INDEX() & MATCH() – More flexible alternative to VLOOKUP. TEXTJOIN() – Joins text with a delimiter. UNIQUE() – Returns unique values from a range. FILTER() – Filters data dynamically. =FILTER(A2:B10, B2:B10>50) 8️⃣ Pivot Tables & Power Query PIVOT TABLES – Summarizes data dynamically. GETPIVOTDATA() – Extracts data from a Pivot Table. POWER QUERY – Automates data cleaning & transformation. You can find Free Excel Resources here: https://t.me/excel_data Hope it helps :) #dataanalytics

Double Tap ❤️ For More Useful Videos

Double Tap ❤️ For More Useful Videos

Import Text to Excel ✅

Excel Trick

🎲 Some Useful Computer Shortcuts 🎲 Ctrl+A - Select All Ctrl+B - Bold Ctrl+C - Copy Ctrl+D - Fill Down Ctrl+F - Find Ctrl+G - Goto Ctrl+H - Replace Ctrl+I - Italic Ctrl+K - Insert Hyperlink Ctrl+N - New Workbook Ctrl+O - Open Ctrl+P - Print Ctrl+R - Fill Right Ctrl+S - Save Ctrl+U - Underline Ctrl+V - Paste Ctrl W - Close Ctrl+X - Cut Ctrl+Y - Repeat Ctrl+Z - Undo F1 - Help F2 - Edit F3 - Paste Name F4 - Repeat last action F4 - While typing a formula, switch between absolute/relative refs F5 - Goto F6 - Next Pane F7 - Spell check F8 - Extend mode F9 - Recalculate all workbooks F10 - Activate Menu bar F11 - New Chart F12 - Save As Ctrl+: - Insert Current Time Ctrl+; - Insert Current Date Ctrl+" - Copy Value from Cell Above Ctrl+’ - Copy Formula from Cell Above Shift - Hold down shift for additional functions in Excel’s menu Shift+F1 - What’s This? Shift+F2 - Edit cell comment Shift+F3 - Paste function into formula Shift+F4 - Find Next Shift+F5 - Find Shift+F6 - Previous Pane Shift+F8 - Add to selection Shift+F9 - Calculate active worksheet Shift+F10 - Display shortcut menu Shift+F11 - New worksheet Ctrl+F3 - Define name Ctrl+F4 - Close Ctrl+F5 - XL, Restore window size Ctrl+F6 - Next workbook window Shift+Ctrl+F6 - Previous workbook window Ctrl+F7 - Move window Ctrl+F8 - Resize window Ctrl+F9 - Minimize workbook Ctrl+F10 - Maximize or restore window Ctrl+F11 - Inset 4.0 Macro sheet Ctrl+F1 - File Open Alt+F1 - Insert Chart Alt+F2 - Save As Alt+F4 - Exit Alt+Down arrow - Display AutoComplete list Alt+’ - Format Style dialog box Ctrl+Shift+~ - General format Ctrl+Shift+! - Comma format Ctrl+Shift+@ - Time format Ctrl+Shift+# - Date format Ctrl+Shift+$ - Currency format Ctrl+Shift+% - Percent format Ctrl+Shift+^ - Exponential format Ctrl+Shift+& - Place outline border around selected cells Ctrl+Shift+_ - Remove outline border Ctrl+Shift+* - Select current region Ctrl++ - Insert Ctrl+- - Delete Ctrl+1 - Format cells dialog box Ctrl+2 - Bold Ctrl+3 - Italic Ctrl+4 - Underline Ctrl+5 - Strikethrough Ctrl+6 - Show/Hide objects Ctrl+7 - Show/Hide Standard toolbar Ctrl+8 - Toggle Outline symbols Ctrl+9 - Hide rows Ctrl+0 - Hide columns Ctrl+Shift+( - Unhide rows Ctrl+Shift+) - Unhide columns Alt or F10 - Activate the menu Ctrl+Tab - In toolbar: next toolbar Shift+Ctrl+Tab - In toolbar: previous toolbar Ctrl+Tab - In a workbook: activate next workbook Shift+Ctrl+Tab - In a workbook: activate previous workbook Tab - Next tool Shift+Tab - Previous tool Enter - Do the command Shift+Ctrl+F - Font Drop down List Shift+Ctrl+F+F - Font tab of Format Cell Dialog box Shift+Ctrl+P - Point size Drop down List Ctrl + E - Align center Ctrl + J - justify Ctrl + L - align Ctrl + R - align right Alt + Tab - switch applications Windows + P - Project screen Windows + E - open file explorer Windows + D - go to desktop Windows + M - minimize all windows Windows + S - search

🗂The order of operations used in MS Excel while evaluating formulas MS Excel follows a standard math protocol to evaluate a formula. This protocol is called “order of operations” – PEMDAS – ~Parentheses ~Exponents ~Multiplication ~Division ~Addition ~Subtraction MS Excel also applies some customization to handle the formula syntax. The order in which MS Excel performs calculations can affect the return value of the formula. First of all, Excel evaluates any expressions in parentheses. As we have seen in mathematical formulae too, parentheses essentially override the normal order of operations. It prioritizes certain operations. Next, Excel resolves cell references like A1 (cell address). It evaluates range references like A1:A10, making them arrays of values. It also performs range operations like a union (comma) and an intersection (space). Next, Excel performs – -Exponentiation -Negation -% conversions -Multiplication and division -Addition and subtraction -Concatenation -Logical operators

The key to mastering Excel for career growth: ❌It's not your degree ❌It's not your job title It's how you apply these principles: 1. Learn by solving real problems 2. Build your own Excel toolkit 3. Share your skills with others No one starts a spreadsheet wizard, but everyone can become one. If you're looking to level up with Excel, start by: ⟶ Watching tutorials ⟶ Practicing with real datasets ⟶ Rebuilding dashboards you admire ⟶ Automating tasks with formulas & macros ⟶ Asking questions and learning from pros You'll be amazed how quickly Excel becomes your superpower. So, start today and let your Excel journey begin! React ❤️ for more helpful tips

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 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 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 | 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 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.

Struggling with messy data in Excel? Here’s how to clean it up: If you’re dealing with unorganized data in Excel, here are some quick steps to clean your sheets: 1️⃣ Trim Function: Eliminate leading & trailing spaces easily. 2️⃣ Remove Duplicates: Use the Data tab feature to delete duplicate rows. 3️⃣ Text to Columns: Separate combined information into different cells. 4️⃣ Filter Blank Cells: Quickly find and manage empty cells. 5️⃣ Clean Function: Remove non-printable characters for a tidier dataset. Like for more ❤️

Excel Shortcuts for Finance

🧵 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

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

Useful Shortcut Keys

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.me/sqlspecialist/547 Part-1: https://t.me/sqlspecialist/617 Part-2: https://t.me/sqlspecialist/620 Part-3: https://t.me/sqlspecialist/623 Part-4: https://t.me/sqlspecialist/624 Part-5: https://t.me/sqlspecialist/628 Part-6: https://t.me/sqlspecialist/633 Part-7: https://t.me/sqlspecialist/634 Part-8: https://t.me/sqlspecialist/635 Part-9: https://t.me/sqlspecialist/640 Part-10: https://t.me/sqlspecialist/641 Part-11: https://t.me/sqlspecialist/644 Part-12: https://t.me/sqlspecialist/646 Part-13: https://t.me/sqlspecialist/650 Part-14: https://t.me/sqlspecialist/651 Part-15: https://t.me/sqlspecialist/654 Part-16: https://t.me/sqlspecialist/655 Part-17: https://t.me/sqlspecialist/658 Part-18: https://t.me/sqlspecialist/660 Part-19: https://t.me/sqlspecialist/661 Part-20: https://t.me/sqlspecialist/662 Bonus: https://t.me/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.me/excel_analyst Python Learning Series: https://t.me/sqlspecialist/615 Complete SQL Topics for Data Analysts: https://t.me/sqlspecialist/523 Complete Power BI Topics for Data Analysts: https://t.me/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 :)

🔓 PRIVATE CHANNEL now OPEN +$154.382 per day raised by Jack subs⚡️ 👉 https://t.me/+qRKP9TmigCwxM2Iy Don’t miss signals and start make money 🔥

Ad 👇👇

Essential Excel Functions for Data Analysts 🚀 1️⃣ Basic Functions SUM() – Adds a range of numbers. =SUM(A1:A10) AVERAGE() – Calculates the average. =AVERAGE(A1:A10) MIN() / MAX() – Finds the smallest/largest value. =MIN(A1:A10) 2️⃣ Logical Functions IF() – Conditional logic. =IF(A1>50, "Pass", "Fail") IFS() – Multiple conditions. =IFS(A1>90, "A", A1>80, "B", TRUE, "C") AND() / OR() – Checks multiple conditions. =AND(A1>50, B1<100) 3️⃣ Text Functions LEFT() / RIGHT() / MID() – Extract text from a string. =LEFT(A1, 3) (First 3 characters) =MID(A1, 3, 2) (2 characters from the 3rd position) LEN() – Counts characters. =LEN(A1) TRIM() – Removes extra spaces. =TRIM(A1) UPPER() / LOWER() / PROPER() – Changes text case. 4️⃣ Lookup Functions VLOOKUP() – Searches for a value in a column. =VLOOKUP(1001, A2:B10, 2, FALSE) HLOOKUP() – Searches in a row. XLOOKUP() – Advanced lookup replacing VLOOKUP. =XLOOKUP(1001, A2:A10, B2:B10, "Not Found") 5️⃣ Date & Time Functions TODAY() – Returns the current date. NOW() – Returns the current date and time. YEAR(), MONTH(), DAY() – Extracts parts of a date. DATEDIF() – Calculates the difference between two dates. 6️⃣ Data Cleaning Functions REMOVE DUPLICATES – Found in the "Data" tab. CLEAN() – Removes non-printable characters. SUBSTITUTE() – Replaces text within a string. =SUBSTITUTE(A1, "old", "new") 7️⃣ Advanced Functions INDEX() & MATCH() – More flexible alternative to VLOOKUP. TEXTJOIN() – Joins text with a delimiter. UNIQUE() – Returns unique values from a range. FILTER() – Filters data dynamically. =FILTER(A2:B10, B2:B10>50) 8️⃣ Pivot Tables & Power Query PIVOT TABLES – Summarizes data dynamically. GETPIVOTDATA() – Extracts data from a Pivot Table. POWER QUERY – Automates data cleaning & transformation. You can find Free Excel Resources here: https://t.me/excel_data Hope it helps :) #dataanalytics