**3-Hour Training Course Outline: Using Excel 365 as a Database**

Unlock the power of Excel 365 as a database with our comprehensive training course. This course is designed to equip you with the knowledge and skills necessary to utilize Excel as an effective database solution.

**Course Duration:** 3 Hours

**Course Overview:**
Master the capabilities of Excel 365 as a database and learn how to leverage its features for efficient data management.

**Course Objectives:**
- Gain an understanding of Excel's potential as a database tool.
- Learn essential data entry, organization, and manipulation techniques.
- Explore advanced features such as pivot tables, data cleansing, and paste special functionalities.

**Course Outline:**

1. **Introduction to Excel as a Database (15 minutes)**
   - Overview of Excel 365: Features and benefits for database functions.
   - Excel vs. Traditional Databases: Knowing when to use Excel and its limitations.

2. **Data Entry and Organization (30 minutes)**
   - Structuring Data: Setting up tables and named ranges.
   - Data Validation: Maintaining data integrity with validation rules.

3. **Data Sorting and Filtering (30 minutes)**
   - Basic Sorting: Alphabetical, numerical, and custom sorting.
   - Advanced Filtering: Techniques for filtering by text, numbers, dates, and color.

4. **Outlines, Grouping, and Subtotals (30 minutes)**
   - Creating Outlines: Grouping data for collapsible outlines.
   - Adding Subtotals: Automatically calculating subtotals in grouped data.

5. **Enhancing Spreadsheet Functionality (30 minutes)**
   - Printing Titles and Headers: Setting up repeated rows/columns.
   - Freeze Panes: Keeping header information visible while scrolling.
   - Conditional Formatting: Highlighting important data with formatting rules.

6. **Introduction to Pivot Tables (30 minutes)**
   - Basics of Pivot Tables: Creating and manipulating pivot tables.
   - Pivot Table Analysis: Summarizing and analysing data efficiently.

7. **Data Cleansing Techniques (30 minutes)**
   - Removing Duplicates: Identifying and removing duplicate entries.
   - Text to Columns: Converting concatenated data into structured format.
   - Error Checking: Tools and formulas for data review.

8. **Advanced Paste Special Features (15 minutes)**
   - Paste Special Overview: Utilizing various paste special options.
   - Practical Applications: Demonstrations of paste special in data management.

**Conclusion and Q&A (10 minutes)**
   - Course Wrap-Up: Summary of key points and best practices.
   - Q&A Session: Addressing remaining questions and providing clarifications.

**Prerequisites:**

To ensure successful participation and comprehension of the "Using Excel 365 as a Database" course, participants are expected to have the following prerequisites:

1. **Basic Understanding of Excel:** Participants should have a foundational understanding of Excel, including familiarity with basic functionalities such as entering data, formatting cells, and navigating through worksheets.

2. **Proficiency in Data Entry and Formulas:** A working knowledge of data entry techniques and Excel formulas is essential. Participants should be comfortable with entering and organizing data, as well as performing basic calculations using Excel formulas.

3. **Understanding of Spreadsheet Concepts:** Familiarity with spreadsheet concepts such as rows, columns, cells, and ranges is necessary. Participants should understand how to navigate and manipulate data within a spreadsheet environment.

4. **Basic Knowledge of Database Concepts:** While not mandatory, a basic understanding of database concepts such as tables, records, fields, and data validation will be beneficial. This knowledge will help participants grasp the concepts of using Excel as a database more effectively.

5. **Access to Excel 365:** Participants must have access to Excel 365 or a compatible version installed on their laptops for hands-on practice during the training sessions.

By ensuring you meet these prerequisites, you will be better equipped to engage with the course material and maximize your learning outcomes during the training sessions.

Unlock the full potential of Excel 365 as a database with our comprehensive training course, designed to empower you with the skills needed for efficient data management and analysis.

Unlock Excel 365's database potential! Learn data entry, sorting, pivot tables & more in our 3-hour course. Prerequisites: basic Excel & database understanding.

Using Excel 365 as a Database

Unlock the potential of Microsoft Excel with our Excel Level 1 course, designed to empower you with the essential skills and knowledge needed to excel in the world of spreadsheets. Whether you're a complete beginner or looking to reinforce your foundational Excel skills, this course is tailored to your needs.

**Course Duration:**  3 Hours


