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

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

Top 20 + common Excel questions for your job interview

This page list all common Excel questions for your job interview and their answer. This page will be updated regularly to ensure it’s most updated accuracy. Please come back regularly or consider to have this page bookmarked. Common Excel questions for your job interview 1) What is Microsoft Excel? Microsoft Excel is software that is … 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