Topics Covered:

• Workbook Basics: Open, save, and navigate Excel workbooks.
• Data Entry: Input numbers, text, and dates into cells.
• Basic Formulas: Use SUM, AVERAGE, MIN, and MAX functions.
• Cell Formatting: Change number formats, fonts, and cell colors.
• Rows and Columns: Insert, delete, and resize rows and columns.
• Sorting and Filtering: Organize data by sorting and applying filters.
• Charts: Create simple charts like bar, line, and pie charts.
• Page Setup: Adjust settings for printing, including margins and orientation.
• Freezing Panes: Keep headers visible while scrolling through data.
• Basic Functions: Learn to use functions like COUNT and IF.
• AutoFill: Quickly fill cells with repetitive or sequential data.
• Cell References: Understand relative, absolute, and mixed references.
• Worksheet Management: Add, rename, and delete worksheets.
• Printing Options: Set print areas and adjust scaling.
• Basic Data Validation: Add data list validation to specific types or ranges.

Objective:
To enable students to manage data, use formulas, and make reports with charts.

Assignment:
Design a basic sales report with totals, conditional formatting, and charts.

Topics Covered:

• Creating Presentations: Start new presentations and choose themes.
• Slide Management: Add, delete, and rearrange slides.
• Text Formatting: Insert and format text boxes with different fonts and sizes.
• Inserting Media: Add images, shapes, and charts to slides.
• Slide Transitions: Apply transitions between slides for visual effect.
• Animations: Animate text and objects to enhance engagement.
• Speaker Notes: Add notes to guide your presentation delivery.
• Slide Show: Run the presentation in full-screen mode.
• Printing Options: Print slides, handouts, and notes pages.
• Saving Formats: Save presentations in different formats like PDF.
• Using Templates: Start presentations with pre-designed templates.
• SmartArt Graphics: Create diagrams and process charts.
• Hyperlinks: Link to other slides, documents, or websites.
• Embedding Videos: Insert and play videos within slides.
• Slide Master: Customize the overall design and layout.

Objective:
To help learners prepare eye-catching and meaningful presentations.

Assignment:
Make a 10-slides business or academic presentation using SmartArt,animations and multimedia. Use the skills provided in class training.

Topics Covered:

• Email Management: Compose, send, receive, and reply to emails.
• Contacts: Add and manage contact information.
• Calendar: Schedule appointments and meetings.
• Tasks: Create and manage to-do lists.
• Email Signatures: Create and insert personalized signatures.
• Out of Office Replies: Set automatic responses when unavailable.

Objective:
To help participants communicate professionally and manage schedules efficiently.

Assignment:
Send a formal email with attachment and schedule a meeting invite.