• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Level 2 Microsoft Office Essentials

Level 2 Microsoft Office Essentials

By Apex Learning

5.0(10)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 5 hours

  • All levels

Description

Course Overview:

Discover the power of Microsoft Office with our Level 2 Microsoft Office Essentials Course. In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint, and Access being the most sought-after applications. As the workplace evolves, the demand for individuals with advanced knowledge of Microsoft Office tools rapidly increases.

Our comprehensive Level 2 Microsoft Office Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint, and Access. You will get into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases all with the help of Microsoft Office.

Enrol today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth!


Key Features of the Course:
  • FREE Microsoft Office CPD-accredited certificate

  • Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)

  • Lifetime access to the Microsoft Office course materials

  • The Microsoft Office program comes with 24/7 tutor support

  • Get instant access to this Microsoft Office course

  • Learn Microsoft Office training from anywhere in the world

  • The Microsoft Office training is affordable and simple to understand

  • The Microsoft Office training is an entirely online


Who is This Course For?

This Microsoft Office course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.


What You Will Learn:

Throughout this Level 2 Microsoft Office Essentials course, you will develop a solid foundation in Microsoft Office Essentials. Starting with Excel, you will learn to navigate the user interface, create and format spreadsheets, apply formulas and functions, and customise the appearance of your data. In Word, you will master document creation, formatting, and editing, as well as utilising advanced features like tables, symbols, and images. PowerPoint will enable you to create captivating presentations, while Access will equip you with the skills to build and manage databases effectively.


Why Enrol in This Course:

The Microsoft Office course has well-reviewed content and a recently updated curriculum that ensures you gain the most relevant knowledge aligned with industry trends. Acquire essential knowledge and get a chance to develop in-demand skills employers seek, boosting your career advancement and employability.


Requirements:

No prior experience or expertise is necessary to enrol in this Microsoft Office course. Basic computer literacy and access to Microsoft Office applications will be beneficial.


Career Path:

Upon completion of this course, you can pursue various professions, including:

  • Administrative Assistant (£20,000 - £25,000 per annum)

  • Microsoft Office Specialist [MOS] (£18,000 - £22,000 per annum)

  • Office Manager (£25,000 - £35,000 per annum)

  • Project Coordinator (£25,000 - £35,000 per annum)

  • Data Entry Operator (£20,000 - £28,000 per annum)

  • Executive Assistant (£25,000 - £40,000 per annum)

  • Business Analyst (£35,000 - £50,000 per annum)


Certification:

Upon completing the course, you will receive a CPD certificate, demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility.


Course Curriculum

32 sections • 96 lectures • 16:31:00 total length

•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:16: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:11: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

•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:05: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

•Add a Watermark: 00:04: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

•Workbooks - Microsoft Word 2016 (Beginner): 00:00:00

•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

•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

•Orientation to Microsoft Access1: 00:39:00

•Create a Simple Access Database: 00:10:00

•Get Help and Configure Options in Microsoft Access: 00:06:00

•Modify Table Data: 00:17:00

•Sort and Filter Records: 00:05:00

•Create Basic Queries: 00:15:00

•Sort and Filter Data in a Query: 00:14:00

•Perform Calculations in a Query: 00:08:00

•Create Basic Access Forms: 00:07:00

•Work with Data on Access Forms: 00:23:00

•Create a Report: 00:23:00

•Add Controls to a Report: 00:12:00

•Enhance the Appearance of a Report: 00:05:00

•Prepare a Report for Print: 00:03:00

•Organize Report Information: 00:15:00

•Format Reports: 00:12:00

About The Provider

Apex Learning
Apex Learning
London
5.0(10)

At Apex Learning, we share the goal of millions of people to mak...

Read more about Apex Learning

Tags

Reviews