Hi Friends

✳️Autofill

🟡Autofill in Microsoft Excel is a feature to fill cells with data that follows a pattern or are based on data in the last cells.

You can use this in two ways:-

🔸1. Ctrl+E: Put 1 in cell B1 and 2 in cell B2 and come to cell B3 then press Ctrl +E, you will get the desired results according to the criteria followed in previous cells.


🔹2. Square drag:-  When you select a particular series of data like 1 in cell A1 and 2 in cell A2, then you will see a small square at the bottom-right corner, which you can drag and you will get the desired results according to the criteria followed in previous cells.

➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S

❗️Note: - This “Paste Special” only works if you have copied or cut some data.

Solution to a very common problem in office

Shortcut keys

Some shortcut keys of MS Excel

Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete

Some shortcut keys of MS Excel
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

These shortcuts are related to formatting only.

Free Microsoft courses for data analytics
https://www.linkedin.com/posts/sql-analysts_excel-dataanalytics-activity-7130785308240936960-v8A3

MS Excel shortcut keys

Question of the day

What is transpose in Excel, where it is exist and how it is working?

Please write your answer in comments.

Answer;-

Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.

It exist in Paste Special box in Home tab.

Working:-

1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.

Thank You

Free Data sets for Data Science & Machine Learning Projects
👇👇
https://t.iss.one/DataPortfolio

100 Excel Tips🚀🚀

Join for more: https://t.iss.one/excel_analyst

Free Data sets for Data Science & Machine Learning Projects
👇👇
https://t.iss.one/DataPortfolio

This channels is for Programmers, Coders, Software Engineers.

0- Python
1- Data Science
2- Machine Learning
3- Data Visualization
4- Artificial Intelligence
5- Data Analysis
6- Statistics
7- Deep Learning
8- programming Languages

✅ Best channels on Telegram:
https://t.iss.one/addlist/JbC2D8X2g700ZGMx

✅ Free Courses with Certificate:
https://t.iss.one/free4unow_backup

Best AI Tools
👇👇
https://t.iss.one/ai_best_tools

✅ Best Telegram channels to get free coding & data science resources
https://t.iss.one/addlist/XYopgGtDUp4zMDkx

✅ Free Courses with Certificate:
https://t.iss.one/free4unow_backup

Business Analytics vs Data Analytics

If you want to be a data analyst, you’ll have to embrace the data-cleaning aspect of the job.

Here are some data-cleaning terms you should become familiar with in Excel:

- Data Validation
- Find and Replace
- Trim
- Left/Mid/Right
- Power Query
- Text to Columns
- Remove Duplicates

Difference between VLOOKUP vs HLOOKUP

Comment "Excel" to get this excel step by step guide 👇
https://www.instagram.com/reel/C2h2GJDtU0q/?igsh=MThzenYyaGh1OHE2YQ==