**COURSE OUTLINE**

- **Course Overview:** Excel Level 1 is the first step in your journey to Excel mastery.
- **Course Objectives:** Develop a strong understanding of Excel's fundamentals, including navigating the interface, creating formulas, and formatting workbooks.

**Lesson One: Getting to know Excel**

- Master the basics of Excel and its interface.
- Microsoft 365 Excel: Introduction to the latest Excel features.
- What are Spreadsheets, Worksheets, and Workbooks?
- What are Columns, Rows, Cells, and Ranges?
- The Excel Interface: Explore the essential components, including the Ribbon Interface and Quick Access Toolbar.
- Worksheet Referencing Elements: Learn how to navigate and reference cells within worksheets.
- Navigating in Excel: Discover various navigation options, including keyboard shortcuts.
- The Ribbon: Uncover the functionality of the Ribbon.
- The Backstage View: Explore file management and Excel 365 file formats.

**Lesson Two: Formulas and Functions**

- Harness the power of Excel formulas and functions.
- Elements of an Excel Formula: Understand mathematical operators and order of operations.
- Types of References: Learn about relative, absolute, and mixed references.
- Excel Formulas: Utilize the Formula Bar, AutoFill, and Flash Fill.
- About Functions: Explore built-in functions using AutoComplete and the Insert Function Dialog Box.
- Practice using Formulas and Functions for data manipulation.
- Selecting Cells: Master essential commands, shortcuts, and data manipulation techniques.
- Inserting Rows and Columns: Customize your worksheets.

**Lesson Three: Formatting a Workbook**

- Enhance the visual appeal of your Excel workbooks.
- What is a Font?: Learn about fonts and the Font Group.
- The Format Cells Dialog Box: Explore advanced formatting options.
- Alignment Options: Control text alignment and indentation.
- Merge & Centre Options: Improve data presentation.
- Renaming Worksheet Tabs and Changing Tab Colour: Organize and customize your worksheets.

**Lesson Four: Printing and Exporting as PDF**

- Learn to prepare and share your Excel documents effectively.
- The Print Options in Backstage View: Configure your printing settings.
- Page Setup Dialog Box and Print Preview Option: Control page orientation, print areas, and preview your work.
- Export As PDF and Save As: Share your documents in different formats.


**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Microsoft Excel 365 - Level 1

catherine Burns-Sweeney

Excellent enviroment, made to feel welcome and full support, training also not rushed.

Master Excel with our Level 1 course—gain essential skills to excel in spreadsheets and unlock your potential!

Question 1

Do you have any previous experience using this software?  If so,  please elaborate?

Question 2

Is there something specific you are hoping to learn on this course?  

Question 3

Anything else you'd like to learn?

One-to-one computer training offers an ideal solution for individuals interested in a variety of computer topics, or seeking highly focused instruction. This personalized approach allows for an in-depth exploration of specific topics or challenges that matter most to the learner. Whether it's troubleshooting issues with your computer setup, understanding software applications, or fine-tuning your computer for optimal performance, one-to-one training ensures that your unique needs and questions are addressed directly. 

One-to-one computer training conducted in the comfort of your home or office offers an ideal solution for individuals facing a variety of computer issues or ...

One-to-One Computer Help (We come to you)

What is the issue you are facing?

Please give the brand/ make of the device you are having issues with (no worries if you do not know).

Is there a day/ time that suits you best (please offer a variety of times/ dates)

Question 4

Anything else you would like to add?

One-to-one computer training conducted in the comfort of your home or office offers an ideal solution for individuals facing a variety of computer issues or seeking highly focused instruction. This personalized approach allows for an in-depth exploration of specific topics or challenges that matter most to the learner. Whether it's troubleshooting issues with your computer setup, understanding software applications, enhancing cybersecurity practices, or fine-tuning your computer for optimal performance, one-to-one training ensures that your unique needs and questions are addressed directly. The convenience of at-home or in-office training makes it even more accessible, providing a tailored and supportive learning environment that empowers individuals to gain the knowledge and skills they need to overcome challenges and achieve their computer-related goals.

One-to-One Computer Help (You come to Us)

**Microsoft Word Beginner Level 1 - Course Outline**

Dive into the world of document creation and editing with our Microsoft Word Beginner Level 1 course. This comprehensive outline is crafted to guide you through the navigation, creation, editing, and printing processes in Microsoft Word, ensuring you develop essential skills for effective document management.

