Overview:
Welcome to "Mastering Microsoft Office: Word, Excel, PowerPoint, and 365," your gateway to becoming proficient in the essential tools for productivity and data management. This course provides a comprehensive exploration of Microsoft Office applications, empowering you with the skills needed to create professional documents, analyze data effectively, and deliver compelling presentations. With hands-on exercises and practical guidance, you'll unlock the full potential of Word, Excel, PowerPoint, and the collaborative features of Office 365.- Interactive video lectures by industry experts
- Instant e-certificate
- Fully online, interactive course with Professional voice-over
- Developed by qualified first aid professionals
- Self paced learning and laptop, tablet, smartphone friendly
- 24/7 Learning Assistance
- Discounts on bulk purchases
Main Course Features:
- Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
- Practical exercises to reinforce learning
- Tips and tricks for efficient document creation, data analysis, and presentation design
- Guidance on leveraging advanced features and functionalities
- Real-world examples and case studies for practical application
Who Should Take This Course:
- Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
- Practical exercises to reinforce learning
- Tips and tricks for efficient document creation, data analysis, and presentation design
- Guidance on leveraging advanced features and functionalities
- Real-world examples and case studies for practical application
Learning Outcomes:
- Master document creation and formatting in Microsoft Word
- Excel in data analysis and visualization using Microsoft Excel
- Design compelling presentations with Microsoft PowerPoint
- Utilize collaborative features of Office 365 effectively
- Automate tasks and workflows using advanced features
- Create professional reports, spreadsheets, and presentations
- Improve productivity through efficient use of Office applications
- Gain practical skills applicable to various industries and professions
Certification
Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.Assessment
At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.Course Content
135 Lectures 8hr 27min
Section 01: Getting Started - 4 lessons
Introduction- Getting started on Windows, macOS, and Linux
- How to ask great questions
- FAQ’s
Section 02: Excel 2021: Basics - 7 lessons
- Excel Overview
- Start Excel Spreadsheet
- Enter Text and Numbers
- Relative References
- Working with ranges
- Save and Save as Actions
- File Extensions, Share, Export, and Publish files
Section 03: Excel 2021: Rows, Columns, and Cells - 2 lessons
- Adding Rows and Columns
- Modifying Rows and Column lengths
Section 04: Excel 2021: Data Handling - 2 lessons
- Copy, Cut, and Paste
- Copying Formulas
Section 05: Excel 2021: Page Setting Up and Print - 3 lessons
- Page setup options
- Fit to print on One Page
- Print Workbooks
Section 06: Excel 2021: Sorting and Filtering - 3 lessons
- Sorting Data Ascending Order
- Sorting Data Descending Order
- Filter Data
Section 07: Excel 2021: Writing Formulas - 4 lessons
- Creating Basic Formulas
- Datetime Formulas
- Mathematical formulas phase1
- Mathematical formulas phase2
Section 08: Excel 2021: Advanced Formulas - 2 lessons
- VLOOKUP formula
- HLOOKUP formula
Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 - 2 lessons
- XLOOKUP
- Handling #NA and Approximates match in XLOOKUP
Section 10: Excel 2021: Data and Tools - 6 lessons
- Split Text into columns
- Flash Fill
- Data Validation
- Remove Duplicates
- Import Data from Text files
- Import Data from .CSV files
Section 11: Excel 2021: Formatting data and tables - 5 lessons
- Formatting Font
- Formatting Alignment
- Formatting Numbers
- Formatting Date
- Formatting Tables
Section 12: Excel 2021: Pivot Tables - 2 lessons
- Pivot Tables
- Pivot Charts
Section 13: Excel 2021: Charts - 7 lessons
- Excel Charts – Categories
- Elements of a chart
- Creating Charts
- Column or Bar charts
- Formatting charts
- Line Charts
- Pie and Doughnut charts
Section 14: PowerPoint 2021: Course Introduction - 3 lessons
- Overview
- Start PowerPoint Presentation
- Screen setting and Views
Section 15: PowerPoint 2021: Basics - 5 lessons
- Presentation Tips and Guidelines
- Creating a New Presentation
- Working with Slides
- Save a Presentation
- Print Slides
Section 16: PowerPoint 2021: Text and Bullet Options - 4 lessons
- Formatting Text
- Slide Text Alignments
- Multi-Column Text Alignments
- Adding Bullets and Numbered List Items
Section 17: PowerPoint 2021: Adding Graphic Assets - 5 lessons
- Insert Shapes
- Insert Icons
- Insert Graphics
- Add 3D Models
- Insert Pictures
Section 18: PowerPoint 2021: Picture Formatting - 3 lessons
- Picture Options
- Picture Cropping
- Applying Built-in Picture Styles
Section 19: PowerPoint 2021: SmartArt Graphics - 3 lessons
- Add SmartArt Graphic
- Modifying SmartArt
- Creating a Target Chart using SmartArt
Section 20: PowerPoint 2021: Working with Tables - 4 lessons
- Create a Table on Slide
- Formatting Tables
- Inserting Tables
- Table Layouts
Section 21: PowerPoint 2021: Working with Charts - 3 lessons
- Add a Chart
- Formatting Charts
- Insert Chart from Microsoft Excel
Section 22: PowerPoint 2021: Adding Multimedia - 3 lessons
- Adding Video to a Presentation
- Adding Audio to a Presentation
- Screen Recording and Adding
Section 23: PowerPoint 2021: Working with Transition - 1 lessons
- Applying Transitions to Presentation
Section 24: PowerPoint 2021: Animation - 4 lessons
- Object Animation
- Effect Options
- Advanced Animation
- Triggers to control animation
Section 25: PowerPoint 2021: Slideshow Effects - 4 lessons
- Onscreen Presentation
- Hiding Slides
- Changing Order of Slides
- Copying Slides
Section 26: Word 2021: Introduction - 2 lessons
- Overview of MS Word
- Start MS Word 2021
Section 27: Word 2021: Basics - 6 lessons
- Create a new blank document
- Creating a paragraph text
- Non-printing characters
- Save a document
- Open a document
- Find and replace
Section 28: Word 2021: Word Formatting - 8 lessons
- AutoCorrect options
- Formatting text
- Copy cut and paste
- Character formatting
- Format painter
- Work with numbers
- Add bullets
- Outline creation
Section 29: Word 2021: Tables - 10 lessons
- Creating a table
- Adding rows and columns to a table
- Formatting table data
- Borders and shading
- Sorting in a table
- Draw a table
- Convert text to table
- Convert table to text
- Insert a spreadsheet
- Quick tables – readily available formats
Section 30: Word 2021: Styles - 3 lessons
- Working with styles
- Creating styles
- Clear formatting
Section 31: Word 2021: Page Layout - 7 lessons
- Margins
- Orientation
- Page size setting
- Adding columns
- Page break – section break
- Adding watermark
- Headers and footers
Section 32: Word 2021: Envelops and Lables - 2 lessons
- Create envelops
- Creating labels
Section 33: Word 2021: Mail Merges - 1 lessons
- Creating a mail merge document
Section 34: Word 2021: Review and Printing - 5 lessons
- Thesaurus and spell check
- Word count
- Speech – read aloud
- Language – translate
- Tracking
Enrolled: 
Duration: 
Chapters: