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

Course Images

Microsoft Office Basic to Advance Course

Microsoft Office Basic to Advance Course

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 18 hours 33 minutes

  • All levels

Description

Overview

Are you aware that proficiency in Microsoft Office is now considered a critical skill across all job sectors? With recent reports highlighting a dramatic increase in demand for digital literacy, the 'Microsoft Office Basic to Advance' course offers a comprehensive pathway to mastering these essential tools. 

In today's digital world, proficiency in Microsoft Office is no longer a bonus; it's a critical skill for success in almost any job sector. With Microsoft Office skills listed in over 80% of middle-skill job postings, this course is designed to propel your career forward. It opens opportunities by equipping you with a deep, practical understanding of Microsoft Office applications-from basic to advanced levels. Whether aiming to boost your resume or streamline office tasks, this course will position you at the forefront of workplace efficiency, inspiring you to reach new heights in your career.

Enrolling in the Microsoft Office Basic to Advance Course significantly enhances your employability and professional capabilities. This will prepare you to meet the challenges of today's job market head-on. This investment in your skill set is an investment in your future, setting you up for long-term success and career satisfaction.

Description

'Microsoft Office Basic to Advance' course that spans comprehensive training in the most widely used Microsoft Office applications. Beginning with Excel, you will learn to perform basic calculations and engage in complex data management tasks like modifying and formatting worksheets and managing and printing workbooks. As you progress, the course delves into Word, where you will enhance your ability to format text and paragraphs, manage lists, add tables, and insert graphic objects, ensuring you are well-prepared to control page appearances and publish documents.

Further, the PowerPoint modules equip you with the skills to handle the PowerPoint interface proficiently, manage presentation basics, insert various objects, and use charts effectively. For those interested in database management, the Access sessions provide insights into modifying data, working with queries, and creating forms and reports. Microsoft Office Basic to Advance Course ensures that each module builds on the last, providing a cohesive learning experience that develops your confidence and competence in using these tools to their full potential.

Learning Outcomes:

  • By the end of this course, you will be able to master the foundational and advanced functionalities of Microsoft Excel 2019, including creating complex formulas, analysing data, and creating visually appealing charts and graphs.

  • Develop skills in professional document preparation with Microsoft Word 2019.

  • Create impactful presentations using the advanced features of Microsoft PowerPoint 2019.

  • Navigate and utilise Microsoft Access 2019 for database management.

  • Implement complex formatting, calculations, and data management across various projects.

  • Prepare and manage professional, publication-ready documents and reports.

Are you ready for a more rewarding career? The 'Microsoft Office Basic to Advanced' course can help you answer that call! Take advantage of this opportunity to enhance your skills and open new doors in your career.

Why Choose Us?

  • This course is accredited by the CPD Quality Standards.

  • Lifetime access to the whole collection of the learning materials.

  • Online test with immediate results.

  • Enroling in the course has no additional cost.

  • You can study and complete the course at your own pace.

  • Study for the course using any internet-connected device, such as a computer, tablet, or mobile device.

Certificate of Achievement

Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99.

Who Is This Course For?

  • Office professionals are seeking to enhance their productivity and software knowledge.

  • Students and recent graduates aim to meet the baseline technical requirements for most job roles.

  • Administrative staff need to improve their reporting and data management skills.

  • Individuals are looking to develop their job qualifications and career prospects.

  • Educators and trainers who wish to instruct on using Microsoft Office tools.

  • Entrepreneurs need efficient ways to manage their business documentation and presentations.

Requirements

The Microsoft Office Basic to Advance course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Microsoft Office Basic to Advance, without any fuss.

Career Path

Microsoft Office Basic to Advance course will prepare you for a range of careers, including:

  • Administrative Assistant

  • Executive Assistant

  • Project Coordinator

  • Office Manager

  • Business Analyst

  • Marketing Coordinator

  • Data Analyst

Order Your Certificate To order CPD Quality Standard Certificate, we kindly invite you to visit the following link:

Course Curriculum

Microsoft Excel 2019

Microsoft Excel 2019 New Features

Introduction to Microsoft Excel 2019 New Features

00:07:00

CONCAT

00:02:00

IFS

00:01:00

MAXIFS

00:01:00

MINIFS

00:01:00

SWITCH

00:02:00

TEXTJOIN

00:01:00

Map Chart

00:02:00

Funnel Chart

00:01:00

Better Visuals

00:06:00

Pivot Table Enhancements

00:02:00

Power Pivot Updates

00:01:00

Getting Started with Microsoft Excel

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

Performing Calculations

