Day long In-Person

Certified Course on Microsoft Excel

📅 Date: Batch 100 – 7 Dec & Batch 101 8 Dec 2024
🕒 Time: 9:30 AM – 5:30 PM
📍 Venue: ICDB
🎓 Certification Provided

  • Program Duration: 8 Hours  
  • Batch Size: 15
Registration

Why Join Our Training?

Unleash the full potential of Microsoft Excel with our hands-on, in-person training designed for professionals, students, and entrepreneurs. Master essential skills to simplify your work, improve productivity, and gain a competitive edge in the job market.

 

Key Features

  • Practical Exercises: Real-world examples and scenarios.
  • Expert Guidance: Step-by-step instructions from an experienced trainer.
  • Certification: Recognized completion certificate to enhance your resume.
  • Interactive Environment: Engage in discussions and hands-on activities.
  • Post-Training Support: Continued learning with resources and Q&A sessions.
Session Duration Content Outcomes
Introduction
30 minutes
- Welcome and Overview
- Importance of Excel in Professional Work
- Objectives of the Training
- Understand the importance of Excel
- Familiarity with the course outline
Getting Started
1 hour
- Excel Interface Overview
- Workbook and Worksheet Basics
- Data Entry and Navigation
- Saving and Managing Files
- Navigate Excel efficiently
- Open, save, and organize workbooks
- Enter and edit data
Formatting Basics
1 hour
- Cell Formatting (Font, Borders, Colors)
- Number Formats (Currency, Date, Percentage)
- Adjusting Rows/Columns
- Applying Themes and Styles
- Format data for clarity and presentation
- Customize cells for specific data types
Break
15 minutes
Working with Data
1 hour
- Efficient Data Entry Techniques
- Sorting and Filtering for Large Datasets
- Data Validation for Accuracy
- Removing Duplicates
- Organize and filter data efficiently
- Maintain data accuracy and consistency
Break
1 hour
Creating Visuals
1 hour
- Introduction to Charts and Graphs
- Creating a Simple Chart (Bar, Column, Pie)
- Formatting and Customizing Charts
- Visualize data using basic charts
- Create professional and readable charts
Formulas & Functions
2 hours
- Introduction to Formulas and Functions
- Relative vs. Absolute References
- Introduction to BODMAS
- Arithmetic and Logical Functions
SUM, AVERAGE, MIN and MAX, COUNT and COUNTA, IF
- Text Functions CONCAT and TEXTJOIN
LEFT, RIGHT, MID
TRIM, LEN
- Date and Time Functions TODAY, NOW, DATEDIF
- Perform calculations and data analysis with basic and intermediate functions.
Closing Session
15 minutes
- Recap of Key Learnings
- Feedback and Evaluation
- Certificate Distribution
- Summarize takeaways
- Collect feedback for continuous improvement

Who Should Attend?

Professionals looking to enhance data management and analysis skills.

Students preparing for data-driven roles.

Entrepreneurs managing their own business data.