- Typing equations vs. Autosum
- Formatting
- Selecting multiple, random ranges
- shading
- text font
- text colour
- vertical alignment
- wrapping text
- text orientation
- borders
- Selecting cells/ranges (5 shortcuts)
- Copy
- Move
- Drag & Drop
- Formulas
- =SUM
- =MAX
- =MIN
- =AVERAGE
- =COUNT
- =COUNTA
- The amazing Fill button
- Using pre-programmed lists
- Creating your own custom lists
- Using it for copying formulas
- Data alignment
- Centering across a span of cells
- Inserting/deleting columns/rows
- Adjusting column widths
- Using the Format Painter efficiently
- Proper spreadsheet layout
- Creating custom fill lists
- Understanding BEDMAS (Proper Order of Operations)
- Understanding and using ABSOLUTE cell addresses
- The Freeze Panes function`
- Print preview
- Printing
- Repeating headings at the top of each printout page
- Using the Conditional Formatting function
- Introduction to =IF equations
Hot Tip: To quickly add a GROUP of cells (meaning: numerous columns and rows at once), select the cells – including the blank (total) cell beneath each column AND the blank (total) cell to the right of each row, then click the AutoSum button on the toolbar. You will get ALL column and row sums in one fell swoop.
This is just one of the many tips that you will learn at our 1-day Excel computer training courses (onsite and classroom).
COURSES COST:
$150 per person (+ GST)
Contact us for on-site Excel training course prices
9am - 4pm.
Manual Included in cost of Excel training course.
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 1 training course
|
