Level 2 Microsoft Office Essentials

Description

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 Essentials 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.

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

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

Begin your journey with Apex Learning right away!

The Level 2 Microsoft Office Essentials course teaches you how to use key Microsoft Office tools like Excel, Word, PowerPoint, and Access. You’ll learn how to create and format documents, spreadsheets, and presentations, apply formulas, and manage databases. This course is perfect for anyone looking to improve their Microsoft Office skills and boost workplace productivity.

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

•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

•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

•Navigate in Microsoft Word

•Create and Save Word Documents

•Manage Your Workspace

•Edit Documents

•Preview and Print Documents

•Customize the Word Environment

•Apply Character Formatting

•Control Paragraph Layout

•Align Text Using Tabs

•Display Text in Bulleted or Numbered Lists

•Apply Borders and Shading

•Make Repetitive Edits

•Apply Repetitive Formatting

•Use Styles to Streamline Repetitive Formatting Tasks

•Sort a List

•Format a List

•Insert a Table

•Modify a Table

•Format a Table

•Convert Text to a Table

•Insert Symbols and Special Characters

•Add Images to a Document

•Apply a Page Border and Color

•Add Headers and Footers

•Control Page Layout

•Add a Watermark

•Check Spelling Grammar and Readability

•Use Research Tools

•Save a Document to Other Formats

•Workbooks - Microsoft Word 2016 (Beginner)

•Navigate the PowerPoint Environment

•View and Navigate a Presentation

•Create and Save a PowerPoint Presentation

•Use PowerPoint Help

•Select a Presentation Type:

•Edit Text

•Build a Presentation

•Format Characters

•Format Paragraphs

•Format Text Boxes

•Insert Images

•Insert Shapes

•Edit Objects

•Format Objects

•Group Objects

•Arrange Objects

•Animate Objects

•Create a Table

•Insert a Table from Other Microsoft Office Applications

•Create a Chart

•Format a Chart

•Insert a Chart from Microsoft Excel

•Review Your Presentation

•Apply Transitions

•Print Your Presentation

•Deliver Your Presentation

•Orientation to Microsoft Access1

•Create a Simple Access Database

•Get Help and Configure Options in Microsoft Access

•Modify Table Data

•Sort and Filter Records

•Create Basic Queries

•Sort and Filter Data in a Query

•Perform Calculations in a Query

•Create Basic Access Forms

•Work with Data on Access Forms

•Create a Report

•Add Controls to a Report

•Enhance the Appearance of a Report

•Prepare a Report for Print

•Organize Report Information

•Format Reports

This Microsoft Office course is ideal for individuals at different stages of their careers. This course is great for people new to Microsoft Office or those who want to improve their skills. It’s perfect for professionals wanting to improve their expertise, students looking to get better job opportunities, and anyone who wants to work more efficiently. The course will equip you with essential Microsoft Office skills for handling tasks in Excel, Word, PowerPoint, and Access.

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.

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

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