advanced excel header

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.


Jun 22, 2009, Excel Chart

How to Use Excel chart to Choose the Right Fund for Your Insurance Policies

Permalink -- click for full blog post


Jun 14, 2009, Lookup - An alternative to IF funtion

Lookup function is one of the most useful functions in Ms Excel. We will tell you why in this page.

Permalink -- click for full blog post


Jun 10, 2009, Install an Excel Addin

Find out how to install an Excel Addin.

Permalink -- click for full blog post


Jun 9, 2009, Data Consol

You can use this page to request for our program on data consolidation.

Permalink -- click for full blog post


Jun 9, 2009, Data Consol

You can use this page to request for our program on data consolidation.

Permalink -- click for full blog post


Jun 9, 2009, Data Consol

You can use this page to request for our program on data consolidation.

Permalink -- click for full blog post


Jun 9, 2009, 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.

Permalink -- click for full blog post


Jun 3, 2009, Excel Calendar Template

This powerful Excel calendar template is developed using only formulas. No Macro is used. A wonderful display of Excel formulas power.

Permalink -- click for full blog post


Jun 2, 2009, What Your Insurance Agents Never Show You

How to Use Excel to Choose the Right Fund for Your Insurance Policies

Permalink -- click for full blog post


Jun 2, 2009, Excel VBA and ADO join

You can join 2 or more data tables together using different types of ADO joins in this page.

Permalink -- click for full blog post


May 9, 2009, Excel VBA and ADO Programming

Using Excel VBA ADO, you are able to combine multiple data tables and retreive records from databases.

Permalink -- click for full blog post


May 9, 2009, Sales Marketing Analytics and Report with Excel course

This advanced excel course in sale & marketing will impart participants with the knowledge on how to exploit the Excel functions in a creative way to achieve the business objectives. This is an online video version of our Tried and Tested Classroom Excel Course.

Permalink -- click for full blog post


May 9, 2009, Understanding the excel date and time functions

Learn more about excel date functions and how to apply them in Excel

Permalink -- click for full blog post


Apr 26, 2009, Calculate Net Present Value

Net present value is one of the method used to evaluate the viability of an investment. In this page, we will show you how to calculate NPV using Excel formula.

Permalink -- click for full blog post


Apr 25, 2009, Import Data from SAP into Excel

How to convert dates downloaded from SAP into proper excel dates

Permalink -- click for full blog post


Apr 25, 2009, 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


Apr 23, 2009, Developing Business Report with Charts

Creating Business Report using Excel Charts could make a lot of difference to your communication. In this page, we will show you the difference between an all number report and one using charts and tables.

Permalink -- click for full blog post


Apr 23, 2009, Developing Business Report with Charts

Creating Business Report using Excel Charts could make a lot of difference to your communication. In this page, we will show you the difference between an all number report and one using charts and tables.

Permalink -- click for full blog post


Apr 23, 2009, Developing Business Report with Charts

Creating Business Report using Excel Charts could make a lot of difference to your communication. In this page, we will show you the difference between an all number report and one using charts and tables.

Permalink -- click for full blog post


Apr 19, 2009, How to calculate depreciation using Excel

Calculating depreciation in Excel is relatively simple if you know the formula to do the job.

Permalink -- click for full blog post

Home
Tips and Tricks
Excel Functions
Excel Formulas
Excel Training
Excel Macro
Business Uses
Download
Excel Tests
Website Updates
About us
Ask Us
Free eCourse
Learn 2007
Excel Book

Subscribe To This Site
XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Add to Newsgator
Subscribe with Bloglines