|
|
|
|
Powerful formulae and clear reporting (Excel next step 2) - agenda
|
| Format: fully hands-on - computers will be provided |
| Duration: one day |
| Arrival and refreshments: 9:00 am |
|
Start: 9:15 am |
|
Finish: 4:30 pm |
|
|
Your power-packed agenda
|
|
|
Learn important, powerful formulae
- Avoid #DIV/0! errors with IF.
- Employ AND and OR to create complex tests for IF.
- SUM through sheets rather than create a formula that refers to a cell on each sheet.
- Use VLOOKUP to search for a matching code and return a value from a table.
- Use SUMIF and criteria to total certain values of a table.
- Understand how Excel stores dates and times.
- Calculate with dates and times.
Format conditionally
- Colour cells according to the band they fall within.
- Colour entire rows according to the band they fall within.
Sort and filter
- Sort in Excel 2007 and earlier versions.
- Apply a filter to view just the data that meets certain criteria.
|
|
Create charts to communicate results clearly
- Create simple charts.
- Customise charts.
- Add pie charts to your data-display diet.
Design clear reports
- Pick up conventions that make reports clear, professional and consistent.
- Learn to structure sheets for ease of navigation and minimisation of errors.
- Use the AbleOwl ESPMini add-in to rapidly build workbooks that have standard
layouts.
Discover other useful features
- Document certain entries with Comments.
- Use ROUND to make totals reconcile with items totalled.
- Use Excel tools to trace formulae references.
|
|
|
|
Who should attend:
- Excel users who can already create basic SUM and arithmetic formulae. Prior attendance at the Best Practice Essentials (Excel next step 1) course is not mandatory, though it would be useful. For those wanting to: (A) master commonly-used powerful formulae. (B) present results in a clear, professional and confidence-inspiring way.
|
|
|
|
All delegates recieve the AbleOwlESPMini add-in to take away
|
Learn in a positive environment
- Be assured the advice you get is well-proven and utilised.
- Feel free to ask questions.
- Get time away from the office and constant interruptions.
- Enjoy a friendly environment where you don’t feel you’re holding others up.
- Instantly apply what you’ve learned on return to work.
The courses cover Microsoft Excel releases XP(2002) through 2010.
Where there are differences among the covered releases, they are pointed out.
Course cancellation policy:
A course booking is considered final when an invoice is sent, and can be cancelled
up to ten working days before the course. After that, payment is expected in full
and no refund will be given.
All cancellations must be notified in writing, i.e. post, fax or email.
Another delegate may be substituted at any time.
|
|