Course Description
-
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: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
-
Preview and Print a Workbook
00:10: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
-
Introduction to Microsoft Word 2019 New Features
00:14:00 -
Inking Tools
00:03: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:13: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:05: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:07:00 -
Check Accessibility
00:03:00 -
Save a Document to Other Formats
00:04: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:05: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 -
Animate 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:08: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:12: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
-
Module One – Getting Started
00:30:00 -
Module Two – Working with the Word Window
01:00:00 -
Module Three – Advanced Editing and Formatting Tasks
01:00:00 -
Module Four – Working with Illustrations
01:00:00 -
Module Five – Formatting Pictures
01:00:00 -
Module Six – Adding SmartArt
01:00:00 -
Module Seven – Adding Tables
01:00:00 -
Module Eight – Inserting Special Objects
01:00:00 -
Module Nine – Working with Document References
01:00:00 -
Module Ten – Reviewing Your Document
01:00:00 -
Module Eleven – Using Comments and Tracking
01:00:00 -
Module Twelve – Wrapping Up
00:30:00 -
Activities-Accredited Microsoft Word Advanced Level Training
-
Create and Use Templates
00:08:00
-
Module One – Getting Started
01:00:00 -
Module Two – SmartArt and Objects
01:00:00 -
Module Three – Auditing
01:00:00 -
Module Four – Creating Charts
01:00:00 -
Module Five – Working with Charts
01:30:00 -
Module Six – Creating Pivot Tables and Pivot Charts
01:00:00 -
Module Seven – Macros
01:00:00 -
Module Eight – Solving Formula Errors
01:00:00 -
Module Nine – Using What If Analysis
01:00:00 -
Module Ten – Managing Your Data
02:00:00 -
Module Eleven – Grouping and Outlining Data
01:00:00 -
Module Twelve – Wrapping Up
00:30:00 -
Activities-Microsoft Excel Advanced CPD & IAO Accredited
-
Module One – Getting Started
00:30:00 -
Module Two – Working with Shapes
01:00:00 -
Module Three – Working with Text Boxes
01:00:00 -
Module Four – Adding SmartArt
01:00:00 -
Module Five – Advanced Drawing Tasks
01:00:00 -
Module Six – Adding Tables
01:00:00 -
Module Seven – Inserting Audio and Video
01:00:00 -
Module Eight – PowerPoint’s Research Tools
01:00:00 -
Module Nine – Preparing for Your Presentation
01:00:00 -
Module Ten – Using Slide Masters
01:00:00 -
Module Eleven – Advanced Presentation Tasks
01:00:00 -
Module Twelve – Wrapping Up
00:30:00 -
Activities-Microsoft PowerPoint Advanced Level
-
Module One – Getting Started
00:30:00 -
Module Two – Using App Views
01:00:00 -
Module Three – Customizing Apps, Part One
01:00:00 -
Module Four – Customizing Apps, Part Two
01:00:00 -
Module Five – Working with More Record Tasks
01:00:00 -
Module Six – Using Advanced Field Tasks
01:00:00 -
Module Seven – Working in Table Design View
01:00:00 -
Module Eight – Working with the Expression Builder
01:00:00 -
Module Nine – Working with External Data
01:00:00 -
Module Ten – Creating Queries
01:00:00 -
Module Eleven – Creating Forms and Reports
01:00:00 -
Module Twelve – Wrapping Up
00:30:00 -
Activities – Certified Microsoft Access Professional
-
Module One – Getting Started
00:30:00 -
Module Two – Working with Messages
01:00:00 -
Module Three – Customizing Your Profile
01:00:00 -
Module Four – Advanced Email Tasks
01:00:00 -
Module Five – Managing Junk Mail
01:00:00 -
Module Six – Advanced Calendar Tasks
01:00:00 -
Module Seven – Doing More With Tasks
01:00:00 -
Module Eight – Using Notes
01:00:00 -
Module Nine – Viewing RSS Feeds
01:00:00 -
Module Ten – Printing
01:00:00 -
Module Eleven – Managing Outlook Data
01:00:00 -
Module Twelve – Wrapping Up
01:00:00 -
Activities- Accredited Microsoft Outlook Advanced
Course Reviews
No Reviews found for this course.
Comming Soon!