The MicroTrain Blog

Entering Functions in Excel 2007

by Scott Coley on April 26th, 2010

This is for the Excel 2007 Newbies! Us old users have discovered this litte trick ages ago.

There are three ways to enter functions in Excel 2007:

1. Type them into the cell or the formular bar

2. Use the Insert Function Wizard

3. Use the new method in Excel 2007 by typing the equal sign, the first few characters of the function name    and follow the syntax.

There is a fourth method, a combination of two and three above.

Type the equal sign and the first few charaters of the function name, the on the Formular Tab click the Insert Function

Icon to bring up the Insert Function dialogue box and enter the needed information in the appropriate rectangle. This method is great for eliminating errors, assuring the correct  punctuation and proper syntax.  One also gets assistance in what to put in each rectangle.

Try this, I think you will like it.  I use it ofter and find it to be speedier and reduces errors.

Office 2010 Beta ready for downloading

by Scott Coley on February 13th, 2010

Great News! Office 2010 BEta is reading for Downloading!

Microsoft has made available the beta version of its new Office Suite of Products.  Microsoft Office 2010 Beta is available for download at: www.microsoft.com. It is a large download so be sure you have a high speed Internet connection, at least one, (1), GB of hard drive space and a few minutes.

There has been some graphical changes in each application.  If you are familiar with Office 2007 you will be able to get up and running in a few minutes.

 

Serveral version of Office may be installed and run on the same system.  Just address that option when installing this beta version.

Do a custom installation if you do not want to install Outlook 2010 beacuse only one version of Outlook can run on a system.

 

Good Luck and have fun!

Raves & Praise

Jean S.

PMP Certification Training, Lombard, 2008

I was laid off for many months and not really getting many callbacks for my resume and no job offers. After I put the letters PMP on it, not only did I see an increase in quantity, but also quality of interviews. I had been spinning my wheels for 5 months, and after the PMP went on, I had 2 job offers in 6 weeks. It really was the "golden ticket"

Ron Cwik

PMP Certification Training, 2008

Great training facility. Great instructors. Great experience.

Kaycee Ekufu

MCSA

The instructor [Al Khalfan] was very knowledgeable in the field. He presented the materials and concepts with a professional touch. He also frequently adds humor to his teachings, which made it easier for me to understand. The support staff was all nice, gentle, caring, and very helpful. The materials, rooms and amenities were excellent and exceeded expected standards.

Robert Graf

MCSA

Microtrain presents the course material in an interesting and concise manner. Microtrain gives the student all the resources necessary to pass the certification exams. Both the Chicago and Lombard facilities were excellent, and the staff goes to any length to accommodate any student changes.

Scott Wilson - Team Bradley

Employer Partner Feedback

Dawn has been a pleasure to work with. She is diligent in her efforts to give MicroTrain’s students the best opportunities to connect and network with various companies and players in the job market. The curriculums and certification programs are in line with today’s current IT needs. It’s good to see that they evolve with what employers are most seeking out there. I would recommend to any employer that hires skilled IT workers that they look into MicroTrain’s career services department as a potential source of candidates. The business of hiring can be quite costly, and Dawn and her staff provide a free service to outside companies. This value-add for MicroTrain’s students aligns with their mission in both training and job assistance to set up a win/win scenario for all involved.

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top