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 :)

1. Ctrl + N: To create a new workbook.
2. Ctrl + O: To open a saved workbook.
3. Ctrl + S: To save a workbook.
4. Ctrl + A: To select all the contents in a workbook.
5. Ctrl + B: To turn highlighted cells bold.
6. Ctrl + C: To copy cells that are highlighted.
7. Ctrl + D: To fill the selected cell with the content of the cell right above.
8. Ctrl + F: To search for anything in a workbook.
9. Ctrl + G: To jump to a certain area with a single command.
10. Ctrl + H: To find and replace cell contents.
11. Ctrl + I: To italicise cell contents.
12. Ctrl + K: To insert a hyperlink in a cell.
13. Ctrl + L: To open the create table dialog box.
14. Ctrl + P: To print a workbook.
15. Ctrl + R: To fill the selected cell with the content of the cell on the left.
16. Ctrl + U: To underline highlighted cells.
17. Ctrl + V: To paste anything that was copied.
18. Ctrl + W: To close your current workbook.
19. Ctrl + Z: To undo the last action.
20. Ctrl + 1: To format the cell contents.
21. Ctrl + 5: To put a strikethrough in a cell.
22. Ctrl + 8: To show the outline symbols.
23. Ctrl + 9: To hide a row.
24. Ctrl + 0: To hide a column.
25. Ctrl + Shift + :: To enter the current time in a cell.
26. Ctrl + ;: To enter the current date in a cell.
27. Ctrl + `: To change the view from displaying cell values to formulas.
28. Ctrl + ‘: To copy the formula from the cell above.
29. Ctrl + -: To delete columns or rows.
30. Ctrl + Shift + =: To insert columns and rows.
31. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
32. Ctrl + Shift + @: To apply time formatting.
33. Ctrl + Shift + !: To apply comma formatting.
34. Ctrl + Shift + $: To apply currency formatting.
35. Ctrl + Shift + #: To apply date formatting.
36. Ctrl + Shift + %: To apply percentage formatting.
37. Ctrl + Shift + &: To place borders around the selected cells.
38. Ctrl + Shift + _: To remove a border.
39. Ctrl + -: To delete a selected row or column.
40. Ctrl + Spacebar: To select an entire column.
41. Ctrl + Shift + Spacebar: To select an entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: To switch to the previous workbook.
44. Ctrl + Shift + F: To open the fonts menu under format cells.
45. Ctrl + Shift + O: To select the cells containing comments.
46. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To drag and insert copy.
48. Ctrl + Up arrow: To go to the top most cell in a current column.
49. Ctrl + Down arrow: To jump to the last cell in a current column.
50. Ctrl + Right arrow: To go to the last cell in a selected row.
51. Ctrl + Left arrow: To jump back to the first cell in a selected row.
52. Ctrl + End: To go to the last cell in a workbook.
53. Alt + Page down: To move the screen towards the right.
54. Alt + Page Up: To move the screen towards the left.
55. Ctrl + F2: To open the print preview window.
56. Ctrl + F1: To expand or collapse the ribbon.
57. Alt: To open the access keys.
58. Tab: Move to the next cell.
59. Alt + F + T: To open the options.
60. Alt + Down arrow: To activate filters for cells.
61. F2: To edit a cell.
62. F3: To paste a cell name if the cells have been named.
63. Shift + F2: To add or edit a cell comment.
64. Alt + H + H: To select a fill colour.
65. Alt + H + B: To add a border.
66. Ctrl + 9: To hide the selected rows.
67. Ctrl + 0: To hide the selected columns.
68. Esc: To cancel an entry.
69. Enter: To complete the entry in a cell and move to the next one.
70. Shift + Right arrow: To extend the cell selection to the right.
71. Shift + Left arrow: To extend the cell selection to the left.
72. Shift + Space: To select the entire row.
73. Page up/ down: To move the screen up or down.
74. Alt + H: To go to the Home tab in Ribbon.
75. Alt + N: To go to the Insert tab in Ribbon.

10 steps to mastering Excel (in no particular order):

1. IF
2. VLOOKUP
3. SUMIF
4. COUNTIF
5. Formatting data types (dates, numbers etc)
6. Pivot Tables
7. Power Query
8. Filters & Slicing
9. Transpose
10. Dealing with duplicates

To unfreeze panes in Excel, you can do the following:
Open your Excel workbook and navigate to the worksheet with frozen panes.
Click the View tab on the Ribbon at the top of Excel.
In the Window group, find the Freeze Panes button.
Click Freeze Panes to open the dropdown menu.
Select Unfreeze Panes from the dropdown menu.

One of the best things you can do as a data analyst is to...


...learn Excel.

Surprised?

If you think you'll NEVER use Excel in your data job because it:

- is outdated, clunky, or too basic
- isn't able to automate repetitive tasks
- doesn't have data visualization capabilities
- can't handle large data sets or complex analysis

...you're probably wrong.

Those reasons might be exactly WHY you'll use Excel, because it's...

- universally understood by stakeholders
- great in basic data exploration
- useful for quick analysis
- user-friendly

Bottom line: learn Excel. Your future self will thank you.

Excel shortcuts

Corporate be like:

Weekdays: Microsoft Excel

Weekends: Surf Excel

𝐕𝐋𝐎𝐎𝐊𝐔𝐏 𝐈𝐍 𝐄𝐗𝐂𝐄𝐋:

Today, one of my colleagues was trying to use VLOOKUP in Excel to get values from another file, but he kept getting the 𝐍/𝐀 error. He asked for my help, and I used the 𝐓𝐑𝐈𝐌 𝐟𝐮𝐧𝐜𝐭𝐢𝐨𝐧 on the lookup column before using VLOOKUP. The problem was fixed right away.

𝐓𝐡𝐞 𝐫𝐞𝐚𝐬𝐨𝐧 𝐈 𝐮𝐬𝐞𝐝 𝐓𝐑𝐈𝐌 𝐟𝐢𝐫𝐬𝐭 is that extra spaces in the cells can stop VLOOKUP from finding a match, causing the 𝐍/𝐀 error. By using TRIM, I removed any extra spaces, making sure the lookup values matched correctly.

✅ It's a good reminder that while we spend a lot of time learning new tools, we sometimes forget the basics. Even though new tools are useful, knowing the basics is just as important. 🙌

Treat everyone with kindness not because they are nice, but because you are. Beautiful people are not always kind but kind people are always beautiful

4 reasons why you should start your analytics journey with Excel.

1) It's the Swiss Army Knife of data
- Clean data
- Ad-hoc analytics
- Create visualizations
- Automations (Macros)

2) Integration with other tools
- Excel spreadsheets feed data into everything
- MS Access, Tableau, Power BI, SQL, etc

3) Power BI adoption
- DAX and Power Query in Excel make PBI easier to adopt

4) All roads lead back to Excel eventually (trust me)
- As hard as you try, you can never escape it

There's much more to learn after Excel, but starting here will create a strong foundation for your analytics career path!

𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐫𝐞𝐩𝐨𝐫𝐭 𝐢𝐬 𝐫𝐮𝐧𝐧𝐢𝐧𝐠 𝐬𝐥𝐨𝐰𝐥𝐲. 𝐖𝐡𝐚𝐭 𝐬𝐭𝐞𝐩𝐬 𝐰𝐨𝐮𝐥𝐝 𝐲𝐨𝐮 𝐭𝐚𝐤𝐞 𝐭𝐨 𝐝𝐢𝐚𝐠𝐧𝐨𝐬𝐞 𝐚𝐧𝐝 𝐟𝐢𝐱 𝐭𝐡𝐞 𝐩𝐫𝐨𝐛𝐥𝐞𝐦?
👇👇
https://t.iss.one/PowerBI_analyst/240

Why is Excel Often the Starting Point for SQL ?


Here's how Excel can help you before you dive into SQL:

✔️ 𝐕𝐋𝐎𝐎𝐊𝐔𝐏 = 𝐒𝐐𝐋 𝐉𝐎𝐈𝐍𝐒
In Excel, we use VLOOKUP to bring together data from different sheets. It's just like using JOINS in SQL to get data from more than one table.

✔️ 𝐒𝐔𝐌 𝐚𝐧𝐝 𝐂𝐎𝐔𝐍𝐓 𝐟𝐨𝐫 𝐒𝐐𝐋 𝐐𝐮𝐞𝐫𝐢𝐞𝐬
Excel's SUM and COUNT functions are like practice for SQL queries. They help you add up and count things, which is what you often do in SQL.

✔️ 𝐅𝐈𝐋𝐓𝐄𝐑 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭𝐬 & 𝐖𝐇𝐄𝐑𝐄 𝐢𝐧 𝐒𝐐𝐋
Excel's 𝐅𝐈𝐋𝐓𝐄𝐑 statements let you make choices with your data. This is similar to using WHERE in SQL to pick specific data.

✔️ 𝐇𝐚𝐧𝐝𝐥𝐢𝐧𝐠 𝐃𝐚𝐭𝐞𝐬 𝐚𝐧𝐝 𝐓𝐞𝐱𝐭
Both Excel and SQL have ways to work with dates and text. Learning these in Excel first can make it easier when you switch to SQL.

✔️ 𝐏𝐢𝐯𝐨𝐭 𝐓𝐚𝐛𝐥𝐞𝐬 & 𝐆𝐑𝐎𝐔𝐏 𝐁𝐘 𝐢𝐧 𝐒𝐐𝐋
Ever used pivot tables in Excel? They're a good start for understanding the GROUP BY function in SQL, which helps you organize and summarize data.

✔️ 𝐗𝐋𝐎𝐎𝐊𝐔𝐏 & 𝐇𝐲𝐩𝐞𝐫𝐥𝐢𝐧𝐤𝐬
Excel's XLOOKUP and hyperlinks are like SQL's ways of finding and linking data. They give you a peek into how SQL finds and connects information.

Learning Excel first makes SQL easier to understand. It's not just about learning a tool, it's about getting ready for the bigger world of data!

You will be asked questions on SQL in interviews for sure! Make sure to practice 2-3 questions daily, it can't be mastered overnight!

Share our channel link with your true friends: https://t.iss.one/excel_analyst

Hope this helps you 😊

Insert Slicers in Excel 👍😊