**Course Duration:** 3 Hours

**COURSE OUTLINE**

- **Course Overview:** Word Level 1 is your stepping stone to mastering the fundamental features of Microsoft Word for creating, editing, and formatting documents.
- **Course Objectives:** Acquire foundational skills in Word, from navigating the interface to efficient document creation and management.

**Lesson One: Navigation of Word**

- Explore the essentials of Word navigation.
- Opening Word: Creating a new page or utilizing templates.
- Layout of Word: Navigate the Ribbon, Backstage View, and other key features.

**Lesson Two: Creating a Word Document**

- Master the art of document creation.
- Creating a Blank Document: Start your writing journey.
- Default Formatting: Understand and customize default settings.
- Save Options: Ensure your work is securely stored.
- Preview and Print Options: Prepare your document for sharing.

**Lesson Three: Views in Word**

- Explore different document views and zoom options.
- Using Each View Feature: Navigate through Print Layout, Draft, and more.
- Zoom Options: Adjust your view for precision.

**Lesson Four: Editing a Word Document**

- Hone your document editing skills.
- Scroll Bars and Keyboard Navigation: Efficiently navigate through your document.
- Text Editing Options: Master basic text manipulation techniques.
- Copy, Paste, Cut Options: Streamline your editing process.
- Undo/Redo Commands: Safeguard your work.
- Formatting Options: Enhance the visual appeal.
- Format Painter: Apply formatting effortlessly.
- Margins, Headers, and Footers: Customize document layout.
- Find & Replace: Locate and modify text efficiently.
- Page Breaks: Control the flow of your document.

**Lesson Five: Adding Items to a Word Document**

- Enhance your documents with tables, charts, and images.
- Adding a Table: Organize data effectively.
- Adding a Chart: Visualize information.
- Adding Pictures: Incorporate images seamlessly.

**Lesson Six: Printing a Word Document**

- Prepare and share your documents effectively.
- Preview and Print Options: Configure printing settings.
- Saving as PDF: Share your document in different formats.
- Sharing Document: Collaborate and distribute your work.

**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Unlock the full potential of Microsoft Word with our Beginner Level 1 course, tailored to empower you with the skills needed for efficient document creation, editing, and sharing.

Explore document creation with our Microsoft Word Beginner Level 1 course. Learn to navigate, create, edit, and print in Word, developing key management skills.

Microsoft Word 365 - Level 1 

**1. Introduction to RoboForm**

- Overview: What is RoboForm and what are its key features?
- Benefits of Using RoboForm: Emphasize security, convenience, and efficiency in managing passwords.

**2. Setting Up RoboForm**

- Downloading and Installing: Guide on how to download and install RoboForm on a PC.
- Creating a RoboForm Account: Steps to create a new user account.
- Initial Setup: Configuring basic settings for first-time use.

**3. Generating and Managing Passwords**

- Using the Password Generator: How to create strong, secure passwords.
- Saving Passwords: Demonstrate how to save newly created passwords in RoboForm.
- Organizing Passwords: Tips on organizing passwords into folders for easy access.

**4. Filling Forms and Logging In**

- AutoFill Feature: How RoboForm fills forms and logs into websites automatically.
- Customizing Form Entries: Editing and adding new personal data into RoboForm for various forms (e.g., addresses, payment information).

**5. Using Bookmarks**

- Saving & Using Bookmarks
- Bookmarks Menu & Options

**6. Safenotes**

- How to create new safenotes
- Viewing Safenotes

**7. Identities**

- How to create an Identity
- Using Identities

**8. RoboForm on Different Platforms**

- Installing RoboForm on Multiple Devices: Instructions on setting up RoboForm on additional computers and mobile devices.
- Syncing Passwords Across Devices: How to ensure your passwords are synced and up-to-date across all devices.

**9. Sharing Passwords Safely**

- Using RoboForm’s Sharing Feature: Steps to safely share login information with family or colleagues.
- Managing Shared Access: How to manage permissions and revoke access when necessary.

**10. Two-Factor Authentication (2FA)**




Excellent password manager that generates very secure passwords for you to use, and allows you to save them and automatically log in to your websites.

Secure Password Management with RoboForm

Do you have any previous experience using RoboForm? or a similar password protection program?

