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.

• Working with Conditional Logic
• Working with Lookup Tables
• Manipulating Information
• Formatting Numbers
• Outlining
• Reviewing a Worksheet / Workbook
• Sharing Workbooks
• Consolidating
• Managing Lists
• Working with a Database
• Using PivotTables and Pivot Charts
• Using Analysis Tools
• Introducing Macros
• 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.

Click here for Programme Enquiry

Informatics Professional Development Centre (IPDC) is an independent entity from Microsoft Corporation and is not affiliated with Microsoft Corporation in any manner. This course is not sponsored by, endorsed by, or affiliated with Microsoft Corporation. Window XP and Microsoft Office are trademarks or registered trademarks of Microsoft Corporation in the United States and certain other countries. All other trademarks are trademarks of their respective owners.