M.S. Office, Excel, PowerPoint, Word
Open in Telegram
📈 Analytical overview of Telegram channel M.S. Office, Excel, PowerPoint, Word
Channel M.S. Office, Excel, PowerPoint, Word (@msofficeknowledge) in the English language segment is an active participant. Currently, the community unites 36 071 subscribers, ranking 5 243 in the Education category.
📊 Audience metrics and dynamics
Since its creation on невідомо, the project has demonstrated rapid growth, gathering an audience of 36 071 subscribers.
According to the latest data from 16 May, 2026, the channel demonstrates stable activity. Although there has been a change in the number of participants by -329 over the last 30 days and by 0 over the last 24 hours, overall reach remains high.
- Verification status: Not verified
- Engagement rate (ER): The average audience engagement rate is 0%. Within the first 24 hours after publication, content typically collects N/A% reactions from the total number of subscribers.
- Post reach: On average, each post receives 0 views. Within the first day, a publication typically gains 0 views.
- Reactions and interaction: The audience actively supports content: the average number of reactions per post is 0.
📝 Description and content policy
The author describes the resource as a platform for expressing subjective opinions:
“Knowledge Sharing”
Thanks to the high frequency of updates (latest data received on 17 May, 2026), the channel maintains relevance and a high level of publication reach. Analytics show that the audience actively interacts with content, making it an important point of influence in the Education category.
36 071
Subscribers
No data24 hours
-387 days
-32930 days
Posts Archive
Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Repost from M.S. Office, Excel, PowerPoint, Word
Shortcut key to do following functions in Excel.
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Repost from M.S. Office, Excel, PowerPoint, Word
Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Repost from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
Repost from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Repost from M.S. Office, Excel, PowerPoint, Word
🤟✌️✌️🟣Step 7: - After selecting 1, close the brackets ‘)’ and press ‘Enter’ or ‘Tab’.
You can see the yellow highlighted Cell C13 Discount Percentage has come out of the Table A which is given below of 0 (Zero) Sale Value. As you can see, we are searching for discount percentage of Sale value 50 but 50 is not given in Table A, As this is Approximate Match that is why if same sale value is not given then system will find the lower nearest results based on approximation. As you can see in below examples: -
1. In front of 50 the percentage is 0% which is of Sale Value 0.
2. In front of 133 the percentage is 5% which is of Sale Value 100.
3. In front of 345 the percentage is 15% which is of Sale Value 300.
But in below examples results are same as given in Table A: -
1. In front of 700 the percentage is 35% which is of Sale Value 700.
2. In front of 800 the percentage is 40% which is of Sale Value 800.
Repost from M.S. Office, Excel, PowerPoint, Word
🤟🤟🟣Step 6: - After selecting ‘Row_Index_Num’ the fourth field will reflect ‘Range_lookup ‘ (1 for approximate match --> ‘True’ and 0 is for Exact Match --> ‘False’), will select 1 for Approximate Match.
Repost from M.S. Office, Excel, PowerPoint, Word
🤟✌️🟣Step 5: - After selecting Table array please put koma (,) and the third field will reflect ‘Row_Index_Num’ means from which row you want to find the results, Type number 2 here.
(Explanation: - In this problem we have two rows in which data exist, and we want to find the Discount Percentage which is lying on 2nd row that is why we typed 2 here)
Repost from M.S. Office, Excel, PowerPoint, Word
✌️✌️🟢Step 4: - After selecting ‘Lookup Value in cell C12, select ‘Table Array from Cell C8 to M9’ from which you want to find the results of ‘lookup value’.
Repost from M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell C12’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
Repost from M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Hlookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
Repost from M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘C13’ and press ‘=’ this will activate the cell to use function, and start typing ‘Hlookup’.
Repost from M.S. Office, Excel, PowerPoint, Word
♦️♦️In the screenshot you can see one problem is given in Table A and we need to find the Discount Percentage in Table B. We will solve this problem with the help of ‘Hlookup’ function. Please follow below steps: -
Repost from M.S. Office, Excel, PowerPoint, Word
After having discussion on Lookup and Vlookup, let us now discuss one of the best function of Lookup Family ‘Hlookup’ with Approximate Match.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
Repost from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Repost from M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: -
https://youtu.be/BXyGREk6ICk
Repost from M.S. Office, Excel, PowerPoint, Word
⏯Step 1: - Use Copy command on the range (Column H and Column I) of cells by using below shortcut keys: -
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
