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.

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"

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.

David

A Cisco Success Story

I attended a resume writing seminar & conducted mock phone interviews with a Microtrain career counselor. These two activities gave me a leg up on distinguishing myself from all the other people looking for work. Since the career counselor's at Microtrain had a track record of getting people hired, their insight and positive past experiences helped me tremendously in getting hired with a Cisco Voice Systems Integrator in the Chicago area. I was hired as a Cisco Voice Tech Engineer with a starting salary of $65,000 / year with a Cisco voice systems reseller located in the Chicagoland area. Microtrain was very instramental in making this a reality. From expediting my WIA grant, to providing excellent hands-on training from knowledgable instructors I was able to achieve becoming certified with my CCNP. Microtrain's career services was the final catalyst in connecting me with this company by communicating with them on my behalf and with me in setting up the interview. One week later and I was hired. No joke. Thanks Microtrain!

Ron Cwik

PMP Certification Training, 2008

Great training facility. Great instructors. Great experience.

Karine Bucci

Project Management

Great class, loved the interaction and team-building exercises. Plenty of materials and learning tools supplied. Although it was a full week's class, never boring. Donna [Russell] was awesome and gave many supporting examples for better understanding.

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top