GET LIFETIME ACCESS TO ALL OUR COURSES FOR ONLY £199 £99 GET NOW
Take This Course
- Original price was: £175.00.£21.00Current price is: £21.00.
- 1 year
- Diploma
- Course Certificate
- Number of Units135
- Number of Quizzes0
- 8 hours, 23 minutes Gift this course
Course Overview
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Microsoft Office 2021 – Word, Excel, PowerPoint & 365 will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time.
The Microsoft Office 2021 – Word, Excel, PowerPoint & 365 will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently.
This course is designed to provide an introduction to Microsoft Office 2021 – Word, Excel, PowerPoint & 365 and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area.
Learning Objectives
- Learn the fundamental skills you require to be an expert
- Explore different techniques used by professionals
- Find out the relevant job skills & knowledge to excel in this profession
- Get a clear understanding of the job market and current demand
- Update your skills and fill any knowledge gap to compete in the relevant industry
- CPD accreditation for proof of acquired skills and knowledge
Who is this Course for?
Whether you are a beginner or an existing practitioner, our CPD accredited Microsoft Office 2021 – Word, Excel, PowerPoint & 365 is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further.
It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects.
Entry Requirement
Anyone interested in learning more about this subject should take this Microsoft Office 2021 – Word, Excel, PowerPoint & 365. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject.
The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day.
CPD Certificate from Course Gate
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
Career path
The Microsoft Office 2021 – Word, Excel, PowerPoint & 365 will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market.
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:18: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:00: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:03: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:00: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:03: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 | ||
| 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 | ||
| Certificate and Transcript | |||
| Order Your Certificates or Transcripts | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
Take This Course
- Original price was: £175.00.£21.00Current price is: £21.00.
- 1 year
- Diploma
- Course Certificate
- Number of Units135
- Number of Quizzes0
- 8 hours, 23 minutes Gift this course
Gift this courseShare Link on 
Instructors
Buying more than one of the same courses?
- 45% discount for orders of 10+ courses
- 55% discount for orders of 50+ courses
- 65% discount for orders of 100+ courses
Looking for a more personalised package?
contact us now
