Microsoft Office Skills (Word, PowerPoint, Excel, Outlook, Project)

In today’s digital landscape, proficiency in office software isn’t just a valuable skill – it’s a necessity. Imagine effortlessly navigating through spreadsheets, crafting captivating presentations, and seamlessly communicating through emails. Our comprehensive training programme is your gateway to mastering the entire suite of Microsoft Office applications. Whether you're a seasoned professional looking to enhance your capabilities or a newcomer eager to dive into the world of office productivity, our meticulously crafted modules cater to all levels of expertise.

Key Features:

• CPD Certified
• Free Certificate from Reed
• CIQ Approved
• Developed by Specialist
• Lifetime Access

• Microsoft Office Skills (Word, PowerPoint, Excel, Outlook, Project) 8:16:59

  • 1: 1a Introduction.mp4 02:58
  • 2: 1b Getting started on Windows macOS and Linux.mp4 01:21
  • 3: 1c How to formulate excellent inquiries.mp4 01:14
  • 4: 1d Frequently Asked Questions.mp4 01:19
  • 5: 2a Overview of Excel.mp4 05:20
  • 6: 2b Launching Excel Spreadsheet.mp4 04:26
  • 7: 2c Inputting Text and Numbers.mp4 07:24
  • 8: 2d Relative References in Action.mp4 03:40
  • 9: 2e Manipulating Ranges.mp4 06:52
  • 10: 2f Saving and Saving as Procedures.mp4 07:52
  • 11: 2g File Extensions, Sharing, Exporting, and Publishing files.mp4 05:53
  • 12: 3a Inserting Rows and Columns.mp4 02:34
  • 13: 3b Adjusting Row and Column Lengths.mp4 05:03
  • 14: 4a Copying, Cutting, and Pasting Techniques.mp4 07:07
  • 15: 4b Replicating Formulas.mp4 03:01
  • 16: 5a Customizing Page Setup.mp4 05:50
  • 17: 5b Adjusting for Printing on One Page.mp4 02:39
  • 18: 5c Printing Workbooks.mp4 02:47
  • 19: 6a Ascending Data Sorting.mp4 03:48
  • 20: 6b Descending Data Sorting.mp4 02:25
  • 21: 6c Filtering Data Sets.mp4 04:09
  • 22: 7a Basic Arithmetic Operations.mp4 06:14
  • 23: 7b Time and Date Functions.mp4 06:20
  • 24: 7c Phase One Mathematical Functions.mp4 19:54
  • 25: 7d Phase Two Mathematical Functions.mp4 12:23
  • 26: 8a Vertical Lookup Formula.mp4 12:12
  • 27: 8b Horizontal Lookup Formula.mp4 04:07
  • 28: 9a Mastering XLookup.mp4 07:39
  • 29: 9b Handling Missing Values and Approximate Matches in XLookup.mp4 10:31
  • 30: 10a Segmenting Text into Columns.mp4 07:03
  • 31: 10b Automated Data Fill.mp4 07:03
  • 32: 10c Validating Data.mp4 06:34
  • 33: 10d Eliminating Duplicate Entries.mp4 07:47
  • 34: 10e Importing Data from Text Files.mp4 05:38
  • 35: 10f Importing Data from CSV Files.mp4 03:22
  • 36: 11a Font Formatting Techniques.mp4 04:15
  • 37: 11b Aligning Data Formats.mp4 06:04
  • 38: 11c Formatting Numbers.mp4 04:37
  • 39: 11d Formatting Dates.mp4 03:29
  • 40: 11e Formatting Data Tables.mp4 05:13
  • 41: 12a Creating Pivot Tables.mp4 06:43
  • 42: 12b Utilizing Pivot Charts.mp4 01:49
  • 43: 13a Categorizing Excel Charts.mp4 02:30
  • 44: 13b Anatomy of a Chart.mp4 04:12
  • 45: 13c Crafting Charts.mp4 01:55
  • 46: 13d Column and Bar Chart Visualization.mp4 04:21
  • 47: 13e Fine-Tuning Chart Appearances.mp4 03:37
  • 48: 13f Drawing Line Charts.mp4 02:13
  • 49: 13g Pie and Doughnut Chart Creation.mp4 03:47
  • 50: 14a Course Overview.mp4 03:47
  • 51: 14b Initiating PowerPoint Presentations.mp4 04:59
  • 52: 14c Screen Adjustments and Views.mp4 04:37
  • 53: 15a Tips and Guidelines for Presentations.mp4 06:00
  • 54: 15b Initiating a New Presentation.mp4 03:51
  • 55: 15c Managing Slides.mp4 03:40
  • 56: 15d Saving Presentations.mp4 04:16
  • 57: 15e Printing Slides.mp4 03:10
  • 58: 16a Text Formatting Essentials.mp4 05:05
  • 59: 16b Aligning Text on Slides.mp4 03:01
  • 60: 16c Aligning Text in Multi-Column Layouts.mp4 01:40
  • 61: 16d Adding Bullets and Numbered Lists.mp4 02:48
  • 62: 17a Incorporating Shapes.mp4 03:26
  • 63: 17b Adding Icons.mp4 03:02
  • 64: 17c Inserting Graphics.mp4 03:38
  • 65: 17d Incorporating 3D Models.mp4 02:41
  • 66: 17e Embedding Pictures.mp4 02:58
  • 67: 18a Advanced Picture Options.mp4 03:56
  • 68: 18b Image Cropping Techniques.mp4 02:33
  • 69: 18c Applying Preset Picture Styles.mp4 04:02
  • 70: 19a Integrating SmartArt Graphics.mp4 02:33
  • 71: 19b Tailoring SmartArt Graphics.mp4 03:13
  • 72: 19c Constructing Target Charts with SmartArt.mp4 03:04
  • 73: 20a Table Creation on Slides.mp4 04:13
  • 74: 20b Refining Table Formats.mp4 02:24
  • 75: 20c Embedding Tables.mp4 01:55
  • 76: 20d Table Layout Design.mp4 01:19
  • 77: 21a Integrating Charts into Presentations.mp4 01:57
  • 78: 21b Fine-Tuning Chart Formats.mp4 01:48
  • 79: 21c Importing Charts from Microsoft Excel.mp4 02:57
  • 80: 22a Integrating Video into Presentations.mp4 02:31
  • 81: 22b Incorporating Audio into Presentations.mp4 01:33
  • 82: 22c Recording Screen Activities and Integrating.mp4 02:28
  • 83: 23a Applying Transitions to Presentations.mp4 04:14
  • 84: 24a Animating Objects.mp4 03:14
  • 85: 24b Customizing Effect Options.mp4 02:03
  • 86: 24c Advanced Animation Techniques.mp4 01:31
  • 87: 24d Using Triggers to Control Animation.mp4 01:47
  • 88: 25a Presenting Onscreen.mp4 02:16
  • 89: 25b Concealing Slides.mp4 01:42
  • 90: 25c Rearranging Slides.mp4 01:50
  • 91: 25d Duplicating Slides.mp4 02:10
  • 92: 26a Overview of MS Word.mp4 03:57
  • 93: 26b Initiating MS Word 2021.mp4 04:48
  • 94: 27a Creating Blank Documents.mp4 04:20
  • 95: 27b Creating Paragraph Texts.mp4 04:55
  • 96: 27c Displaying Non-Printing Characters.mp4 02:59
  • 97: 27d Saving Documents.mp4 02:45
  • 98: 27e Accessing Documents.mp4 01:22
  • 99: 27f Searching and Replacing Text.mp4 03:50
  • 100: 28a Autocorrect Functionality.mp4 02:54
  • 101: 28b Text Formatting Tips.mp4 03:59
  • 102: 28c Copying, Cutting, and Pasting Techniques.mp4 03:50
  • 103: 28d Formatting Characters.mp4 02:28
  • 104: 28e Utilizing Format Painter.mp4 03:58
  • 105: 28f Numerical Operations.mp4 01:43
  • 106: 28g Adding Bullets.mp4 02:46
  • 107: 28h Outline Formation.mp4 03:42
  • 108: 29a Generating Tables.mp4 02:30
  • 109: 29b Adding Rows and Columns to Tables.mp4 02:10
  • 110: 29c Formatting Table Data.mp4 02:19
  • 111: 29d Applying Borders and Shading to Tables.mp4 01:45
  • 112: 29e Sorting Tables.mp4 03:41
  • 113: 29f Drawing Tables.mp4 03:31
  • 114: 29g Converting Text to Tables.mp4 02:43
  • 115: 29h Converting Tables to Text.mp4 02:05
  • 116: 29i Integrating Spreadsheets.mp4 01:41
  • 117: 29j Quick Tables – Predefined Formats.mp4 01:52
  • 118: 30a Utilizing Styles.mp4 01:54
  • 119: 30b Establishing Styles.mp4 01:50
  • 120: 30c Removing Formatting.mp4 01:16
  • 121: 31a Adjusting Margins.mp4 01:44
  • 122: 31b Configuring Orientation.mp4 01:23
  • 123: 31c Customizing Page Size.mp4 00:57
  • 124: 31d Incorporating Columns.mp4 03:24
  • 125: 31e Implementing Page and Section Breaks.mp4 01:37
  • 126: 31f Adding Watermarks.mp4 02:58
  • 127: 31g Customizing Headers and Footers.mp4 02:41
  • 128: 32a Crafting Envelopes.mp4 02:28
  • 129: 32b Generating Labels.mp4 01:58
  • 130: 33a Creating Mail Merge Documents.mp4 03:19
  • 131: 34a Thesaurus and Spell Check.mp4 01:09
  • 132: 34b Word Count Functionality.mp4 01:21
  • 133: 34c Utilizing Speech to Read Aloud.mp4 00:58
  • 134: 34d Language Translation Feature.mp4 01:13
  • 135: 34e Tracking Changes.mp4 01:10