Is there anything specific you wish to learn from this course?

**Course Title: **Microsoft Excel 365: Mastering Excel Formulas

**Course Duration:** 3 Hours

**Course Overview:**
This course is designed to equip participants with a comprehensive understanding of the top Excel formulas essential for data analysis and manipulation. Starting from fundamental functions like SUM and AVERAGE, participants will progress through intermediate functions such as IF and COUNT, and advance to complex formulas including XLOOKUP and CONCATENATE. Additionally, participants will explore bonus formulas to handle errors, calculate dates, manipulate text, and more. By the end of the course, participants will have the skills to efficiently use Excel formulas to streamline their data tasks and improve productivity.

**Course Outline:**

**Module 1: Foundations of Excel Formulas (30 minutes)**
- Introduction to Excel formulas
- Understanding cell references (relative, absolute, mixed)
- Basic arithmetic operators (+, -, *, /)

**Module 2: Essential Formulas for Data Summarization (60 minutes)**

1. SUM: Summing up numerical data
2. AVERAGE: Calculating the average of numerical data
3. MAX and MIN: Finding the maximum and minimum values in a range
4. COUNT and COUNTA: Counting cells with data and non-empty cells respectively
5. CONCATENATE: Joining text strings together

**Module 3: Logical and Conditional Formulas (45 minutes)**

1. IF: Implementing conditional logic
2. COUNTIF and COUNTIFS: Counting cells based on a single criterion and multiple criteria respectively
3. SUMIF and SUMIFS: Summing cells based on a single criterion and multiple criteria respectively
4. AVERAGEIF and AVERAGEIFS: Calculating average based on a single criterion and multiple criteria respectively
5. IFERROR: Handling errors gracefully in formulas

**Module 4: Advanced Formulas for Data Analysis (45 minutes)**

1. XLOOKUP: Advanced lookup function for searching in columns or rows
2. UNIQUE: Extracting unique values from a range
3. DAYS: Calculating the difference in days between two dates
4. NETWORKDAYS: Counting the number of workdays between two dates
5. LEFT, RIGHT, and MID: Extracting substrings from text
6. TRIM: Removing extra spaces from text

**Module 5: Practical Applications and Exercises (45 minutes)**

- Practical examples demonstrating the application of learned formulas
- Hands-on exercises to reinforce understanding
- Q&A session to address participant queries

**Module 6: Integrating Formulas for Basic Data Analysis (15 minutes)**

- Understanding formula nesting: Using formulas within other formulas
- Combining formulas: Creating complex calculations by combining multiple functions
- Case study: Applying multiple formulas to analyze a dataset
- Hands-on exercise: Building a basic data analysis model using integrated formulas
- Tips for efficient formula usage and troubleshooting common errors

**Conclusion and Recap (15 minutes)**

- Review of key concepts and formulas covered in the course
- Recap of practical applications and case studies
- Final Q&A session and feedback collection

**Break**

The Course will also include a 15 minute break half way through 

**Bonus:**

Participants will receive either a PDF or Printed Manual to work alongside this course that they are able to take home with them 


Microsoft Excel 365: Mastering Excel Formulas

Melissa Richards

Superb course - well pitched and really interesting. Learnt a lot about formulas and will be looking to attend pivot tables next

Amiee was brilliant at explaining and giving examples, she also takes the time to oversee you if you are not sure, I learnt a lot from this course, however I need more training and put into practice, Highly recommend :)

Master some of the best Excel formulas in 3 hrs: Learn SUM, IF, XLOOKUP & more to enhance data tasks & boost productivity.

Do you have any previous experience using this software? If yes what? 

Is there anything specific you wish to learn from this session?

**Microsoft Outlook 365 Beginner Level 1 - Course Outline**


Unlock the full potential of Microsoft Outlook 365 with our Beginner Level 1 course. This comprehensive outline is designed to provide you with a solid foundation, ensuring you navigate through emails, calendars, contacts, tasks, and more with confidence.

**Course Duration:** 3 Hours


**COURSE OUTLINE**


- **Course Overview: ** Outlook Level 1 is your entry point into mastering the essential features of Microsoft Outlook 365.
- **Course Objectives: ** Acquire a robust understanding of Outlook's key functionalities, from handling emails and managing calendars to organizing contacts, tasks, and notes.

