Microsoft Excel for everyone

Microsoft Excel for everyone This is a page where we share our knowledge of Microsoft Excel and make it easier for everyone to us

11/02/2023

.

This short tutorial explains the use of Excel WORKDAY and WORKDAY.INTL functions to calculate workdays with custom weeke...
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 ...

Shout out to my newest followers! Excited to have you onboard!Ravind Singh, Vimal Raj, Nigar Ahmad Afridi, Vissu Susarla...
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

In this video, we will show how to create searchable drop down list in Excel.  This method will make it easier for the u...
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...

In this video, we will show how to create searchable drop down list in Excel.  This method will make it easier for the u...
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...

https://www.youtube.com/watch?v=0WLsz2xS2G4
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...

https://www.youtube.com/watch?v=hJ-Z7VvhfSA
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...

Thermometer chart in Excel could be a good way to visually represent data when you have the actual value or achievement ...
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 ...

Address

117-405 Bayfield Crescent
Saskatoon, SK
S7V1J4

Alerts

Be the first to know and let us send you an email when Microsoft Excel for everyone posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share