Booking options
Price:
BuyContact Us£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 certificates are available at an additional cost of £9.99 for a PDF, £16.99 for a printed hard copy, and £24.99 for both PDF and printed versions.
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?