**Lesson One: Navigating Outlook**

- Explore the basics of Outlook navigation.
- Emails and Email Addresses: Understanding the essentials.
- Layout Exploration: Ribbon bar, backstage view, and more.
- Items and Folders: An in-depth look at organization.
- Ribbon Bar Sections: Delving into each section's functionalities.

**Lesson Two: Mail Management**

- Dive into the world of emails and mail folders.
- Mail Workspace: Understanding the mail environment.
- Read/Unread Emails: Navigating through messages.
- Message Icons: Decoding visual cues.
- Composing Emails: Crafting your messages effectively.
- Managing Contacts: Adding from the address book or typing manually.
- Addressing Fields: To/cc/bcc essentials.
- Email Formatting: Enhancing the visual appeal.
- Email Responses: Receiving, replying, and forwarding.
- Printing Emails: Putting messages on paper.
- Folder Organization: Moving messages and the deleted items folder.
- Attachments and Signatures: Streamlining your emails.
- Recall/Resend: Mastering email control.

**Lesson Three: Calendar Mastery**

- Take command of your schedule with Outlook's calendar features.
- Calendar Entry Types: Adding events and recurring occurrences.
- Categorizing Appointments: Organizing your calendar efficiently.
- Meeting Management: Updating, canceling, and using the room finder tool.

**Lesson Four: People and Contacts**

- Effectively manage your contacts within Outlook.
- Contacts Overview: Navigating through your address book.
- Adding and Importing Contacts: Building your contact list.
- Contact Forwarding and Deletion: Managing your contact database.
- Organizing Contacts: Customizing your view.

**Lesson Five: Task Management**

- Streamline your tasks and to-dos.
- Task Basics: Understanding the task management system.
- Adding Tasks: Creating to-dos effectively.
- Recurring Tasks: Setting up repetitive actions.
- Task Options: Customizing your task settings.
- Assigning and Completing Tasks: Collaborating and marking tasks as complete.
- Task Organization: Moving and managing your task list.

**Lesson Six: Notes, Quick Steps, and Beyond**

- Utilize additional Outlook features for enhanced productivity.
- Creating Notes: Jotting down important information.
- Categorizing Notes: Organizing your notes effectively.
- Quick Steps Overview: A brief introduction to this time-saving tool.

Unlock the full potential of Microsoft Outlook 365 with our Beginner Level 1 course, tailored to empower you with the skills needed for efficient communication, organization, and productivity.


**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Master Outlook 365 with our Beginner Level 1 course. Gain a solid foundation to confidently navigate emails, calendars, contacts, tasks, and more.

Microsoft Outlook 365 - Level 1

**Microsoft PowerPoint Beginner Level 1 - Course Outline**

Unlock the creativity and presentation prowess of Microsoft PowerPoint with our Beginner Level 1 course. This comprehensive outline is structured to equip you with fundamental skills, guiding you through the creation, formatting, and delivery of captivating presentations.

**Course Duration:** 3 Hours

**COURSE OUTLINE**

- **Course Overview:** PowerPoint Level 1 is your gateway to mastering the essential features of Microsoft PowerPoint for effective and engaging presentations.
- **Course Objectives:** Develop a strong foundation in PowerPoint, from navigating the interface to creating, formatting, and presenting dynamic slideshows.

**Lesson One: Navigating PowerPoint**
- Explore the basics of PowerPoint navigation.
- What is PowerPoint?: An introduction to the presentation software.
- Opening PowerPoint: Creating a new presentation or utilizing templates.
- Ribbon Bar and Backstage View: Navigate through the essential features.

**Lesson Two: Creating a PowerPoint**
- Dive into the process of building compelling presentations.
- Adding Slides: Constructing the structure of your presentation.
- Different Slide Layouts: Exploring various formatting options.
- Replacing Text: Customizing content for your audience.
- Changing Layouts: Adapting the structure as needed.
- Adding Shapes and Pictures: Enhancing visual appeal.

**Lesson Three: Formatting a PowerPoint**
- Elevate the visual impact of your presentation.
- Basic Formatting: Adjust font size, color, and other essential elements.
- Design Tab: Explore themes and the designer tool for polished presentations.
- Basic Transitions: Enhance slide-to-slide flow.
- Basic Animations: Bring your content to life.

