SP Advanced Excel Training

25/03/2024

Happy Holi to everyone 🎉

22/03/2024

Hello Everyone introducing new upgraded version of SP Advanced Excel Training as SP Advanced Analytics!

Holi combo offer on Tableau+SQL course only on 6000/- INR with 5 additional features FREE!
.com

Visit our page : [email protected]" rel="ugc" target="_blank">[email protected]

05/01/2023

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

22/08/2022

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.

12/08/2022

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.

28/07/2022

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

18/06/2022

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...

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

26/07/2021

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

Send a message to learn more

04/07/2021

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