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
Permalink -- click for full blog post
Oct 25, 2008, Internal rate of return
The page explains what is internal rate of return and how to calculate IRR using Excel formulas.
Permalink -- click for full blog post
Oct 22, 2008, Author | advanced excel resource centre
A brief introduction of the author of Advanced Excel Resource Centre
Permalink -- click for full blog post
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.
Permalink -- click for full blog post
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?
Permalink -- click for full blog post
Sep 20, 2008, NPV FAQ
This page NPV FAQ contains questions posted by visitors and the answers provided by Advanced Excel Profit Center.
Permalink -- click for full blog post
Jul 1, 2008, What is excel used for in business
What is excel talks about how microsoft excel is used in businesses.
Permalink -- click for full blog post
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.
Permalink -- click for full blog post
Jun 28, 2008, Insert Ribbon in Excel 2007 Weekly Course
The insert ribbon allow users to insert non-standard excel items into the worksheet.
Permalink -- click for full blog post
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.
Permalink -- click for full blog post
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.
Permalink -- click for full blog post
May 19, 2008, Home Ribbon in Excel 2007 Weekly Course
The home ribbon consist mainly of common used functions in Excel 2007.
Permalink -- click for full blog post
May 15, 2008, Standard Ribbons in Excel 2007 Weekly Course
Find out more about the standard ribbons in Excel 2007.
Permalink -- click for full blog post
May 8, 2008, Ribbons inExcel 2007 Weekly Course
What is in the ribbons in Excel 2007 has ribbons instead.
Permalink -- click for full blog post
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.
Permalink -- click for full blog post
May 8, 2008, No Toolbar in Excel 2007
No more toolbar. Excel 2007 has ribbons instead.
Permalink -- click for full blog post
May 7, 2008, Excel 2007 Weekly Course
No more toolbar. Excel 2007 has ribbons instead.
Permalink -- click for full blog post
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.
Permalink -- click for full blog post
Mar 30, 2008, Site Search results
This page presents the site search results from this site. The search engine is powered by google.
Permalink -- click for full blog post
Jan 29, 2008, Income Tax Forms - IR8A
Consolidate salary data, for income tax form, from all the worksheets in a workbook.
Permalink -- click for full blog post
|