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
|
