Question:
What is the pre-requisite for the course?
|
Answer:
Those who wish to attend the course should know how to do the following in Excel :
- Create a workbook and navigate through the worksheets in it.
- Enter number and text in a cell;
- Save a new workbook;
- Enter number/text in a workbook and save it;
- Copy and move a cell and a range of cells;
- Insert and hide rows/columns;
- Insert, edit, copy, and move worksheets;
- Adjust the width of a column and the height of a row;
- Sort data in a worksheet;
- Insert a worksheet, move data between worksheets, and copy a worksheet to another workbook;
- Add and modify data and a worksheet;
- Format cells;
- Create simple arithmetic (+-*/) formula and worksheet functions such as sum;
The most important pre-requisite - Can think logically
Anybody who uses Excel will understand most, if not all the terms given
above. If they do not know understand what are presented above,
then they should not attend the course.
|
Question:
Two person took the one minute excel test.
Person A gave up totally without any clue on what the excel test is asking for.
He does not understand its requirements.
Person B could not complete the Excel test but because of his database knowledge, he knows what it is asking for and could provide
the answer using SQL.
Are they suitable for this course?
|
Answer:
If Person A does not understand what is required, then he is not suitable
for the course because he will have problem understanding the other
case scenarios given in the course.
Person B will learn how to complete the task in Excel instead of SQL.
The key is knowing what is required. We will show the
solution step by step. At the end of the course, he will be able to complete
the task within one minute using Excel.
|
Question:
I have already attended basic, intermediate and advanced Excel courses.
Why do I need to attend this course?
|
Answer:
Our course is focussed on business application. We do not show you what are the functions
that are available in Excel. Even if you know all the functions in Excel, you may not
able to apply them in your work. Let me give you and example. Do you know that if you
want to remove duplicates in your list, you need to use the if formula, autofilter and
basic copy & paste function and you have your list ready in 15 seconds.
|
Question:
I have already attended basic, intermediate and advanced Excel courses.
Why do I need to attend this course?
|
Answer:
Our course is focussed on business application. We do not show you what are the functions
that are available in Excel. Even if you know all the functions in Excel, you may not
able to apply them in your work. Let me give you and example. Do you know that if you
want to remove duplicates in your list, you need to use the if formula, autofilter and
basic copy & paste function and you have your list ready in 15 seconds.
|
Question:
I have been working with Excel for so many years. There is nothing new in Excel
that you know that I didn't know.
|
Answer:
That's where you might be wrong. Based on the feedback collected from our
participants, those who have been working for years are learning something new
from the course. In fact, they saved even more time than those who are new to
Excel. Take a look at the chart and do your own comparison. BTW, this chart
is created using Pivot Chart. Did you use it before?
|
Question:
Which version of Excel is the course conducted in?
|
Answer:
The course is conducted using MS Excel Version 2003. You can find out the version
you are using by clicking on the help in the menu bar and select about Excel.
Inside the pop-up screen, you will be able to see the version of Excel you are
using. But we wish to highlight that the skills learned from the course can be
applied to all version of Excel starting from 2000 onwards. Even if you are using
the new Excel version 2007, the course would still be relevant. The only thing you have
to struggle with is the interface. In fact, with the knowledge learnt from
our course, you will be able to leverage on the power of Excel in version 2007.
|
Question:
Where are the courses conducted?
|
Answer:
The courses are conducted at International Plaza, located next to
Tanjong Pagar MRT Station. Please see the map
below for the actual location.
|
