Скачать или смотреть #HowTo

More than 80% companies worldwide, use Excel for doing daily tasks. It is an incredibly powerful tool in business. Learning excel helps to climb the career ladder comparatively faster.

To learn MS Excel and enhance your skills, enrol in our upcoming Excel course.

*Duration*: 20 Hours
Starting from 23rd Nov 2020
Mon – Fri: 7:00 am – 8:30 am IST
Live on Zoom (NO PRE-RECORDED)

Investment:
MRP : ₹ 7,999 + GST
Diwali Offer Price: ₹ 3,999 + GST
(Use promo code *DIWALI*, Limited Period Offer)


To know more about the course, click on the below mentioned link:
https://excelinexcel.in/eielearning

The Excel UNIQUE and Excel SORT are two functions in MS Excel functions that have been added recently and currently available in Office 365.
While the Excel UNIQUE function helps extracts a list of unique values from a range, the Excel
SORT function can help SORT the contents of a range or array.

The output of using the UNIQUE or SORT functions is a dynamic array of values. If this array is the final stage of our work and not an intermediate step to hand off to another function, the array values will "spill" onto the worksheet into a range. This range automatically updates when new unique values are added or removed or when the original values are changed from the source range.
By default, the SORT function will sort values in ascending order using the first column. By using the optional arguments sort_index and sort_order we can choose which column to sort by, and the order of sorting.

In this video, we can see how we can use the Unique and the Sort Functions in MS Excel.

Visit: www.ExcelinExcel.in, an online resource center that seeks to equip users with knowledge about MS Excel with excellent content supported by examples, case studies, and short videos.

Please give this video a Like and subscribe to our channel to Learn more on MS Excel. In the comments section, please share your thoughts and let us know about things that you wish us to cover in our forthcoming videos.

Connect with us on:
Facebook at   / theexcelinexcel  
Twitter at   / theexcelinexcel  
Instagram at   / theexcelinexcel  
LinkedIn at   / theexcelinexcel  
#excel #microsoftexcel #exceltutorial #learnexcel #shortcuts #unique #distinct