MS Excel Formulae & Tricks

Dear followers,
Have you faced issue while sending the Presentation file or excel etc via email ?
Here is a trick to reduce the file size for your perusal.
Below link if for video uploaded on youtube. Check it....

https://youtu.be/ziXia4aWNxw

Hi Everyone,
you may have come across change in date format while pullng a date in column / row field of pivot table. Where data is being displayed as Year > Qtr > Month > Week >.....

To get rid of that format of bring actual data in it, you can un group the date. To ungroup the date you have to right click on the expansion button (+ or -) and select Ungroup.

Attached is the picture for your reference.

How to convert a (normal number) Arabic number to Roman number and Roman number to Arabic number ?

How to Convert Roman Number to Arabic & vice Versa How to Convert Roman Number to Arabic or Arabic number to Roman Number.

How to create an Organogram / Organization chart ?
How to connect two shape with a connector line, so it should not detach with each other while moving one shape.

How to Create an Organogram How to create an organogram and connect the shape. So if you'll move one shape. the connecting arrow will move or adjust automatically.

https://youtu.be/e_5Rwp0NNyQ

Hello,
Here we have a small video for Printing.

How to Print? (Printing setting) This video explains that, How you can do print setup to take a print out in easy way..page: https://www.facebook.com/msexcelformulaeContact/Whatsapp...

https://youtu.be/hPlSIGv6UgQ

What is sparkline in Excel ?
Sparkline is a instant graph displayed in a cell of excel based on a data range. It can be displayed in form of Trendline, Column graph or win loss graph.

page: https://www.facebook.com/msexcelformulae
Ask on whatsapp: https://wa.me/+919594903738
Gmail: [email protected]

Personal / Corporate training available via Online / physical classes.
Special discount for Groups

Need a Data Entry Operator/MIS Executive
Location: Worli, Mumbai
Should be a Graduate
Immediate joiner will be preferred.

Share your CV at [email protected] only.

https://youtu.be/liUHmX5Q9Kg

Hi Everyone,

Do you know, you can change the shape of a series in Graph/chart of Excel/Powerpoint. Here is the steps_

1. create a shape or insert the picture.
2. Format the shape or adjust the picture
3. Copy it
4. Select any series in the graph/chart of Excel/Powerpoint
5. Paste it directly.

The shape of selected series will be replaced with your custom made shape/picture. Try it.

For More like the page:
MS Excel Formulae & Tricks

How to Change shape of series in graph/chart? Hi Everyone,Do you know, you can change the shape of a series in Graph/chart of Excel/Powerpoint. Here is the steps_1. create a shape or insert the picture.2...

Hi Everyone...

We have created & uploaded a small video on 'How to create a butterfly chart?' Please check, Like & share.

Please do not forget to share your feedback...
You can share your feedback in the comment box.

https://youtu.be/xUQ_BsaBjWg

https://chat.whatsapp.com/Fl5BkP41asW3j3vtZ4tdHZ

MSExcel Formulae & Tricks WhatsApp Group Invite

While creating a graph, sometimes we stuck to display the graph properly. In that scenario we can use the Combo graph and Secondary Axis option.
Attached images are showing how can we create a new Combo graph or change the existing one.

For more like the page
Join the whatsapp group for instant solution
https://chat.whatsapp.com/Fl5BkP41asW3j3vtZ4tdHZ