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.
May 18, 2012
Excel Leave Planner
The leave planner is designed to automatically present all the leave taken by the employees for the month.
Permalink -- click for full blog post "Excel Leave Planner"
May 16, 2012
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.
Permalink -- click for full blog post "Excel Tips and Tricks"
May 16, 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.
Permalink -- click for full blog post "Excel Quick Access Toolbar"
Apr 30, 2012
Table of Content for Excel Workbook
You can create a table of content page for your Excel workbook so that users can easily navigate through the worksheets without getting lost.
Permalink -- click for full blog post "Table of Content for Excel Workbook"
Apr 8, 2012
CPF - Central Provident Fund
excelPays helps you to calculate the CPF of the workers in your company.
Permalink -- click for full blog post "CPF - Central Provident Fund"
Apr 5, 2012
CPF confirmation
excelPays helps you to calculate the CPF of the workers in your company.
Permalink -- click for full blog post "CPF confirmation"
Feb 29, 2012
Thank you for asking us a question about Excel
Thank you for asking Jason Khoo a question about Excel.
Permalink -- click for full blog post "Thank you for asking us a question about Excel"
Feb 21, 2012
Swop columns and rows in a table
Swop the columns and the row of data downloaded from the system.
Permalink -- click for full blog post "Swop columns and rows in a table"
Feb 21, 2012
Lottery confirmation
Matching the lottery numbers against the winning numbers
Permalink -- click for full blog post "Lottery confirmation"
Feb 21, 2012
Lottery thank you
Matching the lottery numbers against the winning numbers
Permalink -- click for full blog post "Lottery thank you"
Feb 21, 2012
Lottery
Matching the lottery numbers against the winning numbers
Permalink -- click for full blog post "Lottery"
Feb 15, 2012
Excel Book - Hidden Secrets of Data Analysis with Excel
This excel book is published to share with practitioners on how to work with Excel like a pro, swift and accurate.
Permalink -- click for full blog post "Excel Book - Hidden Secrets of Data Analysis with Excel"
Feb 3, 2012
The purpose of Find All
Find all was introduced in Excel 2003. The purpose of find all is to help to select cells containing the find condition.
Permalink -- click for full blog post "The purpose of Find All"
Jan 26, 2012
Advanced Excel book for Sales & Marketing Professionals
This excel book contains case studies developed from questions and enquiries fielded by participants from different business functions.
Permalink -- click for full blog post "Advanced Excel book for Sales & Marketing Professionals"
Jan 12, 2012
SUBTOTAL Formula - calculating visible cells
The SUBTOTAL formula can perform 11 different calculattions and is a very powerful fomula when used together with the Auto-filter function .
Permalink -- click for full blog post "SUBTOTAL Formula - calculating visible cells"
Nov 21, 2011
Mr.Ng
excellent tips very helpful. hope to learn more from this site. Share: when using vlookup you can use names and indirect function in order to refer
Permalink -- click for full blog post "Mr.Ng"
Oct 24, 2011
excel calendar 2012
This Excel calendar is the improved version of an earlier calendar we have developed. In this calendar, we made use of the new conditional formatting functionin Excel 2007/2010.
Permalink -- click for full blog post "excel calendar 2012"
Oct 18, 2011
Understanding Excel Formulas
Most of the excel formulas by themselves are of no value to users. Their values are only recognized and appreciated when they are applied to a data set containing hundreds of records.
Permalink -- click for full blog post "Understanding Excel Formulas"
Oct 18, 2011
IF Function - clssifying data into groups
The IF function is commonly used to classify data into groups.
Permalink -- click for full blog post "IF Function - clssifying data into groups"
Sep 22, 2011
Excel Case Studies
In this page, we will share with you case studies so that you can have a better appreciation of how Excel can work for you.
Permalink -- click for full blog post "Excel Case Studies"
|
