Updates to Advanced Excel Site

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.

Nov 13, 2008, Answer to Ask Jason Questions

Answer to questions people Ask Jason Khoo

Oct 25, 2008, Internal rate of return

The page explains what is internal rate of return and how to calculate IRR using Excel formulas.

Oct 22, 2008, Author | advanced excel resource centre

A brief introduction of the author of Advanced Excel Resource Centre

Oct 18, 2008, Business Uses of Excel

The Business Uses of Excel is very broad. It is used in different business functions as describe in this page.

Oct 17, 2008, Create Excel Calendar with formulas

Creating an excel calendar is not easy. Most people resort to using Macro for such a task. But do you know that a calendar can also be created purely using formulas?

Sep 20, 2008, NPV FAQ

This page NPV FAQ contains questions posted by visitors and the answers provided by Advanced Excel Profit Center.

Jul 1, 2008, What is excel used for in business

What is excel talks about how microsoft excel is used in businesses.

Jun 29, 2008, Page Layout Ribbon in Excel 2007 Weekly Course

The page layout ribbon allow users to set options and layout the worksheet for printing.

Jun 28, 2008, Insert Ribbon in Excel 2007 Weekly Course

The insert ribbon allow users to insert non-standard excel items into the worksheet.

Jun 5, 2008, Organizing the Excel Toolbars

How to organize your excel toolbars such that you maximise the use of the icons available to you.

May 19, 2008, Budgeting Tool | business planning

This budgeting tool article presents to budget managers the consideration they have to be aware of when they evaluate a budgeting tool for their companies.

May 19, 2008, Home Ribbon in Excel 2007 Weekly Course

The home ribbon consist mainly of common used functions in Excel 2007.

May 15, 2008, Standard Ribbons in Excel 2007 Weekly Course

Find out more about the standard ribbons in Excel 2007.

May 8, 2008, Ribbons inExcel 2007 Weekly Course

What is in the ribbons in Excel 2007 has ribbons instead.

May 8, 2008, Menu in Excel 2007

No more menu in Excel 2007. Find out how to save and open a file within excel 2007.

May 8, 2008, No Toolbar in Excel 2007

No more toolbar. Excel 2007 has ribbons instead.

May 7, 2008, Excel 2007 Weekly Course

No more toolbar. Excel 2007 has ribbons instead.

May 7, 2008, Excel 2007 Weekly Course

Here is a free excel 2007 course for those who are or going to convert from 2003 to 2007.

Mar 30, 2008, Site Search results

This page presents the site search results from this site. The search engine is powered by google.

Jan 29, 2008, Income Tax Forms - IR8A

Consolidate salary data, for income tax form, from all the worksheets in a workbook.