Excel

Excel related topic to be tagged

What is Data: 2 types of data and their general understanding

What is Data

Data are basically units of information that are usually numeric. Technically it is a set of values of qualitative or quantitative variables of a person(s)/subject(s) usually collected by observation.

Data is raw, unorganized which needs to be processed, organized, structured and to be presented in a given context to make it useful to be called as information.

Data could be primary or secondary depending on source of origination.

What is data
What is data

In a high level categorization we can bifurcate data as Qualitative and Quantitative

What is Qualitative data type

Qualitative data type are mostly in categorical form is non numerical and is available in textual and non descriptive form like rating “very satisfied”, “Yes/No”, “Male/Female”, “Observation/review of … Continue Reading

Excel Slicer: How to use Excel slicer to filter data

Excel Slicer: How to use Excel slicer to filter data

What Slicer in excel

Slicers are floating buttons in excel by which we can filter data in an excel table or pivot table. In addition to this slicer reflects the current filter state means what options are selected currently. We can move slicers anywhere in the sheet and even can change their size and color.

How to create Slicer

To create a slicer we need a pivot table or just an excel table. First, we need to go to the Insert tab in ribbon >> Filter section >> Slicer as shown in the below image.

Slicer 1
How to create Slicer

Click on Slicer a new pop up option will come … Continue Reading

How to add Developer Tab in excel | adding developer tab in excel

How to add Developer Tab in excel

The Developer Tab in excel is a very important tab to accomplish many tasks in excel. It contains Macro-related buttons, Add-ins, Controls, and XML. The Developer tab is not preloaded in excel.

How to load Developer tab:

Go to File >>Option

How to add Developer Tab in excel
Developer tab

Then Go to Customize Ribbon >> Check Developer button

Cutom ribbon
Custom Ribbon

A new option will be added in ribbon as a developer:

Developer ribbon
Developer ribbon

We can see for different blocks in developer tab which is very useful in report creating.

You can also read below article for more info.

https://www.excelcampus.com/vba/enable-developer-tab/

https://www.excel-easy.com/examples/developer-tab.htmlContinue Reading

VBA in Excel: What is VBA, How to use

VBA in Excel

VBA stands for Visual Basic Application. It is an event-driven programming language used by Microsoft for its applications. VBA helps in many way ways like creating an automation process of any activity that we do manually, creating user-defined functions, or any activity which is repetitive in nature. By using VBA in excel we can save time and resources.

How to use VBA in Excel

We can use it in two different ways either by using VBA editor or by recording Macro. The choice depends on the expertise and comfort level of the user.

Where is VBA in excel

To use VBA editor we need to open VBA editor either by pressing alt & F11 or go to … Continue Reading

How to use INDIRECT function in Excel

How to use INDIRECT function in Excel

In this blog post, we will try to understand about INDIRECT function of excel. The excel INDIRECT function returns a reference to a range. We can use this function to create a reference that won’t change if rows or columns are inserted in the worksheet. Or, cause it to create a reference from letters and numbers in other cells.
The INDIRECT function in excel has two arguments as seen in the below picture:

How to use INDIRECT function in Excel
Indirect function in excel
  1. ref_text: A cell reference or text string (or both), that creates the range reference. The referenced range can be a cell, a range of cells, or a named range.
  2. a1: TRUE or FALSE. Does the
Continue Reading

How to use MATCH function in Excel

How to use MATCH function in Excel

In this blog, we will be discussing MATCH function in excel. MATCH function basically helps in finding the position of a value. It will not fetch any number but will provide only the position of the lookup value in excel. This function is very helpful when it works with other functions like OFFSET/INDEX.

Let us understand the anatomy of excel MATCH function. It requires 3 input values as can be seen in the below picture.

How to use MATCH function in Excel
match function excel
How to use MATCH function in Excel
How to use MATCH function in Excel

match_type can be explained as below:

match function option
Match function option

In example 1: we will try to find out the position of USA in the country … Continue Reading

How to use HLOOKUP in Excel

How to use HLOOKUP in Excel

HLOOKUP is one of the functions provided by Microsoft Excel which helps us find a value for a particular reference value. Its functions are the same as VLOOKUP, just the difference exists in terms of fetching data horizontally instead of vertically.

This formula also requires 4 inputs as mentioned below:

HLookup1
How to use HLOOKUP in Excel 35
How to use HLOOKUP in Excel
How to use HLOOKUP in Excel 36

We will take an example to understand this in a better way. As we see in the below table we have data for student’s marks achieved in different subject. Now if I wanted to fetch data for a particular student for a particular subject then we will use HLOOKUP to … Continue Reading

How to use VLOOKUP function in excel | VLOOKUP formula in excel with example

How to use VLOOKUP function in excel

Excel Vlookup is the most sought formula in excel and is widely used by everyone. It is used basically for looking up values vertically means from the column.

Before learning how to use vlookup excel we need to understand about different inputs of excel vlookup formula. As we can see below picture there are 4 different inputs required for using excel vlookup function.

How to use VLOOKUP in excel
Vlookup formula

The explanation of values are given as given below:

How to use VLOOKUP in excel
How to use VLOOKUP in excel

Let us understand this by and example.

In the below table we can see the name of the person and sales done by them on the month on month basis. Now we wanted … Continue Reading

employee 3005501 1920

The History of MS Excel: A timeline

The History of MS Excel

The journey of Excel started in 1987 with Excel 2.0 as the first version for Windows. There never was an Excel 1.0 for DOS or Windows. Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.0 (to synchronize with the Macintosh version 2.2) in November 1987.
Excel 3.0 launched in 1990s and it included tool-bars, drawing capabilities, outlining, add-in support, 3D charts among the other features.
Excel 4.0 launched in 1992 and it introduced auto-fill options in Excel.
Excel 5.0 launched in 1993 includes VBA and it had the ability to automate the tasks in excel and has the capacity to create a user-defined … Continue Reading