Course Highlights
The Office Skills and Administration course provides a detailed understanding of administrative functions in modern office environments. Whether you’re starting your career or aiming to enhance your current role, this programme equips you with the expertise to handle business documentation, scheduling, correspondence, and essential office procedures.
A major component of the course includes mastery of Microsoft Office applications—Excel for data management, Word for documentation, and PowerPoint for professional presentations. You’ll learn how to create spreadsheets, use formulas, build databases, format documents, and design impactful slide decks, all aligned with workplace standards and best practices.
This course is structured for flexibility, allowing learners to study at their own pace. With a focus on efficiency and digital literacy, it suits individuals targeting roles such as office assistant, personal assistant, administrative coordinator, or secretarial support. By the end of this course, you’ll be confident managing tasks in any office setting.
Note: Skill-up is a Janets-approved resale partner for Quality Licence Scheme Endorsed courses.
Learning outcome
- - Manage administrative operations with speed and accuracy
- - Format, edit, and produce high-quality business documents using Microsoft Word
- - Organise and analyse data efficiently using Microsoft Excel tools and functions
- - Create engaging and structured visual presentations with Microsoft PowerPoint
- - Maintain workplace professionalism and ensure consistent communication standards
Certificate of Achievement
Quality Licence Scheme Endorsed Certificate
Upon completing the final assessment, you can apply for the Quality Licence Scheme Endorsed Certificate of Achievement. Endorsed certificates can be ordered and delivered to your home by post for only £129.
Order Your QLS Certificate
An extra £10 postage charge will be required for students leaving overseas.
Why should I take this course?
- - Gain core knowledge required in office-based job roles
- - Boost productivity through improved software proficiency
- - Learn time-saving techniques for document and data management
- - Improve your presentation and reporting capabilities
- - Increase job market value with employer-relevant certifications
Career Path
- - Office Administrator
- - Secretary or Personal Assistant
- - Administrative Coordinator
- - Document Controller
- - Receptionist or Front Desk Officer
Requirements
- - Basic understanding of using a computer
- - Reliable internet connection and device access
- - Motivation to develop workplace administration skills
Course Curriculum
-
Personal Assistant
01:23:00
-
Admin Support
01:54:00
-
Administrative Management
00:30:00
-
Introduction to Human Resource
00:17:00
-
Organisational Skills
00:26:00
-
Telephone Etiquette
01:07:00
-
Business Writing
01:24:00
-
Time Management
01:09:00
-
Body Language and Effective Communication
01:23:00
-
Meeting Management
01:00:00
-
Navigate the Excel User Interface
00:28:00
-
Use Excel Commands
00:10:00
-
Create and Save a Basic Workbook
00:19:00
-
Enter Cell Data
00:12:00
-
Use Excel Help
00:05:00
-
Create Worksheet Formulas
00:15:00
-
Insert Functions
00:17:00
-
Reuse Formulas and Functions
00:17:00
-
Insert, Delete, and Adjust Cells, Columns, and Rows
00:10:00
-
Search for and Replace Data
00:09:00
-
Use Proofing and Research Tools
00:07:00
-
Apply Text Formats
00:17:00
-
Apply Number Format
00:08:00
-
Align Cell Contents
00:09:00
-
Apply Styles and Themes
00:12:00
-
Apply Basic Conditional Formatting
00:11:00
-
Create and Use Templates
00:08:00
-
Preview and Print a Workbook
00:10:00
-
Set Up the Page Layout
00:09:00
-
Configure Headers and Footers
00:07:00
-
Manage Worksheets
00:05:00
-
Manage Workbook and Worksheet Views
00:07:00
-
Manage Workbook Properties
00:06:00
-
Excel Templates
-
Navigate in Microsoft Word
00:12:00
-
Create and Save Word Documents
00:24:00
-
Manage Your Workspace
00:06:00
-
Edit Documents
00:16:00
-
Preview and Print Documents
00:04:00
-
Customize the Word Environment
00:08:00
-
Apply Character Formatting
00:17:00
-
Control Paragraph Layout
00:19:00
-
Align Text Using Tabs
00:07:00
-
Display Text in Bulleted or Numbered Lists
00:03:00
-
Apply Borders and Shading
00:04:00
-
Make Repetitive Edits
00:06:00
-
Apply Repetitive Formatting
00:10:00
-
Use Styles to Streamline Repetitive Formatting Tasks
00:14:00
-
Sort a List
00:05:00
-
Format a List
00:06:00
-
Insert a Table
00:07:00
-
Modify a Table
00:06:00
-
Format a Table
00:03:00
-
Convert Text to a Table
00:04:00
-
Insert Symbols and Special Characters
00:04:00
-
Add Images to a Document
00:11:00
-
Apply a Page Border and Color
00:03:00
-
Add Headers and Footers
00:06:00
-
Control Page Layout
00:05:00
-
Check Spelling Grammar and Readability
00:07:00
-
Use Research Tools
00:06:00
-
Check Accessibility
00:03:00
-
Save a Document to Other Formats
00:04:00
-
Add a Watermark
00:04:00
-
Workbooks – Microsoft Office 2016 Word Beginners
-
Navigate the PowerPoint Environment
00:28:00
-
View and Navigate a Presentation
00:15:00
-
Create and Save a PowerPoint Presentation
00:13:00
-
Use PowerPoint Help
00:10:00
-
Select a Presentation Type
00:08:00
-
Edit Text
00:13:00
-
Build a Presentation
00:27:00
-
Format Characters
00:11:00
-
Format Paragraphs
00:16:00
-
Format Text Boxes
00:09:00
-
Insert Images
00:10:00
-
Insert Shapes
00:15:00
-
Edit Objects
00:16:00
-
Format Objects
00:06:00
-
Group Objects
00:04:00
-
Arrange Objects
00:07:00
-
Animate Objects
00:07:00
-
Create a Table
00:09:00
-
Format a Table
00:03:00
-
Insert a Table from Other Microsoft Office Applications
00:06:00
-
Create a Chart
00:10:00
-
Format a Chart
00:10:00
-
Insert a Chart from Microsoft Excel
00:05:00
-
Review Your Presentation
00:11:00
-
Apply Transitions
00:05:00
-
Print Your Presentation
00:05:00
-
Deliver Your Presentation
00:08:00
-
Workbook – Office Skills and Administration
-
Assignment – Office Skills and Administration
-
Submit Your Assignment & Order QLS Certificate
-
Skill Up Recognised Certificate
-
Order CPDQS Certificate
Offer Ends in

-
Duration:23 hours, 32 minutes
-
Access:1 Year
-
Units:97

