Microsoft Office Skills for Office Administration Level 3 CPD Certified Diploma

Learndrive

• Course 01: Mastering Microsoft Office 2021 8:17:59

  • 1: Microsoft Office: 1a Introduction 02:58
  • 2: Microsoft Office: 1b Getting started on Windows macOS and Linux 01:21
  • 3: Microsoft Office: 1c How to ask great questions 01:14
  • 4: Microsoft Office: 1d FAQs 01:19
  • 5: Microsoft Office: 2a Excel Overview 05:20
  • 6: Microsoft Office: 2b Start Excel Spreadsheet 04:26
  • 7: Microsoft Office: 2c Enter Text and Numbers 07:24
  • 8: Microsoft Office: 2d Relative References 03:40
  • 9: Care for a Feedback 01:00
  • 10: Microsoft Office: 2e Working with ranges 06:52
  • 11: Microsoft Office: 2f Save and Save as Actions 07:52
  • 12: Microsoft Office: 2g File Extensions, Share, Export, and Publish files 05:53
  • 13: Microsoft Office: 3a Adding Rows and Columns 02:34
  • 14: Microsoft Office: 3b Modifying Rows and Column lengths 05:03
  • 15: Microsoft Office: 4a Copy Cut and Paste 07:07
  • 16: Microsoft Office: 4b Copying Formulas 03:01
  • 17: Microsoft Office: 5a Page setup options 05:50
  • 18: Microsoft Office: 5b Fit to print on One Page 02:39
  • 19: Microsoft Office: 5c Print Workbooks 02:47
  • 20: Microsoft Office: 6a Sorting Data Ascending Order 03:48
  • 21: Microsoft Office: 6b Sorting Data Descending Order 02:25
  • 22: Microsoft Office: 6c Filter Data 04:09
  • 23: Microsoft Office: 7a Basic formula operations 06:14
  • 24: Microsoft Office: 7b Date time functions 06:20
  • 25: Microsoft Office: 7c Mathematical functions phase1 19:54
  • 26: Microsoft Office: 7d Mathematical functions phase2 12:23
  • 27: Microsoft Office: 8a V Lookup formula 12:12
  • 28: Microsoft Office: 8b HLookup formula 04:07
  • 29: Microsoft Office: 9a XLookup 07:39
  • 30: Microsoft Office: 9b Handling NA and Approximates match in XLookup 10:31
  • 31: Microsoft Office: 10a Split Text into columns 07:03
  • 32: Microsoft Office: 10b Flash Fill 07:03
  • 33: Microsoft Office: 10c Data Validation 06:34
  • 34: Microsoft Office: 10d Remove Duplicates 07:47
  • 35: Microsoft Office: 10e Get - import Data from Text 05:38
  • 36: Microsoft Office: 10f Get - import Data from CSV 03:22
  • 37: Microsoft Office: 11a Formatting Font 04:15
  • 38: Microsoft Office: 11b Formatting Alignment 06:04
  • 39: Microsoft Office: 11c Formatting Number 04:37
  • 40: Microsoft Office: 11d Formatting Date 03:29
  • 41: Microsoft Office: 11e Formatting tables 05:13
  • 42: Microsoft Office: 12a Creating Pivot Table 06:43
  • 43: Microsoft Office: 12b Pivot charts 01:49
  • 44: Microsoft Office: 13a Excel Charts – Categories 02:30
  • 45: Microsoft Office: 13b Elements of a chart 04:12
  • 46: Microsoft Office: 13c Creating charts 01:55
  • 47: Microsoft Office: 13d Column or Bar charts 04:21
  • 48: Microsoft Office: 13e Formatting charts 03:37
  • 49: Microsoft Office: 13f Line charts 02:13
  • 50: Microsoft Office: 13g Pie and Doughnut charts 03:47
  • 51: Microsoft Office: 14a Overview 03:47
  • 52: Microsoft Office: 14b Start PowerPoint Presentation 04:59
  • 53: Microsoft Office: 14c Screen setting and Views 04:37
  • 54: Microsoft Office: 15a Presentation Tips and Guidelines 06:00
  • 55: Microsoft Office: 15b Creating a New Presentation 03:51
  • 56: Microsoft Office: 15c Working with Slides 03:40
  • 57: Microsoft Office: 15d Save a Presentation 04:16
  • 58: Microsoft Office: 15e Print Slides 03:10
  • 59: Microsoft Office: 16a Formatting Text 05:05
  • 60: Microsoft Office: 16b Slide Text Alignments 03:01
  • 61: Microsoft Office: 16c Multi-Column Text Alignments 01:40
  • 62: Microsoft Office: 16d Adding Bullets and Numbered List Items 02:48
  • 63: Microsoft Office: 17a Insert Shapes 03:26
  • 64: Microsoft Office: 17b Insert Icons 03:02
  • 65: Microsoft Office: 17c Insert Graphics 03:38
  • 66: Microsoft Office: 17d Add 3D Models 02:41
  • 67: Microsoft Office: 17e Insert Pictures 02:58
  • 68: Microsoft Office: 18a Picture Options 03:56
  • 69: Microsoft Office: 18b Picture Cropping 02:33
  • 70: Microsoft Office: 18c Applying Built-in Picture Styles 04:02
  • 71: Microsoft Office: 19a Add SmartArt Graphic 02:33
  • 72: Microsoft Office: 19b Modifying SmartArt 03:13
  • 73: Microsoft Office: 19c Creating a Target Chart using SmartArt 03:04
  • 74: Microsoft Office: 20a Create a Table on Slide 04:13
  • 75: Microsoft Office: 20b Formatting Tables 02:24
  • 76: Microsoft Office: 20c Inserting Tables 01:55
  • 77: Microsoft Office: 20d Table Layouts 01:19
  • 78: Microsoft Office: 21a Add a Chart 01:57
  • 79: Microsoft Office: 21b Formatting Charts 01:48
  • 80: Microsoft Office: 21c Insert Chart from Microsoft Excel 02:57
  • 81: Microsoft Office: 22a Adding Video to a Presentation 02:31
  • 82: Microsoft Office: 22b Adding Audio to a Presentation 01:33
  • 83: Microsoft Office: 22c Screen Recording and Adding 02:28
  • 84: Microsoft Office: 23a Applying Transitions to Presentation 04:14
  • 85: Microsoft Office: 24a Object Animation 03:14
  • 86: Microsoft Office: 24b Effect Options 02:03
  • 87: Microsoft Office: 24c Advanced Animation 01:31
  • 88: Microsoft Office: 24d Triggers to control animation 01:47
  • 89: Microsoft Office: 25a Onscreen Presentation 02:16
  • 90: Microsoft Office: 25b Hiding Slides 01:42
  • 91: Microsoft Office: 25c Changing Order of Slides 01:50
  • 92: Microsoft Office: 25d Copying Slides 02:10
  • 93: Microsoft Office: 26a Overview of MS Word 03:57
  • 94: Microsoft Office: 26b Start MS Word 2021 04:48
  • 95: Microsoft Office: 27a Create a New Blank Document 04:20
  • 96: Microsoft Office: 27b Creating a Paragraph Text 04:55
  • 97: Microsoft Office: 27c Non-printing characters 02:59
  • 98: Microsoft Office: 27d Save a Document 02:45
  • 99: Microsoft Office: 27e Open a Document 01:22
  • 100: Microsoft Office: 27f Find and Replace 03:50
  • 101: Microsoft Office: 28a AutoCorrect Options 02:54
  • 102: Microsoft Office: 28b Formatting Text 03:59
  • 103: Microsoft Office: 28c Copy Cut and Paste 03:50
  • 104: Microsoft Office: 28d Character Formatting 02:28
  • 105: Microsoft Office: 28e Format Painter 03:58
  • 106: Microsoft Office: 28f Work with Numbers 01:43
  • 107: Microsoft Office: 28g Add Bullets 02:46
  • 108: Microsoft Office: 28h Outline Creation 03:42
  • 109: Microsoft Office: 29a Creating a Table 02:30
  • 110: Microsoft Office: 29b Adding Rows and Columns to a table 02:10
  • 111: Microsoft Office: 29c Formatting Table Data 02:19
  • 112: Microsoft Office: 29d Borders and Shading 01:45
  • 113: Microsoft Office: 29e Sorting in a Table 03:41
  • 114: Microsoft Office: 29f Draw a Table 03:31
  • 115: Microsoft Office: 29g Convert Text to Table 02:43
  • 116: Microsoft Office: 29h Convert Table to Text 02:05
  • 117: Microsoft Office: 29i Insert a Spreadsheet 01:41
  • 118: Microsoft Office: 29j Quick Tables – Readily Available Formats 01:52
  • 119: Microsoft Office: 30a Working with Styles 01:54
  • 120: Microsoft Office: 30b Creating Styles 01:50
  • 121: Microsoft Office: 30c Clear Formatting 01:16
  • 122: Microsoft Office: 31a Margins 01:44
  • 123: Microsoft Office: 31b Orientation 01:23
  • 124: Microsoft Office: 31c Page size setting 00:57
  • 125: Microsoft Office: 31d Adding columns 03:24
  • 126: Microsoft Office: 31e Page break section break 01:37
  • 127: Microsoft Office: 31f Adding watermark 02:58
  • 128: Microsoft Office: 31g Headers and footers 02:41
  • 129: Microsoft Office: 32a Create envelops 02:28
  • 130: Microsoft Office: 32b Creating labels 01:58
  • 131: Microsoft Office: 33a Creating a mail merge document 03:19
  • 132: Microsoft Office: 34a Thesaurus and spell check 01:09
  • 133: Microsoft Office: 34b Word count 01:21
  • 134: Microsoft Office: 34c Speech - read aloud 00:58
  • 135: Microsoft Office: 34d Language - translate 01:13
  • 136: Microsoft Office: 34e Tracking 01:10

