Advanced Excel Training

In this section of Advanced Excel resource center, we will organize mini advanced excel training, to show you how to solve some of the problems you are likely to encounter in your use of Excel.

The pre-requisite to maximize the resources given in these microsoft excel tutorials is a good basic understanding of Excel. After going through these microsoft excel tutorials, you will be able to manage large spreadsheets containing hundreds and even thousands of rows of data records. You will become more competent in navigating through the excel worksheets, including how to format these spreadsheet quickly and accurate. At the end of these mini microsoft excel tutorials, you will gain greater confidence in managing large and complicated worksheets.

The microsoft excel help contained within here is created from years of experiences in using Microsoft Excel for Management reporting and data analysis. They contain real business scenarios I have encountered over the years and the solutions found through various means. Some of these solutions were only found long after I have encountered them. Prior to finding these solutions, I have to make use inefficient methods to solve these business challenges. I would have been able to save hours if these solutions were found earlier. Please note that advanced excel training courses will make Microsoft Excel work harder for you without using macro programming / VBA.

Mini Advanced Excel Training courses:

I have a range of cells partially filled with data. How can I highlight or format those blanks cells in the range quickly?

Click here for the solution

The find all function in the find and replace dialog box, is a useless function that list down the address of the cells in worksheets that match the word or phrases in the find what box. Or is there more to it than meet the eyes?

Find out the secret to the find all function in excel

How do we convert text to numbers?

Click here to find out how

Paid Excel Training course

Unleashing the potential of Excel is a computer-based course currently running in Singapore. Its purpose is to equip the participants with a strong foundation in using Excel. The course is design with the purpose of how to make full use of formulas and functions in the worksheet. For example, the Goto function can bring you to different areas within the worksheet. But the Goto function is capable of doing more. It can help you select the worksheets quickly based on certain criteria, such as selecting blank cells in a pre-selected area, selecting the visible cells in a range after making use of the autofilter functions.

Another example is the subtotal formula. It is a useful formula to perform calculations when you use it together with the autofilter function. Do you also know that there is a subtotal function as well as a subtotal worksheet formula in Excel?

All these and more are covered in the course which uses realistic case scenarios to share with our participants on how to apply the excel formulas in a given scenario. They will be able to relate the formulas and functions to their works.

To find out more about our classroom-based advanced Excel training course in Singapore, click here.

To find out more about our online video advanced Excel training course, click here.