Welcome to Adarsh Computer Academy

WELCOME TO ADARSH COMPUTER ACADEMY

 
CERTIFICATE IN ADVANCE EXCEL ( S-S-ADV-EXCEL -04 )

BASIC INFORMATION

  • Course Fees : 1800.00 2000.00/-
  • Course Duration : 30 DAYS
  • Minimum Amount To Pay : Rs.1800.00

Module 1: Foundations of Advanced Excel

  • ·         Efficiency and Risk
  • ·         Templates
  • ·         Increasing Efficiency and Reducing Risk
  • ·         Data Validation
  • ·         Advanced Techniques

 Module 2: Advanced Functions and Formulas

  • ·         Functions with Superpowers
  • ·         Array Formulas
  • ·         Tables
  •  ·         Advanced Range Names

 Module 3: Data Analysis and Visualization

  • ·         What If Analysis
  • ·         Problem Solving
  • ·         Excel Interactivity
  • ·         Form Controls
  • ·         Conditional Formatting
  • ·         Charts that Inspire
  • ·         Sparklines
  • ·         Graphics Tricks and Techniques

Module 4: Advanced Data Management and Reporting

  • ·         Turning Data into Decisions
  • ·         Working with External Data
  • ·         Advanced Uses of PivotTables
  • ·         PowerPivot
  • ·         Reporting with PowerPivot

Module 5: Course Plenary and Revision

  • ·         Course Plenary
  • ·         Revise what you have learned

Note: The syllabus can be customized based on the requirements of the learners or the location.

10 TH PASSED