Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Overview:
In today’s digital world, proficiency in Microsoft Office is no longer a bonus, it’s essential. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course is designed for anyone who wants to elevate their productivity and unlock the full potential of Microsoft Office. Whether you’re a student, professional, entrepreneur, or stay-at-home parent, mastering these applications will equip you with the skills to excel in your chosen field.
Our interactive course structure provides clear explanations, and step-by-step guides to help your learning journey. Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is your gateway to a world of opportunity. Enrol today and take your productivity to the next level!
Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
- Master data analysis: Learn foundational and advanced formulas in Excel 2021, including VLOOKUP, HLOOKUP, and XLOOKUP, to manipulate and analyse data efficiently.
- Craft compelling presentations: Gain expertise in designing impactful presentations using PowerPoint 2021. Explore elements like transitions, animations, and multimedia integration to engage your audience.
- Produce professional documents: Develop proficiency in Word 2021 to create polished and error-free documents. Master formatting, layout, and styles to enhance readability and professionalism.
- Navigate across platforms: Learn how to leverage the core functionalities of Microsoft Office 365 on Windows, macOS, and Linux operating systems, ensuring seamless workflow across devices.
- Embrace collaboration: Explore the collaborative features of Microsoft Office 365 to share documents, presentations, and spreadsheets with colleagues in real-time, fostering efficient teamwork.
- Boost efficiency: Discover time-saving techniques across all applications in Microsoft Office 365, including keyboard shortcuts, data validation tools, and automation features.
Who is This Course For:
- Students seeking to enhance their employability.
- Professionals looking to advance their careers.
- Individuals who want to improve their efficiency and organisation.
- Anyone who wants to confidently navigate the Microsoft Office suite.
Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
Upon completing this course, you can enhance your professional credentials and showcase your achievement by ordering a CPD-accredited certificate. Choose the option that best suits your needs:
- PDF Certificate: £9.99
- PDF Certificate + PDF Transcript: £11.99
- Hardcopy Certificate + Hardcopy Transcript: £23.99
- Complete Package – Certificate & Transcript (Hard Copy + PDF): £29.99
Requirements:
This course does not have academic entry requirements and is open to students of all backgrounds.
Career Paths:
- Administrative Assistant: £20,000 – £28,000
- Business Analyst: £30,000 – £45,000
- Marketing Executive: £25,000 – £38,000
- Customer Service Representative: £18,000 – £25,000
- Project Manager: £35,000 – £50,000
- Data Analyst: £28,000 – £42,000
- And Many More!
Course Curriculum
| Section 01: Getting Started | |||
| Introduction | 00:03:00 | ||
| Getting started on Windows, macOS, and Linux | 00:01:00 | ||
| How to ask great questions | 00:01:00 | ||
| FAQ’s | 00:01:00 | ||
| Section 02: Excel 2021: Basics | |||
| Excel Overview | 00:05:00 | ||
| Start Excel Spreadsheet | 00:04:00 | ||
| Enter Text and Numbers | 00:07:00 | ||
| Relative References | 00:04:00 | ||
| Working with ranges | 00:07:00 | ||
| Save and Save as Actions | 00:08:00 | ||
| File Extensions, Share, Export, and Publish files | 00:06:00 | ||
| Section 03: Excel 2021: Rows, Columns, And Cells | |||
| Adding Rows and Columns | 00:03:00 | ||
| Modifying Rows and Column lengths | 00:05:00 | ||
| Section 04: Excel 2021: Data Handling | |||
| Copy, Cut, and Paste | 00:07:00 | ||
| Copying Formulas | 00:03:00 | ||
| Section 05: Excel 2021: Page Setting Up And Print | |||
| Page setup options | 00:06:00 | ||
| Fit to print on One Page | 00:03:00 | ||
| Print Workbooks | 00:03:00 | ||
| Section 06: Excel 2021: Sorting And Filtering | |||
| Sorting Data Ascending Order | 00:04:00 | ||
| Sorting Data Descending Order | 00:02:00 | ||
| Filter Data | 00:04:00 | ||
| Section 07: Excel 2021: Writing Formulas | |||
| Creating Basic Formulas | 00:06:00 | ||
| Datetime Formulas | 00:06:00 | ||
| Mathematical formulas phase1 | 00:20:00 | ||
| Mathematical formulas phase2 | 00:12:00 | ||
| Section 08: Excel 2021: Advanced Formulas | |||
| VLOOKUP formula | 00:12:00 | ||
| HLOOKUP formula | 00:04:00 | ||
| Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365 | |||
| XLOOKUP | 00:08:00 | ||
| Handling #NA and Approximates match in XLOOKUP | 00:11:00 | ||
| Section 10: Excel 2021: Data And Tools | |||
| Split Text into columns | 00:07:00 | ||
| Flash Fill | 00:07:00 | ||
| Data Validation | 00:07:00 | ||
| Remove Duplicates | 00:08:00 | ||
| Import Data from Text files | 00:06:00 | ||
| Import Data from .CSV files | 00:03:00 | ||
| Section 11: Excel 2021: Formatting Data And Tables | |||
| Formatting Font | 00:04:00 | ||
| Formatting Alignment | 00:06:00 | ||
| Formatting Numbers | 00:05:00 | ||
| Formatting Date | 00:03:00 | ||
| Formatting Tables | 00:05:00 | ||
| Section 12: Excel 2021: Pivot Tables | |||
| Pivot Tables | 00:07:00 | ||
| Pivot Charts | 00:02:00 | ||
| Section 13: Excel 2021: Charts | |||
| Excel Charts – Categories | 00:03:00 | ||
| Elements of a chart | 00:04:00 | ||
| Creating Charts | 00:02:00 | ||
| Column or Bar charts | 00:04:00 | ||
| Formatting charts | 00:04:00 | ||
| Line Charts | 00:02:00 | ||
| Pie and Doughnut charts | 00:04:00 | ||
| Section 14: PowerPoint 2021: Course Introduction | |||
| Overview | 00:04:00 | ||
| Start PowerPoint Presentation | 00:05:00 | ||
| Screen setting and Views | 00:05:00 | ||
| Section 15: PowerPoint 2021: Basics | |||
| Presentation Tips and Guidelines | 00:06:00 | ||
| Creating a New Presentation | 00:04:00 | ||
| Working with Slides | 00:04:00 | ||
| Save a Presentation | 00:04:00 | ||
| Print Slides | 00:03:00 | ||
| Section 16: PowerPoint 2021: Text And Bullet Options | |||
| Formatting Text | 00:05:00 | ||
| Slide Text Alignments | 00:03:00 | ||
| Multi-Column Text Alignments | 00:02:00 | ||
| Adding Bullets and Numbered List Items | 00:03:00 | ||
| Section 17: PowerPoint 2021: Adding Graphic Assets | |||
| Insert Shapes | 00:03:00 | ||
| Insert Icons | 00:03:00 | ||
| Insert Graphics | 00:04:00 | ||
| Add 3D Models | 00:03:00 | ||
| Insert Pictures | 00:03:00 | ||
| Section 18: PowerPoint 2021: Picture Formatting | |||
| Picture Options | 00:04:00 | ||
| Picture Cropping | 00:03:00 | ||
| Applying Built-in Picture Styles | 00:04:00 | ||
| Section 19: PowerPoint 2021: SmartArt Graphics | |||
| Add SmartArt Graphic | 00:03:00 | ||
| Modifying SmartArt | 00:03:00 | ||
| Creating a Target Chart using SmartArt | 00:03:00 | ||
| Section 20: PowerPoint 2021: Working With Tables | |||
| Create a Table on Slide | 00:04:00 | ||
| Formatting Tables | 00:02:00 | ||
| Inserting Tables | 00:02:00 | ||
| Table Layouts | 00:01:00 | ||
| Section 21: PowerPoint 2021: Working With Charts | |||
| Add a Chart | 00:02:00 | ||
| Formatting Charts | 00:02:00 | ||
| Insert Chart from Microsoft Excel | 00:03:00 | ||
| Section 22: PowerPoint 2021: Adding Multimedia | |||
| Adding Video to a Presentation | 00:03:00 | ||
| Adding Audio to a Presentation | 00:02:00 | ||
| Screen Recording and Adding | 00:02:00 | ||
| Section 23: PowerPoint 2021: Working With Transition | |||
| Applying Transitions to Presentation | 00:04:00 | ||
| Section 24: PowerPoint 2021: Animation | |||
| Object Animation | 00:03:00 | ||
| Effect Options | 00:02:00 | ||
| Advanced Animation | 00:02:00 | ||
| Triggers to control animation | 00:02:00 | ||
| Section 25: PowerPoint 2021: Slideshow Effects | |||
| Onscreen Presentation | 00:02:00 | ||
| Hiding Slides | 00:02:00 | ||
| Changing Order of Slides | 00:02:00 | ||
| Copying Slides | 00:02:00 | ||
| Section 26: Word 2021: Introduction | |||
| Overview of MS Word | 00:04:00 | ||
| Start MS Word 2021 | 00:05:00 | ||
| Section 27: Word 2021: Basics | |||
| Create a new blank document | 00:04:00 | ||
| Creating a paragraph text | 00:05:00 | ||
| Non-printing characters | 00:03:00 | ||
| Save a document | 00:03:00 | ||
| Open a document | 00:01:00 | ||
| Find and replace | 00:04:00 | ||
| Section 28: Word 2021: Word Formatting | |||
| AutoCorrect options | 00:03:00 | ||
| Formatting text | 00:04:00 | ||
| Copy cut and paste | 00:04:00 | ||
| Character formatting | 00:02:00 | ||
| Format painter | 00:04:00 | ||
| Work with numbers | 00:02:00 | ||
| Add bullets | 00:03:00 | ||
| Outline creation | 00:04:00 | ||
| Section 29: Word 2021: Tables | |||
| Creating a table | 00:03:00 | ||
| Adding rows and columns to a table | 00:02:00 | ||
| Formatting table data | 00:02:00 | ||
| Borders and shading | 00:02:00 | ||
| Sorting in a table | 00:04:00 | ||
| Draw a table | 00:04:00 | ||
| Convert text to table | 00:03:00 | ||
| Convert table to text | 00:02:00 | ||
| Insert a spreadsheet | 00:02:00 | ||
| Quick tables – readily available formats | 00:02:00 | ||
| Section 30: Word 2021: Styles | |||
| Working with styles | 00:02:00 | ||
| Creating styles | 00:02:00 | ||
| Clear formatting | 00:01:00 | ||
| Section 31: Word 2021: Page Layout | |||
| Margins | 00:02:00 | ||
| Orientation | 00:01:00 | ||
| Page size setting | 00:01:00 | ||
| Adding columns | 00:03:00 | ||
| Page break – section break | 00:02:00 | ||
| Adding watermark | 00:03:00 | ||
| Headers and footers | 00:03:00 | ||
| Section 32: Word 2021: Envelops And Lables | |||
| Create envelops | 00:02:00 | ||
| Creating labels | 00:02:00 | ||
| Section 33: Word 2021: Mail Merges | |||
| Creating a mail merge document | 00:03:00 | ||
| Section 34: Word 2021: Review And Printing | |||
| Thesaurus and spell check | 00:01:00 | ||
| Word count | 00:01:00 | ||
| Speech – read aloud | 00:01:00 | ||
| Language – translate | 00:01:00 | ||
| Tracking | 00:01:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
Computer Workstation Safety Training
Original price was: £320.00.£24.99Current price is: £24.99.
Electronic Document Management
Original price was: £320.00.£11.99Current price is: £11.99.
Advanced Typing Training Course
Original price was: £320.00.£11.99Current price is: £11.99.
10 STUDENTS ENROLLED
