Free Excel Database Download

Free Excel Database for Practice 1.01

ZWC Database 1.01 – Overview With this article, I aim to provide you with a sample database for excel. You may use this database as per your needs and practice to enhance your Excel skills. About Free Excel Database Download The database contains a list of 100,000 records with fictitious names. We have put together […]

Calculate Bonus in Excel Using IF Function

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 using the combination of IF & AND function and IF & OR function which were […]

Excel Logical Functions IF, AND, OR

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 how to use AND FUNCTION. Video Demonstration By the end of this video, you should […]

Excel Pay Rate and Downtime Cost Calculation

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 are aware of the cost incurred per minute. We are also briefly covered how to […]

Rounding Day, Hour and Minutes in Excel

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 Excel. Round function to round to the closest value and MRound function to round with […]

Find Quarter in Excel

Calculate Quarter in Excel

How to find quarters in Excel is a video demonstration where we will help you to understand how you can calculate a value for quarters from any given date. With the help of this video, you will be able to learn how to extract quarter values with different scenarios of Fiscal years. Calculation of quarters […]