Unlock the power of Excel as you delve into the intricacies of data manipulation, from basic formulas to advanced functions. Harness the potential of PowerPoint to craft visually stunning presentations that leave a lasting impact on your audience. Dive into the depths of Word and discover the art of document creation and formatting like never before. From organising your inbox with Outlook to efficiently managing projects with Project, our course equips you with the tools and techniques essential for success in today’s competitive landscape. With engaging tutorials, practical demonstrations, and hands-on exercises, you’ll gain the confidence to tackle any task with finesse. Elevate your skill set, boost your productivity, and propel your career forward with our Microsoft Office Skills training programme.

Course curriculum:

• 1a Introduction
• 1b Getting started on Windows macOS and Linux
• 1c How to formulate excellent inquiries
• 1d Frequently Asked Questions
• 2a Overview of Excel
• 2b Launching Excel Spreadsheet
• 2c Inputting Text and Numbers
• 2d Relative References in Action
• 2e Manipulating Ranges
• 2g File Extensions, Sharing, Exporting, and Publishing files
• 2f Saving and Saving as Procedures
  
• 3b Adjusting Row and Column Lengths
• 3a Inserting Rows and Columns
• 4a Copying, Cutting, and Pasting Techniques
• 4b Replicating Formulas
• 7b Time and Date Functions
• 7a Basic Arithmetic Operations
• 6c Filtering Data Sets
• 6b Descending Data Sorting
• 6a Ascending Data Sorting
• 5c Printing Workbooks
• 5b Adjusting for Printing on One Page
• 5a Customizing Page Setup
• 7c Phase One Mathematical Functions
• 7d Phase Two Mathematical Functions
• 10c Validating Data
• 10b Automated Data Fill
• 10a Segmenting Text into Columns
• 9b Handling Missing Values and Approximate Matches in XLookup
• 9a Mastering XLookup
• 8b Horizontal Lookup Formula
• 8a Vertical Lookup Formula
• 12a Creating Pivot Tables
• 11e Formatting Data Tables
• 11d Formatting Dates
• 11c Formatting Numbers
• 11b Aligning Data Formats
• 11a Font Formatting Techniques
• 10f Importing Data from CSV Files
• 10e Importing Data from Text Files
• 10d Eliminating Duplicate Entries
• 12b Utilizing Pivot Charts
• 13a Categorizing Excel Charts
• 13b Anatomy of a Chart
• 13c Crafting Charts
• 13d Column and Bar Chart Visualization
• 13e Fine-Tuning Chart Appearances
  
