Microsoft excel training

August 31, 2012

Advanced Excel 2010 Training

Filed under: advanced excel training — Tags: , , — microsoftexceltraining @ 5:49 am

Course Duration for Microsoft Excel 2010 Training : 2 days

Course Objectives:

Participants will learn to use advanced functions of Excel® 2010 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.

They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

For More Information:
Call +65 98773485
Email: training@intellisoft.com.sg
Website: http://www.intellisoft.com.sg

August 30, 2012

Advanced Microsoft Excel Training 2007

Filed under: microsoft excel training — Tags: , , — microsoftexceltraining @ 5:48 am
  •   Understand how you can apply Advanced functions of Microsoft Excel 2007 to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.
  • Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.

For More Information:
Call +65 98773485
Email: training@intellisoft.com.sg
Website: http://www.intellisoft.com.sg

March 9, 2012

VBA Training Course in Singapore

Filed under: Uncategorized — Tags: , , — microsoftexceltraining @ 9:47 am

This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel macros and Visual Basic for Applications (VBA) programming language.

Excel VBA Course Duration: This is a 3 full day Excel 2007 VBA Course. Course starts at 09:00 and runs until 17:00, with a one hour break for lunch, and two short snack breaks.

For More Information:
Call +65 6296 2995
Email: training@intellisoft.com.sg
Website: http://www.intellisoft.com.sg

April 27, 2010

Changing Chart Size

If you are working with an embedded chart, you can change the size of the chart to any size you want. You cannot directly change the size of a chart sheet; it is set to be a single page. You can modify the printed size of a chart sheet, however. (This is covered in a different ExcelTip.)

You change the size of an embedded chart as you would any other graphical object in Excel:

  1. Click once on the chart. Handles appear around the chart border. As you move the mouse pointer over these handles, they change to sizing arrows.
  2. Click and hold the left mouse button and drag a sizing handle until the graphic is the size you want. The arrow heads on the mouse pointer indicate the direction which you can move the border.
  3. Release the mouse button. The chart is resized and reformatted.

March 12, 2010

Using Loops in VBA in Microsoft Excel

Why Loops? (another Microsoft Excel Training)

The purpose of a loop is to get Excel to repeat a piece of code a certain number of times. How many times the code gets repeated can be specified as a fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as many times as there are rows of data).

Loops can be constructed many different ways to suit different circumstances. Often the same result can be obtained in different ways to suit your personal preferences. These exercises demonstrate a selection of different ways to use loops.

There are two basic kinds of loops, both of which are demonstrated here: Do…Loop and For…Next loops. The code to be repeated is placed between the key words.

Open the workbook VBA02-Loops.xls and take a look at the four worksheets. Each contains two columns of numbers (columns A and B). The requirement is to calculate an average for the numbers in each row using a VBA macro.

Now open the Visual Basic Editor (Alt+F11) and take a look at the code in Module1. You will see a number of different macros. In the following exercises, first run the macro then come and read the code and figure out how it did what it did.

You can run the macros either from the Visual Basic Editor by placing your cursor in the macro and pressing the F5 key, or from Excel by opening the Macros dialog box (ALT+F8) choosing the macro to run and clicking Run. It is best to run these macros from Excel so you can watch them as they work.

Exercise 1: Do… Loop Until…

Continue Learning

January 13, 2010

Microsoft Excel Training – Not Just for Newbies Anymore

If you’ve been using Excel for a number of years, you may feel you already know everything you need to know. You are in a comfort zone and feel that Microsoft Excel training courses would be a waste of your time and your employer’s money. As long as you can do your job, you feel that you’ve learned all you can.

No matter what your level of expertise, you can always benefit from further training. Here are just a few reasons that training can help you and your employer.

Learn better ways to do things

When looking for a solution to a problem, it is human nature to stop once a solution has been found; even if it’s not the best solution. For example, you may know how to get to a feature by navigating the menus but not realize you can activate the same feature with a simple keystroke. Or you might be using cumbersome formatting commands over and over, not realizing Format Painter or AutoFormat can streamline your actions.

MS training can optimize your work, showing you more efficient ways to accomplish tasks and increasing your productivity.

Learn new ways to do things

Continue reading

October 26, 2009

Advanced Excel Training by Intellisoft Systems

These advanced courses will round off your skill set with Microsoft’s popular spreadsheet program, make you more efficient in the workplace and will open up many doors professionally and will be a great weapon in your arsenal for your own career progression.

Course Objectives:

* Understand how you can apply Advanced functions of Microsoft Excel to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.

*Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.

Know more about Intellisoft’s Advanced Microsoft Excel Training

The Shocking Blue Green Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.