advanced excel microsoft

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"

Blog or Build an SBI! Site