Booking options
£11.99
Course Images
Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
8 hours
All levels
Description
Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.
In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.
The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.
Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
Master the fundamentals of Excel 2021, including entering data and working with ranges.
Create and modify Excel charts and pivot tables for data analysis.
Develop PowerPoint presentations with advanced animations and multimedia elements.
Format documents in Word 2021, including creating tables and managing styles.
Execute mail merges and manage page layouts effectively in Word 2021.
Utilise Office 365 features for enhanced productivity and collaboration.
Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.
The Course Curriculum of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
Section 01: Getting Started
Section 02: Excel 2021: Basics
Section 03: Excel 2021: Rows, Columns, And Cells
Section 04: Excel 2021: Data Handling
Section 05: Excel 2021: Page Setting Up And Print
Section 06: Excel 2021: Sorting And Filtering
Section 07: Excel 2021: Writing Formulas
Section 08: Excel 2021: Advanced Formulas
Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365
Section 10: Excel 2021: Data And Tools
Section 11: Excel 2021: Formatting Data And Tables
Section 12: Excel 2021: Pivot Tables
Section 13: Excel 2021: Charts
Section 14: PowerPoint 2021: Course Introduction
Section 15: PowerPoint 2021: Basics
Section 16: PowerPoint 2021: Text And Bullet Options
Section 17: PowerPoint 2021: Adding Graphic Assets
Section 18: PowerPoint 2021: Picture Formatting
Section 19: PowerPoint 2021: SmartArt Graphics
Section 20: PowerPoint 2021: Working With Tables
Section 21: PowerPoint 2021: Working With Charts
Section 22: PowerPoint 2021: Adding Multimedia
Section 23: PowerPoint 2021: Working With Transition
Section 24: PowerPoint 2021: Animation
Section 25: PowerPoint 2021: Slideshow Effects
Section 26: Word 2021: Introduction
Section 27: Word 2021: Basics
Section 28: Word 2021: Word Formatting
Section 29: Word 2021: Tables
Section 30: Word 2021: Styles
Section 31: Word 2021: Page Layout
Section 32: Word 2021: Envelops And Lables
Section 33: Word 2021: Mail Merges
Section 34: Word 2021: Review And Printing
Who is this course for:
Professionals seeking to enhance their productivity with Microsoft Office tools.
Students aiming to improve their technical skills for academic purposes.
Administrative staff needing comprehensive knowledge of Office applications.
Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.
Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
CPD QS Accredited PDF Certificate - Included
CPD QS Accredited Hard Copy Certificate - Not Included
Requirements:
This course has no academic entry requirements and is accessible to students from all backgrounds.
Career Path:
Administrative Assistant: £18,000 - £25,000 per annum
Data Analyst: £25,000 - £40,000 per annum
Office Manager: £22,000 - £35,000 per annum
Project Coordinator: £23,000 - £37,000 per annum
Executive Assistant: £25,000 - £45,000 per annum
IT Support Specialist: £22,000 - £38,000 per annum
Enrol now and advance your Microsoft Office skills to a professional level.
Frequently Asked Questions
What Microsoft Office applications does this course cover?
This course comprehensively covers Microsoft Excel 2021, Word 2021, and PowerPoint 2021.
Does this course cover the latest features of Microsoft Office?
Yes, the course includes modules on XLOOKUP, a function exclusive to Excel 2021 and Microsoft 365.
What kind of certification will I receive?
Upon completing the course, you can obtain a CPD QS certificate at an additional cost:
- £9.99 for a PDF
- £16.99 for a printed hard copy
- £24.99 for both PDF and printed versions
Are there any prerequisites for this course?
No, this course is designed for students of all backgrounds and requires no prior academic qualifications.
What software do I need to complete this course?
While not explicitly stated, completing the course exercises would benefit from having access to Microsoft Office applications (Excel, Word, and PowerPoint).
What jobs can I get with Microsoft Office skills?
Proficiency in Microsoft Office is valuable across many professions. The course highlights career paths such as Data Analyst, Office Manager, and Project Coordinator, all of which typically require strong Microsoft Office skills.
What is the salary range for these careers?
The course provides a salary range for various positions; for instance, Data Analysts can expect to earn between £25,000 and £40,000 per year (UK).
Can I take this course online?
Yes, the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course is available online, allowing you to learn at your own pace and convenience.
How long does the course take to complete?
The duration of the course varies depending on the learner's pace.
Is there support available if I have questions during the course?
Yes, we offer comprehensive support throughout your learning journey. You can reach out to our support team via email or phone for any questions or assistance you may need.
About The Provider
Reviews
There are no reviews for Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 yet.Why not be the first one to review this course?