Microsoft Excel Training - Beginner to Expert Level in Hindi

Course Overview

• Course Title: Microsoft Excel Training - Beginner to Expert Level in Hindi
• Instructor: ZK Tutorials
• Target Audience: Beginner to Advanced Excel Users
• Prerequisites: A Computer with Excel installed

Curriculum Highlights

• Key Topics Covered:
  • Introduction to Excel
  • Logical statements in Excel (IF, SUMIF, COUNTIF, IF and OR NOT etc.)
  • Functions in Excel (conditional formatting, color, protection, flash, text to column etc.)
  • Lookup (V and H look up)
  • Pivot tables, slicers, pivot charts
  • Date and Time function
  • Data handling Dsum, dmax, dmin, dcount
  • Advance component in Excel
  • Excel Macros and VBA
• Key Skills Learned:
  • Basic formula writing and cell references
  • Utilizing logical functions for data analysis
  • Advanced functions (e.g., SUMIFS, COUNTIFS)
  • Conditional formatting to highlight data
  • Vertical Lookup (VLOOKUP) for finding data in tables
  • Recording simple macros to automate tasks
  • Writing and editing macros using VBA code

Course Format

• Duration: 10 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 20 downloadable resources
  • Access on mobile and TV
  • Certificate of completion