Advanced Excel Course

Enroll in the

Advanced Excel Course
  • Duration 2 Month
  • Language
  • Level Certificate
  • Fees One-time ₹ 3000
  • Fees Monthly ₹ 1500
  • Registration Charges ₹ 100

Need Help

Are you ready to elevate your Excel skills to an advanced level? Join our "Advanced Excel Course" at SCI Computer Institute and unlock the full potential of Microsoft Excel. Whether you're a business professional, analyst, or student, this course is designed to empower you with advanced Excel capabilities that can significantly enhance your productivity and decision-making.

  • Introduction to Excel Interface
  • Creating and Formatting Spreadsheets
  • Data Entry and Navigation
  • Basic Formulas and Functions
  • Cell Formatting and Styling
  • Sorting and Filtering Data
  • Using PivotTables for Data Summarization
  • Data Validation and Error Checking
  • Conditional Formatting
  • Data Consolidation Techniques
  • Working with Advanced Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Logical and Text Functions
  • Date and Time Functions
  • Array Formulas
  • Formula Auditing and Error Handling
  • Creating Charts and Graphs
  • Customizing Chart Elements
  • Sparklines for Data Trends
  • Advanced Chart Types
  • Data Labels and Annotations
  • Text-to-Columns and Data Cleansing
  • Using Goal Seek and Solver
  • What-If Analysis with Scenario Manager
  • Advanced Filtering and Slicers
  • Grouping and Outlining Data
  • Macros and Automation
  • Customizing Excel with Macros
  • Data Import and Export
  • Excel Add-Ins and Power Query
  • Excel Tips and Tricks for Efficiency