Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

Description

This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic.

After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast-track your career ladder.

You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.

There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds.

Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.

Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-

And much more!

34 sections • 135 lectures • 08:20:00 total length

•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

•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

•Adding Rows and Columns: 00:03:00

•Modifying Rows and Column lengths: 00:05:00

•Copy, Cut, and Paste: 00:07:00

•Copying Formulas: 00:03:00

•Page setup options: 00:06:00

•Fit to print on One Page: 00:03:00

•Print Workbooks: 00:03:00

•Sorting Data Ascending Order: 00:04:00

•Sorting Data Descending Order: 00:02:00

•Filter Data: 00:04:00

•Creating Basic Formulas: 00:06:00

•Datetime Formulas: 00:06:00

•Mathematical formulas phase1: 00:20:00

•Mathematical formulas phase2: 00:12:00

•VLOOKUP formula: 00:12:00

•HLOOKUP formula: 00:04:00

•XLOOKUP: 00:08:00

•Handling #NA and Approximates match in XLOOKUP: 00:11:00

•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

•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

•Pivot Tables: 00:07:00

•Pivot Charts: 00:02:00

•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

•Overview: 00:04:00

•Start PowerPoint Presentation: 00:05:00

•Screen setting and Views: 00:05:00

•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

•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

•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

•Picture Options: 00:04:00

•Picture Cropping: 00:03:00

•Applying Built-in Picture Styles: 00:04:00

•Add SmartArt Graphic: 00:03:00

•Modifying SmartArt: 00:03:00

•Creating a Target Chart using SmartArt: 00:03:00

•Create a Table on Slide: 00:04:00

•Formatting Tables: 00:02:00

•Inserting Tables: 00:02:00

•Table Layouts: 00:01:00

•Add a Chart: 00:02:00

•Formatting Charts: 00:02:00

•Insert Chart from Microsoft Excel: 00:03:00

•Adding Video to a Presentation: 00:03:00

•Adding Audio to a Presentation: 00:02:00

•Screen Recording and Adding: 00:02:00

•Applying Transitions to Presentation: 00:04:00

•Object Animation: 00:03:00

•Effect Options: 00:02:00

•Advanced Animation: 00:02:00

•Triggers to control animation: 00:02:00

•Onscreen Presentation: 00:02:00

•Hiding Slides: 00:02:00

•Changing Order of Slides: 00:02:00

•Copying Slides: 00:02:00

•Overview of MS Word: 00:04:00

•Start MS Word 2021: 00:05:00

•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

•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

•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

•Working with styles: 00:02:00

•Creating styles: 00:02:00

•Clear formatting: 00:01:00

•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

•Create envelops: 00:02:00

•Creating labels: 00:02:00

•Creating a mail merge document: 00:03:00

•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