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.

Sep 13, 2017

Advanced Excel - From a Business Perspective

This Advanced Excel website is designed to help business users understand how to make of use Excel in their work and increase their productivity.

Continue reading "Advanced Excel - From a Business Perspective"

Aug 21, 2017

Allocate Cost across periods

Allocating the cost across multiple periods automatically

Continue reading "Allocate Cost across periods"

Jul 04, 2017

Learn Microsoft Excel 2007/2010

Learn what's new about Microsoft Excel 2007/2010 in this page

Continue reading "Learn Microsoft Excel 2007/2010"

Dec 07, 2016

How to generate a list of future dates

To generate a list of future dates without dragging down, you can use the fill series function. It can stop filling at a precise date you specify.

Continue reading "How to generate a list of future dates"

Sep 21, 2016

Highlight search results using conditional formatting

Search for word or text in a range by using conditional formatting.

Continue reading "Highlight search results using conditional formatting"

Sep 06, 2016

Identify Sales Below Benchmark

How to highlight sales above and below benchmarks using conditional formatting.

Continue reading "Identify Sales Below Benchmark"

Jul 27, 2016

Calculate Variance within Pivot Table

How to add in arrow next to the number in your Excel Reports

Continue reading "Calculate Variance within Pivot Table"

Jul 01, 2016

Calculate Variance within Pivot Table

Power Pivot can easily display the variance between 2 periods

Continue reading "Calculate Variance within Pivot Table"

May 15, 2016

Extract numbers from a cell

Extract numbers from a cell can be done with a combination of SUBSTITUTE, TRIM, MID worksheet functions.

Continue reading "Extract numbers from a cell"

Apr 06, 2016

COT - Commitment of Traders Report

INDEX and MATCH formula combined allow you to extract text from a report which cannot be done using VLOOKUP.

Continue reading "COT - Commitment of Traders Report"

Apr 03, 2016

Re-arrange the data from columns to rows.

Budget vs target in Pivot Table can be presented beautifully using Power Pivot, the new function from Excel 2010

Continue reading "Re-arrange the data from columns to rows."

Mar 02, 2016

COT - Commitment of Traders Report

COT can be extracted weekly using Excel web query and worksheet functions.

Continue reading "COT - Commitment of Traders Report"

Feb 10, 2016

How to calculate CPF using Microsoft Excel

Calculate CPF is one of the best way to demonstrate the power of Excel.

Continue reading "How to calculate CPF using Microsoft Excel"

Jan 18, 2016

Understanding excel conditional formatting

Conditional formatting is useful for monitoring business performance. The changes in color gives you an quick assessment of the values you are monitoring.

Continue reading "Understanding excel conditional formatting"

Jan 18, 2016

VLOOKUP Function - Merging 2 sets of data

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

Continue reading "VLOOKUP Function - Merging 2 sets of data"

Nov 12, 2015

Re-arrange the data from columns to rows.

Using the INDEX formulas, you can re-arrange the data from columns to rows without using Macros.

Continue reading "Re-arrange the data from columns to rows."

Apr 20, 2015

Format data in Excel

Learn how to import data into an Excel worksheet using the different methods offered by Excel.

Continue reading "Format data in Excel"

Feb 09, 2015

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.

Continue reading "Excel Tips and Tricks"

Dec 03, 2014

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.

Continue reading "Excel download"

Oct 14, 2014

Bootstrap 101 Template

Continue reading "Bootstrap 101 Template"


New! Comments

Have your say about what you just read! Leave me a comment in the box below.