Quality, Affordable & Flexible

Take advantage of our Microsoft Office Series public courses’Buy 2 Get 1 FREEpackage!!Register 2 Pax & the 3rd Pax will beFREE!

Flexible

Pick 3 similar Microsoft Office Series courses OR mix 3 different courses.The course with the lowest fee among the 3 will beFREE!

All 3 participants may attend on the same datesORchoose to attend separately on different dates listed in the public schedule within12 monthsfrom confirmation of registration.

Affordable

The Microsoft Office ‘Essential Series’ courses work out to an average of onlyRM133per day!

Quality & Satisfaction Guaranteed!

Ex-participants of Microsoft Office Series courses who require a ‘refresher’ course of the same title are welcome to join the public classes at Centrilinc again forFREE!, withintwo years, as long as the required courses are available in the public schedule!

Only experienced & certified trainers with above average participants’ ratings will be assigned to the classes.

Enhancing the value of Human Capital

Learning and human capital development ... what Centrilinc has been passionately focusing on since its inception in 2006.

We do this for a simple fact, in order for us to grow, we seek for opportunities to assist in improving our clients’ organisation’s bottom line… through learning.

Get the latest updates

Latest News

Microsoft Excel Tips

VBA - Counting Rows & Columns & Sheets* 27/10/2001

When you have selected a range, it is sometimes useful to know how many rows or columns you have selected as this information can be used in your macros (for eg when you have reached the end, you will know it is time to stop the macros. This macro will do the trick.

VBA - Inserting Rows* 04/01/2002

Formatting - Borders

Need to draw tables? If you noticed your formatting tool bar, the border icon has pretty limited border styles. Where the heck do you go to if you want some fancy borders with colours? It's actually under our nose.

Formatting - Clearing Formats

Standard toolbar & Formatting toolbar sharing one row

Again Office 2000 applications tries to save space buy cramping both toolbars into one row. Land is an expensive commodity these days!!! So, just point at the light grey vertical line at the begining of the Formatting toolbar until you see a crossed double arrow head.

Overcoming common problems - VLOOKUP

Unable to do a lookup? Entries look the same but lookup returns #N/A error. This is a formatting problem. To overcome this you have a couple of options. One is to copy the data from Excel and paste it to Notepad.

Formulas - File Name

Row Height related problems (Text Alignment)

When your row height is much higher the your font, you will notice the contents will be anchored to the bottom of the cell. And that's a bit ugly. What if I want it to be in the centre instead. No problem.

Text Boxes (for exact text placement)

When you need place your text on an exact spot, (for instance when you need to print on pre-printed forms) adjusting the row height & column width can be a big headache coz when you adjust, all other text will move.

More Tool bar

If you're sharing a computer, there's always a smart alec who likes to mess up your toobars. To reset them back to the default style, Right Click any tool bar, Customise, Click the Tool bar tab, select the tool bar you want to reset & click on RESET and presto. It's done.

VBA - Hiding Sheets* 27/10/2001

VBA - Flickering Screen* 27/10/2001

Sometimes when you run a macro, the screen flickers a lot due to the screen updating itself. This slows the macro done especially when the macro has a lot of work to do. You need to include the statement as shown below.

Quick adjustments to a column (Auto Fit)

VBA - Deleting Empty Rows* 27/10/2001

To delete empty rows in a selected range we can use the following macro. The macro here uses the For Next Loop. First the macro counts the rows in a selected range to determine the when the macro should stop. The For Next statement acts as a counter.

VBA - Close All Files* 23/03/2009

Copying & Pasting

There's more to it than just copy (Edit/Copy or ctrl C) & paste (Edit/Paste or ctrl V). You can copy and control exactly what you want to paste. Example you need to copy a total (where you used a formula) and when you pasted it get an error because of the formula.

VBA - Current Date* 24/12/2001

It's a good idea to insert the current date when you save the file so that you can tell if it's the latest version. Of course this is shown under file properties but how many people know where to find it?

VBA - Current Cell Content* 24/12/2001

Sometimes we need to know what the cell contains ie dates, text or formulas before taking a course of action. In this example a message box is displayed. Replace this with a macro should you require another course of action.

VBA - Excel Functions* 08/02/2002

Formulas - Dates

Excel recognises dates whether you use slash ("/") or hyphen ("-"). However if you use full stop (".") Excel would assume the date as a text. Therefore you will not be able to customise the date styles or even perform calculations with the date.

VBA - Auto Run* 24/12/2001

Making your macros run automatically when opening your workbook. You can either use the Auto Open method or the Workbook Open method. These macros will display the message "Hello" when you open the workbook.

Formulas - More Totals

Lets say you need to total numbers that are not in a range, example a1, a5, a10. Well normally the formula would be =a1+a5+a10. If you have 10 cells to total up that would be slow coz you need to type in "+".

Disappearing Toolbars

Formulas - More Dates

Do you want excel to use the system date? Use this formula =today() and presto you can see the system date. Cool huh? But if you just want the system date without using the formula just press ctrl : and Excel will insert the system date.

VBA - Error Trapping* 04/01/2002

Formatting - Centres Text Across Columns

When you need to centre text across cell, the most common method used would be the merge & centre tool. However merging cells could cause other problems when selecting a range or when trying to perform a copy and paste.

Rows - How to Adjust Row Height

VBA - Goto (a range)* 27/10/2001

To specify a macro to go to a specific range you can use the Goto method. Here I have already named a range in my worksheet called "Sales". You may also use an alternative method ie the Range select method.

VBA - Counter* 17/02/2002

Formatting - Date Formats

What if you want your dates to show Sunday, 25 December? Simple, select the cell with the date, click Format/Cells/Number/Custom (If you are too lazy just press Ctrl 1 remember?), go to the TYPE text box and...