COURSE LIST MICROSOFT EXCEL 2010 - LEVEL 2
 

Microsoft Excel 2010 - Level 2

Click here to see if you have the skills to bypass Excel 2010 - Level 2

After taking our Excel 2010 - Level 2 training course, you will see how you can get the multi-talented Excel program to work efficiently for you. An interesting and challenging course for average Excel user who wants to move beyond average-user status.

• =IF equation use
  - Multiple-condition IFs
  - Nested IFs
• =SUMIF
• =COUNTIF
• =RIGHT / =LEFT
• =SUBSTITUTE
• The Text-To-Columns feature
• =CONCATENATE
• Three-dimensional spreadsheets
• Linking sheets with equations
• Linking files with equations
• Data Validation
• Creating and Editing Graphs
  - Bar / Column / Line charts
  - Pie charts
• Sorting data
• Non-alphanumeric sorting
• AutoFilter
• Data sub-total function (group reporting)

Hot Tip: To link a figure on one sheet to a cell on other sheet (in the same file), sit the cellpointer in the blank cell into which you want the figure pulled; type an = sign; click the page tab (bottom of screen) that contains the value to which you want to link; click on the desired cell; press ENTER.
 
Every time the original value changes – your linked cell will instantly update itself. This is just one of the many tips that you will learn in our 1-day Excel computer training courses.

COURSES COST:
$175 per person (+ HST)
9am - 4pm (approx)
Excel 2010 Level 2 manual included
After-course email and telephone support included
Please contact us for on-site Excel 2003, Excel 2007 and Excel 2010 training course prices
Maximum 10 Students.
 

↑ BACK TO TOP