CPD course All Levels

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

4 enrolled 8h 27m of learning Updated Nov 2026
CertificateOn completion
8h 27mSelf-paced
80 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 80 lessons 8h 27m total
01 Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 80 lessons
  1. Introduction
  2. Getting started on Windows, macOS, and Linux
  3. How to ask great questions
  4. FAQ’s
  5. Excel Overview
  6. Start Excel Spreadsheet
  7. Enter Text and Numbers
  8. Relative References
  9. Working with ranges
  10. Save and Save as Actions
  11. File Extensions, Share, Export, and Publish files
  12. Adding Rows and Columns
  13. Modifying Rows and Column lengths
  14. Copy, Cut, and Paste
  15. Copying Formulas
  16. Page setup options
  17. Fit to print on One Page
  18. Print Workbooks
  19. Sorting Data Ascending Order
  20. Sorting Data Descending Order
  21. Filter Data
  22. Creating Basic Formulas
  23. Datetime Formulas
  24. Mathematical formulas phase1
  25. Mathematical formulas phase2
  26. VLOOKUP formula
  27. HLOOKUP formula
  28. XLOOKUP
  29. Handling #NA and Approximates match in XLOOKUP
  30. Split Text into columns
  31. Flash Fill
  32. Data Validation
  33. Remove Duplicates
  34. Import Data from Text files
  35. Import Data from .CSV files
  36. Formatting Font
  37. Formatting Alignment
  38. Formatting Numbers
  39. Formatting Date
  40. Formatting Tables
  41. Pivot Tables
  42. Pivot Charts
  43. Excel Charts – Categories
  44. Elements of a chart
  45. Creating Charts
  46. Column or Bar charts
  47. Formatting charts
  48. Line Charts
  49. Pie and Doughnut charts
  50. Overview
  51. Start PowerPoint Presentation
  52. Screen setting and Views
  53. Presentation Tips and Guidelines
  54. Creating a New Presentation
  55. Working with Slides
  56. Save a Presentation
  57. Print Slides
  58. Formatting Text
  59. Slide Text Alignments
  60. Multi-Column Text Alignments
  61. Adding Bullets and Numbered List Items
  62. Insert Shapes
  63. Insert Icons
  64. Insert Graphics
  65. Add 3D Models
  66. Insert Pictures
  67. Picture Options
  68. Picture Cropping
  69. Applying Built-in Picture Styles
  70. Add SmartArt Graphic
  71. Modifying SmartArt
  72. Creating a Target Chart using SmartArt
  73. Create a Table on Slide
  74. Inserting Tables
  75. Table Layouts
  76. Add a Chart
  77. Formatting Charts
  78. Insert Chart from Microsoft Excel
  79. Adding Video to a Presentation
  80. Adding Audio to a Presentation

About this course

Overview:

Welcome to "Mastering Microsoft Office: Word, Excel, PowerPoint, and 365," your gateway to becoming proficient in the essential tools for productivity and data management. This course provides a comprehensive exploration of Microsoft Office applications, empowering you with the skills needed to create professional documents, analyze data effectively, and deliver compelling presentations. With hands-on exercises and practical guidance, you'll unlock the full potential of Word, Excel, PowerPoint, and the collaborative features of Office 365.

  • Interactive video lectures by industry experts
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
  • Practical exercises to reinforce learning
  • Tips and tricks for efficient document creation, data analysis, and presentation design
  • Guidance on leveraging advanced features and functionalities
  • Real-world examples and case studies for practical application

Who Should Take This Course:

  • Detailed tutorials covering Word, Excel, PowerPoint, and Office 365
  • Practical exercises to reinforce learning
  • Tips and tricks for efficient document creation, data analysis, and presentation design
  • Guidance on leveraging advanced features and functionalities
  • Real-world examples and case studies for practical application

Learning Outcomes:

  • Master document creation and formatting in Microsoft Word
  • Excel in data analysis and visualization using Microsoft Excel
  • Design compelling presentations with Microsoft PowerPoint
  • Utilize collaborative features of Office 365 effectively
  • Automate tasks and workflows using advanced features
  • Create professional reports, spreadsheets, and presentations
  • Improve productivity through efficient use of Office applications
  • Gain practical skills applicable to various industries and professions

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

£39.00 8h 27m · All Levels
Enrol now