**Lesson Four: Presenting a PowerPoint**
- Master the art of delivering impactful presentations.
- Starting a Slide Show: From the beginning or a specific slide.
- Presenter's View: Navigate through the presenter's perspective.
- Presentation Options: Utilize features like laser pointer, drawing tools, subtitles, and more.
- Notes During Presentation: Enhance your delivery with speaker notes.

**Lesson Five: Printing a PowerPoint**
- Prepare and share your presentation materials effectively.
- Printing Selected Slides: Tailor your handouts or print specific slides.
- Print Styles: Choose between full-page or tiled print options.


**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Unlock the full potential of Microsoft PowerPoint with our Beginner Level 1 course, tailored to empower you with the skills needed for creating and delivering impactful presentations

 Master PowerPoint with our Beginner Level 1 course. Learn fundamental skills for creating, formatting, and delivering captivating presentations effectively.

Microsoft PowerPoint 365 - Level 1

**1. Introduction to Basic Computer Operations (30 Minutes)**

- Using a Mouse (Explanation of the mouse, its parts, and its functions, Types of Clicks, using the Scroll Wheel)
- Using a Keyboard (Basic keyboard layout, Key Functions, Shift, Caps Lock, Special Characters, Delete vs Backspace)
- Understanding how to get around Windows
- Adjusting System Settings (volume, changing the date, etc)
- Using the calculator
- Using the Snipping Tool
- The concept of Cut & Paste
- Maximise, minimise and restore

**2. Introduction to Microsoft Office Applications (80 Minutes)**

20 minutes per application

- EXCEL (Navigating the Interface, Creating your first Spreadsheet, the concept of cells, selecting cells, moving cells, using autofill, Creating simple formulas, Formatting a spreadsheet, Saving and opening a file, clearing contents vs clearing formats, Printing)
- OUTLOOK (Navigating the Interface, Creating an email, attaching a document, marking emails as read or unread, using the flag, sorting emails, searching for an email, deleting and recovering emails, Creating an appointment, Different calendar views, Sending a meeting invitation, Creating tasks, Using Notes, Printing)
- WORD (Navigating the Interface, Creating your first Document, Typing Text, Basic text formatting, Basic paragraph formatting, Inserting images and resizing/moving them, using Bullets & numbered lists, Saving a file, Closing a file, Opening a file, Printing)
- POWERPOINT (Navigate the interface, Create a Presentation, Adding slides, using the slide layouts, entering data, formatting data, inserting pictures & shapes, Using Animations and Transitions, Running a slide show, Printing)

**3. Understanding Files and Folders**

- Difference between files and folders
- Navigating the File System
- Storage Locations

**4. Browsing the Internet**

- What is the internet?
- Purpose and Benefits
- What is a Web Browser
- Opening a Web Browser
- Understanding the Browser Interface
- Entering a URL
- What is a search engine
- Performing a search
- Understanding search results
- Basic Internet safety (recognizing secure sites, avoiding suspicious links)
- Using multiple Tabs
- Bookmarking

Master basic computer operations and MS Office: Navigate Windows, use tools, and create documents, spreadsheets, and presentations effectively.

Basic Computer Skills

Do you have any experience using computers, if so what? 

Is there anything specific you with to learn on this course?

Unit 1 Crimp Business Park

The eKit gives you all you need to pass one of the Microsoft Office Specialist exams.  You get one exam (and a free resit if you need it), an online video course covering the exam topics and access to multiple practise tests.  You have access to the tools for 12 months before the eKit expires.

Microsoft Office Specialist (MOS) eKit

Single Video course, Test Preparation, MOS Exam and free retake if needed

Question 0

Please choose from Word Associate, Excel Associate, PowerPoint Associate, Outlook Associate, Excel Expert or Word Expert.

The **Microsoft Office Specialist (MOS)** program is a globally recognized standard for validating expertise in the productivity tools within the Microsoft Office suite, including Word, Excel, PowerPoint, Outlook, Access, and more. Whether you're looking to enhance your career, secure a new job, or simply increase your efficiency in office software, the MOS certification provides you with the tools to achieve your goals.

**Why Choose MOS Certification?**

1. Industry Recognized Certification: MOS is widely recognized in the business world as evidence of advanced skills in Microsoft Office applications, which are crucial in nearly every job role. Having MOS certification on your resume showcases your commitment to enhancing your expertise and sets you apart from your peers in the job market.

