Excel Formulas and Functions 2010 / 2007 - Advanced

Don't waste a whole day in a course that's not designed for you. This half day, hands-on course gets you comfortable using advanced Functions in Microsoft Excel. Take your workbooks to the next level with Excel's powerful Functions

Course Outline

A small class size led by an experienced instructor creates a solid platform to impart knowledge of Excel's advanced Functions to you.  Realistic exercises, time set aside for questions and a reference manual you can take with you all work together to teach you how to:

• Use Logical functions including
• IF
• AND
• OR
• NOT
• FALSE
• TRUE
• IFERROR
• Work with nested functions
• Break up complex or long functions so they are easier to read
• Recognize array formulas
• Define basic array formulas
• Use functions with array formulas
• Use the IF function in an array formula
• Differentiate between VLOOKUP and HLOOKUP
• Find an exact or approximate match with VLOOKUP
• Use VLOOKUP in an array formula
• Use advanced calculation functions including:
• SUMIF(S)
• COUNTIF(S)
• AVERAGEIF(S)

This course is taught in Excel 2010. Users of 2007 will find their version is essentially identical for the purposes of this course.  Users of earlier versions can still benefit from most of the functions taught in this course.

Additional Details

Pre-Requisites

A basic understanding of how to use Formulas and Functions in Excel (+-*/, Sum, etc)

Certificates offered

JN Software Consulting Excel Formulas and Functions - Advanced Certificate of Completion

Cancellation Policy

JN Software Consulting works hard to schedule our training and other services around your life, for your
convenience. With that in mind we have the following cancellation policy for all booked training. 

•  Less than 48 hours: Full quoted fee 
•  Less than 5 business days: 20% of quoted fee 
• NSF Charge Policy
  Clients will incur a $40 charge for any NSF cheques

 PLEASE NOTE: Onsite sessions are subject to a 3 hour minimum charge regardless of the duration of the actual training. For sessions expected to last less than 3 hours we suggest booking a live online training session.

Map & Reviews

JN Software Consulting
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

Philippe was really good at catering the training to our needs. He figured out what our prior knowledge was on the topic and went from there istead of having us go over things we already knew. If we had been in a group setting this would not have been possible. He also was helpful in letting us know how the 2003 version was different from the 2010. We therefore purchased an additional training manual for the 2010 version as we recently had it installed on our workstations.

Reviewed by Jennifer H. 2012

   

There was a little mix up with the time the course was to be held. The website said 9-4 but it should have been 10-5, so when I arrived no one was there. However, it was dealt with quickly after a call and the trainer arrived quickly. I was the only person attending the course, it was very informative and it allowed us to touch on all of the questions I had specifically.

Reviewed by Amy D. 2012

   

The instructor was excellent - she was very knowledgeable, patient, and really tried to tailor the course and specific examples to each student. The room was bit too cold in the morning and quite warm in the afternoon, so I would recommend wearing layers for comfort! I would highly recommend this course.

Reviewed by Sarah K. 2012

   

The instructor used real situations from the participants, so it was extremely relevant to what we were doing. She was very knowledgable and answered all questions.

Reviewed by Sandy P. 2011

   

Very informative session focused on all my concerns regarding advanced QuickBooks. Carolyn was helpful and very pleasant to learn from. I would reccomend her highly and might want to work with her again in the future.

Reviewed by Carmina D. 2011

   

The instructor was very knowlegeable but the seminar wasn't very well structured. No handouts, ran out of time before al topics were covered. Certain points were belabored at the expense of covering all desired topics.

Reviewed by Christopher D. 2011

   

I think this training need more time, it was a bit short in duration

Reviewed by Randa E. 2011

   

Course was given on site at my work place - very convenient. Outline changed during course to fit more with our goups needs. Time frame changed also and this caused some disorganization.

Reviewed by Roxanne A. 2011

   

Gordon was a great presenter and traininer, I learned a lot and he has inspired me to further my knowledge in this subject.

Reviewed by Scott R. 2011

   

We all enjoyed Shauna's presentation of Adobe. She's a knowledgeable trainer.

Reviewed by Anita P. 2011

   

Good course, great instructor.

Reviewed by Nicholas P. 2011

   

The instructor was amazing.

Reviewed by Adam B. 2011

   

Excellent training - instructor, facility, course content. Thank you.

Reviewed by Linda S. 2011

   

I took a private class with Jon and it was terrific. He was very knowledgeable and patient in explaining to me the mechanics of what I needed to know. I have worked with excel as long as I can remember, however I started a new job that required me to us

Reviewed by Christopher . 2008