• Course 02: Administrative Assistant 1:55:15

  • 137: 1.1 - Introduction to Administrative Assistant 00:42
  • 138: 1.2 - An Overview of the Role of an Administrative Assistant 05:27
  • 139: 1.3 - Key Contributions of an Administrative Assistant to Organisational Success 04:33
  • 140: 2.1 - Workstation and Daily Routine 00:39
  • 141: 2.2 - The Importance of a Well-Organised Workstation 05:24
  • 142: 2.3 - Use of Dictation and Transcription 04:29
  • 143: 3.1 - Relationship Management 00:57
  • 144: 3.2 - Relationship Building Between the Boss and the Assistant 04:46
  • 145: 3.3 - Professional Image for Effective Relationship 06:18
  • 146: 4.1 - Communication Skills of Administrative Assistant 00:42
  • 147: 4.2 - Body Language The Art of Communicating Without Words 05:24
  • 148: 4.3 - Matching and Mirroring 08:52
  • 149: 5.1 - Keeping Accurate Records 00:42
  • 150: 5.2 - Crucial Duty of Administrative Assistant in Record-Keeping and File Manag 05:20
  • 151: 5.3 - Computer Files Organisation 02:54
  • 152: 6.1 - Office Equipment in an Organisation 00:55
  • 153: 6.2 - The Evolution of Telephones From PBXs to VoIP 03:59
  • 154: 6.3 - Office Computers The Backbone of Business Productivity 08:17
  • 155: 7.1 - Travel Arrangements 00:50
  • 156: 7.2 - Business Travel and Making Travel Arrangements 05:16
  • 157: 7.3 - Reservations of Transports 04:49
  • 158: 8.1 - Email Management 00:47
  • 159: 8.2 - Overview of Email An Essential Communication Tool for Businesses 06:49
  • 160: 8.3 - Email Programs 05:28
  • 161: 9.1 - Meeting Arrangement 00:36
  • 162: 9.2 - Meeting Anatomy 05:05
  • 163: 9.3 - Scheduling Meetings and Some Problems 04:55
  • 164: 10.1 - Dealing with People and Managing Conflicts 00:47
  • 165: 10.2 - Problem-Solving Techniques in an Organisation 05:11
  • 166: 10.3 - Think Before Speaking 04:22

