Advanced Excel Tips and Tricks

[Saurav Agrawal - Founder at XLearning - Excel in Excel]

Greetings!!

Hope you and your families are keeping well!

Please go through this mail to free up time for analytics rather than data making. 

MS Excel is an application which we all use for our work life and slight improvisation in the way of working can free us a lot of time for analysis rather than data making. 

Here i have come up with my youtube channel to share such tips and tricks in MS excel to reduce our data making time and focus more on analytics.

PFB link to be channel and the videos i have uploaded (Kindly subscribe / share with acquaintances if you like the contents).

• Channel Link: https://www.youtube.com/channel/UCsU28TomcP-FnKUQPxb0DTQ?view_as=subscriber

• Fuzzy Lookup: https://youtu.be/YErnFVi8hc4

• Sumif with wildcard character (*): https://youtu.be/_d3fC5H951A

• Picture Lookup in MS Excel: https://youtu.be/bEuw0UYsu4U

• Convert numbers formatted as text to numbers: https://youtu.be/P8dpnVs18QI

• Interactive Filter in Table: https://youtu.be/vyCnsWKECM8

Thanks and Regards,

Saurav Kumar Agrawal

Management Consultant and Excel Trainer

Ph.: +91 98837 43840 / 9073903607 / 9830034737