Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
About This Course
- Microsoft Office 2019 – Excel, Word, PowerPoint & Access Overview
This educational suite offers an immersive deep dive into the primary 2019 versions of Microsoft’s powerhouse software. Participants will cultivate specialized expertise in drafting documents, overseeing complex spreadsheets, constructing slide decks, and structuring databases through contemporary digital methodologies. The curriculum highlights vital utility, interface mastery, layout styles, and time-saving mechanisms necessary for high-performance corporate settings across the globe.
Individuals will acquire a functional grasp of sophisticated calculation logic, ledger administration, graphical representation, and information scrutiny to manage corporate intelligence with precision. The syllabus further explores text processing for refined correspondence, utilizing stylistic presets, layout grids, and distribution formats. Additionally, the modules delve into slide aesthetics, transition dynamics, and structural data governance to categorize and interpret substantial datasets with optimal speed.
By engaging with this series, scholars will sharpen their electronic output, methodical planning, and troubleshooting capabilities vital for today’s commercial landscape. The instruction prioritizes boosting precision, procedural flow, and visual excellence. Upon finishing the curriculum, graduates will be equipped to tackle administrative duties, simplify routine processes, and advance toward vocational prospects demanding expert-level software fluency across diverse sectors.
- What You Will Learn from Microsoft Office 2019 Course
- Create professional documents using advanced Microsoft Word features
- Analyse spreadsheet data using Microsoft Excel formulas effectively
- Design engaging presentations through Microsoft PowerPoint creative tools
- Organise databases using Microsoft Access management systems efficiently
- Apply formatting techniques improving workplace productivity and presentation
- Manage office documents with structured editing and organisation
- Develop professional reporting skills using Microsoft Office applications
- Improve workflow efficiency through practical digital productivity techniques
- Why Should You Choose this Microsoft Office 2019 Course
This Microsoft Office 2019 course develops practical workplace productivity skills required across administrative, academic, and professional business environments. Learners gain valuable expertise in document creation, spreadsheet analysis, presentation design, and database management techniques.
The course also offers flexible online learning supported by industry-focused training materials and recognised certification. It improves digital confidence, organisational efficiency, and employability for individuals pursuing modern office administration and business support careers successfully.
- Key Topics Covered
- Microsoft Excel formulas, functions, and spreadsheet automation techniques
- Microsoft Word formatting, editing, and publishing document tools
- Microsoft PowerPoint presentation design and animation creation methods
- Microsoft Access database management and reporting system techniques
- Data analysis using charts, tables, and visual reporting
- Professional document organisation and digital productivity improvement strategies
- Workplace communication through structured Microsoft Office applications
- File management and collaborative office workflow improvement practices
- Who Should Take This Course?
Whether you are a student, office administrator, business professional, entrepreneur, or job seeker, this course provides essential digital productivity skills required within modern workplaces. It supports learners seeking practical understanding of Microsoft Office applications for academic, administrative, or professional development purposes.
This course is also suitable for individuals aiming to improve workplace efficiency, organisational abilities, and professional communication standards. Anyone interested in strengthening technical office skills and increasing career opportunities within business and administrative sectors will benefit from this comprehensive training programme.
- Entry Requirements
There are no formal academic qualifications required to enrol in this Microsoft Office 2019 course. Learners should possess basic English communication abilities and access to an internet-connected computer, tablet, or smartphone for participating in online learning activities and successfully completing the programme requirements.
- Why Should You Learn with Imperial Academy
- Flexible online learning accessible through multiple digital devices
- Professionally designed study materials supporting effective independent learning
- Recognised certification improving professional credibility and employability opportunities
- Expert tutor guidance throughout complete online learning experience
- Career-focused training supporting long-term workplace productivity development
- Efficient assessment systems delivering immediate performance evaluation results
- Career Prospects
- Office Administrator (£25,000 – £38,000 per year)
- Administrative Assistant (£24,000 – £35,000 per year)
- Data Entry Specialist (£22,000 – £32,000 per year)
- Business Support Executive (£28,000 – £45,000 per year)
- Microsoft Office Trainer (£30,000 – £50,000 per year)
- Database Support Assistant (£27,000 – £42,000 per year)
Course Curriculum
-
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
-
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:17: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:07:00
-
Preview and Print a Workbook
00:10:00
-
Set Up the Page Layout
00:08: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:05:00
-
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
-
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:04: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
-
Assignment – Microsoft Excel Complete Course 2019
10:19:00
-
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
-
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
-
Create a Table
00:09:00
-
Format a Table
00:03: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:06:00
-
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
-
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 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
-
Workbook – Microsoft Office 2019
06:08:00
Subscribe to this course and 2,000+ top‑rated Training Express courses for your organization.
Try imperial academy business
Add to Cart
