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