Booking options
£25
Course Images
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
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...
Reviews
There are no reviews for Microsoft Office Basic to Advance Course yet.Why not be the first one to review this course?