- =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:
$165 per person (+ GST)
9am - 4pm (approx)
Manual Included
After-course email and telephone support included
Contact us for on-site training prices
Maximum 10 Students.
Please
click here to view schedule
Please
click here to view map
Click here to see if you have the skills to bypass the Excel Level 2 training course
|
