Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Learn to use some of Excel's logical, text, lookup & reference, and conditional functions to process worksheet data more efficiently.

  • Date: May. 24
  • Location: Virtual (Map)
  • Time: 11:30 am - 1:00 pm (Note on end times)
    • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 90 minutes
    11:30 AM - 01:00 PM EST
  • Delivery Method(s):Virtual Instructor Led
    • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
Course Outline
Objective

Learn to use some of Excel's logical, text, lookup & reference, and conditional functions to process worksheet data more efficiently.

Course Description

Do you need to do more advanced calculations? Do you want to learn to use more of the 300+ built-in Excel functions? This class covers four groups of common functions: logical functions, text functions, lookup and reference functions, and conditional functions.

Attend this course if you want to:

Identify portions of an IF statement.
Create simple and nested IF statements.
Understand text functions.
Eliminate extra spaces within your data.
Change text to proper case.
Combine cells.
Convert text to numbers or numbers to text.
Extract a portion of text from a field.
Change a formula to a value.
Separate text into columns.
Look up and merge data.
Use the SUMIF, COUNTIF, and AVERAGEIF functions to calculate records based on certain conditions.
Enter formulas directly into cells.
Prerequisites & Certificates
Pre-Requisites

Comfortable with basic Excel capabilities.

Certificates offered

Certificate of Completion


Cancellation Policy
If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.

Map & Reviews
Elert & Associates Technology Training
[ View Provider's Profile ]

On Line Instructor Led
Your Home or Office
Your City, Your Province
Your Country   --- ---


Reviews
 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

Good content !
Reviewed by 2013
My only complaint was the time, I live in the Pacific time zone and 6am is an early start time, an afternoon east coast option would be nice.
Reviewed by 2013
The course was excellent, as was the instructor (Danielle). The only issue I have is the timing. Being located in Ottawa, Canada I started the course at 4:00 pm and finished at 5:30, which required me to make special daycare arrangements. These 1.5 hour courses should start at 2:30 pm Eastern Time at the latest.
Reviewed by 2012
Felt like a lot of info for a 1.5 hour course. 2 hours might have been better and would have allowed more time for questions. I did an online course so many of the questions asked above do not apply. There is no "N/A" option. Anything I gave half a star is for this reason.
Reviewed by 2012
Some ratings were not applicable ie. Faciltiy since this was a virtual course. Excellent Instructor - very knowledgeable. Course only focused on two form types - the form type I was interested in was not covered. A suggestion would be to offer a course that covers all forms types or offer an additional course that covers form types not included in this course.
Reviewed by 2012
The trainer explained everything in a simple way and gave us the right amount of time to try everything ourselves as well. She had a friendly attitude and also paused from time to time to ask us if we had any questions. All in all a good experience.
Reviewed by 2012
I did the online course and found it awesome! The instructor was very knowledgeable and extremely helpful I finished the course feeling I got my money's worth and then some. Thank you Survey is stupid as it does not take into consideration I was an online course - has mandatory fields not applicable to me.
Reviewed by 2012
There is not enough time to cover all the materials needed in the private course
Reviewed by 2011
Please note that I attended this course via Webinar so the facility rating is not applicable. Also not applicable is the Break Times rating since the course was only an hour and a half. I suggest you add an N/A column to your rating sheet.
Reviewed by 2011
I liked the virtual training. So much easier to fit into my schedule. Did miss the interaction though. There were very little questions asked in both this one and the Powerpoint one. In the Excel presentation, I really liked that the trainer muted everyone. This wasn't the case with the power point one. There were baby noises in the background. Very disruptive and inconsiderate.
Reviewed by 2011
My course was online so any ratings about the facility or instructor attire are not accurate but I can't turn this in without filling them out.
Reviewed by 2011
Excellent Instructor
Reviewed by 2011
24-May-2013 $68 Regular Price $85 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer.

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:



This page has been viewed 28 times.