2. Boost Employability: In today's competitive job market, employers often seek out individuals who can contribute efficiently from day one. By demonstrating proficiency in Microsoft Office, you position yourself as a valuable asset to any team, enhancing your job prospects and promotional opportunities within your current and future roles.

3. Increase Productivity: Learning to use Microsoft Office applications effectively can drastically reduce the time it takes to accomplish daily tasks. From mastering advanced Excel formulas to automating tasks in Word and managing emails more efficiently in Outlook, MOS certification equips you with skills that streamline workflows and increase productivity.

4. Professional Development: Pursuing MOS certification is an excellent way to continue your professional development, stay updated with the latest software updates, and continuously improve your skills. This ongoing learning process is essential for career growth and professional satisfaction.

5. Flexibility and Comprehensive Learning Resources: The MOS certification program offers flexibility in learning and testing. You can prepare for the exams at your own pace using a wide array of resources including online tutorials, in-person classes, textbooks, and practice tests. This wealth of resources ensures that you can fit your learning around your schedule and learning style.

6. Performance-Based Testing: Unlike traditional exams that rely on multiple-choice questions, MOS exams are performance-based. This means you are tested on real-world tasks and scenarios, which provides a deeper understanding of the software and its practical application in your day-to-day activities.

7. Pathway for Advancement: Starting with core certifications, you can advance to expert and then master levels. Each level deepens your expertise and opens up further opportunities for professional growth and recognition.

8. Suitable for All Ages and Skill Levels: Whether you are a student, a job-seeker, an office professional, or someone looking to return to the workforce, MOS certification is suitable for all ages and skill levels. It provides a structured pathway to mastering office applications that are crucial in both academic and business environments.

9. Global Network of Certified Professionals: As a MOS certified professional, you join a global community of individuals who have demonstrated their abilities in Microsoft Office applications. This network can be a valuable resource for career advice, networking, and sharing tips and best practices.

10. Support from Microsoft: As a Microsoft certification, MOS comes with the support and branding of one of the world’s leading technology companies. This backing is invaluable when presenting your credentials to employers or clients.

**How to Get Started?**

Getting started with the MOS certification is simple. Determine which application you want to master first and assess your current skill level. Choose a learning path that suits your needs, and begin your training using the vast resources available. Once ready, you can take the exam at an authorized testing centre or online under a proctored environment.

In conclusion, the Microsoft Office Specialist program not only enhances your technical skills but also enriches your professional development. Whether your goal is to gain a competitive edge in the job market, increase your workplace productivity, or achieve personal satisfaction in mastering a tool, MOS certification is a stepping stone to success.

Microsoft Office Specialist (MOS) Exam

Choose one 50 minute online exam which is performance-based, testing your ability to complete specific tasks rather than answering multiple-choice questions.

The future belongs to those who create. Whether it’s to inform, persuade, entertain, or inspire, success in the digital age means communicating in visually rich and interactive ways. With a firm grasp on the world’s most powerful creative tools, Adobe Certified Professionals are ready to make their mark.

Adobe Certified Professional is the industry-recognized certification that demonstrates mastery of Adobe Creative Cloud software and must-have knowledge for digital media careers. Each exam is integrated with an Adobe application and designed by experts, allowing for an authentic assessment of job-ready skills.

https://youtu.be/YPpmx_7l1Xc

**CREATIVITY WITH CREDIBILITY**

Adobe Certified Professional is an industry-recognized credential that effectively validates one’s skills in Adobe Creative Cloud applications. 

Complete an Exam and get certified in ONE the following:

- Visual Effects & Motion Graphics using **Adobe After Effects**
Advance your career in the motion graphics industry by earning an industry-recognized certification for Adobe After Effects, the world-class tool for video compositing, motion graphics design, and animation.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/after-effects

- Multiplatform Animation using **Adobe Animate**
Show off your animation skills by earning an industry-recognized certification for Adobe Animate, the powerful vector animation and multimedia authoring software.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/animate

- Web Authoring using **Adobe Dreamweaver**
Become an Adobe Certified Professional in Web Authoring and show your skills on Adobe Dreamweaver, the all-in-one visual development tool for creating, publishing, and managing websites and mobile content. 
https://certiport.pearsonvue.com/fc/aca/od/cc2021/dreamweaver

