Session 1: Microsoft Word Basics
1. Introduction to Microsoft Word
Overview of Word interface
Ribbon, toolbar, and navigation pane
2. Creating and Saving Documents
Starting a new document
Saving and opening documents
3 .Formatting Text
Font styles, sizes, and colours
Paragraph alignment, line spacing, and indentation
Using styles and themes
4. Working with Pages
Inserting and deleting pages
Page breaks and section breaks
Headers, footers, and page numbers
5.Basic Editing and Proofing Tools
Spell check and grammar check
Find and replace
Track changes and comments
Session 2: Microsoft Excel Basics
1. Introduction to Microsoft Excel
Overview of Excel interface
Workbook and worksheet basics
Creating and Managing Workbooks )
Creating new workbooks
Saving and opening workbooks
2. Entering and Editing Data
Entering text, numbers, and dates
3. AutoFill and Flash Fill
Editing cell content
4. Basic Formulas and Functions
Basic arithmetic operations
SUM, AVERAGE, MIN, MAX
Using the AutoSum feature
5. Formatting Cells and Data
Formatting numbers, dates, and text
Cell styles and themes
6.Conditional formatting
Session 3: Microsoft PowerPoint Basics
1.Introduction to Microsoft PowerPoint
Overview of PowerPoint interface
Slide layouts and themes
2.Creating and Saving Presentations
Starting a new presentation
Saving and opening presentations
3.Working with Slides
Adding and deleting slides
Rearranging slides
Slide transitions and animations
4. Adding Content to Slides
Text boxes and bullet points
Inserting images, shapes, and icons
Adding tables and charts
5. Presenting and Printing
Slide show view and presenter view
Printing handouts and slides
Exporting presentations
Advanced Excel - course Outline
• Dynamic Excel Dashboard
• Advanced 50+ Formulas and Functions (VLOOKUP, HLOOKUP, XLOOKUP, etc)
• Macros
• Data Validation and Conditional Formatting
• Data Sorting and Filtering
• Pivot Tables and Pivot Charts
• Advanced Charting Techniques
• Advanced Data Analysis
• Excel Templates
• Advanced Tips and Tricks.
• Short Cut keys
For free trial and more details contact us @ 97343699 /66765847 / Whatsapp.
