How to use VLOOKUP in Excel
In this article, we will cover VLookup. To follow along with us make sure you have a copy of this file downloaded using the button below. There are three worksheets, “See it”, “Do it”, and “Data”. “See it” is where…
Category Microsoft Excel Tutorials
Through Excel Learning series my aim is to help you learn Excel. These videos are produced using the Excel 2016 version, however, shall help you learn even if you are using Excel 2019, 2007, 2010, 2013 as they all have same basics with some differences which I will highlight in the course to enlighten you.
I will produce 1 or more than 1 video every week. If I get enough room to produce these videos, I will ensure to bring you at least 1 video every day.
How to use Excel Count Functions
Overview of Excel Functions Excel count functions or very handy and help you in a great way to deal with their assets when it comes to Counting stuff inside Excel. In this article, we are going to talk about five…
Excel Learning – SumIF and SumIFS
In this episode of the Excel Learning Series, we are going to talk about the SumIF and SumIFS function in Excel. We also have AverageIF and AverageIFS functions in excel, however, we are not going to talk about that in…
Calculate Bonus in Excel Using IF Function
Calculate Bonus in Excel Using IF Function video demonstration will help you to understand how you can use if function to calculate bonus of given set of employees. In this video demonstration, we also covered how we calculated the results…
Excel Logical Functions IF, AND, OR
Excel Logical Functions IF, AND, OR video demonstration will help you with the learning of Microsoft Excel logical functions. In the Excel Logical Functions video demonstration, we will cover how to use IF FUNCTION, how to use OR FUNCTION, and…
Excel Pay Rate and Downtime Cost Calculation
Excel Pay Rate and Downtime Cost Calculation video demonstration will help you to calculate the payment by hour In Excel. In this video demonstration, we have also covered how to calculate the cost of downtime during system outages when you…
Rounding Day, Hour and Minutes in Excel
With round day, hours, and minutes in Excel demonstration, I will help you you to learn rounding the numbers (day/minute/hour) to the nearest day, hour or minute in Excel. In this video demonstration, we will be using two functions of…
You must be logged in to post a comment.