Course Objectives
By the end of this course, participants will:
- Master the essential features of Microsoft Excel, PowerPoint, and Word.
- Be able to create, format, and analyze documents, spreadsheets, and presentations.
- Gain practical skills for using Microsoft Office tools in business and personal contexts.
Introduction to Microsoft Office (2 Classes)
Class 1: Introduction to Microsoft Word (2 hours)
- Overview of Microsoft Word interface
- Creating and saving documents
- Formatting text (fonts, sizes, styles, and colors)
- Working with paragraphs (alignment, indentation, line spacing)
- Using bullet points and numbering
Class 2: Introduction to Microsoft Excel (2 hours)
- Overview of Microsoft Excel interface
- Introduction to cells, rows, and columns
- Basic formatting (font, cell size, alignment)
- Using number formats (currency, date, percentage, etc.)
- Simple calculations (SUM, AVERAGE, MIN, MAX)
Microsoft Word (3 Classes)
Class 3: Formatting Documents in Word (2 hours)
- Advanced formatting techniques (headers, footers, page numbers)
- Inserting images, tables, and shapes
- Using Styles for consistent formatting
- Creating and managing a table of contents
Class 4: Working with Templates, References, and Review Tools (2 hours)
- Using and customizing templates
- Inserting footnotes, endnotes, and citations
- Track changes and comments for collaboration
- Using the “Find and Replace” feature effectively
Class 5: Document Formatting and Printing (2 hours)
- Page layout and orientation settings
- Working with columns, sections, and breaks
- Printing options (print preview, page setup)
- Creating mail merges
Microsoft Excel (5 Classes)
Class 6: Advanced Excel Functions (2 hours)
- Introduction to advanced functions (IF, VLOOKUP, HLOOKUP, INDEX, MATCH)
- Logical and lookup functions
- Text functions (CONCATENATE, TEXT, LEFT, RIGHT, MID)
Class 7: Working with Data in Excel (2 hours)
- Sorting and filtering data
- Using the AutoFill feature
- Conditional formatting for data visualization
- Data validation and drop-down lists
Class 8: Data Analysis and Pivot Tables (2 hours)
- Introduction to PivotTables and PivotCharts
- Grouping and summarizing data with PivotTables
- Creating and analyzing PivotCharts
- Using slicers for dynamic reporting
Class 9: Creating and Formatting Charts (2 hours)
- Introduction to Excel charts (bar, line, pie, etc.)
- Customizing chart design and formatting
- Creating dynamic charts linked to data ranges
- Using charts for visual data analysis
Class 10: Advanced Excel Tools (2 hours)
- Working with multiple worksheets and workbooks
- Protecting and sharing workbooks
- Using Excel’s data analysis tools (Goal Seek, Solver)
- Creating macros to automate repetitive tasks
Microsoft PowerPoint (4 Classes)
Class 11: Introduction to PowerPoint and Basic Slide Creation (2 hours)
- Overview of PowerPoint interface
- Creating and saving presentations
- Working with slide layouts, themes, and background designs
- Adding and formatting text on slides
Class 12: Inserting and Formatting Media in PowerPoint (2 hours)
- Inserting images, videos, and audio into slides
- Formatting shapes, text boxes, and SmartArt
- Working with transitions and animations
- Grouping and aligning objects
Class 13: Advanced PowerPoint Features (2 hours)
- Using master slides for consistent formatting
- Customizing animations and transitions for professional presentations
- Creating charts and tables in PowerPoint
- Using hyperlinks and action buttons
Class 14: Presentation Skills and Delivery (2 hours)
- Preparing slides for an engaging presentation
- Using speaker notes and rehearsing timings
- Sharing and printing PowerPoint presentations
- Effective use of PowerPoint for webinars and meetings
Final Review and Hands-On Practice (2 Classes)
Class 15: Integration Between Excel, Word, and PowerPoint (2 hours)
- Linking and embedding Excel charts and tables into Word and PowerPoint
- Copy-paste options between the programs
- Data analysis and presentation integration across apps
Class 16: Review, Q&A, and Final Project (2 hours)
- Recap of key features from Word, Excel, and PowerPoint
- Hands-on project: Create a report in Word with embedded charts from Excel and PowerPoint slides for a presentation
- Final Q&A and troubleshooting common issues
Key Highlights
- Practical Assignments: Weekly exercises and hands-on tasks to reinforce learning.
- Interactive Learning: Live demonstrations, group discussions, and Q&A sessions.
- Certification: Participants will receive a certificate of completion after successfully finishing the course and final assessment.
Course Details
Duration: 2 Months
Class Frequency: 2 Classes per Week
Class Length: 2 Hours per Class
Total Classes: 16
Course Fee: BDT 8,000.00 (Discounts are occasionally available.)
Stay Updated! At Facebook page
Follow our Facebook page to see the latest updates and Discounted pricing. Feel free to message us directly for inquiries.
👉 Visit Our Facebook Page Click Here
COMMENTS