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
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 |