Excel

What is SUMIF Function? SUMIF is the function used to sum the values according to a single criterion. Using this function, you can find the sum of numbers applying a condition within a range. This function comes under Math & Trigonometry functions. Similar to the name, this will sum if the criteria given is satisfied….

What is Sparklines in Excel? Sparkline in Excel is a small graph which is used to represent a series of data. Apart from a well-fledged chart, it fits into a single cell. Three different data visualizations available in Excel Sparkline are: Line Column Win/Loss It is an instant chart that prepares for a range of…

What is VLOOKUP? Vlookup (V stands for ‘Vertical’) is an in-built function in excel which allows establishing a relationship between different columns of excel. In other words, it allows you to find (look up) a value from one column of data and returns it’s respective or corresponding value from another column. Usage of VLOOKUP When…

What is ISBLANK Function? ISBLANK function used to check whether a cell is empty or not. Since this is an information function, it always returns a Boolean value, true or false. If the cell contains a value it will return false and true will be returned if it is not empty. ISBLANK function in excel…

Key Difference between CSV and Excel CSV is a format for saving tabular information into a delimited text file with extension .csv, whereas Excel is a spreadsheet that keeps files into its own proprietary format viz xls or xlsx. CSV is a plain text format with a series of values separated by commas, whereas Excel…

What is Office 365 Cloud? Office 365 is a cloud-based product suite containing Microsoft programs for office use that can be run locally and synchronized to cloud storage. With the help of Office 365, you can work from anywhere and share the work documents with your colleagues worldwide. It helps individuals as well as businesses…

Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This tutorial will focus on that complexity. What is an…

There will be times when you will be required to analyse large amounts of data and produce easy to read and understand reports. Pivot tables allow us to analyse such data and produce reports that meet our business reporting requirements. What is a Pivot Table? A Pivot Table is a summary of a large dataset…