## 5 Things That You Should know About Excel | Excel For Absolute Beginners

This walkthrough illustrates: Creating your first Notebook Understanding the Interface Understanding Cells and Entering your first data Saving Your notebook: Printing the Workbook   Aimed At: People who know nothing about Excel and want to know the Basics Prerequisites: Please Read: Our Previous Post : Things to know about Excel Lets Start ! 1) Creating … Read more

## How to create a pivot table from multiple sheets (data sources) in excel using Pivot Table Wizard

How to create a pivot table from multiple sheets (data sources) in excel? From my previous blog, I have illustrated How to create pivot table in excel. The pivot table was using data from one single location. However, what about if the data itself is from multiple sources. Is it possible to create a pivot … Read more

Let me tell you a secret, Excel has not put all its functions into their ribbons or Excel Quick Access Toolbar. This blog will illustrate how to manipulate the Excel Quick Access Toolbar. Quick Access Toolbar is the bar that allows users to quickly access to some functions. It is located to the top left … Read more

## All Excel Worksheet Functions

The following table listed all Excel worksheet functions

## ABS function – How to get absolute value in excel

This blog explains how to get absolute value in Excel using the ABS function with syntax and examples. How to get absolute value in Excel? The Microsoft Excel ABS function returns the absolute value of a number. What is an absolute value? The absolute value represents its value without its sign. For example: [vtftable ]Value;;;Absolute Value;nn;-1;;;1;nn;+1;;;1;nn;0;;;0;nn;[/vtftable] … Read more

## How to define a range in Excel dynamically

From my previous blog – How to define a range in Excel, I have illustrated how to name a range. We can also define a range in Excel dynamically using the offset excel function. To create a dynamic range, we will use the “offset” function” in Excel offset excel function The Offset excel function returns … Read more

## How to recover a deleted sheet in Excel?

How to recover a deleted sheet? Can you recover a deleted sheet? As mentioned from my previous blog – How to manipulate sheets in Excel, once the delete sheet operation is non-reversible. What if I have deleted a sheet by mistake. Am I going to lose everything I have done on the sheet? My answer … Read more

## How to manipulate worksheets in Excel

How to manipulate worksheets in Excel? As mentioned from my other blogs – How to create a new excel file? – an Excel spreadsheet can have multiple sheets in one file. You can add, rename, move, delete, hide, unhide entire spreadsheet as long as to change colour of the spreadsheet. If you are using Excel … Read more

## How to Add/Update or delete a comment to a cell in Excel

Excel allow users to make comments for any cells in the spreadsheet. By default, those comments are visual only when the cell have been hovered by the mouse. Other time, Excel simply place a red triangle on the top-right corner to indicate there is a comment for the cell. ADD COMMENT Following is the steps … Read more