3 Hours 

• Electricity Bill Calculation
• Necessary Functions & Formulas (Part 04):
  • Round Function, Roundup Function, Rounddown Function, Goal Seek Command

• Create & Manage Table:
  • Create An Excel Table From A Cell Range
  • Add Column & Rows In The Table
  • Customize Table Style Options
  • Controlling Table Using Slicer
  • Sorting & Filtering Table Data
  • Convert A Table To A Normal Range

3 Hours 

• Data Visualization – Creating & Working With Charts:
  • Creating Recommended Charts
  • Moving & Resizing A Chart
  • Formatting And Editing Objects In A Chart
  • Changing A Charts Source Data
  • Changing A Chart Type
  • Working With Pie Charts, Bar Charts, Line Charts, Scatter Charts
  • Uses Of 3 Types Of Sparklines: Line, Column, Win & Loss

• Create & Manage Pivottable & Pivotchart (Part 01):
  • Intro of Pivottable
  • Creating Pivottable With One Row & Column
  • Creating Pivottable Report With Multiple Groups
  • Changing Layout Pivottable
  • Text Orientation

3 Hours 

• Create & Manage Pivottable & Pivotchart (Part 02):
  • Managing Subtotal & Grand Total
  • Changing The Data Field Summary Operation
  • Drill Down The Pivottable Value
  • Filtering The Pivottable Data
  • Creating Pivotchart
  • Use Slicers In Pivottable
  • Formatting A Pivotchart
  • Printing A Pivottable
  • Printing A Pivotchart

• How To Prepare & Maintain A Professional Petty Cashbook In Excel Sheet

• Concept Of Macro

3 Hours 

• Concept Of VBA
• Practice With Practical Business Case Study
• Various Excel Secrets & Shortcuts
• Problem Solving & Recap
  (Topics From 1^st to 8^th Class)

3 Hours 

• Practical Exam