Complete Microsoft Office (Word, Excel, PowerPoint, 365) + Office Administration Training
High Skills Training
*Complete 6 Courses in One Bundle* | PDF Certificate | Lifetime Access | Expert Help | 14-Day Money-Back Promise
Add to basket or enquire
Overview
Certificates
Included
Reed Courses Certificate of Completion
Digital certificate
- Show recruiters you've mastered in-demand skills
- Boost your CV and job applications instantly
- Share on LinkedIn to stand out from other candidates
- Transcript of completion included
Description
Course 1: Microsoft Office 365, Word, Excel, PowerPoint 2021
- Introduction to Microsoft Office 365
- Getting Started
- Introduction
- Getting started on Windows, macOS, and Linux
- How to ask great questions
- FAQ’s
- Basics of Excel
- Excel 2021: Basics
- 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
- Excel 2021: Rows, Columns, and Cells
- Adding Rows and Columns
- Modifying Rows and Column lengths
- Excel 2021: Data Handling
- Copy, Cut, and Paste
- Copying Formulas
- Excel 2021: Page Setting Up and Print
- Page setup options
- Fit to print on One Page
- Print Workbooks
- Excel 2021: Sorting and Filtering
- Sorting Data Ascending Order
- Sorting Data Descending Order
- Filter Data
- Excel 2021 Advanced
- Excel 2021: Writing Formulas
- Creating Basic Formulas
- Datetime Formulas
- Mathematical formulas phase1
- Mathematical formulas phase2
- Excel 2021: Advanced Formulas
- VLOOKUP formula
- HLOOKUP formula
- Excel 2021: XLOOKUP only for 2021 and Office 365
- XLOOKUP
- Handling #NA and Approximates match in XLOOKUP
- Excel 2021: Data and Tools
- Split Text into columns
- Flash Fill
- Data Validation
- Remove Duplicates
- Import Data from Text files
- Import Data from .CSV files
- Excel 2021: Formatting data and tables
- Formatting Font
- Formatting Alignment
- Formatting Numbers
- Formatting Date
- Formatting Tables
- Excel 2021: Pivot Tables
- Pivot Tables
- Pivot Charts
- Excel 2021: Charts
- Excel Charts – Categories
- Elements of a chart
- Creating Charts
- Column or Bar charts
- Formatting charts
- Line Charts
- Pie and Doughnut charts
- Basics of Powerpoint
- PowerPoint 2021: Course Introduction
- Overview
- Start PowerPoint Presentation
- Screen setting and Views
- PowerPoint 2021: Basics
- Presentation Tips and Guidelines
- Creating a New Presentation
- Working with Slides
- Save a Presentation
- Print Slides
- PowerPoint 2021: Text and Bullet Options
- Formatting Text
- Slide Text Alignments
- Multi-Column Text Alignments
- Adding Bullets and Numbered List Items
- PowerPoint 2021: Adding Graphic Assets
- Insert Shapes
- Insert Icons
- Insert Graphics
- Add 3D Models
- Insert Pictures
- Advanced Powerpoint Training
- PowerPoint 2021: Picture Formatting
- Picture Options
- Picture Cropping
- Applying Built-in Picture Styles
- PowerPoint 2021: SmartArt Graphics
- Add SmartArt Graphic
- Modifying SmartArt
- Creating a Target Chart using SmartArt
- PowerPoint 2021: Working with Tables
- Create a Table on Slide
- Formatting Tables
- Inserting Tables
- Table Layouts
- PowerPoint 2021: Working with Charts
- Add a Chart
- Formatting Charts
- Insert Chart from Microsoft Excel
- PowerPoint 2021: Adding Multimedia
- Adding Video to a Presentation
- Adding Audio to a Presentation
- Screen Recording and Adding
- PowerPoint 2021: Working with Transition
- Applying Transitions to Presentation
- PowerPoint 2021: Animation
- Object Animation
- Effect Options
- Advanced Animation
- Triggers to control animation
- PowerPoint 2021: Slideshow Effects
- Onscreen Presentation
- Hiding Slides
- Changing the Order of Slides
- Copying Slides
- Microsoft Word: Basics to Advanced
- Word 2021: Introduction
- Overview of MS Word
- Start MS Word 2021
- Word 2021: Basics
- Create a new blank document
- Creating a paragraph text
- Non-printing characters
- Save a document
- Open a document
- Find and replace
- Word 2021: Word Formatting
- AutoCorrect options
- Formatting text
- Copy cut and paste
- Character formatting
- Format painter
- Work with numbers
- Add bullets
- Outline creation
- Word 2021: Tables
- 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
- Word 2021: Styles
- Working with styles
- Creating styles
- Clear formatting
- Word 2021: Page Layout
- Margins
- Orientation
- Page size setting
- Adding columns
- Page break – section break
- Adding watermark
- Headers and footers
- Word 2021: Envelops and Labels
- Create envelops
- Creating labels
- Word 2021: Mail Merges
- Creating a mail merge document
- Word 2021: Review and Printing
- Thesaurus and spell check
- Word count
- Speech - read aloud
- Language - translate
- Tracking
Course 2: Personal Assistant Training
Course 3: Document Management
Course 4: Time Management
Course 5: Professional Receptionist Training
Course 6: Executive Administrative Assistant
What Next ?
After completing this course,visit for more resources to level up your career.Here are some of the courses we offer:
- Project Management Essentials
- Advanced Excel & Data Analysis
- Leadership & Management Training
- Communication Skills for Professionals
- Customer Service Excellence
- Business Writing Skills
- Data Protection & GDPR Awareness
- Conflict Resolution & Negotiation Skills
- Emotional Intelligence in the Workplace
This course prepares you with the skills and knowledge required to enter this field.After completing the course,you can consider attending the following programs to get more professional certification:
- Project Management Essentials Certification
Institution: Chartered Management Institute (CMI), UK
Gain a strong foundation in project management, learning key principles, tools, and techniques to lead projects effectively. - Advanced Excel & Data Analysis Certification
Institution: London School of Business and Finance (LSBF), UK
Master advanced Excel techniques and data analysis skills, enabling you to work with complex data and perform in-depth analysis. - Leadership & Management Training Certification
Institution: Institute of Leadership & Management (ILM), UK
Develop essential leadership and management skills to motivate teams, improve performance, and handle workplace challenges. - Communication Skills for Professionals Certification
Institution: University of Cambridge - Institute of Continuing Education (ICE), UK
Enhance your professional communication skills, including writing, presentations, and interpersonal communication. - Customer Service Excellence Certification
Institution: Institute of Customer Service (ICS), UK
Learn how to deliver exceptional customer service by managing customer relations, resolving issues, and enhancing satisfaction. - Business Writing Skills Certification
Institution: University of Oxford - Department for Continuing Education, UK
Improve your business writing skills, including crafting professional emails, reports, and proposals to communicate effectively in the workplace. - Data Protection & GDPR Awareness Certification
Institution: GDPR Training (UK)
Understand data protection principles and the GDPR regulations to ensure compliance and safeguard personal data. - Conflict Resolution & Negotiation Skills Certification
Institution: University of London - International Programmes, UK
Develop your ability to resolve conflicts and negotiate successfully, skills that are vital for navigating workplace disputes and enhancing relationships. - Emotional Intelligence in the Workplace Certification
Institution: The British Psychological Society (BPS), UK
Master emotional intelligence techniques to improve interpersonal relationships, decision-making, and stress management in the workplace.
For more resources to advance your career, visit highskillstraining Explore our comprehensive library of 200+ meticulously designed courses
Who is this course for?
This course is ideal for:
Jobseekers looking to build practical office skills and strengthen their CV
Aspiring or current administrative professionals, receptionists, or office assistants
Personal assistants, executive assistants, and team coordinators
Professionals transitioning into hybrid or digital office roles
Anyone needing Microsoft Office proficiency for daily work or business operations
Requirements
There is no prerequisite for this. Don’t worry—we will teach you everything step by step.
Career path
This course can prepare you for several job positions, including:
- Administrative Assistant
- Executive Assistant
- Office Manager
- Project Coordinator
- Data Entry Specialist
- Personal Assistant
- Office Administrator
- Customer Service Representative
- Sales Support Specialist
- Marketing Coordinator
Questions and answers
Reviews
Add to basket or enquire
Course provided by
Spread the cost
Interest-free instalments
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.
CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.
A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.
An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
