Microsoft Excel for Finance & Data Analytics

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

How to create a new workbook 1. Do any of the following: • If Excel is not running, start Excel, and then on the Start screen, double-click Blank workbook. • If Excel is already running, click the File tab of the ribbon, click New to display the New page of the Backstage view, and then double-click Blank workbook. • If Excel is already running, press Ctrl+N. To save a workbook under a new name or in a new location 1. Display the Backstage view, and then click Save As. 2. On the Save As page of the Backstage view, click the folder where you want to save the workbook. 3. In the Save As dialog box, in the File name box, enter a new name for the workbook. 4. To save the file in a different format, in the Save as type list, click a new file type. 5. If necessary, use the navigation controls to move to a new folder. 6. Click Save.

Top Excel Formulas Every Data Analyst Should Know SUM(): Purpose: Adds up a range of numbers. Example: =SUM(A1:A10) AVERAGE(): Purpose: Calculates the average of a range of numbers. Example: =AVERAGE(B1:B10) COUNT(): Purpose: Counts the number of cells containing numbers. Example: =COUNT(C1:C10) IF(): Purpose: Returns one value if a condition is true, and another if false. Example: =IF(A1 > 10, "Yes", "No") VLOOKUP(): Purpose: Searches for a value in the first column and returns a value in the same row from another column. Example: =VLOOKUP(D1, A1:B10, 2, FALSE) HLOOKUP(): Purpose: Searches for a value in the first row and returns a value in the same column from another row. Example: =HLOOKUP("Sales", A1:F5, 3, FALSE) INDEX(): Purpose: Returns the value of a cell based on row and column numbers. Example: =INDEX(A1:C10, 2, 3) MATCH(): Purpose: Searches for a value and returns its position in a range. Example: =MATCH("Product B", A1:A10, 0) CONCATENATE() or CONCAT(): Purpose: Joins multiple text strings into one. Example: =CONCATENATE(A1, " ", B1) TEXT(): Purpose: Formats numbers or dates as text. Example: =TEXT(A1, "dd/mm/yyyy") Excel Resources: t.me/excel_data I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Like this post for more content like this 👍♥️ Share with credits: https://t.me/sqlspecialist Hope it helps :)

Only the first 150 people will be admitted to the group where the best quality signals are shared 🔥🔥 I personally recommend you to participate 👇 https://t.me/+LtTG49-GDoJjNjRi Also don't miss the VIP GROUP where additional signals are shared 💎🔥👇🏻 https://t.me/+LtTG49-GDoJjNjRi

Ad 👇👇