Mapping, Grouping and Summarizing data in MS Excel
The video is showing how to use the mapping technique in Microsoft Excel to summarize data. The data being used…
MS Excel
Read More
Using the Fill Features in Excel
In this video, we will show you how to use the fill features in MS Excel. These features allow you…
Lookup Functions, VLookup, HLookup, XLookup and Lookup
In this video, we will show you how to use lookup functions, and what is the difference between various lookup…
Pivot Tables, Pivot Charts Filters and Slicers
In this video tutorial we will show you how to create pivot tables and pivot charts. How to use slicers,…
How to use COUPDAYBS/COUPDAYS/COUPDAYSNC to calculate number of coupon days
In this video tutorial we will show you how to calculate number of coupon days using COUPDAYBS, COUPDAYS and COUPDAYSNC…
How to use AMORDIGRC function to calculate depreciation
AMORDIGRC is used to calculate degressive depreciation. This function was created for French accounting system however after changes in their…
How to use ACCRIT function to calculate Accrued Interest
In this video tutorial we will show you how to calculated accrued interest using MS Excel built in ACCRINT function.
How to calculate variance and standard deviation in MS Excel and draw a chart
In this video tutorial we will show you how to calculate variance and standard deviation from a very simple dataset…
How to calculate arithmetic mode in MS Excel and display dataset on a chart
In this video tutorial we will show you how to calculate arithmetic mode from a very simple dataset in MS…
How to calculate arithmetic mean / average in MS Excel and display dataset on a line chart
In this video tutorial we will show you how to calculate arithmetic mean or average from a very simple dataset…