ANALYTICS TRAINING HUB

MOD function is named after "Modulo" which is a computer term and the diviser used in division equation is called as "modulus". The function returns the leftover / remainder of one number divided by another divisor number. Watch Video !

The Excel  FIND  function returns the position of a character or sub-string within a supplied text string. Function returns output only in number form as the starting position of a character. Read More....

INT function returns a number after ignoring the fractional part of a number or in other words, it returns the whole value of a number. But this function returns to next lower integer value so when negative value is supplied, it becomes more negative. Also you will learn how we can convert timestamp in Microsoft Excel. Watch Here!

In this video tutorial, I have shared one of my friend's recent Interview experience with one of the Top MNC (Cognizant - Gurgaon). He was asked some of the tricky questions and he got stuck with few of them. I decided to make a series of some Hot Interview Questions and this is the first video in this series. In this tutorial, I have used VLOOKUP with MATCH and INDEX with MATCH functions to build a customize formula to "Perform Two 2 Way Lookup". The video teaches Beginning to Advanced Level of knowledge of both formulas. Watch Here!

Excel SUBSTITUTE Function can be used to replace one or more instances of any specific character or sub string in a give text string. The function is case-sensitive and does not support wild-card characters as well. Watch Here!

We have created Youtube Channel for Excel users. Through this channel we are trying to provide Excel tutorial and Excel tricks for those who has interest into learning Microsoft Excel from scratch and those who wants to upgrade their Excel knowledge. Please subscribe us to get the notification for all upcoming videos. https://www.youtube.com/channel/UCT0uGNH5koT5UpjZAgsjouA

Microsoft Excel FIND Function or Formula helps in searching the position of specific character or sub-string in a text string. In this short video, you can learn the use of FIND function to find the the first instance of any character. But you have to be careful as this function is Case-Sensitive and does not support wildcard characters as well. Watch here!

Having knowledge of Excel Keyboard shortcuts can be really useful. As not only it save lots of time, but also increases the productivity and make user work more faster. It is great to learn as many as Excel keyboard shortcuts we can, but in actual, we don’t use all of them all the time. Subscribe us !

What is IF function and when can we use it? In Excel  IF  function is a powerful feature that helps to get more calculated with less calculations. In other words we can say that  IF  function is used to get the results according to the customized requirement. Read More...

Find Function :-Returning the first occurrence is easy but returning nth occurrence of any character is little tricky. However, In this video, I talked about couple of methods (NESTED Find & FIND along with SUBSTITUTE Function) to return the nth occurrence of any substring in easy steps. You can also combine FIND function along with LEFT function to extract First word or First Name. FIND helps can helps in returning the position of space which later can be supplied to LEFT function, and then LEFT can return specific number of characters from the LEFT side of the text. Watch Here!

Combining text strings from multiple rows/columns/cells into one have been very common problem among basic excel users. However, it's very easy to do it using CONCATENATE which is built in Excel Function. It allows to merge maximum 255 set of text arguments in one single string. Read More...

This tutorial will explain the use of simple Excel functions and a blank spreadsheet to create an automated sales invoice template in Excel in just 15 minutes. You’ll also learn what all details could be required to create an invoice template. This Sales Invoice Template is best for someone who is dealing with products, goods, professional services and very useful for small business owners, freelancers and individuals alike as it can save a lot of their productive time. The functions and features have been used to create in this template are:- 1. Custom Number and date Formatting 2. TODAY, SUM & IF functions 3. Use of Border & Alignment

This tutorial demonstrate the 9 different tricks and tips used to calculate and return the Calendar Quarter, Fiscal Quarter and Customize Quarters from any Date in Excel.  Learn more about extracting Quarters, Fiscal Quarters, and Customize Quarters.

USE OF RIGHT FUNCTION: The Excel  RIGHT  function returns one or more character, based on the specified number of characters from the end of a supplied text string. Read More.....

An  Loan Amortization Schedule  which is also known as mortgage or loan schedule, is a list of payments that shows each loan repayment and a breakdown of the principle amount and the interest. It shows the breakdown so that you can see how much is going toward the principle and interest each month.  Apart from this, the schedule also shows the remaining balance after each payment has been made. In other words, it calculates your monthly loan repayment and lets you know how much of your monthly installment will go towards the principle and how much will be paid for interest. Read More....

Use of LEFT function: LEFT  function in Excel is used to extract one or more characters from the left side of a supplied text string. Syntax: =LEFT(text, num_chars) Read More...

There are several COUNT functions in Microsoft Excel to count the cells that contains specific type of data in the given range or list of arguments. The COUNTA function counts all the cells that contains any type of data. In other words, function counts non-blank cells within the supplied range. Read More....

There are hundred of Excel keyboard shortcuts which are important and can save lots of time however, few of them are very important. Also, knowing all the shortcuts are never easy but few important ones can easily be memorized. Whether it is jumping from one cell to another, expending selections, accessing ribbon commands or printing spreadsheet, almost everything in Excel can be controlled with the keyboards. In this article, I am going to talk about some  45   Quick Time Saving Excel Keyboard Shortcuts  that can increase your productivity by 30% to 40%. Read more.....