What you'll learn
The MS Office 365 Standard course at ET&T Computer Education & Training is designed to provide in-depth, practical knowledge of the most widely used office productivity tools: Microsoft Word, Excel, and PowerPoint. This advanced-level training equips students and professionals with the skills required to create professional documents, perform complex data analysis, and deliver impactful presentations in a modern workplace.
The course focuses on advanced features and techniques of MS Office 365 applications, enabling learners to improve productivity, automate tasks, and enhance collaboration using cloud-based Office tools. Participants will gain hands-on experience in using formulas, data visualization, formatting, templates, macros, and advanced presentation tools to meet real-world business and academic requirements.
Key Learning Areas:
Advanced Microsoft Word
- Professional document formatting and styles
- Table of contents, headers, footers, and page numbering
- Mail merge, templates, and document automation
- Track changes, comments, and collaboration features
- Advanced graphics, SmartArt, and document security
Advanced Microsoft Excel
- Advanced formulas and functions (LOOKUP, INDEX-MATCH, TEXT, DATE)
- Pivot tables and Pivot charts for data analysis
- Conditional formatting and data validation
- Charts, dashboards, and data visualization
- Introduction to macros and automation (VBA basics)
Advanced Microsoft PowerPoint
- Designing professional slide decks
- Slide master, templates, and custom layouts
- Advanced animations, transitions, and multimedia integration
- Charts, SmartArt, and infographics
- Collaborative presentations and real-time editing
Who Should Attend:
- Students, job seekers, and professionals aiming to improve workplace productivity
- Entrepreneurs and business owners handling reports, presentations, and data
- Anyone looking to gain advanced skills in Microsoft Office 365 for academic or professional purposes
Prerequisites:
- Basic knowledge of computers and MS Office is recommended
- No prior advanced knowledge required
Course Outcome:
By the end of this course, learners will be able to:
- Create and manage professional documents, spreadsheets, and presentations
- Analyze and visualize data effectively using Excel
- Deliver impactful and professional presentations
- Increase productivity using advanced MS Office 365 features
Show More
Course Syllabus
Module 1: Advanced Microsoft Word
- Overview of MS Word 365 and interface features
- Document formatting: Styles, themes, fonts, and paragraph alignment
- Headers, footers, page numbers, and section breaks
- Creating and managing tables, charts, and SmartArt
- Advanced features: Mail Merge, Templates, and AutoText
- Collaboration tools: Track Changes, Comments, and Co-authoring
- Document security: Password protection, restricting editing, and digital signatures
- Hands-on exercises: Create a professional report, automate letters using mail merge
Module 2: Advanced Microsoft Excel
- Excel interface and advanced navigation shortcuts
- Advanced formulas and functions:
- Lookup & Reference (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Logical (IF, AND, OR, IFS)
- Text & Date functions
- Mathematical & Statistical functions
- Data tools: Conditional formatting, data validation, remove duplicates
- Pivot Tables & Pivot Charts for data summarization and analysis
- Data visualization: Charts, Sparklines, and Dashboard creation
- Introduction to macros and VBA basics for automation
- Hands-on exercises: Prepare financial reports, create dashboards, automate repetitive tasks
Module 3: Advanced Microsoft PowerPoint
- PowerPoint interface and slide management
- Slide master, templates, and custom layouts
- Designing professional presentations with themes and color schemes
- Advanced animations, slide transitions, and multimedia integration (audio, video, GIFs)
- Charts, SmartArt, and infographics for visual impact
- Collaborative features: Sharing, co-authoring, and commenting
- Presentation tips: Notes, rehearse timing, and slide show delivery
- Hands-on exercises: Create a corporate presentation with charts, animation, and multimedia
Module 4: Integration & Productivity Tools
- Linking data between Word, Excel, and PowerPoint
- Using OneDrive for cloud storage and collaboration
- Sharing documents and real-time editing
- Keyboard shortcuts, tips, and productivity hacks for faster workflow
- Hands-on exercises: Create an integrated report combining Excel data into Word and PowerPoint
Module 5: Practical Applications & Projects
- Prepare a professional business report in Word
- Create a financial dashboard in Excel
- Design an interactive presentation in PowerPoint
- Real-world mini-projects simulating office tasks
- End-of-course project combining all three applications
Course Outcomes
By the end of this course, learners will be able to:
- Handle professional documents, spreadsheets, and presentations efficiently
- Perform data analysis, visualization, and reporting using Excel
- Create impactful presentations with advanced multimedia and design features
- Improve productivity and collaboration using MS Office 365 cloud tools
Who Should Attend
- Students, job seekers, and working professionals
- Entrepreneurs and business owners
- Anyone aiming to gain advanced office productivity skills
Prerequisites
- Basic knowledge of computers
- No prior advanced experience required
Bestseller