Create Worksheet Formulas

00:15:00

Insert Functions

00:17:00

Reuse Formulas and Functions

00:17:00

Modifying a Worksheet

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

Formatting a Worksheet

Apply Text Formats

00:16:00

Apply Number Format

00:07: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

Printing Workbooks

Preview and Print a Workbook

00:10:00

Set Up the Page Layout

00:09:00

Configure Headers and Footers

00:07:00

Managing Workbooks

Manage Worksheets

00:05:00

Manage Workbook and Worksheet Views

00:07:00

Manage Workbook Properties

00:06:00

Microsoft Word 2019

Microsoft Word 2019 New Features

Introduction to Microsoft Word 2019 New Features

00:14:00

Inking Tools

00:03:00

Inking Tools 1

00:07:00

Learning Tools

00:07:00

Microsoft Translate

00:03:00

LaTeX

00:05:00

Smart Lookup

00:04:00

Side to Side Scrolling

00:02:00

Scalable Vector Graphics

00:03:00

Getting Started with Word

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

Formatting Text and Paragraphs

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

Working More Efficiently

Make Repetitive Edits

00:06:00

Apply Repetitive Formatting

00:10:00

Use Styles to Streamline Repetitive Formatting Tasks

00:14:00

Managing Lists

Sort a List

00:05:00

Format a List

00:06:00

Adding Tables

Inserting a Table

00:06:00

Modify a Table

00:06:00

Format a Table

00:03:00

Convert Text to a Table

00:04:00

Inserting Graphic Objects

Insert Symbols and Special Characters

00:04:00

Add Images to a Document

00:11:00

Controlling Page Appearance

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

Preparing to Publish a Document

Check Spelling Grammar and Readability

00:07:00

Use Proofing and Research Tools

00:07:00

Check Accessibility

00:03:00

Save a Document to Other Formats

00:04:00

Workbooks - Microsoft Word 2016 (Beginner)

Workbooks - Microsoft Word 2016 (Beginner)

00:00:00

Microsoft PowerPoint 2019

Microsoft PowerPoint 2019 New Features

Introduction to Microsoft PowerPoint 2019 New Features

00:06:00

Highlighting

00:02:00

Morph Transition

00:03:00

Zoom

00:03:00

Vector Graphics

00:03:00

SVG Icons to Shapes

00:04:00

3D Modeling

00:04:00

Background Removal

00:03:00

4K

00:03:00

PowerPoint Interface

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

Presentation Basics

Select a Presentation Type

00:08:00

Edit Text

00:13:00

Build a Presentation

00:27:00

Formatting

Format Characters

00:11:00

Format Paragraphs

00:16:00

Format Text Boxes

00:09:00

Inserting Options

Insert Images

00:10:00

Insert Shapes

00:15:00

Working with Objects

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

Table

Create a Table

00:09:00

Format a Table

00:03:00

Insert a Table from Other Microsoft Office Applications

00:06:00

Charts

Create a Chart

00:10:00

Format a Chart

00:10:00

Insert a Chart from Microsoft Excel

00:05:00

Review and Presentation

Review Your Presentation

00:11:00

Apply Transitions

00:05:00

Print Your Presentation

00:05:00

Deliver Your Presentation

00:08:00

Microsoft Access 2019

Microsoft Access 2019 New Features

Introduction to Microsoft Access 2019 New Features

00:05:00

Window Resize

00:01:00

Charts

00:02:00

dbf

00:01:00

Large Number

00:01:00

Property Sorting

00:01:00

Introduction to Access

Orientation to Microsoft Access

00:39:00

Create a Simple Access Database

00:10:00

Get Help and Configure Options in Microsoft Access

00:06:00

Modify Data

Modify Table Data

00:17:00

Sort and Filter Records

00:05:00

Working with Queries

Create Basic Queries

00:15:00

Sort and Filter Data in a Query

00:14:00

Perform Calculations in a Query

00:08:00

Access Forms

Create Basic Access Forms

00:07:00

Work with Data on Access Forms

00:23:00

Working with Reports

Create a Report

00:28: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

Assignment

Assignment - Microsoft Office Basic to Advance

00:00:00

Recommended Materials

Workbook - Microsoft Office Basic to Advance

00:00:00

Order Your Certificate

Order Your Certificate

00:00:00

About The Provider

NextGen Learning
NextGen Learning
London, United Kingdom

NextGen Learning offers futuristic learning tailored for emerging leaders. Dedicated to empowering learners, this platform boasts a vast array of courses, crafted by industry...

Read more about NextGen Learning

Tags

Reviews