Microsoft Excel Professional |
Microsoft Office 2003 Professional |
| |
|
| |
This course is an extension to the fundamentals in Microsoft Office Excel. It will be looking at advanced topics for the preparations of professional spreadsheets. Coverage of building charts, database functions, analyzing data, macro, conditional formatting and using the auditing toolbar, will be done here |
| |
|
| |
At the end of this course participants should be able to:
- Competent in using the conditional logic function and lookup tables.
- Use formulae to manipulate and format data.
- Effectively use the database functions to manage simple database.
- Through the use of outlining tools, organise the documents for better management.
- Use the PivotTable and PivotChart effectively to represent data.
- Understand how analysis tools are used to achieve results.
- Create and manage macros.
- Using Shared Workbooks in a workgroup
- Using the Reviewing Toolbar to track changes.
|
| |
|
| |
General public and industry specific personal who want to gain better product knowledge. |
| |
|
| |
1. Working with Conditional Logic
2. Working with Lookup Tables
3. Manipulating Information
4. Formatting Numbers
5. Outlining
6. Reviewing a Worksheet /Workbook
7. Sharing Workbooks
8. Consolidating
9. Managing Lists
10. Working with a Database
11. Using PivotTables and Pivot Charts
12. Using Analysis Tools
13. Introducing Macros
14. Security
|
| |
|
| |
|
Course Duration : 9 hours
* All Schedules are correct at the injection date, the management reserved the right to change the schedule from time to time without prior notice. Kindly contact your Account Executive and/or Customer Service Executive for more information and queries. |
| |
|
| |
Informatics Campus
10 & 12 Science Centre Road, Singapore 609080
Course Enquiry Hotline: (65) 6580 4555
Email: enquiry@informaticseducation.com
SMS: +65 91072222
Opening Hours:
Monday - Friday : 9.00am to 9.00pm
Saturday : 9.00am to 5.00pm
Closed on Sunday and Public Holidays
|
|
