Microsoft Excel is the world's most popular spreadsheet program, learning how to
use the software with Osborne Training shows that you've taken one of the best
Excel training courses available. A comprehensive training course with up to
date material to practice at home and during your class. You will also be
provided a step by step manual of all the tricks you can do using Excel
spreadsheets to gain better management reporting and budgeting skills. It is a
fundamental programme for professional Accountants. Excel spread sheets are the
most powerful tool, extensively used for reporting and analysis. Having advanced
skills on excel can excel your career and help you to stand ahead of the
competitive job market. Advanced skills on excel is a must for any potential
professional accountants.
You will receive an attendance certificate once you complete the course
successfully.
EXCEL COURSE CONTENT
* Creating worksheets, formatting text
* Simple and complex formulas
* Handling rows and columns
* Autocomplete, using styles, headers and footers,
* Average, max and min functions and using charts.
* Use of IF Formula
* Summing Techniques
* Cell References
* Formula Linking
* Sumifs
* Tables and Bordering
* Look up References (Vlookup, Hlookup,etc)
* Data Validation
* Conditional Formatting
* Date & Time Formulas
* Charts & Graphs
* Protection & Security
* Creating Pivot Table
* Pivot Table Analysis