Advanced Excel resource centre hopes to be the center of choice for
Microsoft® Excel users who hope to achieve breakthrough in using Excel.
We hope fill this web site with resources where you could learn how to
apply Excel functions, formulas (also known as worksheet functions), tips
and tricks on using Excel.
This place is not going to just show you how to enter the formulas.
It is going to show you with examples on how to apply the formulas
in your day to day work. This is because some of these formulas are
useless on its own. But if we are to combine these formulas in a particular
situation, they can become very powerful.
May 15, 2013
All about excel functions
Knowing all the excel functions and making them work for you.
Continue reading "All about excel functions"
May 15, 2013
Circular Reference
What is circular reference and how to resolve it?
Continue reading "Circular Reference"
Apr 29, 2013
everydayExcel Money Manager
A revolutionary product on cash flow planning that is easy to use, powerful and deliver everything you have been asking for
Continue reading "everydayExcel Money Manager"
Mar 11, 2013
Understanding Excel Formulas
Excel formulas are also known as worksheet functions. They are usually used within a cell and you need to start off the formula with an equal sign.
Continue reading "Understanding Excel Formulas"
Mar 08, 2013
Advanced Excel Business Centre
Advanced Excel Business Lab is committed to share with you knowledge about advanced formulas/functions and how to use Excel for business. It contains many case studies on how Excel can be used to process and analyse data.
Continue reading "Advanced Excel Business Centre"
Feb 18, 2013
Adding Excel icons to the toolbar
You can improve your efficiency in excel by adding excel icons to the toolbar for your commonly used functions
Continue reading "Adding Excel icons to the toolbar"
Feb 18, 2013
Organizing the Excel Toolbars
How to organize your excel toolbars such that you maximise the use of the icons available to you.
Continue reading "Organizing the Excel Toolbars"
Feb 18, 2013
Excel Tips and Tricks
This page contains excel tips and tricks which are presented using case examples. Each example will show you how to make full use of the features or formulas that are readily available in Excel.
Continue reading "Excel Tips and Tricks"
Feb 12, 2013
Maintaining a master list
Mantaining a good master list will determine how much time you spend on collection and reporting.
Continue reading "Maintaining a master list"
Jan 30, 2013
Listing non-blank Cells
This write up show you how to display a list of non-blank cells in a worksheet. It works like an autofilter function.
Continue reading "Listing non-blank Cells"
Jan 23, 2013
Calculate working days
Calculating working days between 2 dates demonstrate the power of combined formula.
Continue reading "Calculate working days"
Nov 25, 2012
Numbers displayed as Text
When you extract numbers from a range of cells using LEFT, MID or RIGHT formulas, the extracted numbers are displayed as text.
Continue reading "Numbers displayed as Text"
Nov 17, 2012
Convert text to number
This page provides you with the solution to convert text to number and also text formatted formulas to real formulas.
Continue reading "Convert text to number"
Nov 17, 2012
Convert text formatted date to excel date
Convert text formatted dates to excel dates is one of the key challenges faced by Excel users, especially when they import records from ERP systems such as SAP.
Continue reading "Convert text formatted date to excel date"
Oct 12, 2012
Excel Leave Planner
The leave planner is designed to automatically present all the leave taken by the employees for the month.
Continue reading "Excel Leave Planner"
Oct 10, 2012
Author Advanced Excel Resource Portal
A brief introduction of Jason Khoo, the author of Advanced Excel Resource Portal.
Continue reading "Author Advanced Excel Resource Portal"
Aug 01, 2012
Excel Dynamic Hyperlink
The hyperlink function can be turned into a powerful search function.
Continue reading "Excel Dynamic Hyperlink"
Jun 29, 2012
Excel download
You can find various excel download that will show you how powerful Excel can be and others that enhances the power of Excel.
Continue reading "Excel download"
Jun 29, 2012
Excel Quick Access Toolbar
Excel Quick Access Toolbar is a very powerful tool yet many people including Excel gurus tend to underutilize it. This toolbar gives you all the build in functions available in Excel including those that are not seen in Excel ribbon.
Continue reading "Excel Quick Access Toolbar"
Jun 25, 2012
Tracking changes in Excel
This tracking changes page demonstrates how you could identify who makes changes to the workbook.
Continue reading "Tracking changes in Excel"