The syllabus covers the following skills –

1. Apply custom formats and layouts
2. Create advanced formulas
3. Use of Scenario
4. Pivot tables and charts
5. Manage and share workbooks

Outputs:

The participant will learn to draw Event expenses, Exam record, to do list, Database, Monthly Budget, Agenda, Receipt and Inventory

Syllabus mapping:

The KLiC Advanced Excel is highly recommended to MBA students as it covers 94% syllabus of MBA subject ‘MS Excel and Advanced Excel Lab’.

Event Expense sheet

Database

Detailed Syllabus:

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

Create advanced formulas

• Functions
• Apply functions in formulas
• Mathematical Functions
• Financial functions
• Useful Data Functions
• Some Other Useful Functions
• Look up data by using functions
• Apply advanced date and time functions
• Functions for Manipulating Text
• Arrays

Use Scenarios

• Use What-If Analysis Tools
• Create Scenarios
• Merge Scenarios
• Create Scenario Summaries
• Use Data Tables
• Create Advanced Charts
• Basic Excel Charts
• Use Area, Scatter & Stock Charts
• Use Surface, Radar & Combination Charts
• Create Custom Chart Templates
• Work with Sparkline’s

Pivot tables & charts

• PivotTables
• Use Pivot Charts

Manage and Share Workbooks

• Manage Workbook Versions
• Copy Styles within Workbooks
• Copy Macros within Workbooks
• Use Track Changes and Comments
• Merge Workbooks
• Protect Workbooks for Sharing
• Connect To External Data
  
  
  Download Syllabus