KLiC Certificate in Advanced Excel

Event Expense Sheet

Advanced Excel Skills:

• Apply Custom Data Formats
• Use Advanced Fill Options
• Apply Advanced Conditional Formatting and Filtering
• Use Form Controls
• Apply Custom Styles and Templates
• Prepare Workbooks for Internationalization
• Mathematical Functions
• Look up data by using functions
• Apply advanced date and time functions
• Functions for Manipulating Text
• Merge Scenarios
• Create Scenarios
• Use Area, Scatter & Stock Charts
• Create Custom Chart Templates
• Manage Workbook Versions
• Copy Macros between Workbooks
• Protect Workbooks for Sharing

Outputs:

• Event Expenses
• Exam Record
• Planner
• To Do List
• Database
• Monthly Budget
• Agenda
• Receipt
• Inventory

Database

Detailed Syllabus:

KLiC Advanced Excel

Apply Custom Formats and Layouts:

• Apply Custom Data Formats
• Use Advanced Fill Options
• Apply Advanced Conditional Formatting and Filtering
• Apply Custom Styles and Templates
• Use Form Controls
• Prepare Workbooks for Internationalization
• Use Outlines
• Use Custom Views