• 15a Tips and Guidelines for Presentations
• 14c Screen Adjustments and Views
• 14b Initiating PowerPoint Presentations
• 14a Course Overview
• 13g Pie and Doughnut Chart Creation
• 13f Drawing Line Charts
• 15b Initiating a New Presentation
• 21a Integrating Charts into Presentations
• 20d Table Layout Design
• 20c Embedding Tables
• 20b Refining Table Formats
• 20a Table Creation on Slides
• 19c Constructing Target Charts with SmartArt
• 19b Tailoring SmartArt Graphics
• 19a Integrating SmartArt Graphics
• 18c Applying Preset Picture Styles
• 18b Image Cropping Techniques
• 18a Advanced Picture Options
• 17e Embedding Pictures
• 17d Incorporating 3D Models
• 17c Inserting Graphics
• 17b Adding Icons
• 17a Incorporating Shapes
• 16d Adding Bullets and Numbered Lists
• 16c Aligning Text in Multi-Column Layouts
• 16b Aligning Text on Slides
• 16a Text Formatting Essentials
• 15e Printing Slides
• 15d Saving Presentations
• 15c Managing Slides
• 24d Using Triggers to Control Animation
• 24c Advanced Animation Techniques
• 24b Customizing Effect Options
• 24a Animating Objects
• 23a Applying Transitions to Presentations
• 22c Recording Screen Activities and Integrating
• 22b Incorporating Audio into Presentations
• 22a Integrating Video into Presentations
• 21c Importing Charts from Microsoft Excel
• 21b Fine-Tuning Chart Formats
• 28b Text Formatting Tips
• 28a Autocorrect Functionality
• 27f Searching and Replacing Text
• 27e Accessing Documents
• 27d Saving Documents
• 27c Displaying Non-Printing Characters
• 27b Creating Paragraph Texts
• 27a Creating Blank Documents
• 26b Initiating MS Word 2021
• 26a Overview of MS Word
• 25d Duplicating Slides
• 25c Rearranging Slides
• 25b Concealing Slides
• 25a Presenting Onscreen
• 28h Outline Formation
• 28g Adding Bullets
• 28f Numerical Operations
• 28e Utilizing Format Painter
• 28d Formatting Characters
• 28c Copying, Cutting, and Pasting Techniques
• 29b Adding Rows and Columns to Tables
• 29a Generating Tables
• 30c Removing Formatting
• 30b Establishing Styles
• 30a Utilizing Styles
• 29j Quick Tables – Predefined Formats
• 29i Integrating Spreadsheets
• 29h Converting Tables to Text
• 29g Converting Text to Tables
• 29f Drawing Tables
• 29e Sorting Tables
• 29d Applying Borders and Shading to Tables
• 29c Formatting Table Data
• 31a Adjusting Margins
• 33a Creating Mail Merge Documents
• 32b Generating Labels
• 32a Crafting Envelopes
• 31g Customizing Headers and Footers
• 31f Adding Watermarks
• 31e Implementing Page and Section Breaks
• 31d Incorporating Columns
• 31c Customizing Page Size
• 31b Configuring Orientation
• 34c Utilizing Speech to Read Aloud
• 34b Word Count Functionality
• 34a Thesaurus and Spell Check
• 34d Language Translation Feature
• 34e Tracking Changes

Learning Outcomes:

• Utilise Excel functions proficiently for data manipulation and analysis tasks.
• Design compelling presentations incorporating various multimedia elements effectively.
• Demonstrate advanced Word processing techniques for document creation and formatting.
• Implement mail merge and label creation functionalities in Microsoft Word.
• Apply advanced formatting options to enhance the visual appeal of documents.
• Utilise Outlook features for efficient email management and communication.

• Individuals interested in supporting families in various social settings.
• Those seeking knowledge in safeguarding and child welfare practices.
• Aspiring professionals in family support and child care services.
• Students aiming for roles in community outreach and family advocacy.
• Individuals pursuing careers in public health or social work sectors.

• Family Support Worker
• Child Welfare Officer
• Community Outreach Coordinator
• Safeguarding Advisor
• Child Development Practitioner
• Public Health Educator

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

Digital certificate

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included