In this video we calculate the percentage of year complete using an Excel formula.
This formula can calculate the percentage complete of a date from any start date, so is not limited to just a calendar year starting on the 1st January.
**FREE Instant do...

From Computergaga

In this video we calculate the percentage of year complete using an Excel formula.
This formula can calculate the percentage complete of a date from any start date, so is not limited to just a calendar year starting on the 1st January.
**FREE Instant do...

From Computergaga

In this video we show 5 secret Text to Columns tips. These examples are not taught by others, leaving Excel users unaware of some great tips.
Text to Columns is used to split text in a cell over multiple columns. It is a great tool for manipulating text ...

From Computergaga

In this video we show 5 secret Text to Columns tips. These examples are not taught by others, leaving Excel users unaware of some great tips.
Text to Columns is used to split text in a cell over multiple columns. It is a great tool for manipulating text ...

From Computergaga

In this video we will use the COUNTIFS function to create a conditional rank formula.
Although Excel has a RANK function to rank values in a list, it does not have a RANKIF function for conditional rankings.
The good news is though that there are ways t...

From Computergaga

In this video we will use the COUNTIFS function to create a conditional rank formula.
Although Excel has a RANK function to rank values in a list, it does not have a RANKIF function for conditional rankings.
The good news is though that there are ways t...

From Computergaga

Learn how to use the Excel VBA MsgBox function with these 6 examples.
When starting out earning Excel VBA, the Message Box function (MsgBox Function) is one of the first ones that you learn.
It provides an instant satisfaction in seeing some code workin...

From Computergaga

Learn how to use the Excel VBA MsgBox function with these 6 examples.
When starting out earning Excel VBA, the Message Box function (MsgBox Function) is one of the first ones that you learn.
It provides an instant satisfaction in seeing some code workin...

From Computergaga

In this video we use the SUMPRODUCT function to calculate the weighted average of a range of values.
When calculating the average, all values are assumed to be equal.
However the weighted average, or weighted arithmetic mean, applies a greater weight t...

From Computergaga

In this video we use the SUMPRODUCT function to calculate the weighted average of a range of values.
When calculating the average, all values are assumed to be equal.
However the weighted average, or weighted arithmetic mean, applies a greater weight t...

From Computergaga

In this video we link together 2 combo boxes so that the second combo box options are dependent upon the selection from the first combo box.
In this example, the list is very large so the Advanced Filter is used to return the correct entries for the seco...

From Computergaga

In this video we link together 2 combo boxes so that the second combo box options are dependent upon the selection from the first combo box.
In this example, the list is very large so the Advanced Filter is used to return the correct entries for the seco...

From Computergaga

In this video we show the simplest way to create dependent combo boxes on a userform with Excel VBA.
Each list is named to identify them. In VBA a Select Case statement is used to test what was selected in the first combo box, and select the options for ...

From Computergaga

In this video we show the simplest way to create dependent combo boxes on a userform with Excel VBA.
Each list is named to identify them. In VBA a Select Case statement is used to test what was selected in the first combo box, and select the options for ...

From Computergaga

In this video we show 5 examples of using Conditional Formatting with dates.
Working with dates is a very common use for Conditional Formatting. Highlighting the overdue dates, and milestone dates etc.
Did you know the formulas shown in this video?
Enr...

From Computergaga

In this video we show 5 examples of using Conditional Formatting with dates.
Working with dates is a very common use for Conditional Formatting. Highlighting the overdue dates, and milestone dates etc.
Did you know the formulas shown in this video?
Enr...

From Computergaga

In this beginners guide to For loops in Excel VBA we show 4 examples of For Loops in action.
To learn Excel VBA fast, enrol in our online course for just $10 - https://www.udemy.com/excel-vba-course/?couponCode=YOUTUBE10
Understanding loops is essential...

From Computergaga

In this beginners guide to For loops in Excel VBA we show 4 examples of For Loops in action.
To learn Excel VBA fast, enrol in our online course for just $10 - https://www.udemy.com/excel-vba-course/?couponCode=YOUTUBE10
Understanding loops is essential...

From Computergaga

In this video we use a custom formula as a Data Validation rule to allow uppercase entries only.
In this example we want to control the input of UK postcodes. So we need to allow the entry of text and numbers, but the text must be uppercase.
We use a fo...

From Computergaga

In this video we use a custom formula as a Data Validation rule to allow uppercase entries only.
In this example we want to control the input of UK postcodes. So we need to allow the entry of text and numbers, but the text must be uppercase.
We use a fo...

From Computergaga

Find the top 10 values in a range with one Excel formula. This video shows you how to apply a formula to 10 cells in one go to return the top 10 values, and other data associated with them.
Think you need to improve your Excel formula skills?
Sign up for...

From Computergaga

Find the top 10 values in a range with one Excel formula. This video shows you how to apply a formula to 10 cells in one go to return the top 10 values, and other data associated with them.
Think you need to improve your Excel formula skills?
Sign up for...

From Computergaga

In this video we sum the top 5 values in a range using an Excel formula. This formula can easily be adjusted to sum the top 3, top 10 or whatever you need.
Think you need to improve your Excel formula skills?
Enroll in our Excel Formulas Made Easy cours...

From Computergaga

In this video we sum the top 5 values in a range using an Excel formula. This formula can easily be adjusted to sum the top 3, top 10 or whatever you need.
Think you need to improve your Excel formula skills?
Enroll in our Excel Formulas Made Easy cours...

From Computergaga