- Graphic Design & Illustration using **Adobe Illustrator**
Digital media gurus bring their unique vision to life everyday with shapes, colour, and effects through Adobe Illustrator, the industry-standard vector graphics software. Earn an industry-recognized certification for Adobe Illustrator and prove your guru skills. 
https://certiport.pearsonvue.com/fc/aca/od/cc2021/illustrator

- Print & Digital Media Publication using **Adobe InDesign**
Show your understanding and ability to create print and digital media publications using Adobe InDesign, the industry-leading layout and page design application.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/indesign

- Visual Design using **Photoshop**
Adobe Photoshop is now considered a household name. Show your skills on the world’s most widely used digital imaging software by becoming an Adobe Certified Professional in Visual Design.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/photoshop

- Digital Video using **Adobe Premiere Pro**
Prove your video editing skills by earning an industry-recognized certification for Adobe Premiere Pro, the industry-leading non-linear editing software for TV, film, and social sharing.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/premiere-pro

While meaningful to any job seekers and students interested in digital creative careers, these exams are best suited for ages 14 and up. No Bachelor's degree or other prerequisites are necessary, other than what is outlined in the Objective Domains. Each certification is valid for three years from the date of issue.

Ready to prove that you have the skills to work with multiple Adobe software applications? Earn two Adobe Certified Professional certifications and you will receive an Adobe Certified Professional specialty certificate for Visual, Web or Video Design.

Adobe Certified Professional Exam

Single 50 minute Adobe exam completed from home. Choose from Photoshop, Illustrator, InDesign, Premiere Pro, After Effects, Animate & Dreamweaver.

Which Adobe exam (and version) were you after?

Adobe Certified Professional e-Kit

Video Course, Practise Tests, official Adobe exam and a free retake if needed.  Valid for 12 months.

Which Adobe application e-Kit would you like?

We provide you with a PDF Training Manual that you can print yourself.

Includes Digital Manual

We will provide you with a professionally printed training manual.

Includes Printed Manual

VIEW_CONTACT_INFO

RESCHEDULE_BOOKING

CANCEL_BOOKING

COURSE_NOTIFICATIONS

EDIT_BOOKING_GUEST

EMAIL_BOOKING

RESEND_EMAILS

MANAGE_BUNDLE_BOOKINGS

MANAGE_PRIVATE_PAYMENTS

MANAGE_TICKET_TYPES

MANAGE_WAITING_LIST

USE_EARLY_ACCESS

USE_WIDGET_GIFT_CARDS

USE_ZOOM_INTEGRATION

USE_CALENDAR_INTEGRATION

USE_EXTERNAL_BOOKINGS

MANAGE_REVIEWS

REMOVE_REVIEWS

MANAGE_CUSTOMERS

FILTER_CUSTOMERS

DOWNLOAD_CUSTOMERS

MANAGE_INCOME

DOWNLOAD_INCOME

USE_DISCOUNTS

USE_SPECIFIC_DISCOUNTS

USE_WIDGET

CUSTOMIZE_WIDGET

USE_BULK_CHANGES

SHARE_CLASS

USE_RECURRING_CLASS_DATES

CREATE_UNLIMITED_POSTAGES

CREATE_STANDARD_LIMITED_POSTAGES

PRIVATE_TAG_CREATION

CREATE_SECOND_TUTOR

CREATE_LIMITED_TUTORS

CREATE_UNLIMITED_TUTORS

CUSTOM_CANCELLATION_POLICY

TIMETABLE_FILTER

TIMETABLE_BULK_ACTIONS

WIDGET_EMBED_BRANDING

AVAILABILITY_VIEW_APPOINTMENTS

LARGE_GROUP_ENQUIRE

ARCHIVE_SCHOOL

OPT_IN_2FA_SMS

DELETE_SCHOOL_ACCOUNT

CAN_ENABLE_WIDGET_ACCOUNT

CAN_ADD_DOMAIN_ON_STRIPE

Aimee lives in Bradworthy with her family and is a Data Analyst Apprentice.  She is also completing all of her Microsoft Office Specialist (MOS) exams.

Leanne lives with her family in Welcombe and is a Trainer, Programmer, VBA Developer and Data Analyst with over 20 years experience. 

Using Excel 365 as a Database

Age Requirement