• Final Exam 01:00

  • 167: Final Exam 01:00

• Order Your CPDQE Certificate and Transcript 01:00

  • 168: Order Your CPDQE Certificate and Transcript 01:00

Key Lesson Snippets:

➥ Microsoft Office Excel 2021
Gain in-depth knowledge of Excel 2021, focusing on data management, spreadsheet functionalities, and advanced formulas to handle administrative tasks effectively.

➥ Microsoft Office PowerPoint
Learn to design engaging and professional presentations that communicate information clearly and persuasively, an essential skill for effective office communication.

➥ Microsoft Office Word
Master document creation, from simple memos to complex reports, with Microsoft Word's extensive formatting, styles, and design options.

➥ Introduction to Administrative Assistant
Explore the role of an administrative assistant with an emphasis on using Microsoft Office tools to manage appointments, schedules, and office documentation.

➥ Workstation and Daily Routine Management
Organize and optimize your daily administrative routines using Microsoft Office applications to enhance efficiency and productivity at your workstation.

➥ Relationship Management
Understand the techniques to build and maintain professional relationships, enhancing workplace communication and cooperation.

➥ Travel Arrangements
Master the logistics of planning and booking travel, including accommodations and itineraries, to ensure smooth business trips.

➥ Email Management
Develop strategies to efficiently handle email communication, prioritize messages, and maintain professional correspondence.

➥ Dealing with People and Managing Conflicts
Gain insights into navigating interpersonal dynamics and resolving conflicts constructively in the workplace.

This course will pave the way for higher study in the field of Microsoft Office for Office Administration. You can enrol on higher level Microsoft Office for Office Administration courses, such as:

• Level 3 Certificate in Microsoft Office
• Level 4 Certificate in Microsoft Office
• Level 3 Certificate in the Use of Microsoft Office Applications
• BTEC Level 3 Diploma in Microsoft Office Applications

• Office Administrator
• HR Admin
• Receptionist
• Audio Typist
• Office Admin
• Customer service representative
• Administrative assistant

There are currently no Q&As for this course. Be the first to ask a question.