SP Advanced Excel Training

Happy Holi to everyone 🎉

Whenever we think about data Visualization or Charts, always Bar Charts comes in our mind first.
" Do you know the earliest version of a bar chart was found in 14th Century, a book by mathematician Nicole Oresme."

Happy New Year 2023

Why we make dashboards highly graphical?
Not only because it looks beautiful, but with graphical presentation we can often communicate with greater efficiency and richer meaning or understanding than text alone.

Dashboard
# # # # # # # # # # #
A dashboard is a visual display of the most important information needed to achieve
one or more objectives; consolidated and arranged on a single screen so the
information can be monitored at a glance.

The part of information technology that focuses on reporting and analysis currently goes by the name
business intelligence (BI).

What a advance techniques we can use in Excel to do some of tedious tasks in our daily life....hope this will be helpful for many more...

Steve Nouri on LinkedIn: 10 awesome Excel Tips for data analysts. I will start sharing the | 2458 comments 10 awesome Excel Tips for data analysts. I will start sharing the "40 days of Data Analytics" from the next week. Don't miss my posts, Click Follow here... 2458 comments on LinkedIn

Sorting
--------
The ability to sort is very important for and manipulation of . You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. You can also sort by a custom list (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set. Most sort operations are column sorts, but you can also sort by rows.

will also helps to the of your file. In other term, if you will do add/delete/apply formula operation those will work more way.

Hope this post will help you to compete your daily excel task fastly.

SP Advanced Excel Training

SP Advanced Excel Training Send a message to learn more

3 excel functions which we can be used for Reverse VLOOKUP are:
1. Index Match function
2. VLookup with Choose
3. XLoookup