📗Excel shorts -Part 1📗

📗Excel Shorts - Part 1📗

Hello guys, thank you so much for such a wonderful response to our blog...

Yes, you have heard right..."Our blog".

So specially for you we have started a new series known as

📗Excel Shorts📗

In Excel Shorts you will get best tips and tricks and with to the point information.

This will not only help you to save time but also will benefit you in your career development.

So now without wasting time, let's start the magic😉

Absolute References ($)

Indispensable! The dollar in front of the letter fixes the column, the dollar sign in front of number fixes the 

row F4 toggles through the four possible combinations. Try it out with the following exercise. Type out 

three Fruits horizontally in cells B1, C1, D1 (Grapes, Apple, Banana) and three colours in cells A2, B2, 

C2 (Green, Blue, Yellow). Now type in cell B2 '=A2&" "&B1'. Congratulations: Green Grapes! Now - and 

here's the exercise - add dollar signs so that when you copy the formula across you get green everything. 

Conditional Formatting

Making sense of our data-rich, noisy world is hard but vital. Used well, Conditional Formatting brings out 

the patterns of the universe, as captured by your spreadsheet. That's why Excel experts and Excel users 

alike vote this the #1 most important feature. This can be sophisticated. But even the simplest colour 

changes can be hugely beneficial. Suppose you have volumes sold by sales staff each month. Just three 

clicks can reveal the top 10% performing salespeople and tea up an important business conversation

Add Multiple Rows

Probably one among the foremost frequently administered activities in spreadsheeting. Ctrl Shift + is that the shortcut, 

but actually it takes longer than simply right-clicking on the row numbers on the left of the Excel display. 

So Right Click is our recommendation. And if you would like to feature quite one, select as many rows or 

columns as you want to feature then Right Click and add.

That's it for today guys...

If you like this article then do comment,like and share with your near and dear ones.....

you have any query or want any help related to excel feel free to join our Telegram channel and message us..

Channel link :

https://t.me/msexcelmaster101