Admin 
You can compare data in a column and match the content to a different column. Different Excel formulas can be used to compare two columns, find the matches in the column and return a value. In this article, I will show you different methods you can use to compare data from different columns. Option one
A macro is an excel feature used to automate tasks. As an accountant, you always carry out repetitive tasks each day and you can automate some of those tasks to make your work easier. A macro is a set action recorded through the visual basic application to help in speeding up operations with an organization.
This tutorial is suitable for individuals who generate reports for complex data processes using Ms. Excel charts, Gantt charts, Pivot tables among other tools. What is excel dashboard? A dashboard tracks metrics, data points, and KPIs in a single central place. It provides a quick visual status update of your projects and important details in
IF statement Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. An if statement with four outcomes requires you to test three conditions The excel If () function is used to test a single condition that returns a value if the condition is met otherwise
VLOOKUP function returns a corresponding value of the first instance in a lookup value. The function searches specific values defined and returns the matching value in another column. The VLOOKUP function, just as the name looks up a value in the first column of a specified range of cells and then returns the results on
IF statement is used to test whether a certain condition is met. Sometimes you can have more than one condition to test, thus creating an If statement within another if statement (nested if statement). This enables you to come up with a statement with many possible outcomes. The excel If () function is used when
Concatenate is an excel function that allows you to join two or more strings together. When creating a Pivot table, you may want to combine data from two or more columns to form a single column. An example, you may wish to combine the names field with the address field to form a single column
A Pivot table is one of the powerful features in excel for any data analyst. The feature allows you to extract data from a large dataset. You can also create a multi-level Pivot table to analyze data. To help you understand how to create a nested PivotTable, we will use a data set consisting of
1. TODAY function This function returns the current date. This function is useful when you want the current date displayed on your worksheet. The returned value will be updated each time the worksheet is recalculated or when you open the workbook. Syntax =TODAY () The function has no arguments. Example =TODAY() this function returns current
Find and replace is an excel feature used to search for specific data in an excel worksheet or within a workbook and what you do with the data found. This article will explore different ways you can use find and replace together with using advanced find features. Scanning through columns and rows in a large