Administrator & Microsoft Office Specialist Training - CPD Accredited

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners.

Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word.

Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV.

Learning Outcomes:

• Gain a solid understanding of administrative management and admin support
• Learn the fundamental principles of business writing and improve your telephone etiquette
• Learn how to communicate effectively and develop your body language skills
• Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA
• Get tips on how to organise your workload and manage your time efficiently
• Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access
• Share documents, automate tasks, analyse data, create slideshows & much more
• Gain valuable transferable skills to boost your professional development
• Be able to customise the user interface to your desire
• Discover time-saving techniques, tips & shortcuts to work faster and more efficiently

Course Outline

**Administrator**

Module 1: Personal Assistant

• Module 1 Personal Assistant

Module 2: Admin Support

• Module 2 Admin Support

Module 3: Administrative Management

• Module 3 Administrative Management

Module 4: Organisational Skills

• Module 4 Organisational Skills

Module 5: Telephone Etiquette

• Module 5 Telephone Etiquette

Module 6: Business Writing

• Module 6 Business Writing

Module 7: Time Management

• Module 7: Time Management

Module 8: Body Language and Effective Communication

• Module 8: Body Language and Effective Communication

Module 9: Meeting Management

• Module 9: Meeting Management

Module 10: Microsoft Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions
• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data 88
• Use Proofing and Research Tools
• Apply Text Formats
• Apply Number Format
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates
• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

**Microsoft Office Specialist**

Microsoft Word 2016

• Modify User Information
• Share a Document
• Work with Comments
• Compare Document Changes
• Review a Document
• Merge Document Changes
• Coauthor Documents
• Add Captions
• Add Cross-References
• Add Bookmarks
• Add Hyperlinks
• Insert Footnotes and Endnotes
• Add Citations
• Insert a Bibliography
• Insert Blank and Cover Pages
• Insert an Index
• Insert a Table of Contents
• Insert an Ancillary Table
• Manage Outlines
• Create a Master Document
• Suppress Information
• Set Editing Restrictions
• Add a Digital Signature to a Document
• Restrict Document Access
• Create Forms
• Manipulate Forms
• Form Data Conversion
• Create a New Document Version
• Compare Document Versions
• Merge Document Versions

Microsoft Excel 2016

• Update Workbook Properties
• Activity-Update Workbook Properties
• Create and Edit a Macro
• Activity-Create and Edit a Macro
• Apply Conditional Formatting
• Activity-Apply Conditional Formatting
• Add Data Validation Criteria
• Activity-Add Data Validation Criteriaty
• Trace Cells
• Activity-Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Activity-Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Activity-Watch and Evaluate Formulas
• Create a Data List Outline
• Activity-Create a Data List Outline
• Create Sparklines
• Activity_Create Sparklines
• Create Scenarios
• Perform a What-If Analysis
• Activity-Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis ToolPak
• Create Interactive Data with Power View
• Consolidate Data
• Activity-Consolidate Data
• Link Cells in Different Workbooks
• Merge Workbooks
• Activity-Merge Workbooks
• Export Excel Data
• Import a Delimited Text File
• Integrate Excel Data with the Web
• Create a Web Query
• Activity-Create a Web Query
• Import and Export XML Data

Microsoft PowerPoint 2016

• Customize the User Interface
• Set PowerPoint 2016 Options
• Create and Manage Sections
• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master
• Create SmartArt
• Modify SmartArt
• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions
• Add Comments to a Presentation
• Review a Presentation
• Store and Share Presentations on the Web
• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation
• Secure a Presentation
• Present a Slide Show Online
• Create a Video or a CD

Microsoft Outlook 2016

• Insert Advanced Characters and Objects
• Modify Message Settings, Properties, and Options
• Use Automatic Replies
• Sort Messages
• Filter Messages
• Organize Messages
• Search Messages
• Manage Junk Mail
• Manage Your Mailbox
• Manage Advanced Calendar Options
• Manage Additional Calendars
• Manage Meeting Responses
• Assign and Manage Tasks
• Edit an Electronic Business Card
• Manage Advanced Contact Options
• Forward Contacts
• Export Contacts
• Delegate Access to Mail Folders
• Share Your Calendar
• Share Your Contacts
• Back Up Outlook Items
• Change Data File Settings
• Configure E-mail Message Security Settings

Microsoft Access 2016

• Add Controls to Forms
• Set Form Controls
• Create Subforms
• Organize Information with Tab Pages
• Enhance Navigation with Forms
• Format a Form
• Apply Conditional Formatting
• Field Validation
• Form and Record Validation
• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
• Convert a Macro to VBA
• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database
• Split a Database for Multiple User Access
• Implement Security
• Set Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options

Method of Assessment:

Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly.

Certification

After successfully completing the course, you will be able to obtain the certificates. You can claim a PDF certificate by paying a little processing fee of £2. There is an additional fee to obtain a hardcopy certificate which is £9.

This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career.

Our Administrator & Microsoft Office Specialist Training Course is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.

On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles:

• Office Administrator
• Secretary
• Personal Assistant
• Receptionist
• Admin Assitant
• Data Entry Clerk

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