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.
|