Microsoft Excel for everyone

11/02/2023

.

08/13/2023

This short tutorial explains the use of Excel WORKDAY and WORKDAY.INTL functions to calculate workdays with custom weekend parameters and holidays.
Microsoft Excel provides two functions specially designed for calculating weekdays - WORKDAY and WORKDAY.INTL

The WORKDAY function returns a date N working days in the future or in the past and you can use it to add or subtract workdays to a given date.
The Excel file used in this tutorial has been uploaded on the Watch Learn Grow Repeat group on Facebook

This short tutorial explains the use of Excel WORKDAY and WORKDAY.INTL functions to calculate workdays with custom weekend parameters and holidays.Microsoft ...

06/21/2023

Shout out to my newest followers! Excited to have you onboard!

Ravind Singh, Vimal Raj, Nigar Ahmad Afridi, Vissu Susarla, Hossam Sweelam, Saif Ullah, Hameed Jan, Sanjay Yadav Yadav, Ashish Jha, Manish Joshi, Saeed Anowar, QaXi Honey Jahan, Good Ness, Eyzs Villajuan, Himanshu Joshi

01/28/2023

https://www.youtube.com/watch?v=1Al89JRdk7A

Special Transpose - In response to a query on Whatsapp. Here was convert columns into a single column 8 rows at a time.

07/31/2022

In this video, we will show how to create searchable drop down list in Excel. This method will make it easier for the user to pick off an option from a drop down list. Here you type a word or a partial word and then click on the drop down list and only those options that start with the characters you had typed would show and the rest of the options are filtered out.

In you want to download the Excel file used in this tutorial then please browse to the Watch Learn Grow Repeat group on Facebook and download it.

If you liked this video then please give it a thumbs up and if you would like to see more videos like this then please subscribe.

In this video, we will show how to create searchable drop down list in Excel. This method will make it easier for the user to pick off an option from a drop...

07/20/2022

In this video, we will show how to create searchable drop down list in Excel. This method will make it easier for the user to pick off an option from a drop down list. Here you type a word or a partial word and then click on the drop down list and only those options that contain the word you had types would show and the rest of the options are filtered out.

In you want to download the Excel file used in this tutorial then please browse to the Watch Learn Grow Repeat group on Facebook and download it.

If you liked this video then please give it a thumbs up and if you would like to see more videos like this then please subscribe.

https://www.youtube.com/watch?v=Mbgo4aIn0wE

03/23/2022

Microsoft Excel only has support for vertical filtering. In this video we show you a work around to implement horizontal filtering.The Excel file used in th...

01/23/2022

Supposing you want to extracting text within specific characters from a cell in Excel, this video will show you step by step process on how to do exactly tha...

12/13/2021

https://www.youtube.com/watch?v=0WLsz2xS2G4

This is PART ONE of the TWO PART video series on ration analysis in Microsoft Excel and how to use MS Excel to try to figure out which company to invest in a...

12/13/2021

https://www.youtube.com/watch?v=hJ-Z7VvhfSA

In this video we would look at how to use linear regression to draw a trend line and how to estimate the performance of the housing market as an example when...

02/21/2021

Thermometer chart in Excel could be a good way to visually represent data when you have the actual value or achievement and the target value.

A few scenarios when where it can possibly be used is when analyzing sales performance of regions or sales rep, or employee satisfaction ratings vs the target value, company's actual market share versus desired or targeted share.

In this video, we will see the exact steps you need to follow to create a thermometer chart in Excel.

Download File: https://tinyurl.com/thermometergraph

Videos on creating dropdowns in Excel:

1) Searchable Drop-Down Lists https://www.youtube.com/watch?v=gsvpjsWSk9Q
2) Dependent drop-down lists in Excel https://www.youtube.com/watch?v=i1ZACQwAjwg
3) Dependent Drop Down Lists Advanced https://www.youtube.com/watch?v=n9KzwPQxXvU
4) Data validation and Drop Down Lists in Microsoft Excel - Live Stream https://www.youtube.com/watch?v=sS2cMiHDnmA
5) Data validation and Drop Down Lists in Microsoft Excel - ADVANCED https://www.youtube.com/watch?v=-tx3IBkTTuk

Subscribe to get awesome Excel Tips: https://www.youtube.com/watchlearngrowrepeat5?sub_confirmation=1

If you liked this video then please give it thumbs up! Thank you

Thermometer chart in Excel could be a good way to visually represent data when you have the actual value or achievement and the target value.A few scenarios ...