![The Excel Hub](/img/default-banner.jpg)
- 148
- 1 367 244
The Excel Hub
United Kingdom
Приєднався 10 чер 2020
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
Subscribe for new videos every month!
For any enquiries, please contact:
theexcelhub@outlook.com
Subscribe for new videos every month!
For any enquiries, please contact:
theexcelhub@outlook.com
Excel Formulas Unleashed: Top 10 Must-Know Functions!
We cover the top 10 Excel functions you must know to boost your productivity and make your data analysis more powerful. Whether you are a beginner or an advanced user, these functions will help you automate tasks, analyse data and create dynamic spreadsheets with ease. The functions covered are: SUM, AVERAGE, VLOOKUP, IF, CONCATENATE, INDEX & MATCH, SUMIF, LEFT, RIGHT, TODAY & NOW. You will learn how to use these essential Excel functions with step-by-step examples and understand the practical applications of each one to enhance your spreadsheets.
Subscribe for weekly Excel tutorials, techniques and examples:
ua-cam.com/channels/gdRm6hepAn6Y0FqMZPLiAw.html
Please share this video with others that may find it useful:
ua-cam.com/video/NPrRyNdcaaU/v-deo.html
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview: (0:00)
SUM: (0:19)
AVERAGE: (0:57)
VLOOKUP: (1:24)
IF: (2:23)
CONCATENATE: (3:13)
COUNTIF: (4:07)
INDEX & MATCH: (4:43)
SUMIF: (6:09)
LEFT & RIGHT: (6:53)
TODAY & NOW: (7:50)
Subscribe for weekly Excel tutorials, techniques and examples:
ua-cam.com/channels/gdRm6hepAn6Y0FqMZPLiAw.html
Please share this video with others that may find it useful:
ua-cam.com/video/NPrRyNdcaaU/v-deo.html
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview: (0:00)
SUM: (0:19)
AVERAGE: (0:57)
VLOOKUP: (1:24)
IF: (2:23)
CONCATENATE: (3:13)
COUNTIF: (4:07)
INDEX & MATCH: (4:43)
SUMIF: (6:09)
LEFT & RIGHT: (6:53)
TODAY & NOW: (7:50)
Переглядів: 105
Відео
Top 5 Data Validation Techniques In Excel You Need To Know
Переглядів 1,4 тис.Місяць тому
We dive into essential data validation techniques in Excel to help you create error-free spreadsheets. Whether you’re a beginner or an advanced user, these tips will improve your data accuracy and consistency. You will learn how to set up basic data validation, create dropdown lists, use formulas for advanced validation, implement dependent dropdown lists and add custom error alerts and input m...
Master Excel With These Top 7 Conditional Formatting Tips!
Переглядів 5412 місяці тому
We dive into the powerful features of Conditional Formatting in Excel. Learn how to make your data more insightful and visually appealing with these tips: 1) Highlight Cells Rules 2) Top/Bottom Rules 3) Data Bars 4) Color Scales 5) Icon Sets 6) Custom Rules 7) Managing Rules. We cover everything from highlighting high sales figures to spotting trends with data bars. Perfect for beginners and ad...
Calculate 2024-25 UK Income Tax - Using VLOOKUP In Excel
Переглядів 2452 місяці тому
We cover how to calculate 2024-25 UK Income Tax in Excel. The UK follows a progressive system and therefore, the VLOOKUP function with its approximate match is particularly useful when calculating tax payments. We will start by calculating the deduction in the tax-free allowance based on the taxable income to account for incomes above £100,000. We will then identify the amount payable in each t...
How To Calculate And Plot Bollinger Bands In Excel - The Excel Hub
Переглядів 1923 місяці тому
Bollinger Bands are a technical analysis tool which are used to indicate potentially overbought or oversold conditions and trend identification among other uses. They consist of a middle band being a simple moving average, an upper band which is a certain number of standard deviations above the middle band and a lower band which is a certain number of standard deviations below the middle band. ...
Estimating VaR Using The Historical Simulation Method - Value At Risk In Excel
Переглядів 3054 місяці тому
We cover how to estimate Value at Risk (VaR). VaR is one of the most important risk measures in financial markets and it can be interpreted as a minimum loss that would be expected to occur over a given period of time. It can be measured either in currency units or percentage terms. There are three commonly used methods for estimating VaR: the parametric or variance-covariance method, the histo...
Estimating VaR Using The Parametric Method - Value At Risk In Excel
Переглядів 4485 місяців тому
We cover how to estimate Value at Risk (VaR). VaR is one of the most important risk measures in financial markets and it can be interpreted as a minimum loss that would be expected to occur over a given period of time. It can be measured either in currency units or percentage terms. There are three commonly used methods for estimating VaR: the parametric or variance-covariance method, the histo...
Stacked & Clustered Combo Chart In Excel - Mastering Data Visualisation
Переглядів 3086 місяців тому
We cover how to create a stacked and clustered combination chart in Excel. This type of chart is very useful if you want to visualise a multi-dimensional dataset in a digestible way. In our example, we have the global sales of two products across 4 quarters. We also show the breakdown of how much is coming from the US for each product in each quarter. We want to show how much of the sales is co...
Create A Dividend Discount Model To Value A Stock In Excel - The Excel Hub
Переглядів 4287 місяців тому
We cover how to create a Dividend Discount Model (DDM) to value a stock in Excel. The DDM is a present value model for valuing a stock which is based on the dividends paid by a company. Since dividends are less volatile than earnings, this may make the DDM less sensitive to short run fluctuations in the inputs than other models. Generally, this model is most suitable when a company is dividend ...
Project Timeline - Add Vertical Line To Represent Today's Date In Excel
Переглядів 1,2 тис.8 місяців тому
Creating a project timeline in Excel is beneficial compared to PowerPoint because it reduces manual effort and increases precision as you are able to place tasks exactly where you want to. Timelines are useful if you have a project and want to provide stakeholders with a big picture overview of future objectives or deadlines. We cover how to add a vertical line to show today’s date in a project...
Create A Residual Income Model To Value A Stock In Excel - The Excel Hub
Переглядів 1,6 тис.9 місяців тому
We cover how to create a Residual Income model to value a stock in Excel. Residual income is the income after considering all of a company’s capital. Residual income is also sometimes referred to as economic profit because it estimates the company’s profit after subtracting both debt and equity. This is unlike a company’s income statement which only includes a charge for the cost of debt in the...
Do Not Merge & Center, Use This Trick Instead To Sort Effectively - The Excel Hub
Переглядів 23110 місяців тому
We cover a useful trick to merge cells without using merge & centre and the drawbacks that come with it. In our example, we have fictitious investment fund data. For most of the funds, we have data for the Returns, ESG Rating, Fees and Fund Size. The exception is one fund where the data is missing. To make it look more presentable, we may want to merge the 4 cells that currently have N/A values...
Searchable List In Excel - Create A Dynamic Dropdown Using The FILTER, ISNUMBER & SEARCH Functions
Переглядів 48211 місяців тому
We cover how to create a dynamic, searchable list that is also sorted in alphabetical order. In our example, we have a list of student names. We want to be able to search for a text string and automatically extract the list of names that contains it. We also want to be able to incorporate this in a drop down list using data validation. To do this, we’re going to use several functions. The overa...
Add Borders Dynamically When Cells Are Populated - Conditional Formatting In Excel
Переглядів 820Рік тому
We cover how to add borders when cells are populated in Excel. In our example, we have a list of students and we have added borders around the names. However, as a default, when we add a new name, a border is not added and when we delete a name, the border is not removed. To overcome this, we can make our borders dynamic using conditional formatting. This ensures that they update as soon as cel...
Calculate CAGR (Compound Annual Growth Rate) For An Investment Period Over A Period Of Days In Excel
Переглядів 976Рік тому
We cover how to calculate the compound annual growth rate (CAGR) in Excel using daily figures. The compound annual growth rate calculates the rate of return over a period of time and it is often used to measure the past performance of investments or analyse business measures like sales or market value. In our example, we will calculate the compounded annual rate of growth a given company’s sale...
Open PowerPoint And Add Slides Using Excel VBA - The Excel Hub
Переглядів 1 тис.Рік тому
Open PowerPoint And Add Slides Using Excel VBA - The Excel Hub
Calculate 2023-24 UK National Insurance In Excel - The Excel Hub
Переглядів 7 тис.Рік тому
Calculate 2023-24 UK National Insurance In Excel - The Excel Hub
Calculate 2023-24 UK Income Tax - Using VLOOKUP In Excel
Переглядів 19 тис.Рік тому
Calculate 2023-24 UK Income Tax - Using VLOOKUP In Excel
Highlight Top And Bottom Bars Of A Chart Dynamically In Excel - Change Colour Of MIN And MAX Values
Переглядів 532Рік тому
Highlight Top And Bottom Bars Of A Chart Dynamically In Excel - Change Colour Of MIN And MAX Values
Create Dynamic Row Numbers - Numbered Lists Using ROW And SEQUENCE Functions In Excel
Переглядів 1,6 тис.Рік тому
Create Dynamic Row Numbers - Numbered Lists Using ROW And SEQUENCE Functions In Excel
Show Or Hide A Chart Based On A Condition In Excel - The Excel Hub
Переглядів 3,4 тис.Рік тому
Show Or Hide A Chart Based On A Condition In Excel - The Excel Hub
Mortgage Rate Change Calculator - Assess Impact Of Rising Interest Rates On Monthly Payments
Переглядів 471Рік тому
Mortgage Rate Change Calculator - Assess Impact Of Rising Interest Rates On Monthly Payments
Convert Chart To Picture Automatically In Excel Using Named Ranges - The Excel Hub
Переглядів 348Рік тому
Convert Chart To Picture Automatically In Excel Using Named Ranges - The Excel Hub
Smallest And Largest N Values In A Range Using SMALL And LARGE Functions - The Excel Hub
Переглядів 389Рік тому
Smallest And Largest N Values In A Range Using SMALL And LARGE Functions - The Excel Hub
Automate Investment Commentary - Dynamic Reporting On Stock Performance In Excel
Переглядів 784Рік тому
Automate Investment Commentary - Dynamic Reporting On Stock Performance In Excel
How To Graph Active Exposures Of A Fund In Excel - The Excel Hub
Переглядів 8242 роки тому
How To Graph Active Exposures Of A Fund In Excel - The Excel Hub
Forecast In Excel Using The GROWTH And TREND Functions - The Excel Hub
Переглядів 4,4 тис.2 роки тому
Forecast In Excel Using The GROWTH And TREND Functions - The Excel Hub
Calculate The Day Of A Week For A Date Using The WEEKDAY Function - The Excel Hub
Переглядів 2,1 тис.2 роки тому
Calculate The Day Of A Week For A Date Using The WEEKDAY Function - The Excel Hub
Show And Highlight Formulae In Excel - The Excel Hub
Переглядів 1742 роки тому
Show And Highlight Formulae In Excel - The Excel Hub
Create A Frequency Table And Histogram - Frequency Distribution In Excel
Переглядів 6212 роки тому
Create A Frequency Table And Histogram - Frequency Distribution In Excel
Can this example be downloaded
00:02:02, When you don't know maths you use =PMT()... when you know maths, you know exactly what you are doing... just use: =($A$12*(1+$A$6/100/12)^($A$10*12)*$A$6/100/12/((1+$A$6/100/12)^($A$10*12)-1) Where: $A$12 = mortgage $A$6 = interest (yearly) $A$10 = Term (years)
It changes chart into a line rather than keeping my chart
How to downlaod excel file?
Is there a tweak for the FV function to work from day one? Also why does the function give a negative value and that I have to add a negative sign at the beginning?
orange is too hard to read
the duration bar does come in the center of days complete and percentage bar. any idea how to make it at the bottom of it ? plz
Thanks
This is awesome! Question - how do you the same, but for charts created with Smart Art - when i use the same formula (i named my graph prior to lbk - IF($C$60="LBK 1441",lbk,"NA"), i receive a display of 15 horizontal and 30 vertical chart or cells with "#Ref!" in them. If i change the text of C60 to something else, i receive NA (which is expected). Again, i have named lbk the chart i created from Smart Art
Phenomenal!
Commenting for the algorithm - your solution was the best, thank you!
Thank you very much!
please send me same tamplate for my use
Hi @The Excel Club, A help, some how the scatter plot dots are not aligning with the Y Axis. If you have few mins, can you please help docs.google.com/document/d/12pgby_9IUJ7tCo9naeOxBDN3PgQ-GGsfs5TO9M5HxYI/edit?usp=sharing
You can change/adjust in Series options and put 9 hence the today's date line will hit the top of the chart...
This is very helpful. Thank you. The one thing that is missing (for me) is a way of inputting into a cell a number so that the password then generated will have that number of characters. To ensure that it has upper or lower case letters, numbers or special characters, there would, ideally, be options to have at least one of each. I've found plenty of guidance online on using Excel to generate passwords, but nothing that explains how to add these options.
could be hourly?
Amazing! Thank you
Please if you can make vedio on material stock also in projects
It's very useful n easy
Thanks for sharing, well done
Thank you
Thanks for watching!
I was just wondering how to change it to cover the Scottish Tax Rates. I'm thinking I just need to enlarge the array used by VLOOKUP to include the extra rows...
TY for reminding me that there are more format choices besides custom ones that I typically use.
Glad you found it useful!
A Truly excellent tutorial. Concise, yet not rushed. Well laid out and not overly complicated. Well done sir!
Perfect! Straight to the point! I thank you, so very much, for this very well done tutorial.
Thanks. Can I ask if a chart is created based on table it doesn’t automatically update ?
THIS IS NOT ACCURATE! The error is marginal, but with the biggest numbers the error can increase to millions. You cannot divide the interest directly by months. The interest must be calculated with a higher root =(1 + r) ^ (1/12) -1 (1+1.5%)^(1/12)-1 NOT 1.5%/12
Why did you use 2 for the upper and lower band?
What if I contribute monthly with different amount and I put it in Term deposit of 1 year and rollover principle + interest. How do I calculate that?
This video is excellent! Thank you for sharing!!
This is AWESOME TY
big help dawg
Great video, thanks for sharing
Hi, if there are a total of 3 levels, what do you do? Do you sum up the level 2 and multiply it by the level 1 weight?
Very nicely explained...unfortunately, the formula doesn't give me the correct rate. I got an answer of over 10% for one bond and I know that that's way overstated. I will keep researching this as it's good to know. Coupon rate really isn't telling us how much return we're getting.
Hey, do you have a tutorial for this video, how to make assessment
Perfect
/When I get to the Axis Format page, I don't have the date options. Why is that?
Thank you. I am going to try to create a template according to this. Good idea.
Great video, how can we exclude weekend in the progress bar?
Why is the Error bar grayed out on my Excel?
How can we connect table and pivot table with single slicer?
thank you
how would someone do this in google sheets?
How do you set up the % progress, what formula do you use?
Free
Hi I want learn us taxation and accounting
Finally!..An accent I can understand, thank you.
Happy to help!
Very helpful, thanks a lot
How to do this for combo chart?