Setup Menus in Admin Panel

Course ID Course Name & Link Modules Name & Link
161975 Microsoft Access 2016 Professional Diploma Add Controls to Forms
Set Form Controls
Create Subforms
Organize Information with Tab Pages
Enhance Navigation with Forms
Format a Form
Apply Conditional Formatting
Field Validation
Form and Record Validation
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Split a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
Activities – Exercise Files for Microsoft Access 2016 Professional Diploma
103104 Microsoft Access Beginners Level Module One – Getting Started
Module Two – Opening and Closing Access
Module Three – An Introduction to Databases
Module Four – Sharing Data Using Apps
Module Five – Working in Your App
Module Six – An Introduction to Desktop Databases
Module Seven – Performing Basic Table Tasks
Module Eight – Working with Fields
Module Nine – Working with Table Relationships
Module Ten – An Introduction to Queries, Forms, and Reports
Module Eleven – Protecting Your Data
Module Twelve – Wrapping Up
Activities – Microsoft Access Beginners Level
Mock Exam – Microsoft Access Beginners Level
Final Exam – Microsoft Access Beginners Level
201243 Microsoft Access Beginners to Advanced Course Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access
Modify Table Data
Sort and Filter Records
Create Lookups
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Create Parameter Queries
Create Action Queries
Create Unmatched and Duplicate Queries
Summarize Data
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
The Access Options Dialog Box
Relational Database Design
Create a Table
Create Table Relationships
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
Data Normalization
Create a Junction Table
Improve Table Structure
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Organize Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Add Controls to Forms
Create Subforms
Organize Information with Tabs Pages
Enhance Navigation of Forms
Apply Conditional Formatting
Field and Record Validation
Form Validation
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Splitting a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Analyze the Performance of a Database
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
108144 Microsoft Access Complete Diploma Module One – Getting Started
Module Two – Opening and Closing Access
Module Three – An Introduction to Databases
Module Four – Sharing Data Using Apps
Module Five – Working in Your App
Module Six – An Introduction to Desktop Databases
Module Seven – Performing Basic Table Tasks
Module Eight – Working with Fields
Module Nine – Working with Table Relationships
Module Ten – An Introduction to Queries, Forms, and Reports
Module Eleven – Protecting Your Data
Module Twelve – Wrapping Up
Activities – Microsoft Access Beginners Level
Module One – Getting Started
Module Two – Creating a Custom App
Module Three – Customizing App Actions
Module Four – Customizing Your App Views with Macros
Module Five – Working with Validation Rules and Messages
Module Six – Working with Macros
Module Seven – Advanced Query Tasks
Module Eight – Designing Forms
Module Nine – Advanced Reporting Tasks
Module Ten – Advanced Database Tools
Module Eleven – Working with the Access Environment
Module Twelve – Wrapping Up
Activities – Microsoft Access Intermediate Level
Module One – Getting Started
Module Two – Using App Views
Module Three – Customizing Apps, Part One
Module Four – Customizing Apps, Part Two
Module Five – Working with More Record Tasks
Module Six – Using Advanced Field Tasks
Module Seven – Working in Table Design View
Module Eight – Working with the Expression Builder
Module Nine – Working with External Data
Module Ten – Creating Queries
Module Eleven – Creating Forms and Reports
Module Twelve – Wrapping Up
Activities – Microsoft Access Advanced Level
Mock Exam- Level 3 Diploma in Microsoft Access
Final Exam- Level 3 Diploma in Microsoft Access
108153 Microsoft Access Complete Diploma – Beginners, Intermediate & Advanced Module One – Getting Started
Module Two – Opening and Closing Access
Module Three – An Introduction to Databases
Module Four – Sharing Data Using Apps
Module Five – Working in Your App
Module Six – An Introduction to Desktop Databases
Module Seven – Performing Basic Table Tasks
Module Eight – Working with Fields
Module Nine – Working with Table Relationships
Module Ten – An Introduction to Queries, Forms, and Reports
Module Eleven – Protecting Your Data
Module Twelve – Wrapping Up
Activities – Microsoft Access Beginners Level
Module One – Getting Started
Module Two – Creating a Custom App
Module Three – Customizing App Actions
Module Four – Customizing Your App Views with Macros
Module Five – Working with Validation Rules and Messages
Module Six – Working with Macros
Module Seven – Advanced Query Tasks
Module Eight – Designing Forms
Module Nine – Advanced Reporting Tasks
Module Ten – Advanced Database Tools
Module Eleven – Working with the Access Environment
Module Twelve – Wrapping Up
Activities – Microsoft Access Intermediate Level
Module One – Getting Started
Module Two – Using App Views
Module Three – Customizing Apps, Part One
Module Four – Customizing Apps, Part Two
Module Five – Working with More Record Tasks
Module Six – Using Advanced Field Tasks
Module Seven – Working in Table Design View
Module Eight – Working with the Expression Builder
Module Nine – Working with External Data
Module Ten – Creating Queries
Module Eleven – Creating Forms and Reports
Module Twelve – Wrapping Up
Activities – Microsoft Access Advanced Level
Mock Exam- Microsoft Access Complete Diploma – Beginners, Intermediate & Advanced
Final Exam – Microsoft Access Complete Diploma – Beginners, Intermediate & Advanced
230543 Microsoft Access Training: Beginner to Advanced Course Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access
Modify Table Data
Sort and Filter Records
Create Lookups
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Create Parameter Queries
Create Action Queries
Create Unmatched and Duplicate Queries
Summarize Data
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
The Access Options Dialog Box
Relational Database Design
Create a Table
Create Table Relationships
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
Data Normalization
Create a Junction Table
Improve Table Structure
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Organize Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Add Controls to Forms
Create Subforms
Organize Information with Tabs Pages
Enhance Navigation of Forms
Apply Conditional Formatting
Field and Record Validation
Form Validation
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Splitting a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Analyze the Performance of a Database
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
100671 Microsoft Excel 2010 Intermediate Training Diploma Module One – Getting Started
Module Two – Working with Permissions and Options
Module Three – Sharing Workbooks
Module Four – Performing Advanced Formula and Function Tasks
Module Five – Working with Array Formulas
Module Six – Working with Functions
Module Seven – Working with Macros
Module Eight – Working with Forms
Module Nine – Applying Advanced Chart Features
Module Ten – Working with PivotTables and PivotCharts
Module Eleven – Using the Automated Analysis Tools Add -In
Module Twelve – Wrapping Up
Activities – Microsoft Excel 2010 Intermediate Training Diploma
Mock Exam – Microsoft Excel 2010 Intermediate Training Diploma
Final Exam – Microsoft Excel 2010 Intermediate Training Diploma
169478 Microsoft Excel 2016 Advanced Level Update Workbook Properties3
Activity-Update Workbook Properties
Create and Edit a Macro3
Activity-Create and Edit a Macro
Apply Conditional Formatting
Activity-Apply Conditional Formatting
Add Data Validation Criteria
Activity – Add Data Validation Criteriaty
Trace Cells
Activity-Trace Cells
Troubleshoot Invalid Data and Formula Errors
Activity-Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Activity-Watch and Evaluate Formulas
Create a Data List Outline
Activity-Create a Data List Outline
Create Sparklines
Activity – Create Sparklines
Create Scenarios
Activity-Create Scenarios
Perform a What-If Analysis
Activity-Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Activity-Perform a Statistical Analysis with the Analysis ToolPak
Create Interactive Data with Power View
Activity-Create Interactive Data with Power View
Consolidate Data
Activity-Consolidate Data
Link Cells in Different Workbooks
Activity-Link Cells in Different Workbooks
Merge Workbooks
Activity-Merge Workbooks
Export Excel Data
Activity-Export Excel Data
Import a Delimited Text File
Activity- Import a Delimited Text File
Integrate Excel Data with the Web
Activity-Integrate Excel Data with the Web
Create a Web Query
Activity-Create a Web Query
Import and Export XML Data
Activity-Import and Export XML Data
Activities and Exercise Files – Microsoft Excel 2016 Advanced
Mock Exam – Microsoft Excel 2016 Advanced Level
Final Exam – Microsoft Excel 2016 Advanced Level
169435 Microsoft Excel 2016 and VBA Training Diploma Create a Macro Using the Macro Recorder
Edit a Macro
Debug a Macro
Customize the Quick Access Toolbar and Hotkeys
Set Macro Security
Insert Text
Format Text
Sort Data
Duplicate Data
Generate a Report
Determine the Dialog Box Type
Capture User Input
Insert, Copy, and Delete Worksheets
Rename Worksheets
Modify the Order of Worksheets
Print Worksheets
Create User-Defined Functions
Automate SUM Functions
Activities – Microsoft Excel 2016 and VBA
Mock Exam- Microsoft Excel 2016 and VBA Training Diploma
Final Exam- Microsoft Excel 2016 and VBA Training Diploma
161247 Microsoft Excel 2016 Beginners Level Identify the Elements of the Excel Interface
Activity – Identify the Elements of the Excel Interface
Create a Basic Worksheet
Activity – Create a Basic Worksheet
Use the Help System
Activity – Use the Help System
Create Formulas in a Worksheet
Activity – Create Formulas in a Worksheet
Insert Functions in a Worksheet
Activity – Insert Functions in a Worksheet
Reuse Formulas
Activity – Reuse Formulas
Manipulate Data
Activity – Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
Search For and Replace Data
Activity – Search For and Replace Data
Spell Check a Worksheet
Activity – Spell Check a Worksheet
Modify Fonts
Activity – Modify Fonts
Add Borders and Colors to Cells
Activity – Add Borders and Colors to Cells
Apply Number Formats
Activity – Apply Number Formats
Align Cell Contents
Activity – Align Cell Contents
Apply Cell Styles
Activity – Apply Cell Styles
Define the Basic Page Layout for a Workbook
Activity – Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Activity – Refine the Page Layout and Apply Print Options
Format Worksheet Tabs
Activity – Format Worksheet Tabs
Manage Worksheets
Activity – Manage Worksheets
Manage the View of Worksheets and Workbooks
Activity – Manage the View of Worksheets and Workbooks
Customize General and Language Options
Activity – Customize General and Language Options
Customize Formula Options
Activity – Customize Formula Options
Customize Proofing and Save Options
Activity – Customize Proofing and Save Options
Customize the Ribbon and Quick Access Toolbar
Activity – Customize the Ribbon and Quick Access Toolbar
Customize the Functionality of Excel by Enabling Add-Ins
Activity – Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced and Trust Center Options
Activity – Customize Advanced and Trust Center Options
Activities – Microsoft Excel 2016 for Beginners
Mock Exam – Microsoft Excel 2016 Beginners Level
Final Exam – Microsoft Excel 2016 Beginners Level
326921 Microsoft Excel 2016 Bundle Diploma: 5 Accredited Diplomas in 1 Course Apply Range Names
Use Specialized Functions
Use Text Functions
Use Logical Functions
Use Lookup Functions
Use Date Functions
Use Financial Functions
Create and Modify Tables
Sort and Filter Data3
Use Subtotal and Database Functions to Calculate Data
Create Charts
Modify and Format Charts
Create a Trendline
Create Advanced Charts
Create a PivotTable
Filter Data by Using Slicers
Analyze Data with PivotCharts
Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Incorporate SmartArt
Customize Workbooks
Manage Themes
Create and Use Templates
Protect Files3
Preparing a Workbook for Multiple Audiences
Activities – Microsoft Excel 2016 Intermediate
Update Workbook Properties3
Activity-Update Workbook Properties
Create and Edit a Macro3
Activity-Create and Edit a Macro
Apply Conditional Formatting
Activity-Apply Conditional Formatting
Add Data Validation Criteria
Activity – Add Data Validation Criteriaty
Trace Cells
Activity-Trace Cells
Troubleshoot Invalid Data and Formula Errors
Activity-Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Activity-Watch and Evaluate Formulas
Create a Data List Outline
Activity-Create a Data List Outline
Create Sparklines
Activity – Create Sparklines
Create Scenarios
Activity-Create Scenarios
Perform a What-If Analysis
Activity-Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Activity-Perform a Statistical Analysis with the Analysis ToolPak
Create Interactive Data with Power View
Activity-Create Interactive Data with Power View
Consolidate Data
Activity-Consolidate Data
Link Cells in Different Workbooks
Activity-Link Cells in Different Workbooks
Merge Workbooks
Activity-Merge Workbooks
Export Excel Data
Activity-Export Excel Data
Import a Delimited Text File
Activity- Import a Delimited Text File
Integrate Excel Data with the Web
Activity-Integrate Excel Data with the Web
Create a Web Query
Activity-Create a Web Query
Import and Export XML Data
Activity-Import and Export XML Data
Activities and Exercise Files – Microsoft Excel 2016 Advanced
Create a Macro Using the Macro Recorder
Edit a Macro
Debug a Macro
Customize the Quick Access Toolbar and Hotkeys
Set Macro Security
Insert Text
Format Text
Sort Data
Duplicate Data
Generate a Report
Determine the Dialog Box Type
Capture User Input
Insert, Copy, and Delete Worksheets
Rename Worksheets
Modify the Order of Worksheets
Print Worksheets
Create User-Defined Functions
Automate SUM Functions
Activities – Microsoft Excel 2016 and VBA
Use Links and External References
Use 3-D References
Consolidate Data
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Collaborate on a Workbook
Protect Worksheets and Workbooks
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Create Sparklines
MapData
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends
Enable and Navigate
Import Data from Various Data Sources
Refresh Data from a Data Source
Create Linked Tables
Organize and Format Tables
Create Calculated Columns
Sort and Filter PowerPivot Data
Create and Manage Table Relationships
Create PivotTables
Create PivotCharts
Create Power Views
Filter Data Using Slicers
Present PivotTable Data Visually
Manipulate PowerPivot Data Using DAX Functions
Extract Data from Tables Using Functions
Save Reports in Different File Formats
Work with Time Dependent Data
Protect Reports
Activities – Microsoft Excel 2016 PowerPivot Advanced
Mock Exam – Microsoft Excel 2016 Intermediate Training Diploma
Final Exam – Microsoft Excel 2016 Intermediate Training Diploma
Mock Exam – Microsoft Excel 2016 Advanced Level
Final Exam – Microsoft Excel 2016 Advanced Level
Mock Exam- Microsoft Excel 2016 and VBA Training Diploma
Final Exam- Microsoft Excel 2016 and VBA Training Diploma
163507 Microsoft Excel 2016 Intermediate Training Diploma Apply Range Names
Use Specialized Functions
Use Text Functions
Use Logical Functions
Use Lookup Functions
Use Date Functions
Use Financial Functions
Create and Modify Tables
Sort and Filter Data3
Use Subtotal and Database Functions to Calculate Data
Create Charts
Modify and Format Charts
Create a Trendline
Create Advanced Charts
Create a PivotTable
Filter Data by Using Slicers
Analyze Data with PivotCharts
Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Incorporate SmartArt
Customize Workbooks
Manage Themes
Create and Use Templates
Protect Files3
Preparing a Workbook for Multiple Audiences
Activities – Microsoft Excel 2016 Intermediate
Mock Exam – Microsoft Excel 2016 Intermediate Training Diploma
Final Exam – Microsoft Excel 2016 Intermediate Training Diploma
158263 Microsoft Excel 2016 PowerPivot Advanced Enable and Navigate
Import Data from Various Data Sources
Refresh Data from a Data Source
Create Linked Tables
Organize and Format Tables
Create Calculated Columns
Sort and Filter PowerPivot Data
Create and Manage Table Relationships
Create PivotTables
Create PivotCharts
Create Power Views
Filter Data Using Slicers
Present PivotTable Data Visually
Manipulate PowerPivot Data Using DAX Functions
Extract Data from Tables Using Functions
Save Reports in Different File Formats
Work with Time Dependent Data
Protect Reports
Activities – Microsoft Excel 2016 PowerPivot Advanced
100823 Microsoft Excel 365 Basics Training Module One – Getting Started
Module Two – Welcome to Office 365 Web Apps
Module Three – Worksheets and Workbooks
Module Four – Working with Excel Files
Module Five – Editing in the Browser (I)
Module Six – Editing in the Browser (II)
Module Seven – Building Formulas
Module Eight – Understanding Functions
Module Nine – Working with Data
Module Ten – Formatting your Data
Module Eleven – The Insert Tools
Module Twelve – Wrapping Up
Activities – Microsoft Excel 365 Basics Training
Mock Exam – Microsoft Excel 365 Basics Training
Final Exam – Microsoft Excel 365 Basics Training
197946 Microsoft Excel Complete Course – Beginner, Intermediate, Advanced Introduction to Microsoft Excel 2019 New Features
CONCAT
IFS
MAXIFS
MINIFS
SWITCH
TEXTJOIN
Map Chart
Funnel Chart
Better Visuals
Pivot Table Enhancements
Power Pivot Updates
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 Formats
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
Workbooks – Microsoft Excel Beginners
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Create Charts
Modify and Format Charts
Use Advanced Chart Features
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
Workbooks – Microsoft Excel Intermediate
Use Links and External References
Use 3-D References
Consolidate Data
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Collaborate on a Workbook
Protect Worksheets and Workbooks
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Create Sparklines
MapData
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends
Workbooks – Microsoft Excel Advanced
Order your Certificate
103790 Microsoft Excel Complete Diploma – Beginners, Intermediate, Advanced Module One – Getting Started
Module Two – Opening and Closing Excel
Module Three – Working with the Interface
Module Four – Your First Worksheet
Module Five – Viewing Excel Data
Module Six – Building Formulas
Module Seven – Using Excel Functions
Module Eight – Using Quick Analysis
Module Nine – Formatting Your Data
Module Ten – Using Styles, Themes, and Effects
Module Eleven – Printing and Sharing Your Workbook
Module Twelve – Wrapping Up
Activities – Microsoft Excel for Beginner Learners
Module One – Getting Started
Module Two – Working with Permissions and Options
Module Three – Sharing Workbooks
Module Four – Performing Advanced Formula and Function Tasks
Module Five – Working with Array Formulas
Module Six – Working With Macros
Module Seven – Working With Forms
Module Eight – Applying Advanced Chart Features
Module Nine – Working With Slicers and Timelines
Module Ten – Working With Multiple Tables, Relationships and External Data
Module Eleven – Working With PowerView
Module Twelve – Wrapping Up
Activities- Microsoft Excel – Intermediate Level
Module One – Getting Started
Module Two – SmartArt and Objects
Module Three – Auditing
Module Four – Creating Charts
Module Five – Working with Charts
Module Six – Creating Pivot Tables and Pivot Charts
Module Seven – Macros
Module Eight – Solving Formula Errors
Module Nine – Using What If Analysis
Module Ten – Managing Your Data
Module Eleven – Grouping and Outlining Data
Module Twelve – Wrapping Up
Activities-Microsoft Excel – Advanced Level
Mock Exam – Microsoft Excel Complete Diploma – Beginners, Intermediate, Advanced
Final Exam – Microsoft Excel Complete Diploma – Beginners, Intermediate, Advanced
101311 Microsoft Excel for Beginner Learners Module One – Getting Started
Module Two – Opening Excel
Module Three – Working with the Interface
Module Four – Your First Worksheet
Module Five – Viewing Excel Data
Module Six – Building Formulas
Module Seven – Using Excel Functions
Module Eight – Using Quick Analysis
Module Nine – Formatting Your Data
Module Ten – Using Styles, Themes, and Effects
Module Eleven – Printing and Sharing Your Workbook
Module Twelve – Wrapping Up
Activities – Microsoft Excel for Beginner Learners
Mock Exam – Microsoft Excel for Beginner Learners
Final Exam – Microsoft Excel for Beginner Learners
259463 Microsoft Excel Training: Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table
Drill Down
Managing the Field List
Changing the Calculation type with Value Field Settings
Growing your Pivot Table with Multiple Fields
Formatting the Pivot Table
Sorting and Filtering the Pivot Table
Creating a Dashboard with Slicers, Timelines and Pivot Charts
Reporting by day, month, qtr, or year within the Pivot Table
Refreshing the Pivot Data with new data
Adding your own calculations into the Pivot Table
The power of the Filter Section in the Pivot Table
PowerQuery
PowerPivot
259101 Microsoft Excel: Build Models Using Advanced Formulas, VBA, Power Query Course Outline and Introduction
Minimum Requirements for the Course
Prepayments Introduction
Month End Date Prepaid Expenses Amortization Calculation
Exact Prepaid Expenses Payment Date Calculation
Prepaid Expenses Accounting Definition: Prepayments
Prepaid Expense Example: How Accounting works for Prepayments
Advantages and Disadvantages of Prepaid Expenses
Introduction to PRO Excel Models and Formulas
Date Function
DATEVALUE function
IF Function
IFS Function (Office 365 Only)
VLOOKUP Function
MATCH Function
INDIRECT Function
NAMED Ranges: Name Manager
Advanced Version of VLOOKUP Function
Introduction to Model and Control Panel Tab (Important Sheet Tab)
Formula Based Prepaid Expenses Model – Deep Dive (Part 1)
Formula Based Prepaid Expenses Model – Deep Dive (Part 2)
Formula Based Prepaid Expenses Model – Deep Dive (Part 3)
IFS Function – Month End date Prepayment calculation
Prepaid Expenses – Closing Balance Summary Tab (Formula Based Summary)
Protecting Formulas Cells and Fields in the Model
Exact Date Prepaid Amortisation calculation Intro
Formulas update and Model Changes for Exact Prepaid Exps Calculation
Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1)
Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2)
Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3)
Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4)
IFS Function – Exact Date Prepayments Amortisation
Data Validation Controls (Enhancing Data Input Controls with Protection)
Bonus: Prepayment Model with Opening Balance Calculation (Part 1)
Bonus: Prepayment Model with Opening Balance Calculation (Part 2)
Additional Material: Resources
Power Query and Pivot Table Prepayment Summary Table Intro
What is Power Query and Some Awesome Resources for Power Query learning
Power Query and Pivot Table Summary – Deep Dive (Part 1)
Power Query and Pivot Table Summary – Deep Dive (Part 2)
Power Query and Pivot Table Summary – Deep Dive (Part 3)
Power Query and Pivot Table Summary – Deep Dive (Part 4)
Using Array Formulas to Add Formula Protection
Bonus: Allocate Prepaid Expenditure Cost Centre Wise – 1
Bonus: Allocate Prepaid Expenditure Cost Centre Wise – 2
Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version)
Changing Macros Security in Excel
Complete Walkthrough – Advanced VBA Prepaid Expenses Amortisation Model
Bonus : New Version – Excel VBA Model for Prepayment Expenditure
Dynamic Dashboard Overview
Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets
Creating Dynamic Data Validation
Creating Named Ranges for Dynamic Table Arrays
Dynamic Date Column Headings for each Divisional PL Table
Dynamic Month and YTD Dashboard tables headings (PRO TIP)
Dynamic VLOOKUP Formula – Preparing First section of the Dashboard
Creating Rolling Dashboard with Dynamic VLOOKUP Function
IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP)
Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function)
Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1)
Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2)
Introduction – Formula-less Dashboard – Fully Dynamic and easily refreshed
Understanding the data files before building dashboard
Consolidating Reports with Power Query (Get & Transform) , How to install PQ
Dynamic File Path Trick in Power Query with Parameters (Amazing trick)
Conditional Cumulative totals with SUMIFS Function
Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code)
Dashboard Creation – Pivot Table showing Month and YTD KPIs division wise
Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast)
Dashboard Creation – Line Charts
Update Dashboard with Additional Divisional Data with Few Click (Magical)
Thank you
Ultimate Prepaid Expenditure Model (Super Bonus)
Visualization: AREA Charts for Month – Revenue, Gross Profit and Net Profit
Resources – Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
259170 Microsoft Excel: Datasets Comparison with VBA Tool Introduction to Compare Data Workbook
Download Resources
Key requirements for Comparing any Datasets or Worksheets
Tool to Compare Datasets or Worksheets
Overview of Compare Data Workbook
Most Important things to remember before you use compare data workbook
IMPORTANT – First Column as KEY Column with UNIQUE Values
Deep Dive into Compare Data Workbook’s Environment
How to Change Header Rows for your data
Basics of Using macro enabled Excel files and Code Modules
Changing the Main two sheets name, variance tags in VBA Code
Changing various elements across VBA Code modules
Clear Sheet data button VBA Code
Convert Row data into Structured, clean and formatted data with Power Query 1
Convert Row data into Structured, clean and formatted data with Power Query 2
Mutual Funds Portfolio – Finding Variances at two different times
Comprehensive Payroll Analysis – Creating Powerful Dashboard 1
Comprehensive Payroll Analysis – Creating Powerful Dashboard 2
Comprehensive Payroll Analysis – Creating Powerful Dashboard 3
Comprehensive Payroll Analysis – Creating Powerful Dashboard 4
Comprehensive Payroll Analysis – Creating Powerful Dashboard 5
IMPORTANT Facts and Limitation of Compare Data Workbook
Conclusion
259163 Microsoft Excel: Depreciation Accounting Introduction
Minimum requirements before taking the course
Download master depreciation template
Definition of Depreciation
Amortization: Depreciation vs Amortization
Related Terms to Depreciation
Most Common Methods of Depreciation
Accounting for Depreciation
Depreciation Tax Shield
Depreciation Tax Shield Under Various Depreciation Methods
Introduction and basics of Depreciation Model in Excel
Deep Dive into Depreciation Model
How to use the model with Example
Advanced functionalities of the Model
Thank you for Enrolling
Resources – Microsoft Excel Training: Depriciation Accounting
259459 Microsoft Excel: Vlookup, Xlookup, Match and Index 1.1 Excel vlookup
1.2 Excel xlookup
1.3 Excel vlookup
1.4 Excel vlookup
1.5 Excel vlookup
1.6 Excel vlookup
1.7 Excel vlookup
187127 Microsoft Internet Explorer 6,7,8 Complete Diploma DEFINITIONS
INTERNET EXPLORER BASICS
THE INTERNET EXPLORER INTERFACE
MORE ABOUT TOOLBARS
GETTING HELP
ACCESSING A WEB SITE
SEARCHING THE WEB
WORKING WITH DATA
PRINTING FROM THE WEB
FAVOURITE BASICS
CREATING AND USING FAVOURITES
ORGANIZING FAVOURITES
THE LINKS TOOLBAR
SECURE SITES
ACCESSING PROTECTED SITES
SECURITY FEATURES
KEEPING YOURSELF SAFE
MANAGING INFORMATION
SETTING YOUR OPTIONS, PART ONE
SETTING YOUR OPTIONS, PART TWO
MANAGING YOUR HISTORY
ADDITIONAL COMPONENTS
Definitions to Microsoft Internet Explorer 7
Internet Explorer Basics
The Internet Explorer Interface
The Internet Explorer Window
More About Toolbars
Getting Help
Access a Web Site
Using Tabs
Searching the Web
Working with Data
Printing from the Web
Favorite Basics
Creating and Using Favorites
Organizing Favorites
The Links Folder
Secure Sites
Accessing Protected Sites
Security Features
Keeping Yourself Safe
Managing Information
Setting Your Options
Managing Your History
RSS Feeds
Additional Components
Definitions
Internet Explorer Basics
The Internet Explorer Interface
The Internet Explorer Window
More about Toolbars
Getting Help
Accessing a Web Site
Using Tabs
Searching the Web
Working with Data
Printing from the Web
Favorite Basics
Creating and Using Favorites
Organizing Favorites
Accelerators
Web Slices
Secure Sites
Accessing Protected Sites
Security Features
Keeping Yourself Safe
Managing Information
Setting Your Options
Managing your History
RSS Feeds
Additional Components
106345 Microsoft Office 2007 for Advanced Learners Module One – Getting Started
Module Two – Working with the Word Window
Module Three – Adding Pictures
Module Four – Adding Smart Art
Module Five – Adding Tables
Module Six – Advanced Table Tasks
Module Seven – Inserting Special Objects
Module Eight – Adding In-Document References
Module Nine – Advanced Research Tasks
Module Ten – Reviewing a Document
Module Eleven – Customizing Word
Module Twelve – Wrapping Up
Activities-Microsoft Word 2007 Advanced Level
Module One – Getting Started
Module Two – SmartArt
Module Three – Inserting Objects
Module Four – Creating Charts
Module Five – Creating Pivot Tables
Module Six – Working with Pivot Tables
Module Seven – Creating Pivot Charts
Module Eight – Solving Formula Errors
Module Nine – Using What-If Analysis
Module Ten – Managing Your Data
Module Eleven – Grouping and Outlining Data
Module Twelve – Wrapping Up
Activities-Microsoft Excel 2007 Advanced Level
Module One – Getting Started
Module Two – Adding Pictures
Module Three – Working with Text Boxes
Module Four – Adding SmartArt
Module Five – Adding Tables
Module Six – Inserting Advanced Objects
Module Seven – Advanced Drawing Tasks
Module Eight – PowerPoint’s Research Tools
Module Nine – Creating Notes and Handouts
Module Ten – Using Slide Masters
Module Eleven – Advanced Presentation Tasks
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint 2007 Advanced Level
Module One – Getting Started
Module Two – Advanced Table Tasks
Module Three – Advanced Form Tasks
Module Four – Advanced Reporting Tasks
Module Five – Understanding Relationships
Module Six – Advanced Query Tasks
Module Seven – Working with SQL
Module Eight – Linking Data
Module Nine – Importing Data
Module Ten – Exporting Data
Module Eleven – Advanced Database Tools
Module Twelve – Wrapping Up
Activities- Microsoft Access 2007 Advanced Level
Module One – Getting Started
Module Two – Customizing Outlook
Module Three – Adding Word Elements to an E-mail
Module Four – Customizing Your Profile
Module Five – Advanced E-Mail Tasks
Module Six – Advanced Calendar Tasks
Module Seven – Doing More with Tasks
Module Eight – Using Notes
Module Nine – Viewing RSS Feeds
Module Ten – Managing Outlook Data, Part One
Module Eleven – Managing Outlook Data, Part Two
Module Twelve – Wrapping Up
Activities-Microsoft Outlook 2007 Advanced Level
Mock Exam – Microsoft Office 2007 for Advanced Learners
Final Exam – Microsoft Office 2007 for Advanced Learners
176256 Microsoft Office 2007 Outlook Beginners Training Diploma The Program Window
Outlook Today
Getting Help
E-mail Accounts
Creating and Sending E-mail Messages
Creating and Sending E-mail Messages
Working with Messages
Attachments
Message Options
E-mail Security
Junk E-mail
Search Folders
Printing Messages
Managing Contacts
Distribution Lists
Electronic Business Cards
Working with Tasks
Managing Tasks
Creating and Sending Appointments
Modifying Appointments
Calendar Views
Events
Meeting Requests
Meeting Request Responses
Managing Meeting Responses
179526 Microsoft Office 2007 Word Intermediate – Video Training Course Examining Formatting
Creating Styles 
Modifying Styles
Outlining 
Using Full Screen Reading View
Creating and Formatting Sections 
Working with Columns
Table Formatting Basics 
Borders and Shading 
Table  Date
Table Styles 
Labels
Envelopes
Template Basics
Building Blocks 
Document Properties
Diagrams 
Drawing Tools
Formatting Text Graphically
Tracking Changes in a Document 
Working with Comments
Web Pages
Hyperlinks
182133 Microsoft Office 2010 Access Advanced – Video Training Course Course 01 Topic A SQL and Access
Course 01 Topic B Writing SQL Statements
Course 01 Topic C Attaching SQL Queries to Controls
Course 02 Topic A Creating Crosstab Queries
Course 02 Topic B Creating Parameter Queries
Course 02 Topic C Using Action Queries
Course 03 Topic A Creating, Running, and Modifying Macros
Course 03 Topic B Attaching Macros to the Events of Database Objects
Course 04 Topic A Creating Macros to Provide User Interaction
Course 04 Topic B Creating Macros that Require User Input
Course 04 Topic C Creating AutoKeys and AutoExec Macros
Course 04 Topic D Creating Macros for Data Transfer
Course 05 Topic A Importing Objects
Course 05 Topic B Exporting Objects
Course 05 Topic C Working with XML Documents
Course 05 Topic D Linking Access Objects
Course 05 Topic E Using Hyperlink Fields
Course 06 Topic A Optimizing Resources
Protecting Databases
Setting Options and Properties
108061 Microsoft Office 2010 for Advanced Learners Module One – Getting Started
Module Two – Working with the Word Window
Module Three – Adding Pictures
Module Four – Formatting Pictures
Module Five – Adding Smart Art
Module Six – Adding Tables
Module Seven – Inserting Special Objects
Module Eight – Adding In Document References
Module Nine – Advanced Research Tasks
Module Ten – Reviewing a Document
Module Eleven – Customizing Word
Module Twelve – Wrapping Up
Activities-Microsoft Word 2010 Advanced Level
Module One – Getting Started
Module Two – SmartArt and Objects
Module Three – Auditing
Module Four – Creating Charts
Module Five – Creating Pivot Tables
Module Six – Working with PivotTables and PivotCharts
Module Seven – Macros
Module Eight – Solving Formula Errors
Module Nine – Using What If Analysis
Module Ten – Managing Your Data
Module Eleven – Grouping and Outlining Data
Module Twelve – Wrapping Up
Activities-Microsoft Excel 2010 Advanced Level
Module One – Getting Started
Module Two – Adding Pictures
Module Three – Working with Text Boxes
Module Four – Adding SmartArt
Module Five – Adding Tables
Module Six – Inserting Advanced Objects
Module Seven – Advanced Drawing Tasks
Module Eight – PowerPoint’s Research Tools
Module Nine – Creating Notes and Handouts
Module Ten – Using Slide Masters
Module Eleven – Advanced Presentation Tasks
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint 2010 Advanced Level
Module One – Getting Started
Module Two – Advanced Table Tasks
Module Three – Advanced Form Tasks
Module Four – Advanced Reporting Tasks
Module Five – Understanding Relationships
Module Six – Advanced Query Tasks
Module Seven – Working with SQL
Module Eight – Linking Data
Module Nine – Importing Data
Module Ten – Exporting Data
Module Eleven – Advanced Database Tools
Module Twelve – Wrapping Up
Activities – Microsoft Access 2010 Advanced Level
Module One – Getting Started
Module Two – Customizing Outlook
Module Three – Adding Word Elements to an E-mail
Module Four – Customizing Your Profile
Module Five – Advanced E-Mail Tasks
Module Six – Advanced Calendar Tasks
Module Seven – Doing More with Tasks
Module Eight – Using Notes
Module Nine – Viewing RSS Feeds
Module Ten – Managing Outlook Data, Part One
Module Eleven – Managing Outlook Data, Part Two
Module Twelve – Wrapping Up
Activities-Microsoft Outlook 2010 Advanced Level
Mock Exam – Microsoft Office 2010 for Advanced Learners
Final Exam – Microsoft Office 2010 for Advanced Learners
171103 Microsoft Office 2010 Word Advanced Level – Certified Video Training Form Letters
Data Sources for the Recipient List
Mailing Labels and Envelopes
Inserting Content from Other Applications
Changing the Document Background
Recording and Running Macros
Modifying and Deleting Macros
Creating Forms
Protecting Forms
Sharing and Securing Documents
Customizing the Ribbon
Customizing the Quick Access Toolbar
Customizing Keyboard Shortcuts
Master Documents
Tables of Contents and Figures
Indexes, Bibliographies, and Other References
Bookmarks and Cross-References
Web Frames
Working with XML
171224 Microsoft Office 2010 Word Beginners Level – Certified Video Training The Word Window
New Documents
Word Help
Document Navigation
Selection Techniques
Working with Text
The Undo and Redo Commands
Cutting, Copying and Pasting Text
Character Formatting
Tab Settings
Paragraph Formatting
Paragraph Spacing and Indents
Automatic Formatting
Creating Tables
Working with Table Content
Changing Table Structure
Headers and Footers
Margins
Page Breaks
Checking Spelling and Grammar
Using AutoCorrect
Finding and Replacing Text
Printing Documents
PDF and XPS Documents
Adding Graphics and Clip Art
Working with Graphics
172324 Microsoft Office 2013 Access Intermediate – Certified Video Training Relational Database Design
Create a Table
Create Table Relationships
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
Data Normalization
Create a Junction Table
Improve Table Structure
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Organize Report Information
Format Reports
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
176279 Microsoft Office 2013 Access Professional – Accredited Video Training Add Controls to Forms
Create Subforms
Organize Information with Tabs Pages
Enhance Navigation of Forms
Apply Conditional Formatting
Field and Record Validation
Form Validation
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Splitting a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Analyze the Performance of a Database
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
177896 Microsoft Office 2013 Excel Beginners – Online Video Training Course Identify the Elements of the Excel Interface
Create a Basic Worksheet
Use the Help System
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas
Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Search for and Replace Data
Spell Check a Worksheet
Modify Fonts
Add Borders and Color to Cells
Apply Number Formats
Align Cell Contents
Apply Cell Styles
Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
E2013B Course 06 Topic A Format Worksheet Tabs
Manage Worksheets
Manage the View of Worksheets and Workbooks
Customize General and Language Options
Customize Formula Options
Customize Proofing and Save Options
Customize the Ribbon and Quick Access Toolbar
Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced and Trust Center Options
171495 Microsoft Office 2013 Excel Intermediate Level – Accredited Video Training Apply Range Names
Use Specialized Functions
Leverage Questions and Testing to Write Formulas
Use Logical and Lookup Functions to Find Answers to Questions
Create and Modify Tables
Sort and Filter Data
Use Summary and Database Functions to Calculate Data
Create Charts
Modify and Format Charts
Create a Trendline
Create Advanced Charts
Create a PivotTable
Filter Data by Using Slicers
Analyze Data by Using PivotCharts
Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Incorporate SmartArt
Customizing Workbooks
Manage Themes
Create and Use Templates 12
Protect Files
172603 Microsoft Office 2013 Lync Beginners Sign In and Get Oriented
Establish Lync Options
Add Contacts and Groups
Use Presence
Send and Receive IM’s
Use Conversation History
Use the Contact Card
Make an Audio Call
Make a Video Call
Schedule a Meeting
Join a Meeting
Conduct a Meeting
175313 Microsoft Office 2013 PowerPoint Advanced – Online Video Training Course Customize the User Interface
Set PowerPoint 2013 Options
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Create SmartArt
Modify SmartArt
Add Audio to a Presentation
Add Video to a Presentation
Customize Animations and Transitions
Review a Presentation
Store and Share Presentations on the Web
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks and Action Buttons
Record a Presentation
Secure a Presentation
Broadcast a Slide Show
Create a Video or a CD
172001 Microsoft Office 2013 Word Beginners Level – Accredited Video Training Diploma Identify the Components of the Word Interface
Create a Word Document
Help
Find and Select Text
Modify Text
Find and Replace Text
Apply Character Formatting
Align Text Using Tabs
Display Text as List Items
Control Paragraph Layout
Apply Borders and Shading
Apply Styles
Manage Formatting
Insert a Table
Modify a Table
Format a Table
Convert Text to a Table
Sort a List
Renumber a List
Customize a List
Insert Symbols and Special Characters
Add Images to a Document
Apply a Page Border and Color
Add a Watermark
Add Headers and Footers
Control Page Layout
Check Spelling and Grammar
Other Proofing Tools
Customize the Word Interface
Additional Save Options
177606 Microsoft Office 2013 Word Intermediate – Video Training Diploma Sort Table Data
Control Cell Layout
Perform Calculations in a Table
Create a Chart
Create and Modify Text Styles
Create Custom List or Table Styles
Apply Document Themes
Resize an Image
Adjust Image Appearance
Integrate Pictures and Text
Insert and Format Screenshots
Insert Video
Create Text Boxes and Pull Quotes
Draw Shapes
Add WordArt and Other Text Effects
Create Complex Illustrations with SmartArt
Insert Building Blocks
Create and Modify Building Blocks
Insert Fields Using Quick Parts
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow
Create a Document Using a Template
Create a Template
The Mail Merge Features
Merge Envelopes and Labels
Create a Data Source Using Word
Automate Tasks Using Macros
Create a Macro
187852 Microsoft Office 2016 Beginners Diploma Identify the Components of the Word Interface
Create a Word Document
Help
Navigate and Select Text
Modify Text
Find and Replace Text
Apply Character Formatting
Align Text Using Tabs
Display Text as List Items
Control Paragraph Layout
Apply Borders and Shading
Apply Styles
Manage Formatting
Insert a Table
Modify a Table
Format a Table
Convert Text to a Table
Sort a List
Renumber a List
Customize a List
Insert Symbols and Special Characters
Add Images to a Document
Apply a Page Border and Color
Add a Watermark
Add Headers and Footers
Control Page Layout
Check Spelling and Grammar
Other Proofing Tools
Check Accessibility
Customize the Word Interface
Additional Save Options
Manage Additional File Types
Activities – Microsoft Word 2016 for Beginners
Identify the Elements of the Excel Interface
Activity – Identify the Elements of the Excel Interface
Create a Basic Worksheet
Activity – Create a Basic Worksheet
Use the Help System
Activity – Use the Help System
Create Formulas in a Worksheet
Activity – Create Formulas in a Worksheet
Insert Functions in a Worksheet
Activity – Insert Functions in a Worksheet
Reuse Formulas
Activity – Reuse Formulas
Manipulate Data
Activity – Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
Search For and Replace Data
Activity – Search For and Replace Data
Spell Check a Worksheet
Activity – Spell Check a Worksheet
Modify Fonts
Activity – Modify Fonts
Add Borders and Colors to Cells
Activity – Add Borders and Colors to Cells
Apply Number Formats
Activity – Apply Number Formats
Align Cell Contents
Activity – Align Cell Contents
Apply Cell Styles
Activity – Apply Cell Styles
Define the Basic Page Layout for a Workbook
Activity – Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Activity – Refine the Page Layout and Apply Print Options
Format Worksheet Tabs
Activity – Format Worksheet Tabs
Manage Worksheets
Activity – Manage Worksheets
Manage the View of Worksheets and Workbooks
Activity – Manage the View of Worksheets and Workbooks
Customize General and Language Options
Activity – Customize General and Language Options
Customize Formula Options
Activity – Customize Formula Options
Customize Proofing and Save Options
Activity – Customize Proofing and Save Options
Customize the Ribbon and Quick Access Toolbar
Activity – Customize the Ribbon and Quick Access Toolbar
Customize the Functionality of Excel by Enabling Add-Ins
Activity – Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced and Trust Center Options
Activity – Customize Advanced and Trust Center Options
Activities – Microsoft Excel 2016 for Beginners
Navigate the PowerPoint Environment
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
Create and Save a PowerPoint Presentation
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
Use PowerPoint Help
ACTIVITY – USING POWERPOINT HELP
Select a Presentation Type
ACTIVITY – SELECTING A PRESENTATION TYPE
Build a Presentation
ACTIVITY – BUILDING A PRESENTATION
Lay Out a Presentation
ACTIVITY – LAYING OUT A PRESENTATION
Edit Text
ACTIVITY – EDITING TEXT
View and Navigate a Presentation
ACTIVITY – VIEWING A PRESENTATION
Format Characters
ACTIVITY – FORMATTING CHARACTERS
Format Paragraphs
ACTIVITY – FORMATTING PARAGRAPHS
Format Text Boxes
ACTIVITY – FORMATTING TEXT BOXES
Insert Images
ACTIVITY – INSERTING IMAGES
Insert Shapes
ACTIVITY – INSERTING SHAPES
Insert WordArt
ACTIVITY – INSERT WORDART
Edit Objects
ACTIVITY – EDITING OBJECTS
Format Objects
ACTIVITY – FORMATTING OBJECTS
Group Objects
ACTIVITY – GROUPING OBJECTS
Arrange Objects
ACTIVITY – ARRANGING OBJECTS
Animate Objects
ACTIVITY – ANIMATING OBJECTS
Create a Table
ACTIVITY – CREATING A TABLE
Format a Table
ACTIVITY – FORMATTING A TABLE
Insert a Table from Other Microsoft Office Applications
ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL
Create a Chart
ACTIVITY – CREATING A CHART
Format a Chart
ACTIVITY – FORMATTING A CHART
Manipulate a Chart
ACTIVITY – MANIPULATING A CHART
Insert a Chart from Microsoft Excel
ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL
Review Your Presentation
ACTIVITY – REVIEWING YOUR PRESENTATION
Apply Transitions
ACTIVITY – APPLYING TRANSITIONS
Print Your Presentation
ACTIVITY – PRINTING YOUR PRESENTATION
Deliver Your Presentation
ACTIVITY – DELIVERING YOUR PRESENTATION
Activities – Microsoft PowerPoint 2016 Beginners Level
Navigate the Outlook Interface
ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE
Perform Basic E-mail Functions
ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS
Use Outlook Help
ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016
Create an E-mail Message
ACTIVITY – CREATING AN E-MAIL MESSAGE
Check Spelling and Grammar
ACTIVITY – CHECK SPELLING AND GRAMMAR
Format Message Content
ACTIVITY – FORMAT MESSAGE CONTENT
Attach Files and Items
ACTIVITY – ATTACHING A FILE TO A MESSAGE
Enhance an E-mail Message
ACTIVITY – ENHANCING AN E-MAIL MESSAGE
Manage Automatic Message Content
ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT
Customize Reading Options
ACTIVITY – CUSTOMIZING READING OPTIONS
Work with Attachments
ACTIVITY – WORKING WITH ATTACHMENTS
Manage Your Message Responses
ACTIVITY – MANAGING YOUR MESSAGE RESPONSES
Manage Messages Using Tags, Flags, and Other Commands
ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS
Organize Messages Using Folders
ACTIVITY – ORGANIZING MESSAGES USING FOLDERS
View the Calendar
ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW
Manage Appointments
ACTIVITY – MANAGING APPOINTMENTS
Manage Meetings
ACTIVITY – CREATING AND MANAGING MEETINGS
Print Your Calendar
ACTIVITY – PRINTING YOUR CALENDAR
Create and Update Contacts
ACTIVITY – CREATING AND UPDATING CONTACTS
View and Organize Contacts
ACTIVITY – VIEW AND ORGANIZE CONTACTS
Create Tasks
ACTIVITY – CREATING TASKS
Manage Tasks
ACTIVITY – MANAGING TASKS
Manage Notes
ACTIVITY – CREATING AND MANAGING NOTES
Customize the Outlook Interface
ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE
Create and Manage Quick Steps
ACTIVITY – CREATING AND MANAGING QUICK STEPS
Activities – Microsoft Outlook 2016 for Beginners
Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access
Modify Table Data
Working With Records
Sort and Filter Records
Create Lookups
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Create Parameter Queries
Create Basic Queries
Create Find Duplicate and Find Unmatched Queries
Summarize Data
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
The Access Options Dialog Box
Create a Table
Modify a Table and Fields
Create Table Relationships
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries
Data Normalization
Create a Junction Table
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Organize Report Information
Format Reports
Include Charts in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Create a Mailing Label Report
Publish a Report as PDF
Activities – Exercise Files for Microsoft Access 2016 Beginners Level
187844 Microsoft Office 2016 Complete Diploma Level 3 Modify User Information
Share a Document
Work with Comments
Compare Document Changes
Review a Document
Merge Document Changes
Coauthor Documents
Add Captions
Add Cross-References
Add Bookmarks
Add Hyperlinks
Insert Footnotes and Endnotes
Add Citations
Insert a Bibliography
Insert Blank and Cover Pages
Insert an Index
Insert a Table of Contents
Insert an Ancillary Table
Manage Outlines
Create a Master Document
Suppress Information
Set Editing Restrictions
Add a Digital Signature to a Document
Restrict Document Access
Create Forms
Manipulate Forms
Form Data Conversion
Create a New Document Version
Compare Document Versions
Merge Document Versions
Activities – Microsoft Word 2016 Advanced
Update Workbook Properties3
Activity-Update Workbook Properties
Create and Edit a Macro3
Activity-Create and Edit a Macro
Apply Conditional Formatting
Activity-Apply Conditional Formatting
Add Data Validation Criteria
Activity – Add Data Validation Criteriaty
Trace Cells
Activity-Trace Cells
Troubleshoot Invalid Data and Formula Errors
Activity-Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Activity-Watch and Evaluate Formulas
Create a Data List Outline
Activity-Create a Data List Outline
Create Sparklines
Activity – Create Sparklines
Create Scenarios
Activity-Create Scenarios
Perform a What-If Analysis
Activity-Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Activity-Perform a Statistical Analysis with the Analysis ToolPak
Create Interactive Data with Power View
Activity-Create Interactive Data with Power View
Consolidate Data
Activity-Consolidate Data
Link Cells in Different Workbooks
Activity-Link Cells in Different Workbooks
Merge Workbooks
Activity-Merge Workbooks
Export Excel Data
Activity-Export Excel Data
Import a Delimited Text File
Activity- Import a Delimited Text File
Integrate Excel Data with the Web
Activity-Integrate Excel Data with the Web
Create a Web Query
Activity-Create a Web Query
Import and Export XML Data
Activity-Import and Export XML Data
Activities and Exercise Files – Microsoft Excel 2016 Advanced
Customize the User Interface
Set PowerPoint 2016 Options
Create and Manage Sections
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Create SmartArt
Modify SmartArt
Add Audio to a Presentation
Add Video to a Presentation
Customize Animations and Transitions
Add Comments to a Presentation
Review a Presentation
Store and Share Presentations on the Web
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks and Action Buttons
Record a Presentation
Secure a Presentation
Present a Slide Show Online
Create a Video or a CD
Activities – Microsoft PowerPoint 2016 Advanced Level
Insert Advanced Characters and Objects
Modify Message Settings, Properties, and Options
Use Automatic Replies
Sort Messages
Filter Messages
Organize Messages
Search Messages
Manage Junk Mail
Manage Your Mailbox
Manage Advanced Calendar Options
Manage Additional Calendars
Manage Meeting Responses
Assign and Manage Tasks
Edit an Electronic Business Card
Manage Advanced Contact Options
Forward Contacts
Export Contacts
Delegate Access to Mail Folders
Share Your Calendar
Share Your Contacts
Back Up Outlook Items
Change Data File Settings
Configure E-mail Message Security Settings
Activities – Microsoft Outlook 2016 Advanced Level
Add Controls to Forms
Set Form Controls
Create Subforms
Organize Information with Tab Pages
Enhance Navigation with Forms
Format a Form
Apply Conditional Formatting
Field Validation
Form and Record Validation
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Split a Database for Multiple User Access
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
Activities – Exercise Files for Microsoft Access 2016 Professional Diploma
Mock Exam – Microsoft Office 2016 Complete Diploma Level 3
Final Exam – Microsoft Office 2016 Complete Diploma Level 3
173169 Microsoft Office 2016 Excel Advanced – Certified Video Training Use Links and External References
Use 3-D References
Consolidate Data
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Collaborate on a Workbook
Protect Worksheets and Workbooks
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Create Sparklines
MapData
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends
175698 Microsoft Office 2016 Excel Beginners – Online Video Training 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 Formats
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
Mock Exam – Microsoft Office 2016 Excel Beginners – Online Video Training
Final Exam – Microsoft Office 2016 Excel Beginners – Online Video Training
173017 Microsoft Office 2016 Excel Intermediate – Video Training Course Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Create Charts
Modify and Format Charts
Use Advanced Chart Features
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
230535 Microsoft Office 2016 Video Training Course: Beginners to Advanced Accredited Diploma 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
Check Accessibility
Save a Document to Other Formats
Workbooks – Microsoft Office 2016 Word Beginner
Sort Table Data
Control Cell Layout
Perform Calculations in a Table
Create a Chart
Add an Excel Table to a Word Document
Create and Modify Text Styles
Create Custom List or Table Styles
Apply Document Themes
Insert Building Blocks
Create and Modify Building Blocks
Insert Fields Using Quick Parts
Create a Document Using a Template
Create a Template
Manage Templates with the Template Organizer
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow
Insert Blank and Cover Pages
Insert an Index
Insert a Table of Contents
Insert an Ancillary Table
Manage Outlines
Create a Master Document
The Mail Merge Feature
Merge Envelopes and Labels
Workbooks – Microsoft Office 2016 Word Intermediate
Integrate Pictures and Text
Adjust Image Appearance
Insert Other Media Elements
Create Text Boxes and Pull Quotes
Add WordArt and Other Text Effects
Draw Shapes
Create Complex Illustrations with SmartArt
Prepare a Document for Collaboration
Mark Up a Document
Review Markups
Merge Changes from Other Documents
Add Captions
Add Cross References
Add Bookmarks
Add Hyperlinks
Insert Footnotes and Endnotes
Add Citations and a Bibliography
Suppress Information
Set Formatting and Editing Restrictions
Restrict Document Access
Add a Digital Signature to a Document
Create Forms
Modify Forms
Automate Tasks by Using Macros
Create a Macro
Workbooks – Microsoft Office 2016 Word Advanced
174119 Microsoft Office 2016 Word Advanced Level – Accredited Video Training Integrate Pictures and Text
Adjust Image Appearance
Insert Other Media Elements
Create Text Boxes and Pull Quotes
Add WordArt and Other Text Effects
Draw Shapes
Create Complex Illustrations with SmartArt
Prepare a Document for Collaboration
Mark Up a Document
Review Markups
Merge Changes from Other Documents
Add Captions
Add Cross References
Add Bookmarks
Add Hyperlinks
Insert Footnotes and Endnotes
Add Citations and a Bibliography
Suppress Information
Set Formatting and Editing Restrictions
Restrict Document Access
Add a Digital Signature to a Document
Create Forms
Modify Forms
Automate Tasks by Using Macros
Create a Macro
197800 Microsoft Office 2016 Word Beginners – Advanced Accredited Video Training Course 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
Check Accessibility
Save a Document to Other Formats
Sort Table Data
Control Cell Layout
Perform Calculations in a Table
Create a Chart
Add an Excel Table to a Word Document
Create and Modify Text Styles
Create Custom List or Table Styles
Apply Document Themes
Insert Building Blocks
Create and Modify Building Blocks
Insert Fields Using Quick Parts
Create a Document Using a Template
Create a Template
Manage Templates with the Template Organizer
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow
Insert Blank and Cover Pages
Insert an Index
Insert a Table of Contents
Insert an Ancillary Table
Manage Outlines
Create a Master Document
The Mail Merge Feature
Merge Envelopes and Labels
Integrate Pictures and Text
Adjust Image Appearance
Insert Other Media Elements
Create Text Boxes and Pull Quotes
Add WordArt and Other Text Effects
Draw Shapes
Create Complex Illustrations with SmartArt
Prepare a Document for Collaboration
Mark Up a Document
Review Markups
Merge Changes from Other Documents
Add Captions
Add Cross References
Add Bookmarks
Add Hyperlinks
Insert Footnotes and Endnotes
Add Citations and a Bibliography
Suppress Information
Set Formatting and Editing Restrictions
Restrict Document Access
Add a Digital Signature to a Document
Create Forms
Modify Forms
Automate Tasks by Using Macros
Create a Macro
173967 Microsoft Office 2016 Word Beginners – Video Training Diploma 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
Check Accessibility
Save a Document to Other Formats
171998 Microsoft Office 2016 Word Intermediate – Video Training Diploma Sort Table Data
Control Cell Layout
Perform Calculations in a Table
Create a Chart
Add an Excel Table to a Word Document
Create and Modify Text Styles
Create Custom List or Table Styles
Apply Document Themes
Insert Building Blocks
Create and Modify Building Blocks
Insert Fields Using Quick Parts
Create a Document Using a Template
Create a Template
Manage Templates with the Template Organizer
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow
Insert Blank and Cover Pages
Insert an Index
Insert a Table of Contents
Insert an Ancillary Table
Manage Outlines
Create a Master Document
The Mail Merge Feature
Merge Envelopes and Labels
174368 Microsoft Office 365 – SharePoint Basics SharePoint Overview
Creating Your First Site
Adding Content to the Team Site Searching for Content
172238 Microsoft Office 365 Administration – Accredited Video Training Getting Your Domain Ready
Getting Domain Ready
Licenses and Subsc
Bing places for Busines
Service Setting
Reports
Checking Health
Checking and Log
Managing Users Office 365 Administration
Creating users in office 365
Creating Distribution Groups
Importing 365 Users
Resetting User Passwords
user preperties
Insalling MS office
Maintaining Office 365 Users- Office 365 Administration
Creating user Resourse Mailboxes
Creating Shared User Mailboxes
Exchange Recipients
Checking Service Settings
Managing Skype for Business Users
174293 Microsoft Office 365 SharePoint Certificate Course Office 365 Overview
Email, Contacts & Calendar
Using the Office 365 Office Apps
174716 Microsoft Office 365 Web Apps Basics Introduction
Getting Started
Collaborating with Shared Files
Using the Outlook Web Apps
Communicating with Skype for Business
Using Skype for Business Meetings
Interacting with Mobile Devices
107976 Microsoft Office Advanced Level Module One – Getting Started
Module Two – Working with the Word Window
Module Three – Advanced Editing and Formatting Tasks
Module Four – Working with Illustrations
Module Five – Formatting Pictures
Module Six – Adding SmartArt
Module Seven – Adding Tables
Module Eight – Inserting Special Objects
Module Nine – Working with Document References
Module Ten – Reviewing Your Document
Module Eleven – Using Comments and Tracking
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – SmartArt and Objects
Module Three – Auditing
Module Four – Creating Charts
Module Five – Working with Charts
Module Six – Creating Pivot Tables and Pivot Charts
Module Seven – Macros
Module Eight – Solving Formula Errors
Module Nine – Using What If Analysis
Module Ten – Managing Your Data
Module Eleven – Grouping and Outlining Data
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Working with Shapes
Module Three – Working with Text Boxes
Module Four – Adding SmartArt
Module Five – Advanced Drawing Tasks
Module Six – Adding Tables
Module Seven – Inserting Audio and Video
Module Eight – PowerPoint’s Research Tools
Module Nine – Preparing for Your Presentation
Module Ten – Using Slide Masters
Module Eleven – Advanced Presentation Tasks
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Using App Views
Module Three – Customizing Apps, Part One
Module Four – Customizing Apps, Part Two
Module Five – Working with More Record Tasks
Module Six – Using Advanced Field Tasks
Module Seven – Working in Table Design View
Module Eight – Working with the Expression Builder
Module Nine – Working with External Data
Module Ten – Creating Queries
Module Eleven – Creating Forms and Reports
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Working with Messages
Module Three – Customizing Your Profile
Module Four – Advanced Email Tasks
Module Five – Managing Junk Mail
Module Six – Advanced Calendar Tasks
Module Seven – Doing More With Tasks
Module Eight – Using Notes
Module Nine – Viewing RSS Feeds
Module Ten – Printing
Module Eleven – Managing Outlook Data
Module Twelve – Wrapping Up
Mock Exam- Microsoft Office Advanced Level
Final Exam- Microsoft Office Advanced Level
206863 Microsoft Office Bundle Complete Video Course 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 Formats
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
Check Accessibility
Save a Document to Other Formats
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
Format 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 Access
Create a Simple Access Database
Cover Your Assets And Your Customers
Modify Table Data
Sort and Filter Records
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query
Basic Knowledge on Billings
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
Navigate the Outlook Interface
Perform Basic E-mail Functions
Use Outlook Help
Create an E-mail Message
Check Spelling and Grammar
Format Message Content
Attach Files and Items
Enhance an E-mail Message
Manage Automatic Message Content
Customize Reading Options
Work with Attachments
Manage Your Message Responses
Manage Messages Using Tags, Flags, and Other Commands
Organize Messages Using Folders
View the Calendar
Manage Appointments
Manage Meetings
Print Your Calendar
Create and Update Contacts
View and Organize Contacts
Create Tasks
Manage Tasks
Manage Notes
Customize the Outlook Interface
Create and Manage Quick Steps
105526 Microsoft Office Complete Diploma Module One – Getting Started
Module Two – Opening
Module Three – Working with the Interface
Module Four – Your First Document
Module Five – Basic Editing Tasks
Module Six – Basic Formatting Tasks
Module Seven – Formatting Paragraphs
Module Eight – Advanced Formatting Tasks
Module Nine – Working with Styles
Module Ten – Formatting the Page
Module Eleven – Sharing Your Document
Module Twelve – Wrapping Up
Activities- Microsoft Word for Beginners
Module One – Getting Started
Module Two – Opening Excel
Module Three – Working with the Interface
Module Four – Your First Worksheet
Module Five – Viewing Excel Data
Module Six – Building Formulas
Module Seven – Using Excel Functions
Module Eight – Using Quick Analysis
Module Nine – Formatting Your Data
Module Ten – Using Styles, Themes, and Effects
Module Eleven – Printing and Sharing Your Workbook
Module Twelve – Wrapping Up
Activities – Microsoft Excel for Beginner Learners
Module One – Getting Started
Module Two – Opening PowerPoint
Module Three – Working with the Interface
Module Four – Your First Presentation
Module Five – Working with Text
Module Six – Formatting Text and Paragraphs
Module Seven – Adding Pictures
Module Eight – Advanced Formatting Tasks
Module Nine – Working with Transitions and Animations
Module Ten – Setting Up Your Slide Show
Module Eleven – Showtime!
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Opening and Closing Access
Module Three – An Introduction to Databases
Module Four – Sharing Data Using Apps
Module Five – Working in Your App
Module Six – An Introduction to Desktop Databases
Module Seven – Performing Basic Table Tasks
Module Eight – Working with Fields
Module Nine – Working with Table Relationships
Module Ten – An Introduction to Queries, Forms, and Reports
Module Eleven – Protecting Your Data
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Opening and Closing Outlook
Module Three – Understanding the Interface
Module Four – Working with the Message List and the Reading Pane
Module Five – Using Message List Commands
Module Six – Creating a New Email
Module Seven – Managing Email
Module Eight – Searching for Items
Module Nine – An Introduction to the Calendar
Module Ten – An Introduction to Tasks
Module Eleven – An Introduction to Contact
Module Twelve – Wrapping Up
Mock Exam – Microsoft Office Complete Diploma
Final Exam – Microsoft Office Complete Diploma
271768 Microsoft Office Essential Training in Arabic تحميل وتحديث برامج الاوفيس 2019 – ويندوز 10 فقط
تحميل وتحديث برامج الاوفيس 2016 – لجميع الويندوز
شرح اهم اساسيات برنامج الورد وشرح واجهة البرنامج
شرح هوامش الورقه والقوائم في برنامج الورد
شرح كيفية تنسيق الكتابة والهوامش والصور – تاسك عملي
شرح كيفية تصميم وعمل الجداول علي برنامج الورد وتنسيقهم بشكل احترافي – تطبيق عملي
شرح كيفية اعدادات الطباعة في الورد وكيفية عمل اللوان مختلفة لعدة صفحات
مقدمة شرح برنامج الاكسل
شرح واجهة وادوات برنامج الاكسل
شرح التنسيق والمعادلات البسيطة في الاكسل
IF + IFs function in Excel | شرح المعادلات الشرطية في الاكسل
شرح المعادلات المركبة والمساعدة ومعادلات العد في الاكسل
معادلات الجمع بشرط والقوائم المنسدلة في الاكسل
معادلات العد والمتوسط بشرط او باكثر من شرط والجمع الفرعي في الاكسل
برنامج زوم للمحاضرات الاونلاين
مقدمة شرح برنامج الباوربوينت
شرح الاساسيات وادوات برنامج الباوربوينت
التصميم والحركات الانتقالية في الباوربوينت
المؤثرات الانتقالية وترتيب الدخول في البرزنتيشن
كيفية اضافة مقاطع الفيديو والصوت وتسجيل الشاشة في الباوربوينت – والرسم البياني
اعداد عرض تقديمي كامل بالمؤثرات لتطبيق عملي علي الكورس
تحويل وتصدير العرض التقديمي الي فيديو او ملف للعرض فقط او PDF
105264 Microsoft One Note Advanced Training Diploma Module One – Getting Started
Module Two – Working with Notebooks
Module Three – Using Additional Notebooks
Module Four – Formatting and Editing Your Notes
Module Five – Working with Audio and Video
Module Six – Working with Tables
Module Seven – Working with Equations and Excel Spreadsheets
Module Eight – Researching a Topic
Module Nine – Advanced Review Tasks
Module Ten – Collaborating
Module Eleven – Advanced Sharing Options
Module Twelve – Wrapping Up
Activities – Microsoft One Note Advanced Training Diploma
Mock Exam – Microsoft One Note Advanced Training Diploma
Final Exam – Microsoft One Note Advanced Training Diploma
169562 Microsoft OneNote 2016 Accredited Training Navigate the OneNote 2016 Environment
Create a Notebook
Use Predesigned Templates for OneNote Notebooks
Customize the User Interface
Modify Formatting in a Notebook
Add Images to a Notebook
Add Tables to a Notebook
Add Audio and Video to a Notebook
Add Quick Notes and Links
Use Tags, Symbols, Drawing Tools, and Pen Options
Save and Export Content and Use Alternate File Types
Manage Notebook Recycle Bins and Backups
Work with Excel Spreadsheets and Visio Diagrams
Work with Embedded Files
Send a Notebook and Use Outlook Integration
Share and Collaborate on Notebooks
Finalize a Notebook Using Proofing and Print Settings
Configure Notebook Properties and Security
Search Notebooks
Activities – Microsoft OneNote 2016 Accredited Training
169865 Microsoft Outlook 2016 Advanced Level Insert Advanced Characters and Objects
Modify Message Settings, Properties, and Options
Use Automatic Replies
Sort Messages
Filter Messages
Organize Messages
Search Messages
Manage Junk Mail
Manage Your Mailbox
Manage Advanced Calendar Options
Manage Additional Calendars
Manage Meeting Responses
Assign and Manage Tasks
Edit an Electronic Business Card
Manage Advanced Contact Options
Forward Contacts
Export Contacts
Delegate Access to Mail Folders
Share Your Calendar
Share Your Contacts
Back Up Outlook Items
Change Data File Settings
Configure E-mail Message Security Settings
Activities – Microsoft Outlook 2016 Advanced Level
Mock Exam – Microsoft Outlook 2016 Advanced Level
Final Exam – Microsoft Outlook 2016 Advanced Level
169591 Microsoft Outlook 2016 Beginners Level Navigate the Outlook Interface
ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE
Perform Basic E-mail Functions
ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS
Use Outlook Help
ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016
Create an E-mail Message
ACTIVITY – CREATING AN E-MAIL MESSAGE
Check Spelling and Grammar
ACTIVITY – CHECK SPELLING AND GRAMMAR
Format Message Content
ACTIVITY – FORMAT MESSAGE CONTENT
Attach Files and Items
ACTIVITY – ATTACHING A FILE TO A MESSAGE
Enhance an E-mail Message
ACTIVITY – ENHANCING AN E-MAIL MESSAGE
Manage Automatic Message Content
ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT
Customize Reading Options
ACTIVITY – CUSTOMIZING READING OPTIONS
Work with Attachments
ACTIVITY – WORKING WITH ATTACHMENTS
Manage Your Message Responses
ACTIVITY – MANAGING YOUR MESSAGE RESPONSES
Manage Messages Using Tags, Flags, and Other Commands
ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS
Organize Messages Using Folders
ACTIVITY – ORGANIZING MESSAGES USING FOLDERS
View the Calendar
ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW
Manage Appointments
ACTIVITY – MANAGING APPOINTMENTS
Manage Meetings
ACTIVITY – CREATING AND MANAGING MEETINGS
Print Your Calendar
ACTIVITY – PRINTING YOUR CALENDAR
Create and Update Contacts
ACTIVITY – CREATING AND UPDATING CONTACTS
View and Organize Contacts
ACTIVITY – VIEW AND ORGANIZE CONTACTS
Create Tasks
ACTIVITY – CREATING TASKS
Manage Tasks
ACTIVITY – MANAGING TASKS
Manage Notes
ACTIVITY – CREATING AND MANAGING NOTES
Customize the Outlook Interface
ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE
Create and Manage Quick Steps
ACTIVITY – CREATING AND MANAGING QUICK STEPS
Activities – Microsoft Outlook 2016 for Beginners
334266 Microsoft Power BI – Master Power BI in 90 Minutes! Overview of Power BI Course
Power BI Intro
Power BI High Level Flow
Install and Sign Up
Power Query Intro
Power Pivot Intro
Power View Intro
Big Picture
Get Data
How to Get More Data
Modelling Data
Adding Relationships Manually
Visualization
Visualization Customization
More Visualizations
Visualization Format and Analytics
Ask a Question
Real World Example
Get Data
Modelling Data
Visualization with multiple charts
Publishing
Power BI Website
FINAL
106065 Microsoft PowerPoint 2010 Complete Diploma Module One – Getting Started
Module Two – Opening and Closing PowerPoint
Module Three – Working with Presentations
Module Four – Your First Presentation
Module Five – Working with Text
Module Six – Formatting Text
Module Seven – Formatting Paragraphs
Module Eight – Advanced Formatting Tasks
Module Nine – Customizing Slide Elements
Module Ten – Setting Up Your Slide Show
Module Eleven – Showtime
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint 2010 for Beginners
Module One – Getting Started
Module Two – Working with the PowerPoint Environment
Module Three – Working with Presentations
Module Four – Formatting Presentations
Module Five – Formatting Text Boxes
Module Six – Creating a Photo Album
Module Seven – Working with Graphical Elements
Module Eight – Working with Audio and Video Content
Module Nine – Working with Transitions and Animations
Module Ten – Collaborating on Presentations
Module Eleven – Delivering Presentations
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint 2010 Intermediate Level
Module One – Getting Started
Module Two – Adding Pictures
Module Three – Working with Text Boxes
Module Four – Adding SmartArt
Module Five – Adding Tables
Module Six – Inserting Advanced Objects
Module Seven – Advanced Drawing Tasks
Module Eight – PowerPoint’s Research Tools
Module Nine – Creating Notes and Handouts
Module Ten – Using Slide Masters
Module Eleven – Advanced Presentation Tasks
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint 2010 Advanced Level
Mock Exam – Microsoft PowerPoint 2010 Complete Diploma
Final Exam – Microsoft PowerPoint 2010 Complete Diploma
169912 Microsoft PowerPoint 2016 Advanced Level Customize the User Interface
Set PowerPoint 2016 Options
Create and Manage Sections
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Create SmartArt
Modify SmartArt
Add Audio to a Presentation
Add Video to a Presentation
Customize Animations and Transitions
Add Comments to a Presentation
Review a Presentation
Store and Share Presentations on the Web
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks and Action Buttons
Record a Presentation
Secure a Presentation
Present a Slide Show Online
Create a Video or a CD
Activities – Microsoft PowerPoint 2016 Advanced Level
169660 Microsoft PowerPoint 2016 Beginners Level Navigate the PowerPoint Environment
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
Create and Save a PowerPoint Presentation
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
Use PowerPoint Help
ACTIVITY – USING POWERPOINT HELP
Select a Presentation Type
ACTIVITY – SELECTING A PRESENTATION TYPE
Build a Presentation
ACTIVITY – BUILDING A PRESENTATION
Lay Out a Presentation
ACTIVITY – LAYING OUT A PRESENTATION
Edit Text
ACTIVITY – EDITING TEXT
View and Navigate a Presentation
ACTIVITY – VIEWING A PRESENTATION
Format Characters
ACTIVITY – FORMATTING CHARACTERS
Format Paragraphs
ACTIVITY – FORMATTING PARAGRAPHS
Format Text Boxes
ACTIVITY – FORMATTING TEXT BOXES
Insert Images
ACTIVITY – INSERTING IMAGES
Insert Shapes
ACTIVITY – INSERTING SHAPES
Insert WordArt
ACTIVITY – INSERT WORDART
Edit Objects
ACTIVITY – EDITING OBJECTS
Format Objects
ACTIVITY – FORMATTING OBJECTS
Group Objects
ACTIVITY – GROUPING OBJECTS
Arrange Objects
ACTIVITY – ARRANGING OBJECTS
Animate Objects
ACTIVITY – ANIMATING OBJECTS
Create a Table
ACTIVITY – CREATING A TABLE
Format a Table
ACTIVITY – FORMATTING A TABLE
Insert a Table from Other Microsoft Office Applications
ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL
Create a Chart
ACTIVITY – CREATING A CHART
Format a Chart
ACTIVITY – FORMATTING A CHART
Manipulate a Chart
ACTIVITY – MANIPULATING A CHART
Insert a Chart from Microsoft Excel
ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL
Review Your Presentation
ACTIVITY – REVIEWING YOUR PRESENTATION
Apply Transitions
ACTIVITY – APPLYING TRANSITIONS
Print Your Presentation
ACTIVITY – PRINTING YOUR PRESENTATION
Deliver Your Presentation
ACTIVITY – DELIVERING YOUR PRESENTATION
Activities – Microsoft PowerPoint 2016 Beginners Level
183792 Microsoft PowerPoint 2016 Complete Course – Beginner to Advanced Navigate the PowerPoint Environment
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
Create and Save a PowerPoint Presentation
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
Use PowerPoint Help
ACTIVITY – USING POWERPOINT HELP
Select a Presentation Type
ACTIVITY – SELECTING A PRESENTATION TYPE
Build a Presentation
ACTIVITY – BUILDING A PRESENTATION
Lay Out a Presentation
ACTIVITY – LAYING OUT A PRESENTATION
Edit Text
ACTIVITY – EDITING TEXT
View and Navigate a Presentation
ACTIVITY – VIEWING A PRESENTATION
Format Characters
ACTIVITY – FORMATTING CHARACTERS
Format Paragraphs
ACTIVITY – FORMATTING PARAGRAPHS
Format Text Boxes
ACTIVITY – FORMATTING TEXT BOXES
Insert Images
ACTIVITY – INSERTING IMAGES
Insert Shapes
ACTIVITY – INSERTING SHAPES
Insert WordArt
ACTIVITY – INSERT WORDART
Edit Objects
ACTIVITY – EDITING OBJECTS
Format Objects
ACTIVITY – FORMATTING OBJECTS
Group Objects
ACTIVITY – GROUPING OBJECTS
Arrange Objects
ACTIVITY – ARRANGING OBJECTS
Animate Objects
ACTIVITY – ANIMATING OBJECTS
Create a Table
ACTIVITY – CREATING A TABLE
Format a Table
ACTIVITY – FORMATTING A TABLE
Insert a Table from Other Microsoft Office Applications
ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL
Create a Chart
ACTIVITY – CREATING A CHART
Format a Chart
ACTIVITY – FORMATTING A CHART
Manipulate a Chart
ACTIVITY – MANIPULATING A CHART
Insert a Chart from Microsoft Excel
ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL
Review Your Presentation
ACTIVITY – REVIEWING YOUR PRESENTATION
Apply Transitions
ACTIVITY – APPLYING TRANSITIONS
Print Your Presentation
ACTIVITY – PRINTING YOUR PRESENTATION
Deliver Your Presentation
ACTIVITY – DELIVERING YOUR PRESENTATION
Customize the User Interface
Set PowerPoint 2016 Options
Create and Manage Sections
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Create SmartArt
Modify SmartArt
Add Audio to a Presentation
Add Video to a Presentation
Customize Animations and Transitions
Add Comments to a Presentation
Store and Share Presentations on the Web
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks and Action Buttons
Record a Presentation
Secure a Presentation
Present a Slide Show Online
Create a Video or a CD
201178 Microsoft Powerpoint Beginner to Advanced Course 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
Format 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
Customize the User Interface
Set PowerPoint 2016 Options
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Create SmartArt
Modify SmartArt
Write Math Equations
Add Audio to a Presentation
Add Video to a Presentation
Customize Animations and Transitions
Review a Presentation
Store and Share Presentations on the Web
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks and Action Buttons
Record a Presentation
Secure a Presentation
Broadcast a Slide Show
Create a Video or a CD
108915 Microsoft PowerPoint Complete Diploma – Beginners, Intermediate & Advanced Module One – Getting Started
Module Two – Opening PowerPoint
Module Three – Working with the Interface
Module Four – Your First Presentation
Module Five – Working with Text
Module Six – Formatting Text and Paragraphs
Module Seven – Adding Pictures
Module Eight – Advanced Formatting Tasks
Module Nine – Working with Transitions and Animations
Module Ten – Setting Up Your Slide Show
Module Eleven – Showtime!
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint for Beginners
Module One – Getting Started
Module Two – Working with the PowerPoint Environment
Module Three – Working with Sections and Presentation Organization
Module Four – Formatting Presentations
Module Five – Formatting Shapes and Text Boxes
Module Six – Creating a Photo Album
Module Seven – Working with Graphical Elements
Module Eight – Working with Audio and Video Content
Module Nine – Working with Transitions and Animations
Module Ten – Collaborating on Presentations
Module Eleven – Working with Presentation Info and Other Formats
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint Intermediate Level
Module One – Getting Started
Module Two – Working with Shapes
Module Three – Working with Text Boxes
Module Four – Adding SmartArt
Module Five – Advanced Drawing Tasks
Module Six – Adding Tables
Module Seven – Inserting Audio and Video
Module Eight – PowerPoint’s Research Tools
Module Nine – Preparing for Your Presentation
Module Ten – Using Slide Masters
Module Eleven – Advanced Presentation Tasks
Module Twelve – Wrapping Up
Activities-Microsoft PowerPoint Advanced Level
Mock Exam – Microsoft PowerPoint Complete Diploma – Beginners, Intermediate & Advanced
Final Exam – Microsoft PowerPoint Complete Diploma – Beginners, Intermediate & Advanced
102962 Microsoft PowerPoint for Beginner Level Module One – Getting Started
Module Two – Opening PowerPoint
Module Three – Working with the Interface
Module Four – Your First Presentation
Module Five – Working with Text
Module Six – Formatting Text and Paragraphs
Module Seven – Adding Pictures
Module Eight – Advanced Formatting Tasks
Module Nine – Working with Transitions and Animations
Module Ten – Setting Up Your Slide Show
Module Eleven – Showtime!
Module Twelve – Wrapping Up
Microsoft PowerPoint for Beginner Level – Activities
Mock Exam – Microsoft PowerPoint for Beginner Level
Final Exam – Microsoft PowerPoint for Beginner Level
102961 Microsoft PowerPoint for Intermediate Learners Module One – Getting Started
Module Two – Working with the PowerPoint Environment
Module Three – Working with Sections and Presentation Organization
Module Four – Formatting Presentations
Module Five – Formatting Shapes and Text Boxes
Module Six – Creating a Photo Album
Module Seven – Working with Graphical Elements
Module Eight – Working with Audio and Video Content
Module Nine – Working with Transitions and Animations
Module Ten – Collaborating on Presentations
Module Eleven – Working with Presentation Info and Other Formats
Module Twelve – Wrapping Up
Activities – Microsoft PowerPoint for Intermediate Learners
Mock Exam – Microsoft PowerPoint for Intermediate Learners
Final Exam – Microsoft PowerPoint for Intermediate Learners
230539 Microsoft Powerpoint Training: Beginner to Advanced 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
Format 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
Customize the User Interface
Set PowerPoint 2016 Options
Modify Slide Masters and Slide Layouts
Add Headers and Footers
Modify the Notes Master and the Handout Master
Create SmartArt
Modify SmartArt
Write Math Equations
Add Audio to a Presentation
Add Video to a Presentation
Customize Animations and Transitions
Review a Presentation
Store and Share Presentations on the Web
Annotate a Presentation
Set Up a Slide Show
Create a Custom Slide Show
Add Hyperlinks and Action Buttons
Record a Presentation
Secure a Presentation
Broadcast a Slide Show
Create a Video or a CD
176232 Microsoft Project 2010 Advanced Level – Video Training Course Working with Templates
Creating Projects From Other Projects
Setting Baselines
Updating an Active Project
Monitoring Progress
Analyzing the Plan
Delays and Conflicts
Team Planner View
Standard Reports
Visual Reports
Custom Views
Working with Tables
Gantt Chart Formatting
Custom Fields
Consolidating and Sharing Projects
Sharing Resources Among Projects
Collaboration
Hyperlinks
Exporting to Office Applications
171598 Microsoft Project 2010 Beginners – Certified Video Training Diploma Project Management Concepts
The Project Window
Project Files
The Help Window
Creating a Task List
Modifying a Task List
The Work Breakdown Structure
Task Links
Task Relationships
Task Options
The Base Calendar
Resources and Calendars
Project Costs
Working with Views
Working with Tables
Filters
Groups
Sorting Tasks and Resources
Finalizing Schedules
Handling Resource Conflicts
171772 Microsoft Project 2013 Advanced Level – Accredited Video Training Link Projects
Baseline a Project
Work with Custom Fields
Change a Task List
Create a Network Diagram
Manage the Critical Path
Use Lag and Lead
Analyze Earned Value
Use View Commands
Use Existing Views
Create Custom Views
Format and Share the Timeline View
Use Existing Reports
Create Custom Reports
Export Visual Reports
171695 Microsoft Project 2013 Beginners Level – Accredited Training Project Management 101
Navigate and Customize the Project 2013 Interface
Add Tasks to a Project
Add Resources to a Project
Save a Project
Manage Project Time Frames
Change Working Time
Manage Project Tasks
Add Summary Tasks and Milestones
Manage Project Resources
Allocate and Level Work Resources
Print Project Views
Share Projects
Export Projects
172804 Microsoft Project 2016 Advanced Training Diploma Link Projects
Create and Use Resource Pools
Baseline a Project
Work with Custom Fields
Change Project Options
Extend Project with Apps
Change a Task List
Create a Network Diagram
Manage the Critical Path
Use Lag and Lead
Update Project Work
Analyze Earned Value
Use View Commands
Use Existing Views
Create Custom Views
Format and Share the Timeline View
Use Existing Reports
Create Custom Reports
Export Visual Reports
Activities – Microsoft Project 2016 Advanced
172658 Microsoft Project 2016 Beginners Level Project Management 101
ACTIVITY – PROJECT MANAGEMENT 101
Navigate and Customize the Project 2016 Interface
ACTIVITY – NAVIGATING AND CUSTOMIZING THE PROJECT 2016 INTERFACE
Add Tasks to a Project
ACTIVITY – ADDING TASKS TO A PROJECT
Add Resources to a Project
ACTIVITY – ADDING RESOURCES TO A PROJECT
Save a Project
ACTIVITY – SAVING A PROJECT
Manage Project Time Frames
ACTIVITY – MANAGING PROJECT TIME FRAMES
Change Working Time
ACTIVITY – CHANGING THE WORKING TIME FOR A PROJECT
Manage Project Tasks
ACTIVITY – MANAGING PROJECT TASKS
Add Summary Tasks and Milestones
ACTIVITY – ADDING SUMMARY TASKS AND MILESTONES
Manage Project Resources
ACTIVITY – MANAGING PROJECT RESOURCES
Allocate and Level Work Resources
ACTIVITY – LEVELING RESOURCES
Print Project Views
ACTIVITY – PRINTING A PROJECT VIEW
Share Projects
ACTIVITY -SHARING PROJECTS
Export Projects
ACTIVITY – EXPORTING A PROJECT
Activities – Microsoft Project 2016 Beginners Level
104156 Microsoft Project Beginners Level Module One – Getting Started
Module Two – Opening and Closing Project
Module Three – Your First Project
Module Four – Adding Tasks
Module Five – Advanced Task Operations
Module Six – Adding Resources
Module Seven – Other Ways to View Project Information
Module Eight – Managing Your Project Status
Module Nine – Updating and Tracking Your Progress
Module Ten – Creating Reports
Module Eleven – Adding the Finishing Touches
Module Twelve – Wrapping Up
Microsoft Project Beginners Level – Activities
201240 Microsoft Project Beginners to Advanced Project Management 101
Navigate and Customize the Project 2013 Interface
Add Tasks to a Project
Add Resources to a Project
Save a Project
Manage Project Time Frames
Change Working Time
Manage Project Tasks
Add Summary Tasks and Milestones
Manage Project Resources
Allocate and Level Work Resources
Print Project Views
Share Projects
Export Projects
Link Projects
Baseline a Project
Work with Custom Fields
Change a Task List
Create a Network Diagram
Manage the Critical Path
Use Lag and Lead
Analyze Earned Value
Use View Commands
Use Existing Views
Create Custom Views
Format and Share the Timeline View
Use Existing Reports
Create Custom Reports
Export Visual Reports
104328 Microsoft Project Complete Course – Beginners, Intermediate & Advanced Module One – Getting Started
Module Two – Opening and Closing Project
Module Three – Your First Project
Module Four – Adding Tasks
Module Five – Advanced Task Operations
Module Six – Adding Resources
Module Seven – Other Ways to View Project Information
Module Eight – Managing Your Project Status
Module Nine – Updating and Tracking Your Progress
Module Ten – Creating Reports
Module Eleven – Adding the Finishing Touches
Module Twelve – Wrapping Up
Microsoft Project Beginners Level – Activities
Module One – Getting Started
Module Two – Working with the Project Environment (I)
Module Three – Working with the Project Environment (II)
Module Four – Templates and Other New Project Time Savers
Module Five – Working with Custom Fields
Module Six – Working with Tasks
Module Seven – Working with Resources (I)
Module Eight – Working with Resources (II)
Module Nine – Using the Team Planner
Module Ten – Managing Risks and Measuring Performance
Module Eleven – Communicating Project Information
Module Twelve – Wrapping Up
Activities – Microsoft Project Intermediate Level
Module One – Getting Started
Module Two – Viewing the Project
Module Three – Working with Tasks (I)
Module Four – Working with Tasks (II)
Module Five – Working with Resources
Module Six – Working with Costs
Module Seven – Balancing the Project
Module Eight – Updating Project Progress
Module Nine – Checking Project Progress
Module Ten – Working with Reports
Module Eleven – Working with Multiple Projects
Module Twelve – Wrapping Up
Activities – Microsoft Project Complete Course – Advanced
Mock Exam – Microsoft Project Complete Course – Beginners, Intermediate & Advanced
Final Exam – Microsoft Project Complete Course – Beginners, Intermediate & Advanced
319676 Microsoft Project: Learn the Fundamentals of Project Management Lesson 01: What is Microsoft Project
Lesson 02: The Project Interface
Lesson 03: Project Management Phases
Lesson 04: Create a new Project Plan
Lesson 05: Create a Project Calendar
Lesson 06: Creating Project Tasks
Lesson 07: Placeholder Text and Task Types
Lesson 08: Create Work Breakdown Structure
Lesson 09: Define Task Relationships
Lesson 10: Tying Up Loose Ends
Lesson 11: Add Resources to Project Plan
Lesson 12: Creating a Resource Calendar
Lesson 13: Assign Resources to Tasks
Lesson 14: Resolve Resource Conflicts
Lesson 15: Optimise the Project Plan
Lesson 16: Adding Additional Resources
Lesson 17: Cost of the Project
Lesson 18: Setting a Baseline
Resource – Microsoft Project: Learn the Fundamentals of Project Management
105045 Microsoft Publisher for Beginner Level Module One – Getting Started
Module Two – Opening Publisher
Module Three – Working with the Interface
Module Four – Your First Publication
Module Five – Working with Pictures
Module Six – Basic Editing Tasks
Module Seven – Formatting Fonts
Module Eight – Formatting Paragraphs
Module Nine – Working with Objects
Module Ten – Working with Pages
Module Eleven – Publishing Your Work
Module Twelve – Wrapping Up
Activities – Microsoft Publisher for Beginner Level
Mock Exam – Microsoft Publisher for Beginner Level
Final Exam – Microsoft Publisher for Beginner Level
183892 Microsoft SharePoint 2016 Complete Course Access SharePoint Sites
Navigate SharePoint Sites
Adding Documents
Searching SharePoint
Add Items to Lists
Modifying List Items
Configure List Views
Filter, Group, and Sort List Data
Update and Share Your Profile
Share and Follow SharePoint Content
Create a Blog Post
Open and Save SharePoint Documents with Microsoft Office
Use Document Versions in Microsoft Office
Access SharePoint Using Outlook 2016
Synchronize OneDrive with SharePoint
Use SharePoint with a Mobile Device
Create a Site
Design Your SharePoint Site
Configure a Document Library for a Team Site
Configure the Site Assets Library for a Site
Add a Wiki to your Site
Add an Announcement List
Add a Task List
Add a Blog
Add a Custom List
Configure Site Search Options
Configure Site Administration Settings
Configure Site Navigation Settings
Configure Site Permissions and Security Options
Create a Site Collection
Set Quotas
Configure Audit Options
Back Up a Site Collection
Managing Features and Apps
Add an RSS Feed to Your Site
Create a New Content Type
Add Columns to Content Types
Configure Site Polices
Configure In-Place Records Management
Configure Information Management Policies
Configure and Use the Content Organizer
Understanding Workflows
Create and Run a Workflow
Configure Search Options
Create Search Alerts
173240 Microsoft SharePoint 2016 For Administrators Training Diploma Create a Site Collection
Set Quotas
Configure Audit Options
Back Up a Site Collection
Managing Features and Apps
Add an RSS Feed to Your Site
Create and Configure Document Sets
Create a New Content Type
Add Columns to Content Types
Configure Site Polices
Configure In-Place Records Management
Configure Information Management Policies
Configure and Use the Content Organizer
Understanding Workflows
Create and Run a Workflow
Configure Search Options
Create Search Alerts
Activities – Microsoft SharePoint 2016 For Administrators Training Diploma
175449 Microsoft SharePoint 2016 For Site Owners – Online Training Course Create a Site
Design Your SharePoint Site
Configure a Document Library for a Team Site
Configure the Site Assets Library for a Site
Add a Wiki to your Site
Add an Announcement List
Add a Task List
Add Contact and Calendar Lists
Add a Blog
Add a Custom List
Configure Site Search Options
Configure Site Administration Settings
Configure Site Navigation Settings
Configure Site Permissions and Security Options
Activities – Microsoft SharePoint 2016 For Site Owners
175351 Microsoft SharePoint 2016 For Users – Online Training Course Access SharePoint Sites
Navigate SharePoint Sites
Adding Documents
Searching SharePoint
Add Items to Lists
Modifying List Items
Configure List Views
Filter, Group, and Sort List Data
Update and Share Your Profile
Share and Follow SharePoint Content
Create a Blog Post
Open and Save SharePoint Documents with Microsoft Office
Use Document Versions in Microsoft Office
Access SharePoint Using Outlook 2016
Synchronize OneDrive with SharePoint
Use SharePoint with a Mobile Device
Activities – Microsoft SharePoint 2016 For Users – Online Training Course
106260 Microsoft SharePoint 365 Beginners Module One – Getting Started
Module Two – Basic SharePoint Concepts
Module Three – Working with My Site
Module Four – Working with SharePoint Content
Module Five – Working with Libraries
Module Six – Working with Lists
Module Seven – Working with Other Types of Lists
Module Eight – Working with Calendars
Module Nine – Working with Sites and Pages
Module Ten – Working with Views
Module Eleven – Using Workflows
Module Twelve – Wrapping Up
Activities – Microsoft SharePoint 365 Beginners
Mock Exam – Microsoft SharePoint 365 Beginners
Final Exam – Microsoft SharePoint 365 Beginners
174827 Microsoft SharePoint Foundation Essentials Training Getting Started
Announcements
Events
Link Lists
Task Lists
Contacts
Deleting List Items
Document Libraries
Picture Libraries
Wiki Pages
Asset Libraries
Form Libraries
Discussion Boards
Surveys
Blog Pages
Page Views
Personal Views
Personal and Regional Settings
Alerts
RSS Feeds
Mock Exam – Microsoft SharePoint Foundation Essentials Training
Final Exam – Microsoft SharePoint Foundation Essentials Training
169755 Microsoft SharePoint Foundation Professional Skills SharePoint Libraries
SharePoint Lists
Navigation
Site Themes
Changing Site Components
Managing Item Controls
Editing Pages
Public Views
RSS Feed Settings
Workflows
Site Galleries
Mock Exam – Microsoft SharePoint Foundation Professional Skills
Final Exam – Microsoft SharePoint Foundation Professional Skills
271551 Microsoft SQL Server for Beginners Course and Instructor Introduction
Pre-requisites & Different Editions of SQL Server
Downloading Express Edition & sample database
Installing the downloads & Configuration
The sa Login
Wrap up – what we went over!
What is RDBMS?
Where does SQL Server fit in?
Basic database objects
Different Files that got installed – MDF & LDF
Wrap up – what we went over!
Getting started with SSMS
Getting around Object Explorer
Query Window
Pre-built DB – system database
Wrap up – what we went over!
Bare Minimum: SELECTING a literal
Retrieving / querying data from a table – using FROM clause
Playing with Column Names
Rearranging columns to your liking
Wrap up – what we went over!
Narrowing down and ordering result set – WHERE and ORDER clause
Narrowing down result set – BETWEEN / NOT BETWEEN
Narrowing down result set – IN and NOT IN operator
Narrowing down result set – Pattern Matching: LIKE and Wildcards
Wrap up – what we went over!
Dealing with nothing: NULL
Working with strings: Concatenation and other string functions
Working with dates: Date Functions
Some System Functions
Wrap up – what we went over!
Joining multiple tables – INNER JOIN
Join types – OUTER JOIN – LEFT / RIGHT / FULL
Join types – CROSS JOIN
Holy UNION!
Subqueries
Wrap up – what we went over!
DISTINCT and ALL Predicates
Aggregate Functions
GROUP BY clause / HAVING clause
WHERE and ORDER BY in aggregate queries
Wrap up – what we went over!
Bonus Section
Assignment – Microsoft SQL Server for Beginners
163577 Microsoft Visio 2016 Advanced Training Work with Shape Styles
Use 3D Shapes
Apply Backgrounds, Borders, and Titles
Create Custom Stencils
Create Simple Custom Shapes
Create Master Shapes
Create Custom Templates
Generate a Pivot Diagram from an Excel Spreadsheet
Create a Chart from a Project File
Create a Timeline from a Project File
Connect to an Access Database
Create Macros
Modify ShapeSheets
Use Advanced Shape Tools
Save and Share Drawings with One Drive
Review Drawings
Insert Drawings into Other Office Files
Export Drawings
Print Drawings
Activities – Microsoft Visio 2016 Advanced Training
183955 Microsoft Visio 2016 Application Training – Beginner to Advanced Navigate the Visio Environment
Create a Basic Drawing
Use the Help System
Use Drawing Components
Modify a Drawing
Work with Callouts and Groups
Create a Basic Organization Chart
Do More with Organization Charts
Make a Basic Floor Plan
Model a Room Layout
Create a Cross-Functional Flowchart
Modify a Cross-functional Flowchart
Create Network Diagrams
Use Shape Data
Use Layers
Work with Shape and Connector Styles
Work with Themes and Variants
Work with Containers
Work with Shape Styles
Use 3D Shapes
Apply Backgrounds, Borders, and Titles
Create Custom Stencils
Create Simple Custom Shapes
Create Master Shapes
Create Custom Templates
Generate a Pivot Diagram from an Excel Spreadsheet
Create a Chart from a Project File
Create a Timeline from a Project File
Connect to an Access Database
Create Macros
Modify ShapeSheets
Use Advanced Shape Tools
Save and Share Drawings with One Drive
Review Drawings
Export Drawings
Print Drawings
175254 Microsoft Visio 2016 for Beginners Training Navigate the Visio Environment
Create a Basic Drawing
Use the Help System
Use Drawing Components
Modify a Drawing
Work with Callouts and Groups
Create a Basic Organization Chart
Do More with Organization Charts
Make a Basic Floor Plan
Model a Room Layout
Create a Cross-Functional Flowchart
Modify a Cross-functional Flowchart
Create Network Diagrams
Use Shape Data
Use Layers
Work with Shape and Connector Styles
Work with Themes and Variants
Work with Containers
Activities – Microsoft Visio 2016 for Beginners Training
175531 Microsoft Windows & Office Key Applications Video Training Course Application Features
Working with Word Processing
Working with Spreadsheets
Making a Presentation
Databases
Collaboration
Final Exam – Microsoft Windows & Office Key Applications Video Training Course
Mock Exam – Microsoft Windows & Office Key Applications Video Training Course
174249 Microsoft Windows 10 Advanced Training
























167235 Microsoft Windows 10 Application Training Diploma Identify Components of a Personal Computer
Sign Into Windows 10
Navigate the Desktop
Explore the Start Menu
Multitask with Apps
Search Your Computer
View Notifications
Windows 10 Navigation Summary
Manage Files and Folders with File Explorer
Create and Modify Files with Desktop Applications
Navigate Microsoft Edge
Use Microsoft Edge
Manage Tabs
Modify Microsoft Edge Options
Change Basic Windows Settings
Customize the Lock Screen
Customize the Desktop
Configure Passwords
Use Windows Defender
Store and Share Files with OneDrive
Mock Exam – Microsoft Windows 10 Application Training Diploma
Final Exam – Microsoft Windows 10 Application Training Diploma
186982 Microsoft Windows 10 Complete Professional Diploma Navigate the Desktop
Explore the Start Menu
Multitask with Apps
View Notifications
Search Your Computer
Work with Virtual Desktops
Connect Devices to Your PC
Change Basic Windows Settings
Customize the Lock Screen
Customize the Desktop
Store and Share Files with OneDrive
Use Mail
Use Calendar
Use Camera
Use Groove Music
Use Movies & TV
Use Xbox
Navigate Microsoft Edge
Use Microsoft Edge
Manage Tabs
Modify Microsoft Edge Options
Identify Components of a Personal Computer
Start and Sign into Windows 10
Navigate the Start Menu
Using the Desktop
Elements of a Desktop Window
Manage Files and Folders with File Explorer
Create and Modify Files with Desktop Applications
Components of the Internet
Use Microsoft Edge
Manage Tabs in Microsoft Edge
Using Windows Store
Universal Apps in Windows 10
Interact with Microsoft Cortana
Store and Share Files with OneDrive
Configure User Accounts Using the Settings Window
Personalize Windows 10
Account Passwords
Use Windows Defender
The Settings Window
The Control Panel
Work with Virtual Desktops
Manage Apps
Configure User Accounts Using the Control Panel
Configure User Accounts Using the Settings Window
Use Family Safety Features
Use Mail
Use Calendar
Use Groove Music
Use Movies & TV
Use Camera
Use Xbox
Connect Devices to Your PC
Modify Device Settings
Devices and Printers in the Control Panel
Overview of Networks
Share Files and Folders with a Homegroup
Manage Networks
File History
System Recovery
View System Information
Use the Task Manager
Optimize Power Consumption
Troubleshoot Problems
Mock Exam- Microsoft Windows 10 Complete Professional Diploma
Final Exam- Microsoft Windows 10 Complete Professional Diploma
174132 Microsoft Windows 10 Standard Application Training Certificate Identify Components of a Personal Computer
Start and Sign into Windows 10
Navigate the Start Menu
Using the Desktop
Elements of a Desktop Window
Manage Files and Folders with File Explorer
Create and Modify Files with Desktop Applications
Components of the Internet
Use Microsoft Edge
Manage Tabs in Microsoft Edge
Using Windows Store
Universal Apps in Windows 10
Interact with Microsoft Cortana
Store and Share Files with OneDrive
Configure User Accounts Using the Settings Window
Personalize Windows 10
Account Passwords
Use Windows Defender
174029 Microsoft Windows 10 Transition from 8.1 Online Training Diploma Navigate the Desktop
Explore the Start Menu
Multitask with Apps
View Notifications
Search Your Computer
Work with Virtual Desktops
Connect Devices to Your PC
Change Basic Windows Settings
Customize the Lock Screen
Customize the Desktop
Store and Share Files with OneDrive
Use Mail
Use Calendar
Use Camera
Use Groove Music
Use Movies & TV
Use Xbox
Navigate Microsoft Edge
Use Microsoft Edge
Manage Tabs
Modify Microsoft Edge Options
176229 Microsoft Windows 7 Essentials – Certified Video Training Course The Windows 7 Desktop
The Taskbar and Start Menu
Window Management
Windows Help and Support
Folders and Libraries
Working with Files
Working with Windows Explorer
Searching for Content
Icons and Shortcuts
Gadgets
System Settings
Web Browsing
Tabbed Browsing
Web Searching
Customization
Multimedia Content
Mock Exam – Microsoft Windows 7 Essentials – Certified Video Training Course
Final Exam – Microsoft Windows 7 Essentials – Certified Video Training Course
175365 Microsoft Windows 7 Professional Account Management
Password Management
Devices
Printers
File and Folder Management
File Protection
Disk Maintenance
System Restore
Troubleshooting
Networks
File and Printer Sharing
Offline Files
Remote Assistance
Power Settings and Plans
User Account Control
Windows Firewall
Windows Update
Malware Protection
Internet Explorer Security and Privacy
Mock Exam – Microsoft Windows 7 Professional
Final Exam – Microsoft Windows 7 Professional
167219 Microsoft Windows 7 Professional Training Diploma Meet the Control Panel
Common Customization Tasks
Advanced Customization Tasks
Setting Accessibility Options
Customizing User Accounts
Overview of Networking
Other Networking Tasks
Advanced Networking Tasks
Wireless Networking
Maintaining your Computer
Optimizing your Computer
Using Windows Defender
Keeping your Family Safe
The Basics of Managing Software
Advanced Software Management
Managing Hardware
Advanced Hardware Management
173463 Microsoft Windows 8 – Intermediate Training Diploma Customizing Tile Display
Working with Tiles
Modifying the Start Screen
Customizing the Lock Screen
Customizing Other Settings
Using the Music App
Using the Video App
Playing Games
Using the Camera App
Windows Media Player, Part One
Windows Media Player, Part Two
The Basics of Internet Explorer (Desktop)
Doing More with Internet Explorer (Desktop)
Using Calculator
Using Paint
WordPad Basics
Doing More with WordPad
Using Notepad
Using Windows Journal
Using Windows Fax and Scan, Part One
Using Windows Fax and Scan, Part Two
Using the Snipping Tool
Using Sticky Notes
Using the XPS Viewer
Using the Sound Recorder
173645 Microsoft Windows 8 Advanced Training Adding Administrative Icons to the Start Screen
Meet the Control Panel
Personalizing Your Desktop
Changing Display Options
Changing Regional Options
Advanced Customization Techniques
Setting Accessibility Options
Using Ease of Access Tools
Using Speech Recognition
Customizing User Accounts with the Control Panel
Monitoring System Performance
Maintaining Your Computer
Optimizing Your Computer
Using Task Manager, Part One
Using Task Manager, Part Two
The Basics of Managing Software
Advanced Program Management Tools
Managing Hardware
Advanced Hardware Management
Improving System Performance
Overview of Networking
Using the Homegroup
Networking Tasks
Advanced Networking Tasks
Wireless Networking
Using Remote Desktop
Troubleshooting your Computer with the Action Center9
Using System Configuration
Refreshing and Resetting Your Computer
Using System Restore
163402 Microsoft Windows 8 Basics Training The Basics of Windows 8
Interacting with the Computer Using a Mouse and Keyboard
Interacting with the Computer Using Touch Gestures, Part One
Interacting with the Computer Using Touch Gestures, Part Two
Exiting Windows 8
Introducing the Windows 8 Start Screen
Using the Windows 8 Start Screen
Working with Windows 8 Apps
Using the Charms Bar
Using the Windows Store
Getting Started – The Basic Windows 8 Applications, Part One
Managing Accounts
Using Mail
Using Calendar
Using People and Messaging
Using Photos
Using Windows 8 Internet Explorer, Part One
Using Windows 8 Internet Explorer, Part Two
Using News Apps
Using Maps
Using SkyDrive
Introducing the Windows 8 Desktop
Managing Desktop Windows
Using Desktop Features
Using Jump Lists
Desktop Application Basics
Interface Basics
The Basic Components
The File Explorer Tabs
Customizing File Explorer
Using the Recycle Bin
Getting Help in Windows 8
177802 Microsoft Windows Vista Essentials Exploring the New Interface
New Interface
Leaving Your Computer
Documents & Files
Advance Search Options
Keyboard and Mouse
Programs and Documents
Programs and Documents
Impute Panels and Tablets
Sidebar and Gadgets
Running Commands
Windows Calendar
Working with Pictures, Sound and Music
Finding, Labeling & Tagging Your Picture
Printing and Scanning
Printing Pictures
Printing Pictures
Managing Files and Folders
Views
Folder Links
Folders
Sharing Files Part 1
Sharing Files Part 2
Recovering Deleted Items
Flash Drives and Removable Memory
Mock Exam – Microsoft Windows Vista Essentials
Final Exam – Microsoft Windows Vista Essentials
174666 Microsoft Windows Vista for Intermediate Users Setting up your PC
Easy transfer wizard (Old Computer)
Easy transfer wizard (New Computer)
Turning Components on/off
Windows Mail
Connecting to a Networking Printer
Networking
Exploring the network
Sharing Printers
Customizing Your PC
Screen Saver
Customize the Start Menu
Security
User Accounts and Account Access
Windows Firewall and Windows Update
Internet Explorer Security
Email Viruses
Managing Vista
Windows Status Part 1
Windows Status Part 2
Power Options Part 1
Power Options Part 2
Computer Management
Mock Exam – Microsoft Windows Vista for Intermediate Users
Final Exam – Microsoft Windows Vista for Intermediate Users
101725 Microsoft Word for Intermediate Learners Module One – Getting Started
Module Two – Customizing Word
Module Three – Working with Reusable Content
Module Four – Working with Templates
Module Five – Working with Sections and Linked Content
Module Six – Managing Versions and Tracking Documents
Module Seven – Using Cross References
Module Eight – Creating Mail Merges and Labels
Module Nine – Working with Master Documents
Module Ten – Working with Macros
Module Eight – Creating Mail Merges and Labels
Module Twelve – Wrapping Up
Activities – Microsoft Word for Intermediate Learners
Mock Exam – Microsoft Word for Intermediate Learners
Final Exam – Microsoft Word for Intermediate Learners
309945 Midwifery Certificate Course Definition and Origin of Midwifery
Midwifery as a Career Option
Midwifery Management and Education
Midwives’ Role in Health and Inequality
Social, Cultural and Spiritual Context of Childbearing
Antenatal Care and Screening
Midwifery Support in Labour: Intrapartum Care
Induction of Labour
Postnatal Care as a Midwife
Nurture and Nature: The Healthy Newborn
Stillbirth, Neonatal Death and Bereavement
Infant feeding
Newborn Infection
Home Birth
Complementary and Alternative Medicines Applied to Maternity Care
Pharmacology and Medicines Management
Bleeding in Pregnancy
Medical Disorders of Pregnancy
Pre-term Labour
Twins and higher-order births
Care During the Third Stage of Labour
Terminology and Abbreviations for Midwifery
Perinatal mental health
Supporting a Healthy Pregnancy
Contraception and family planning
Effective Communication for Midwifery
Ethics in Midwifery
327419 Mikrotik Network Management with LABS Module 01: Introduction to MikroTik Kid Control
Module 02: Configuring Kid Control on MikroTik
Module 03: Introduction to MikroTik Neighbor Discovery
Module 04: Configuring Neighbor Discovery on MikroTik
Module 05: Introduction to MikroTik RoMON
Module 06: Configuring RoMON on MikroTik Routers
Module 07: Configuring RoMON over EOIP Tunneling
Module 08: Introduction to MikroTik System Cloud Backup
Module 09: Configuring MikroTik System Cloud backup
Module 10: Introduction to MikroTik Mobile App
Module 11: Downloading and installing MikroTik Mobile App
Module 12: Introduction to MikroTik USB Management
Module 13: MikroTik USB Flash Drive for logging
Module 14: Adding a new Ethernet port using an USB to LAN adapter
Module 15: MikroTik USB – Lte 4G connection
Module 16: Introduction to MikroTik SMB
Module 17: Configuring SMB on MikroTik Routers
Assignment -Mikrotik Network Management with LABS
316809 Mindfulness for Wellbeing and Peak Performance Module 1: Introduction to Mental Health
Module 2: Overview of Mental Health First Aid
Module 3: Childhood and Adolescent Psychiatric Disorders
Module 4: Stress and Anxiety Disorders
Module 5: Schizophrenia
Module 6: Personality Disorders
Module 7: Mood Disorders
Module 8: Eating & Sleeping Disorders
Module 9: Self-Harm and Suicide
Module 10: Medication and Therapy in the Treatment of Mental Illness
Module 11: Social Attitudes to Mental Illness
Module 12: Mental Health Legislation and Services
Module 13: Mental Health in the Workplace
Module 14: Approach and React To People in Mental Health Crisis
206891 Mindfulness Meditation for Everyday Life Introduction- Let’s Begin the Journey to True Love
Mindfulness Practice #1- Breath- A Doorway to Freedom
Meditation #2: Are you ready to fall in love with your body as a sacred temple?
Practice #3: Discover the Mystery of the Present Through Sensation tracking
Practice #4: If you like freedom this practice is for you!
Practice #5: Opening to the Secret of the Magical Pause
Practice #6: Say what? Lining Up Your Speech with Integrity
Practice #7- Dropping Down Into the Mystery of the Golden Realms
Practice #8- A Return to the Bliss of Self-Love
Now You’re Ready to Dive Into Practice — A Review of it All
259353 Mindfulness Meditation Level 2 Introduction- Let’s Begin the Journey to True Love
Mindfulness Practice #1- Breath- A Doorway to Freedom
Meditation #2: Are you ready to fall in love with your body as a sacred temple?
Practice #3: Discover the Mystery of the Present Through Sensation tracking
Practice #4: If you like freedom this practice is for you!
Practice #5: Opening to the Secret of the Magical Pause
Practice #6: Say what? Lining Up Your Speech with Integrity
Practice #7- Dropping Down Into the Mystery of the Golden Realms
Practice #8- A Return to the Bliss of Self-Love
Now You’re Ready to Dive Into Practice — A Review of it All
310621 Mini MBA Appreciating the Mini MBA
The Foundations of Business
Understanding Business Law
Competitive Business Strategies
Departments in Business
Planning the Right Strategy for Business
Managing Human Resources in Business
Economics Influences on Business
Business Accounting
Finance in Business
Business Marketing
Advertising and Promotion
The Art of Negotiation
Communication and Presentation
Organisational Behaviour in Business
Building Teams in Business
Business Leadership
Operations Management
The Importance of Risk Management
Project Management
Quantitative Research and Analysis
Qualitative Research and Analysis
Becoming an Entrepreneur
Corporate Social Responsibility (CSR)
Avoiding Management Mistakes
72737 Mini MBA Business Planning Basics
Market Evaluation
Analyze Competition
Determine A Marketing Strategy
Decide What Extras You May Need Like Staff etc
The Dangers In Not Making A Business Plan
Introduction
Make Yourself Well Recognised Before Your Customers
Wow Your Customers
Develop a Personal Style
Use Creative Imageries to Catch the Attention
Be a Traditionalist, Not a Fad Chaser
Bringing Out the Purple Cow in Your Business
Conclusion
Getting Started
Succession Planning Vs. Replacement Planning
Preparing for the Planning Process
Initiating Process
The SWOT Analysis
Developing the Succession Plan
Executing the Plan
Gaining Support
Managing the Change
Overcoming Roadblocks
Reaching the End
Wrapping Up
Businesses Budgeting Basics
Steps To Better Business Budgeting
How And What To Consider When Preparing A Business Plan And Budget
The Ins And Outs Of Corporate Budgeting
Including Social Business Budgets In The Plan
Impacts Of Debts On Business Budgets
Managing Business Budgets And Finances Together
Introduction to Management
How to Build Trust and Confidence
A Manager’s Pitfalls
How to Build Team Spirit
Dealing with Problem Employees
Using Your Emotional Intelligence
Conclusion to Management
Business Plan Basics
The Executive Summary
The Mission Statement
Exploring Financial Needs
Evaluating Competition
The Troubles You Can Run Into Without The Proper Business Plan
Wrapping Up
Introduction
Can You Manage Yourself Out Of A Paper Bag?
Setting the Stage for a Successful Project
The Importance of Developing and Managing A Budget
Taking Action – Execution of the Plan
Rules to Manage The Projects
Your Personality and Project Management Style
The Cycle of Decision Making
Getting Your Project Back On Track
Keeping It Moving Forward
Problems and Solutions in Project Management
Leader and HR Management
Commitment and HR Management
Team Management
Build A Mastermind Group
People Recognition in HR Management
Performance, Goals and Management
Think Outside The Box
Be Passionate about Your Work
The Importance Of A Good Team Leader
Introduction
The Idea of Systemizing Your Business
Why You Should Systemize Your Business
A Lesson Learned From The Book “The E-Myth”
So, How Do I Create This Wonderful Business System?
Outsourcing As a Way of Systemizing Your Business
How to Keep It Growing: The Systemized Business
Some General Ideas To Consider As You Systemize Your Business
Conclusion
Getting Started To Business Ethics
What is Ethics?
Implementing Ethics in the Workplace
Employer/Employee Rights
Business & Social Responsibilities
Ethical Decisions
Whistle Blowing
Managerial Ethics
Unethical Behavior
Ethics in Business (I)
Ethics in Business (II)
Wrapping Up
What Is A Sales Funnel?
What is Internet Commerce
What Can I Sell
Clickbank
Drop Shipping
Affiliate Marketing
The Link Between Products, Key Words and Prospects
The Front-end and Back-end of Sales Funnels
Sales Funnel Success
Sales Funnel Planning
Putting Your Theory to Practice
Content Marketing
Article Marketing
Google’s Adwords Program
Marketing Offline
Blogs
Social Media
Auto Responders
The Joint Venture
Measuring Success
Top Sales Funnel Products
Mock Exam- Mini MBA
Final Exam- Mini MBA
223188 Minute Taking Course Module 01: Introduction and Background of Minute Taking
Module 02: Sections of Meeting
Module 03: Agenda
Module 04: Roles and Responsibility of Minute Takers
Module 05: Note Taking Methods and Skill Development
Module 06: Main Parts of Meeting Minutes, Recording Decisions and Actions
Module 07: The Freedom of Information Act
Module 08: Making Minute Interesting and Building Confidence
Mock Exam- Minute Taking Course
Final Exam- Minute Taking Course
233854 Minute Taking Course Module 01: Introduction to Minute Writing
Module 02: Preparation for Minute Taking
Module 03: The Meeting Structure
Module 04: Minute Meeting, Decision and Action
Module 05: Roles and Responsibility of Minute Taker
Module 06: Tips for Minute Taking
Module 07: Technology in Minute Taking
Module 08: Building Confidence
164499 Minute Taking With OneNote 2007 Training Certificate Introduction and Course Overview
The Role of a Minute-Taker
The Skills of a Minute-Taker
Meeting Agreements
Minutes Styles
What Do I Record
Techniques for Preparing Minutes
Taking Minutes in an Interactive Meeting
The Minute Book
72990 Mobile Marketing Strategy Level 3 Introduction
Dominate Local Market with Mobile Marketing
Mobile Marketing Is Going Web
Effective Mobile Advertising
List Building with Mobile Marketing
The Surefire Success Mobile Marketing Campaign
Mock Exam – Mobile Marketing Strategy Level 3
Final Exam – Mobile Marketing Strategy Level 3
317350 Model Thinking Personal Skills
Management Skills
Time Management
Effective Communication Skills
Module 05: Organisational Skills
To Do Lists
Development of Personality
Tools to Fight Procrastination
Module 09: Negotiation Techniques
Conflict Management
Stress Management
Diary Management and Note taking
Effective Planning and Scheduling
Cognitive Behavioural Therapy
Neuro Linguistic Programming NLP
Improvement of Presentation Skills
Motivation and Mindset
Visualising Whole Life Goals
209119 Modeling 101: Fundamentals of Modeling Module 01: Professional Modeling Explained & Explored
Module 02: Getting Jobs
Module 03: Working as a Model
Module 04: The Pose
Module 05: Working Internationally
Module 06: Grooming and Exercise
Module 07: Finances, longevity and future career prospects
253414 Modern Facebook Marketing Masterclass Module 01: Introduction
Module 02: 10 Common Facebook Marketing Mistakes
Module 03: The 8 Most Effective Ways to Market on Facebook
Module 04: The Top 10 Benefits of Meditation
Module 05: Facebook Group Marketing
Module 06: Influencer Page Outreach
Module 07: Paid Page Boost Campaign
Module 08: Paid Traffic Campaigns
Module 09: Paid Lead Generation Campaigns
Module 10: Facebook Pixel Retargeting Campaign
Module 11: How to Optimize Your Facebook Ad Campaigns
Module 12: Conclusion
334945 Modern Flat Design in Affinity Designer Introduction to the course
Create A New Document
Create Your Own Colour Palettes
Start with Creating the Sun
Create the Palm Tree
Create the Remaining Leaves
Create the Clouds
Create the Waves
Break the Project Down
Start with The Background
Time to Add the Mountains
Add the First Trees
Finish the Forest
Plant Trees with Symbols
Start Creating the Chalet
Time to Add the Bars
No Hut Is Complete Without the Chimney and The Smoke
Its Time Let the Sun Inside the House
Explore the Garden Project
Create the Sky and The Clouds
Create the Grass
Add Some Plants
Add the Umbrella
Who Wants Lemonade?
Add the Chairs
Creating the First BBQ
Creating the Same Grill
Add the Wheels
How to Use the Segment Tool to Create The BBQ?
The Second BBQ Begins
It’s All About the Sizzle
Add the Legs and Finish The BBQ
Explore the Airfield Project
Add the Gradient Sky First
Add the Windows
Add the Clouds
Add the Chairs
Add the Sign and The Arrows
Time to Add the Escalator
Use Simple Shapes to Create Proportionate Ornaments
Adding Buckles and Straps
Add the Wheels
Add the Handle
Add the Second Piece of Luggage
Explore the Project
Create the Shelves First
Add the Lamp
Create the Beer Tap
Create the Bar Stools
Add the Beer Mug
Add the Foam
Start with The Lager Bottle
Add the Cap
Add the Neck Label – 1
Add the Main Label – 2
Add the Shading
Start Creating the Second Beer Bottle
Add the Cap
Add the Label
Add the Logo and The Text
Start Creating the Wine Bottle
Add the Neck and The First Label
Add the Main Label
Add the Grapes Logo
Add the Text to The Label
Add the First Glass
Pour Some Wine and Add the Shading
Start Creating the Whiskey Bottle
Add the Cap
Bend Sides of The Bottle
Adding the Label11
Add the Text
Add the Glass and The Ice Cubes
Create the Champagne Bottle
Add the Main Label
Create the Champagne Glass
Create the Tequila Bottle
Add the Sombrero Cap
Add the Main Label with The Cactus
Create the Tequila Glass
Create the Lime?
Put the Lime Inside the Glass
Finish the Project
Explore the Design
Start with The Background
Create the Clock
Start Creating the Picture
Add the Boat
Create the Folders
Create the Printer
Add the Router
Create a Computer
Create the Lamp
Finish the Project
Introduction to The Project
Create the Sky and The Stars
Add the Moon
Create the Mountains
Create the Trees
Create the Tent
Add the Entrance
Add the Backpack
Create the Stove
Create the Fire
Create the Wheels
Add the Bumpers
Add the Paint Job and The Lights
Add the Windows
Add the Reflections
Add the Side Mirror
Add the Roof
Finish the Project3
257228 Modern Instagram Marketing Mastery Module 01: Introduction @@
Module 02: 10 Key Reasons Most Marketers Fail on Instagram
Module 03: You Don’t Have to Fail
Module 04: Instagram Success is All about Persona
Module 05: Find Your Competitors on Instagram and Reverse Engineer Them
Module 06: Curate Top Notch content and Mix in Your Reverse Engineered Content
Module 07: Adopt a Content-First Sales Funnel
Module 08: Use Facebooks Ad Retargeting System to Pull Instagram Users Deeper Into Your Funnel
Module 09: Pay and Interact with Niche-Specific Instagram Influencers
Module 10: Continuously Optimize All Parts of Your Funnel
Module 11: Best Practices
298964 Modern OpenGL 3D Game Introduction
GLFW & GLEW Windows (Absolute Linking) Setup
GLFW & GLEW Windows (Relative Linking) Setup
GLFW & GLEW Mac Setup
SDL & GLEW Windows (Absolute Linking) Setup
SDL & GLEW Windows (Relative Linking) Setup
SDL & GLEW Windows (Relative Linking) Setup
SFML & GLEW Windows (Absolute Linking) Setup
SFML & GLEW Windows (Relative Linking) Setup
SFML & GLEW Mac Setup
GLM Windows Setup
SOIL Windows Setup
Drawing a Triangle
Shader Files
Textures
Transformations
Projections and Coordinate Systems
Camera
Colours
Basic Lighting
Materials
Lighting Maps
Directional Lights
Point Lights
Spot Light
Combining Directional, Point and Spot Lights
Assimp Windows Setup
Assimp Mac Setup and Mesh Class
Assimp Model Class & Loading a Model
Cubemapping/Skybox
Resource
Assignment – Modern OpenGL 3D Game
336571 Monetise Your Mobile Game or App Introduction
How to Monetize Your Game or App
Monetize Your Game or App with ADS
Monetize Your Game or App with in App Purchases
In-App Purchases – Subscriptions
Upload Your Game or App on Google Play and Apple Store
Ad Formats – Banner
Ad Formats – Interstitial
Ad Formats – Rewarded Ad
Ad Formats – Offerwall
In-App Purchases – Consumable
In-App Purchases – Non-Consumable
In-App Purchases – Subscriptions
174202 Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) Professional Training Diploma What is System Center 2012
Discussion of Cloud Computing
Important Requirements
Working with System Center and the Infrastructure
Maintaining the Cloud Health
How Components are Integrated
Are You in Compliance
Examining SC 2012 VMM
Working with VMs with the VMM
Creating Clouds for Business
Looking at Service Templates and VMM Profiles
Web Deploy Packages
Server App V Introduction
The Data of the N Tier Application
What’s New with VMM R2
Overview of Operations Manager
Customize the Monitoring Operations
Monitoring Application Performance
Advanced Monitoring
Using Operations Manager for Applications
Using Operations Manager for the Network
Using Operations Manager for Distributed Applications
What’s New in Operations Manager 2012 R2
Looking at Orchestrator 2012
Putting Orchestrator, Operations Manager, and Service Manager Together
What’s New with Orchestrator 2012 R2
What is Problem Management
Using Custom Rules
Service Manager Introduction
Security Settings
Work Items
Incident Queues and Service Offerings
What’s New with Service Manager 2012 R2
Protecting and Recovering Data for the Private Cloud
Data Recovery
Overview of the Process Pack for IT GRC
Installing the Process Pack for IT GRC
Implementing an IT GRC Control Management Program
How to Maintain Compliance Through VMM Security Baselines with System Center
What’s New with DPM 2012 R2 Advisor
Configuring and Deploying Widgets and Dashboards
Real-Time State Using Visio
System Center Analytics
Service Level Tracking
Viewing SSRS and Excel to View Data
PerformancePoint
Service Manager Groom Settings
View and Purge Orchestrator Runbook Logs
310049 Mortgage Adviser Training Introduction to Mortgage and Mortgage Adviser
Basics of Mortgage Purchase
Understanding the Buyer’s Perspective
Mortgage Finances
Being a Successful Mortgage Advisor
Mortgage Regulation and Law: UK
The Mortgage Conduct of Business (MCOB)
The Mortgage Conduct of Business (MCOB), Part 2
UK Mortgage Market and Borrowers
Assignment – Mortgage Adviser Training
255155 Most Successful Steps to Reduce Anxiety and Raise Resiliency Introduction
What Will We Learn?
The TFB Cycle
What is MY Experience with TFB Cycle?
Automatic Thoughts
Negativity Bias
Confirmation Bias
Thoughts Are Not Facts
Pessimistic Thinking
Unconsidered Thinking
Catastrophizing
Mislabelling
Emotional Reasoning
Demand Thinking
Homework on Thoughts and Thinking
Feelings and Emotions
Why Emotions?
Getting to Know Our Emotions
Physical Reactions to Emotions
My Experience – Getting to Know Our Emotions
Homework on Physical Reactions to Emotions
Putting our thoughts and emotions together
Brian’s Driving Test
Exercise on Brian’s Thoughts
Labelling Brian’s Thoughts
Kate’s Story
Exercise on Kate’s Thoughts
Labelling Kate’s Thoughts
Persistent Thoughts and Embedded Beliefs
Questions
Challenging Brian’s Thoughts
Challenging Kate’s Thoughts
Homework on Challenging our Thoughts
Other Factors – Sleep
Other Factors – Food, Drink and Exercise
Other Factors – More Tips
Congratulations
254599 Most used English Idioms & Phrases Introduction
What are Idioms and Why We Must Learn Them?
More about this Course
Shoot Yourself in the Foot
My Lips are Sealed
Hit the Nail on the Head
Tighten Someone’s Belt
Frog in Throat
Slip Someone’s Mind
Lose Someone’s Face
Come Rain or Shine
Turn Yourself in
Cost an Arm and Leg
Homie
Give Someone a Cold Shoulder
Have an Egg on Someone’s Face
Get Butterfly in Someone’s Stomach
Throw Someone’s Money around
Play Innocent
Turn Someone’s Stomach
Not Cut out for Something
Kick Someone out
To Put the Blame on Someone
Hands Off
Pass Away
Cut the Deal
For My Money
Burn Your Bridges
Come in Handy
Come at Price
In a Broad Daylight
In the Mood to do Something
In a Jiffy
In so Many Words
Put Your Mind to It
Joking Apart , Joking Aside
In Your Dreams
Green with Envy
Overstep the Line
Have a Craving for Something
Red Herring
Brush Up on Something
Clown Around
Top Banana
Work Like a Dog
Mouse Potato
Teeny-Weeny
Take Time Off
On the Eleventh Hour
How Dare You
Hush-Hush
Over Someone’s Head
Not Lift a Finger
Fall Behind
Make a Fuss
That’s no Excuse
Fender-Bender
Scare Someone to Death
Come Down to Earth
Nothing between the Ears
Lay an Egg
Feel Like a Million Dollars
I wasn’t Born Yesterday
Peanut Money
Run Into
I’ll Eat My Hat
Sing Like a Bird
Black Out
On Tip of Someone’s Tongue
Time Flies
Tie the Knot
Something Sucks
Step on It
Creep by
Pull Someone’s Leg
A Pain in the Neck
Out of the Blue
Heart in the Right Place
Hush Money
Chicken Out
Fill Someone’s Shoes
Cut it Out
To be Off ( food )
Make Up ( story )
Soak Up
Make up for someone or something
Own Up
To be Taken Aback
Break Down
Hit Below the Belt
Get Carried Away
Make Ends Meet
look Down on Someone
Drop Off
All-Nighter
At the End of Your Rope
Basket Case
Cold Feet
Sell Someone Short
Go Bananas
Copycat
Jump Ship
Know-it-All
No-Brainer
To Mess Up with Someone
Knock on the Wood
If I Get my Hands on You
Come Clean
Have a Lot in Plate
It’s Between to Our Ears
What a Mess
I’m All Eyes
To Have a Lot in Common
Go Dutch
Eye- Catching
Take Your Time
Touch Guy
Kick up Someone’s Heels
Make a Boo-Boo!
Voracious
To Make a Fortune
To be on the Go
Cool Someone’s Heels
Top Dog
Road Hog
To Put Someone on a Pedestal
Bury the Hatchet
Zip Someone’s Mouth
To Ditch Someone
Henpecked Husband
Bury the Head in the Sand
Eager Beaver
Until the Cows Come Home
Worn Out
Drag Someone’s Feet
Keep Someone’s Words
Bookworm
To be an Old Hand
Runny Nose
That’s News to Me
To Have a Heart of Gold
Get to the Point
To Get out of Bed on the Wrong Side
Barking Up the Wrong Tree
To Have Other Fish to Fry
No Offense
Two-Fisted
To Thumb Your Nose at Somebody
I Got Your 6
Act Your Age
Pig Out
To Make Up for Something
To Hell with Something or Somebody
Hop in
Cut the Comedy
Why the Long Face
Ta-ta for Now
The Damage is Done
Turn on the Waterworks
Home Sweet Home
A Dead Ringer for Someone
Your Wish is My Command
Just My Luck
What’s It to You?
To Answer the Call of Nature
To be Stuffed
Not to be on Speaking Term
Wearing Odd Shoes / Gloves / Socks
Rise and Shine
Stand Someone Up
Pangs of Conscience
Leave It to Someone
Walking Papers
Jump Down Someone’s Throat
To Soak Someone
To have a screw loose
To Blow the Fuse
Hit and Miss
Eat Like a Horse
Not in the Same Wave Length
Eat Your Words
From A to z
As White as a Sheet
Find Someone’s Feet
Shake a Leg
Wind Your Neck in
Save Someone’s Neck
It’s Beyond Your Dignity
You are Over the Hump
Rainy Day
To have a Big Mouth
Not in a Good Mood
Dog Days
To Stab Somebody in the Back
To Get a Kick Out of Something
Feel Under the Weather
Pipe Down
Never Say Die
Get in Someone’s Hair
Cat Got Your Tongue
311320 Motivating, Performance Managing and Maintaining Team Culture in a Remote Team Motivating Remote Team Members
Tactics of Influence and Persuasion
Nurturing Team Connections and Resolving Conflicts
Establishing Compelling Performance Goals
Building Effective Relationships
Virtual Team Building Games and Activities
Developing Team Culture
Effective Communication
Strengthening Team Cooperation
234026 Motorcycle Maintenance Course Introduction to Motorbike Maintenance
Basics of Engine
Engine Cooling and Lubrication
Ignition
Suspension
Intake, Fuel, Clutch and Exhaust Systems
Electrical Maintenance
Wheels, Tires and Brakes Maintenance
Transmission, Frame and Steering
Cleaning, Setting Up and Storage
Troubleshooting
240739 Motorcycle Repairing and Maintenance Course Introduction to Motorbike Maintenance
Basics of Engine
Engine Cooling and Lubrication
Ignition
Suspension
Intake, Fuel, Clutch and Exhaust Systems
Electrical Maintenance
Wheels, Tires and Brakes Maintenance
Transmission, Frame and Steering
Cleaning, Setting Up and Storage
Troubleshooting
110535 Muscle Building and Strength Training Course Introduction
Fitness And Where You Stand Right Now
Body Fitness And Its Effect On Your Life
Diet Fitness, You Are What You Eat, Really!
Mind Fitness, A Healthy Emotional Life
Lifestyle Fitness, You Are What You Do, Too
Conclusion
Nutrition
Physiology and Kinesiology
Aerobic Training
Weight Training
Muscle Exercise Cross Reference
Fitness Testing
Stretching
Yoga
Pregnancy
Senior Fitness
Exercise Injury
Personal Training Tips
Personal Trainer Mistakes & Solutions
Introduction To Aerobic Exercise
Kinds Of Aerobic Exercises
Set To Aerobics Exercises
About Of Aerobic Breathing
Aerobic Dance Combines Exercise
Aerobic Exercise  Equipment
About Of Aerobic Kickboxing
Step Aerobics Exercise For Fitness
Aerobics For Kids
The Best Types Of Aerobics
Aerobics Exercise basics
Aerobics During Pregnancy
Kinds Of Aerobic Equipment
The Beauty Of Aerobic Exercises
Benefits Of Aerobics Exercises
Success Means Being Healthy
How Does Detoxifying Help With Fitness
Nutrition? What You Need to Know
Benefits from Being Fit
The Interchangeability of Wellness, Fitness and Health
Introduction
Knowing About Fitness, Health and Exercise
The Basic Requirements
Essentials and Advices
Types of Aerobics
Strength and Building Plans
Live Longer and Stay Healthy While Feeling Younger
Promoting Health
Conclusion
Introduction
Assessing Physical Damage and Accepting the Importance of Exercise
How to Include Exercise
Busy Traveler? You Can Fit Exercise into your Trips
Exercise Equipment “To Go”
Resources
Conclusion
Recommended Reading : Muscle Building and Strength Training Course
Mock Exam – Muscle Building and Strength Training Course
Final Exam – Muscle Building and Strength Training Course
310107 Mushroom Growing Course Introduction to Mushroom Cultivation
Identifying Edible Mushrooms
Mushroom Culture Part One
Mushroom Culture Part Two
Mushroom Spawning
Mushroom Compost Part One
Mushroom Compost Part Two
Making and Casing Mushroom Beds
Mushrooms Growing Conditions
Growing Mushrooms Outside
Harvesting and Storing Mushrooms
Mushroom Business
323178 MySQL Database Development Module 01: Introduction to MySQL Server and Databases
Module 02: Download and Install MySQL Server and MySQL Workbench
Module 01: Connect and Create a Database
Module 02: Drop or Remove Database
Module 03: Create an SQL Database Table
Module 04: Insert Data into the Table with SQL Script
Module 05: Insert Data into the Table with Workbench
Module 06: Select Data from the Table with SQL Script
Module 07: Select Data with Filters
Module 08: Update Data in the Table
Module 09: Delete Data from the Table
Module 10: Reverse Engineer Database into Model
Module 11: Forward Engineer Data Model into Database
Module 01: What are Relationships, Foreign Keys and Normalization?
Module 02: Create Relationships with Data Modeling
Module 03: Create Relationships with Workbench Table Design Tool
Module 04: Insert Records in Related Tables
Module 05: Run Queries on Related Tables (Inner Joins)
Module 06: Left, Right and Cross-Joins
Module 01: Grouping Data using SQL GROUP BY Clause
Module 02: SQL AVG Aggregate Function
Module 03: SQL COUNT Aggregate Function
Module 04: SQL MIN & MAX Aggregate Functions
Module 05: SQL SUM Aggregate Function
Module 06: Splitting Groups using HAVING Clause
Assignment – MySQL Database Development
73868 Nail Design & Manicure Online Training Introduction to Nail Design
Choosing your nail art brushes
The importance of using products, tools, equipment and techniques
All About Manicures
All about Products and Supplies for Nail Manicures
How to Give a Manicure
Manicure Procedure
Recommended Reading : Nail Design & Manicure Online Training
Mock Exam – Nail Design & Manicure Online Training
Final Exam – Nail Design & Manicure Online Training
326473 Nail Technician Diploma with Gel Manicure Training Module 01: General Care of Hands
Module 02: Manicure
Module 03: Pedicure
Module 04: Nail Art
Module 05: Gel and Shellac Manicures
Mock Exam – Gel Manicure and Nail Technician Diploma
Final Exam – Gel Manicure and Nail Technician Diploma
275162 Nanny Workers Care Guideline Introduction to Nanny Care Workers
Understanding Child Development
Care for Children
Healthy Food, Healthy living
Keeping Children Healthy & Safe
Early Years Provision
Establishing Relationship and Routines
Time Management for Nannies
Nanny’s Job Profile
Establishing a Nanny’s Career
260612 Natural Nutrition: Naturopathic Approach Health & Healthy Diet
Chemical and synthetic food
Meat and meat industry – Part 1
Meat and meat industry – Part2. Milk and dairy products
Thermally treated plant food
Raw seeds, nuts, beans and mushrooms
Raw fruits, vegetables, juices and honey
Listen to your body
Intestines, degree of contamination – Part 1
Intestines, degree of contamination – Part 2
Intestines, two types of contamination reactions – slow and fast metabolism
Intestines, methods of cleaning – Part 2
Intestines, restoration of normal (symbiotic) microflora – Part 1
Intestines, restoration of normal (symbiotic) microflora – Part 2
Kidneys, water and water regime – Part 1
Kidneys, water and water regime – Part 2
Skin as an excretory system – Part 1
Skin as an excretory system – Part 2
Peculiarities of the purification period. Deficiencies of substances and energy.
82326 Natural Pain Management Skills Training Diploma Level 3 Introducing Pain Management
Pain Theories
Types of Pain
Physiology and Psychology of Acute Pain
Pain as a Long-term Condition
Back and Neck Pain
Headache
Neuropathic Pain and Its Management
Cancer Pain
Assessment of Pain
Relaxation for Pain Management
Introduction
What is pain?
It starts at the very beginning…
What kind of pain do you have?
Acupuncture – the great pain reliever…
Hypnosis for dealing with pain
Herbs for pain relief
Conclusion
Mock Exam – Natural Pain Management Skills Training Diploma Level 3
Final Exam – Natural Pain Management Skills Training Diploma Level 3
260039 Naturopathic Approach to Natural Nutrition Level 2 Health & Healthy Diet
Chemical and synthetic food
Meat and meat industry – Part 1
Meat and meat industry – Part2. Milk and dairy products
Thermally treated plant food
Raw seeds, nuts, beans and mushrooms
Raw fruits, vegetables, juices and honey
Listen to your body
Intestines, degree of contamination – Part 1
Intestines, degree of contamination – Part 2
Intestines, two types of contamination reactions – slow and fast metabolism
Intestines, methods of cleaning – Part 2
Intestines, restoration of normal (symbiotic) microflora – Part 1
Intestines, restoration of normal (symbiotic) microflora – Part 2
Kidneys, water and water regime – Part 1
Kidneys, water and water regime – Part 2
Skin as an excretory system – Part 1
Skin as an excretory system – Part 2
Peculiarities of the purification period. Deficiencies of substances and energy.
108907 Negotiation Skills Training Advanced Diploma How to Negotiate With Your Landlord About Problems
How to Negotiate With Your Family Members, and Keep the Peace
What is Involved When A Labor Negotiation Takes Place?
What is involved when negotiating a car lease?
What is involved when negotiating a car purchase?
What is involved when negotiating a real estate purchase?
How to use Negotiating Skills
How to practice negotiating skills
How to put your negotiating skills to work for your business
How to find negotiating skills that you can really use
How to make negotiating a habit
How to avoid negotiating too much
How you use words when negotiating
How to use body language when negotiating contracts
How to use eye contact when negotiating sales
How to ask for a raise, negotiation for your career
How to ask for better benefits, how to negotiate
What is the art of negotiating
How to negotiate your way out of paying your bill all at one time
How to avoid raising your voice when negotiating a problem
Three methods of getting someone to do what you want with the negotiation skills
Three Methods of avoiding a conflict while negotiating
Three Methods of avoiding a fight with your co-workers with negotiation skills
Three methods of getting someone to do what you want with the negotiation skills
How to realize your own negotiation skills and put them to work in your career
What is the top three negotiation skills needed by managers?
How to negotiate when trading in a car
How to negotiate with your boss, about anything
How to negotiate with your creditor about debts
How to negotiate when opening a new investment account
Module One – Getting Started
Module Two – Understanding Negotiation
Module Three – Getting Prepared
Module Four – Laying the Groundwork
Module Five – Phase One — Exchanging Information
Module Six – Phase Two — Bargaining
Module Seven – About Mutual Gain
Module Eight – Phase Three — Closing
Module Nine – Dealing with Difficult Issues
Module Ten – Negotiating Outside the Boardroom
Module Eleven – Negotiating on Behalf of Someone Else
Module Twelve – Wrapping Up
Negotiation Skills Certificate- Activities
Module One – Getting Started
Module Two – Three Main Factors
Module Three – Seeing Objections as Opportunities
Module Four – Getting to the Bottom
Module Five – Finding a Point of Agreement
Module Six – Have the Client Answer Their Own Objection
Module Seven – Deflating Objections
Module Eight – Unvoiced Objections
Module Nine – The Five Steps
Module Ten – Dos and Don’ts
Module Eleven – Sealing the Deal
Module Twelve – Wrapping Up
Handling Sales Objections & Negotiating Course- Activities
Mock Exam – Negotiation Skills Training Advanced Diploma
Final Exam – Negotiation Skills Training Advanced Diploma
177940 Networking with Windows Server 2016 (MCSA) Certified Training Course Plan and Implement IP Addressing Schemes for IPv4 Networks
Configuring IPv4 Hosts
Managing and Troubleshooting IPv4 Connectivity
Implementing IPv6 for Network Hosts
Implementing IPv6 Transitioning and Coexistence
Overview of the DHCP Server Role
Deploying DHCP
Managing and Troubleshooting DHCP
Implementing DNS Servers
Creating and Configuring DNS Zones
Understanding Active Directory Integration
Configuring Advanced DNS Settings
Troubleshooting DNS Name Resolution
Overview of IPAM
IPAM Deployment
Managing IP Address Spaces by using IPAMM
Remote Access Overview
Implementing the Web Application Proxy
Planning and Implementing VPNs
Overview of DirectAccess
Implementing DirectAccess
Configuring Networking for Branch Offices
Implementing Distributed File Systems
Implementing BranchCache
Implementing Networking Features for High Performance
Implementing Hyper-V Advanced Networking Features
Introduction to Software-Defined Networking
Overview of Network Virtualization
Mock Exam- Networking with Windows Server 2016 (MCSA) Certified Training Course
Final Exam – Networking with Windows Server 2016 (MCSA) Certified Training Course
250162 Neuro Linguistic Programming (NLP) Training Level 2 Course Overview
What is Neuro Linguistic Programming?
The NLP Presuppositions
The Senses According to NLP
Using Enriched Language
Interpreting Body Language
Asking Clean Questions
The Power of Hypnotic Language
Understanding Common NLP Terms
Mock Exam – Level 2 Neuro Linguistic Programming (NLP) Training Course
Final Exam – Level 2 Neuro Linguistic Programming (NLP) Training Course
310200 Neurology Introduction to Neurology
Neurological Disorders
Visual Disorders
Disorders of Hearing
Spinal Cord Disorders
Peripheral Nervous System Disorders
Child Neurology
Neurological Assessments
Medications
325667 NLP Training Course What is NLP?
Modeling – A Powerful Tool For Rapid Success!
Learning Styles – Gain the Edge!
Value Systems – The Driving Force!
Eye Movements – Windows To The Soul – Truth Detector
Powerful Communication – The KEY to Success!
Emotional Mastery – Increasing & Decreasing Emotions
Anchoring – Connecting With Your Power
Scrambling Techniques – Rid Yourself Of Negative Emotions
Building Unshakable Confidence!
Final Thoughts & Tips!
BONUS Lecture & Demo – LIVE!!!
WOW! 2nd BONUS Video & Demo
310273 Noise and Hearing Protection Training The Concept of Noise and Hearing Protection
Identify, Assess and Control Noise at Workplace
Health Effects of Loud Noise
Safe Hearing
Noise Control Laws and Legislation
Hearing Conservation at Workplace
1581 Nursing Assistant Training Diploma Level 3 NOTES ON NURSING
VENTILATION AND WARMING
HEALTH OF HOUSES
PETTY MANAGEMENT
NOISE
VARIETY
TAKING FOOD
WHAT FOOD?
BED AND BEDDING
LIGHT
CLEANLINESS OF ROOMS AND WALLS
PERSONAL CLEANLINESS
CHATTERING HOPES AND ADVICES
OBSERVATION OF THE SICK
CONCLUSION
Fundamental Nursing Skills
Nursing Theories and Nursing Practice
Mock Exam- Nursing Assistant Training Diploma Level 3
Final Exam- Nursing Assistant Training Diploma Level 3
263088 Nutrición y Entrenamiento Deportivo Introducción a la nutrición
El papel del nutricionista
El sistema digestivo
Nutrientes para la vida: macronutrientes
Nutrientes para la vida – Micronutrientes
Requisitos nutricionales para adultos y varios grupos
Dieta saludable
Gestión del control de peso
Manejo de la pérdida de peso
El día de la competencia
Reemplazo de nutrientes después de la competencia
Mock Exam – Curso de entrenador personal/instructor de fitness y formación en nutrición deportiva
Final Exam – Curso de entrenador personal/instructor de fitness y formación en nutrición deportiva
238284 Nutrition and Health Level 2 Module 01: Introduction to Nutrition
Module 02: Nutrients for Life – Nutrients for Life Macronutrients
Module 03: Nutrients for Life – Micronutrients
Module 04: Nutrition Requirements from Pregnancy to Teenage
Module 05: Nutrition Requirements for Adults and Various Groups
Module 06: Healthy Dieting
Module 07: Eating Disorders
Module 08: Diet and Nutrition Related Diseases
Module 09: Use of Nutrition in Different Illnesses/Diseases
Module 10: Weight Control Management
Module 11: Weight Loss Management
Module 12: Basics of Ketogenic Diet
Module 13: The Role of Nutritionist
310213 Nutrition and Hydration Introduction to Nutrition
Nutrients
Malnutrition
Special Nutritional Support
Hydration
Dehydration
Need of Water
113008 Nutrition Bundle Diploma Getting Started with a Diet
Low Carb (No Carb) Diets
Women’s Health Look Good Naked Diet
Prevention System’s Flat Belly Diet
Weight Watchers International’s Pro Points
Mike Geary’s Truth about Abs Diet
HCG Diet
Diet Supplements and Weight Loss
Diets that Provide Food Supplements
Wrapping Up
Role Of Nutrition In Heart Disease Treatment
The Natural Remedy Enhances Heart Health
Vitamins For A Healthy Heart
Nutritional Supplements For Treating Heart Diseases
Getting Folic Acid For Heart Disease
Natural Fat Is Good For The Heart
Wrapping Up
You Are What You Eat
Importance Of Nutrition For Dieting
The Delicious Foods You Should Avoid
You Should Eat More Nutritious Food
Your Weight Loss Nutrition Plan
Do Supplements Really Work?
Accelerate Your Progress With Physical Activities
Diet and Nutrition
Mock Exam – Nutrition Bundle Diploma
Final Exam – Nutrition Bundle Diploma
218093 Nutrition Certification Masterclass for the Correct Dieting & Meal Planning Welcome To The Course & What You Will Learn
Get to Know Your Instructor
Meal Planning Explained
Calories Explained 1455
Micronutrients Introduction
Protein Explained
How much protein do you need to consume per day
Fats explained
How Much Fat Should You Eat Per Day
Carbohydrate Explained
Macronutrients Explained
The Different Types of carbs
How Much Carbs should you eat per day
Meal Timing Intro 2 copy
Protein Timing
Carbohydrate Timing
Fat Timing
Pre-Workout Meal
Post Workout Meal
What About the Anabolic Window
Food Composition Introduction 2 copy
Protein Composition
Carbohydrate Composition
Fat Composition
Top 3 Beginner Supplements
How to Use Protein Powder When, How Much & With What
How to Use Creatine When,How Much & With What
Other Supplements to consider
How To Determin Your Optimal Calorie Intake 2
How to Track Calories
Determining Protein Intake
Determining Carb Intake
Determining Fat Intake
What About the Ramaining Calories
Determining Meal Structure
Quality Protein Sources
Quality Carbs Sources
Quality Sources Of Fat
Adjusting You Diet For Weight Gain
Adjusting Your Diet For Weight Loss
Cheat Days and Cheat Meals
Post Workout Shake
Healthy Dieting Intro copy
Dieting myth #1 Carbs are bad for you
Dieting Myth #2 Fat is bad for you
Dieting Myth #3 Protein is bad for you
Dieting Myth #5 Avoid Salt At All Cost
Dieting Myth #6 Eat several small meals throughout the day to lose weight
Dieting Myth #7 Diet Foods Will Lead To Weight Loss
Red Meat Always Causes Cancer
Common Diets Intro Copy
Common Diets Intro Copy
Gluten Free Diet Explained
Paleo Diet Explained
Low Carb Diet Explained
Intermittend Fasting Explained
Vegan Diet Explained
Micronutrients Introduction
Vitamin A
Vitamin B
Vitamin C
Vitamin D
Vitmain E
Vitamin K
Calcium
Magnesium
Phosphorus
Potassium
Sodium
Copper
Iron
Zinc
Water
Intro Specific dieting tips and strategies
5 Best Supplements to Boost Your Immune System
How to Read a Nutrition Label
How to Do You Own Research
260059 Nutrition Fundamentals Level 2 Nutrition Overview
Nutrition & Carbs
What Are Proteins
This is Fat
Water
What Are Micronutrients
Effortless Nutrition
Strategies to Apply Today
Nutrition Myths
Are Diet Foods Good For You?
249430 Nutrition, Diet and Meal Planning Course Module 01: Introduction to Nutrition
Module 02: Micronutrients
Module 03: Nutrients for Life – Micronutrients
Module 04: Nutrition Requirements from Pregnancy to Teenage
Module 05: Nutrition Requirements for Adults and Various Groups
Module 06: Healthy Dieting
Module 07: Eating Disorders
Module 08: Diet and Nutrition Related Diseases
Module 09: Use of Nutrition in Different Illnesses/Diseases
Module 10: Weight Control Management
Module 11: Weight Loss Management
Module 12: Basics of Ketogenic Diet
Module 13: The Role of Nutritionist
Module 1: What is Beauty?
Module 2: How Diet Affects Body and Beauty
Module 3: The ‘Fat’ Controversy
Module 4: Protein Dilemma
Module 5: The Case of Ageing: Diet to Look Younger
Module 6: Detoxification for Beauty
Module 7: Diet for a Glamourous Skin
Module 8: Strong and Healthy Hair
Module 9: Diet for a Glimmering Smile
Module 10: Weight Loss
Welcome To The Course & What You Will Learn
Get to Know Your Instructor
Meal Planning Explained
Calories Explained 1455
Micronutrients Introduction
Protein Explained
How much protein do you need to consume per day
Fats explained
How Much Fat Should You Eat Per Day
Carbohydrate Explained
Macronutrients Explained
The Different Types of carbs
How Much Carbs should you eat per day
Meal Timing Intro 2 copy
Protein Timing
Carbohydrate Timing
Fat Timing
Pre-Workout Meal
Post Workout Meal
What About the Anabolic Window
Food Composition Introduction 2 copy
Protein Composition
Carbohydrate Composition
Fat Composition
Top 3 Beginner Supplements
How to Use Protein Powder When, How Much & With What
How to Use Creatine When,How Much & With What
Other Supplements to consider
How To Determin Your Optimal Calorie Intake 2
How to Track Calories
Determining Protein Intake
Determining Fat Intake
What About the Ramaining Calories
Determining Meal Structure
Quality Protein Sources
Quality Carbs Sources
Quality Sources Of Fat
Adjusting You Diet For Weight Gain
Adjusting Your Diet For Weight Loss
Cheat Days and Cheat Meals
Post Workout Shake
Healthy Dieting Intro copy
Dieting myth #1 Carbs are bad for you
Dieting Myth #2 Fat is bad for you
Dieting Myth #3 Protein is bad for you
Dieting Myth #5 Avoid Salt At All Cost
Dieting Myth #6 Eat several small meals throughout the day to lose weight
Dieting Myth #7 Diet Foods Will Lead To Weight Loss
Red Meat Always Causes Cancer
Common Diets Intro Copy
Common Diets Intro Copy
Gluten Free Diet Explained
Paleo Diet Explained
Low Carb Diet Explained
Intermittend Fasting Explained
Vegan Diet Explained
Micronutrients Introduction
Vitamin A
Vitamin B
Vitamin C
Vitamin D
Vitmain E
Vitamin K
Calcium
Magnesium
Phosphorus
Potassium
Sodium
Copper
Iron
Zinc
Water
Intro Specific dieting tips and strategies
5 Best Supplements to Boost Your Immune System
How to Read a Nutrition Label
How to Do You Own Research
315059 Object-Oriented JavaScript Section 01: About the Author
Section 02: Introduction to JavaScript
Section 03: Strengths and Weaknesses of JavaScript
Section 04: Writing JavaScript in Chrome
Section 05: JavaScript Variables
Section 06: Demo of JavaScript Variables
Section 07: Basic Types of JavaScript
Section 08: JavaScript Boolean
Section 09: JavaScript Strings
Section 10: JavaScript Numbers
Section 11: JavaScript Objects
Section 12: Demo of JavaScript Objects
Section 13: JavaScript Arrays
Section 14: Demo of JavaScript Arrays
Section 15: JavaScript Functions
Section 16: Demo of JavaScript Functions
Section 17: JavaScript Scope and Hoisting
Section 18: Demo of JavaScript Scope and Hoisting
Section 19: Currying Functions
Section 20: Demo of Currying Functions
Section 21: Timeouts and Callbacks
Section 22: Demo of Timeouts and Callbacks
Section 23: JavaScript Promises
Section 24: Demo of JavaScript Promises
Section 25: Demo of Javascript Async
Section 26: Flow Control
Section 27: Demo of Flow Control
Section 28: JavaScript For Loop
Section 29: Demo of JavaScript For Loop
Section 30: Demo of Switch Statements
Section 31: Error Handling
Section 32: Demo Project
309735 Observation Skills for Carers Introduction to Observation Skill
Child Observation
Child Observation Plan and Documentation
Observational Methods and Studies
Social Policy and Social Work Observation
Basic Health Observation
Clinical Management Observation
309913 Observation Skills for Carers Introduction to Observation Skill
Child Observation
Child Observation Plan and Documentation
Observational Methods and Studies
Social Policy and Social Work Observation
Basic Health Observation
Clinical Management Observation
197849 Occupational Therapy Course About the Course & Instructor
What is Occupational Therapy?
Knowledge & Skills for Occupational Therapy
Working with Adults
Working with Children
The Structure & the Functions
The Blood & the Immune System
What is ‘Brain Injury’?
Developmental Disorders & Conditions
Physical Disabilities
The Use of Creative Activities
Management & Leadership Skills
Building Confidence & Self-Esteem
Dealing with Depression
Professional Development
Personal & Academic Development
Alternative Career Options
A Theory of Human Need for Occupation
Occupations for Health & Wellbeing
Coping Strategies (stress)
Maslow’s Hierarchy of Needs
Thank You & Good Bye!
310057 OCD Awareness Introduction to Obsessive Compulsive Disorder (OCD)
Signs, Symptoms and Causes of OCD
Identifying and Treating Specific OCD Symptoms
Treatment for OCD
Treating Children with OCD
Overcoming OCD
Relapse Prevention and Recovery
Living with OCD
106718 Office Admin & Receptionist Diploma Level 3 Introduction to Reception and Receptionist
Business Telephone Skills
Representing Your Boss and Company
Mail Services and Shipping
Travel Arrangements
Organising Meeting and Conferences
Time Management
Record Keeping and Filing Systems
Business Writing Skills
Organisational Skills
Communication Skills
Customer Service
Effective Planning and Scheduling
Invoicing Petty Cash
Business Environment
How to Get the most of the course
Text formulas in Excel
Text Formulas Exercise
Text Formulas Exercise (answers)
Mathematical Formulas In Excel
Mathematical Formulas Exercise
Mathematical Formulas Exercise (answers)
Date and Time Formulas In Excel
Date and Time Formulas Exercise
Date and Time Exercise Formulas (answers)
Logic Formulas In Excel
Logic Formula Exercise
Logic Formula Exercise (answers)
Financial Formula In Excel
Financial Formula Exercise
Financial Formula Exercise (answers)
Informational Formula In Excel
Informational Formula Exercise
Informational Formula Exercise (answers)
Getting Traffic To Your Site
Menu Example with Excel Vlookup
Wildcard Search with Excel Vlookup
Looking to the Left with Excel Vlookup
2-Way Lookup
Comparing Lists with Excel Vlookup
Microsoft Excel Vlookup Tips and Tricks
Power Query Intro and Excel version
Excel Power Query – Introduction
Enabling M in Power Query
Transform Data – Trim in Excel Power Query
Transform Data – Format Dates and Values in Excel Power Query
Simple Expressions
Simple Expressions – Nested Expressions
Transform Data – Parsing URLs in Excel Power Query
Variables
Formatting Excel Keyboard Shortcuts
Table Excel Keyboard Shortcuts
Editing Excel Keyboard Shortcuts
Formula Excel Keyboard Shortcuts
Workbook Excel Keyboard Shortcuts
Handy Excel Shortcuts Keyboard Shortcuts
Mock Exam – Office Admin & Receptionist Diploma Level 3
Final Exam – Office Admin & Receptionist Diploma Level 3
Assignment – Office Admin & Receptionist Diploma Level 3
Module One – Getting Started
Module Two – Getting Organized (I)
Module Three – Getting Organized (II)
Module Four – Managing Time
Module Five – Getting It All Done On Time
Module Six – Special Tasks
Module Seven – Verbal Communication Skills
Module Eight – Non-Verbal Communication Skills
Module Nine – Empowering Yourself
Module Ten – The Team of Two
Module Eleven – Taking Care of Yourself
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Why Your Office Needs Administrative Procedures
Module Three – Gathering the Right Tools
Module Four – Identifying Procedures to Include
Module Five – Top Five Procedures to Record
Module Six – What to Include in Your Binder (I)
Module Seven – What to Include in Your Binder (II)
Module Eight – Organizing Your Binder
Module Nine – What Not to Include in the Procedure Guide
Module Ten – Share Office Procedure Guide
Module Eleven – Successfully Executing the Guide
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Remove the Clutter
Module Three – Prioritize
Module Four – Scheduling Your Time
Module Five – To Do Lists
Module Six – Paper and Paperless Storage
Module Seven – Organization in Your Work Area
Module Eight – Tools to Fight Procrastination
Module Nine – Organizing Your Inbox
Module Ten – Avoid the Causes of Disorganization
Module Eleven – Discipline is the Key to Stay Organized
Module Twelve – Wrapping Up
Organisational Skills Training for Administrator – Activities
Receptionist
Importance of Receptionist
Different Types of Receptionist & Roles
Communication Skills for Receptionist
Telephone Skills
Listening Skills
Taking Messages
Presenting & Appearance
Reservation Procedure
Confidentiality Checklist
Being Organized as Receptionist
Becoming a Successful Receptionist
Module One – Getting Started
Module Two – The Right Attitude Starts with You
Module Three – Stress Management (Internal Stressors)
Module Four – Stress Management (External Stressors)
Module Five – Transactional Analysis
Module Six – Why are Some Customers Difficult
Module Seven – Dealing with the Customer Over the Phone
Module Eight – Dealing with the Customer In Person
Module Nine – Sensitivity in Dealing with Customers
Module Ten – Scenarios of Dealing with a Difficult Customer
Module Eleven – Following up With a Customer Once You Have Addressed Their Issue
Module Twelve – Wrapping Up
Module One – Getting Started
Module Two – Core Skills Required
Module Three – Self-Management (I)
Module Four – Self-Management (II)
Module Five – Time Management (I)
Module Six – Time Management (II)
Module Seven – Organizing and Planning (I)
Module Eight – Organizing and Planning (II)
Module Nine – Communication (I)
Module Ten – Communication (II)
Module Eleven – Additional Challenges
Module Twelve – Wrapping Up
Level 3 Diploma in Telephone Receptionist Skills – Activities
293556 Office Administration Masterclass Introduction to Office Administration
Skills of an Effective Administrator
Business Writing Skills
Communication Skills
Managing Meetings and Giving Feedback
Organisational Skills
Telephone Etiquette
Negotiation Techniques
Conflict Management
Stress Management
Time Management
169757 Office Business Contact Manager 3 Certified Training Getting Started
Using Business Contact Manager
Working with Business Contact Manager Data
Getting Help in Business Contact Manager
Accounts
Business Contacts
Opportunities
Business Projects and Project Tasks
Communications History and Linking
Using the Dashboard
Information Management Tools
Marketing Campaigns
Customizing Forms
95146 Office Management Diploma Module One – Getting Started
Module Two – New Hires
Module Three – It’s About Interacting and Influencing
Module Four – Dealing with Rumors Gossip and Half Truths
Module Five – Office Personalities (I)
Module Six – Office Personalities (II)
Module Seven – Getting Support for Your Projects
Module Eight – Conflict Resolution
Module Nine – Ethics
Module Ten – You Are Not an Island
Module Eleven – Social Events Outside of Work
Module Twelve – Wrapping Up
Office Management Diploma – Activities
Mock Exam- Office Management Diploma
Final Exam- Office Management Diploma
208155 Online Accredited Nursery Nurse Course Introduction to Nursery
What is a Nursery Nurse
The Importance of Learning in Early Years
Why is Learning Important?
Key Benefits of Early Childhood Learning
Parent Involvement in Early Childhood Learning
How Education Affects Early Years Development
Qualities of an Early Childhood Teacher
The Early Years Framework
A Fair and Flexible Framework
Regulation and Legislation in Early Learning and Development
Requirements of the Learning and Development
The Early Learning Goals
Characteristics of the Effective Learning
Understanding Your Child’s Needs and Behaviour
Raising Caring Children
Child Development Theories
Cognitive Development
Emotional Development
Social Development
Early Learning Activities
Activities for Everyday Brain Development and Building
Children’s Health and Nutrition
95447 Online Adult Care Training Certificate Introduction To Guide To Dealing And Caring Elderly
Caring For Elderly Parents or Relatives While Keeping Your Money
How To Handle Bad Behaviour Problems By Elderly Parents
Effective Caring For Your Elderly Relative’s: Home Help
Going To A Better Place
Listening To Your Parents Even Now
Way To Improve Quality Of Life For Your Senior
The Basics Of Caring For The Elderly: Pressure Sores
The Golden Rule Of Caring For The Elderly Revealed!
The Greatest Loss Of Them All
Watching Your Step: Avoiding And Dealing With Falls Whilst Caring For The Elderly
Adult Care in Different Life Stages
Caring For The Elderly- A Stressful Job
4 Most Common Ailments Affecting The Elderly
Top Outdoor Elderly Activities
Safeguarding The Health Of The Elderly
Taking Care Of Yourself As Well As The Elderly: Vacation And Respite
The Caregiver’s Enemy No.1
Recommended Reading: Online Adult Care Training Certificate
Mock Exam – Online Adult Care Training Certificate
Final Exam – Online Adult Care Training Certificate
199114 Online Animal Psychology Diploma AP Promo Video
About the Course
Introduction to Animal Psychology
The Evolution of Pets
Exercise Lesson 1
Dealing with Dogs
Behaviour in Dogs
Psychology of Dogs
Aggression in Dogs
Exercise Lesson 2
Dealing with Cats
Behaviour in Cats
Aggression and Cats
Psychology of Cats
Exercise Lesson 3
About Rabbits
Behaviour of Rabbits
Exercise Lesson 4
Final Test Preparation
Thank you and Good bye
Resources – Animal Psychology
Mock Exam – Online Animal Psychology Diploma
Final Exam – Online Animal Psychology Diploma
203814 Online Basic Accounting and Finance Course Chris Moore – Accounting for Beginners Promo
Chris Moore – 1. Introduction
Chris Moore – 2. First Transactions
Chris Moore – 3. T Accounts introduction
Chris Moore – 4. T-Accounts conclusion
Chris Moore – 5. Trial Balance
Chris Moore – 6. Income Statement
Chris Moore – 7. Balance Sheet
Chris Moore – 8. Balance Sheet Variations
Chris Moore – 9. Accounts in practise
Chris Moore – 10. Balance Sheets what are they
Chris Moore – 11. Balance Sheet Level 2
Chris Moore – 12. Income Statement Introduction
Chris Moore – 13. Are they Expenses, or Assets
Chris Moore – 14. Accounting Jargon
Chris Moore – 15. Accruals Accounting is Fundemental
Chris Moore – 16. Trial Balance 3 days ago More
Chris Moore – 17. Fixed Assets and how it is shown in the Income Statement
Chris Moore – 18. Stock movements and how this affects the financials
Chris Moore – 19. Accounts Receivable
Chris Moore – 20. How to calculate the Return on Capital Employed
Chris Moore – 21. Transfer Pricing – International Rules
Assignment – Online Basic Accounting and Finance Course
209063 Online Business Marketing Module 01: Marketing Your Business
Module 02: Our Marketing Plan
Module 03: Low-cost Marketing Techniques
Module 04: Developing Your Brand
Module 05: Your Website
Module 06: Social Media and Online Marketing
Module 07: Public Relations and Advertising
Module 08: Sales
Mock Exam – Online Business Marketing
Final Exam – Online Business Marketing
230154 Online CBT (Cognitive Behavioural Therapy) Course CBT Eating Disorders Promo
About the Tutor
About the Course
What is CBT (the CBT model)
NICE guidelines
The therapeutic alliance, Trust and Empathy
Ethics of the therapy
Eating disorders: Categorisations
Core Psychopathology of Eating Disorders
Co-morbid psychiatric illness
Social and Family factors
Cognitive factors
Emotional Intelligence
First session – Assessment
Dietary and Nutritional issues
Setting Goals with the client
Motivational factors
Working with Anxiety
The Socratic approach (Socratic questioning)
Psychoeducation
The ‘Exposure’ technique
Working with Beliefs (shape, weight, food)
Behavioural Experiments
Designing and Reviewing Action plans
Concluding therapy successfully
Follow up and Relapse Prevention
Thank you and Good Bye!
Resources – Online CBT (Cognitive Behavioural Therapy) Course
Mock Exam – Online CBT (Cognitive Behavioural Therapy) Course
Final Exam – Online CBT (Cognitive Behavioural Therapy) Course
260512 Online Cupcake and Baking Course Introduction
Meeting Clients/Establishing Requirements for Jobs
Supplies and Equipment Needed
Pricing, Ingredients & Budgeting
Cupcakes & Muffins
Birthday Cakes
Wedding Cakes
Baking
Icing & Working with Chocolate
Cake Decorating
Creating Stands and Displays
Cake Transportation
Photographing your Cakes
Running Your Own Business
Marketing and Social Media
The Do’s and Don’ts & What to Do When Things Don’t Go to Plan
Accounting, VAT, Tax, Insurance and Record Keeping
Hiring Staff and Providing Sufficient Training
Mock Exam – Online Cupcake and Baking Course
Final Exam – Online Cupcake and Baking Course
250093 Online Deep Tissue Massage Basic to Advance Course Massage Intro to Course
Massage Tables-The 4 Most Important considerations
Creams and Oils-Whats Great and whats not
The Set up-Dont do what i did
This factor makes a huge difference
It’s all in the timing
Contraindications of Massage, intake forms and more
Why i Don’t include these things in my massages
Do no Harm
The Perfect Person to Practice your massage on
Why Most Therapists don’t last!
Now is the time to put the time in
Some Final Points
Putting it all together
General Stroke
Kneading
Scissor Stroke
Acupressure Techniques
Forearms
Massage Start Sequence
Back Sequence 1
Back Sequence 2
Back of Legs
Legs Prone Stretching
Neck
Arms
Front of Legs
Front of Legs Stretching
Full Body Massage Sequence
326461 Online Diploma Course in Baking and Cake Decorating Basic Concepts of Baking
Basic Ingredients of Baking
Glossary and Equipment Used in Baking
Types of Cakes
Baking the Cake
Baking Principles
Cake Decorating Recipes
Cake Decorating Ideas
Frosting and Icing
Working with Different Pastes
Working with Glazes
How to Stack a Cake
Piping and Writing
Health, Safety and Food Hygiene
Troubleshooting
Cake Decorating Business
Assignment – Baking & Cake Decorating Online Diploma Course
224817 Online Emergency First Aid Course for Workplace and Home bundle course Introduction to Workplace First Aid
Legal Framework for Workplace First Aid
Incident Management at Work
Primary Survey
Secondary Survey
Basic First-Aid Techniques
Dealing with Minor Injuries at the Workplace
Secondary Illness Loss of Responsiveness and CPR
Secondary Illness Breathing Problems
Secondary Illnesses and Injuries
Dealing With Fractures and Dislocations
Call for an Emergency
Introduction and Primary Assessment
Emergency, First Aid and Safety Procedures
Cardiopulmonary Resuscitation (CPR)
Injuries, Illness and Treatments: I
Injuries, Illness and Treatments: II
Injuries, Illness and Treatments: III
Injuries, Illness and Treatments: IV
Injuries, Illness and Treatments: V
The Aim of First Aid
The Secondary Survey
Treating Secondary Injuries
Resuscitation (CPR)
Secondary Illnesses and Conditions
Additional Secondary Illnesses and Conditions
Order your Certificate
230224 Online Emergency First Aid Training: Workplace and Home Bundle Introduction and Primary Assessment
Emergency, First Aid and Safety Procedures
Cardiopulmonary Resuscitation (CPR)
Injuries, Illness and Treatments: I
Injuries, Illness and Treatments: II
Injuries, Illness and Treatments: III
Injuries, Illness and Treatments: IV
Injuries, Illness and Treatments: V
The Aim of First Aid
The Secondary Survey
Treating Secondary Injuries
Resuscitation (CPR)
Secondary Illnesses and Conditions
Additional Secondary Illnesses and Conditions
Order your Certificate
249890 Online Forensic Science Criminology & Profiling Course Introduction: About the Course and the Tutor
History of development of Forensic Psychology
Research Design and Methodology
Critical evaluation of psychological research
Introduction to Criminology
Classification of Crimes
Understanding Crime
Different Types of Crime
Introduction to theories of offending
Theories of sexual offending
Theories of violent offending
Theories of fire-setting behaviour
Personal characteristics of offenders
Personality disordered offenders
Psychopathic offenders
Mental Illness and offending
An Introduction to Offender Profiling
Approaches to Offender Profiling
The Effectiveness of Offender Profiling
Eye-witness testimony
Expert witness testimony
Attitudes towards victims

Interventions to reduce risk of re-offending
Incident management (Crisis Negotiation)
224826 Online HR & Payroll Diploma with MS Excel Course Introduction to Human Resources
Employee Recruitment and Selection Procedure
Employee Training and Development Process
Performance Appraisal Management
Employee Relations
Motivation and Counselling
Ensuring Health and Safety at the Workplace
Employee Termination
Employer Records and Statistics
Essential UK Employment Law
Introduction to Payroll Management
An Overview of Payroll
Running the payroll – Part 1
Running the payroll – Part 2
Manual payroll
Benefits in kind
Computerised systems
Total Photo scenario explained
Brightpay conclude
Find software per HMRC Brightpay
Add a new employee
Add 2 more employees
Payroll settings
Monthly schedule – Lana
Monthly schedule – James
Directors NI
Reports
Paying HMRC
Paying Pensions
RTI Submission
Coding Notices
Journal entries
Schedule
AEO
Payroll run for Jan & Feb 2018
Leavers – p45
End of Year p60
Installing Brightpay
PAYE TAX
NI
Pensions
Online calculators
Payslips
Journal entries
Conclusion and Next Steps
Mock Exam – Online HR & Payroll Diploma with MS Excel Course
Final Exam – Online HR & Payroll Diploma with MS Excel Course
Order your Certificate
Human Resource Management
HR Planning, Recruitment and Selection
Induction, Training and Development
HR Department’s Responsibilities
Organisational Culture
Motivation, Counseling, Resignations and Retirement
Performance Appraisal
Remuneration Policy
Records and Statistics
Industrial Relations
Introduction to the Course and Instructor
An Overview of Payroll
Running the payroll – Part 1
Running the payroll – Part 2
Manual payroll
Benefits in kind
Computerised systems
Total Photo scenario explained
Brightpay conclude
Find software per HMRC Brightpay
Add a new employee
Add 2 more employees
Payroll settings
Monthly schedule – Lana
Monthly schedule – James
Directors NI
Reports
Paying HMRC
Paying Pensions
RTI Submission
Coding Notices
Journal entries

AEO
Payroll run for Jan & Feb 2018
Leavers – p45
End of Year p60
Installing Brightpay
PAYE TAX
NI
Pensions
Online calculators
Payslips
Conclusion and Next Steps
Tax System in the UK
The Requirements
The Timeline
Planning Checklist
Getting & Providing Support – Things to Consider
Changes ahead for accounting firms
Conclusion and Next Steps
Logging into the HMRC System
Fill in the Self Assessment Return
Viewing the Calculation
Submitting the Assessment
Conclusion
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 Formats
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
250131 Online Interior Design Course – Design Principles & Elements Introduction to Chapters
Introduction & Design Recipe
Element_Line
Element_Shape
Element_Form
Element_Colour
Element_Texture
Element_Space
Element_Value
Principles_Pattern
Principles_Contrast
Principle_Emphasis & Focal Point
Principle_Balance
Principle_Scale Proportion
Rhythm/Movement
Principle_Harmony
DPE_Conclusion
250347 Online Life Coaching and NLP Course Module 01: Introduction to Life Coaching
Module 02: History of Life Coaching
Module 03: Listening as a Coach
Module 04: The Language of Coaching
Module 05: Coaching as a Developmental Change Process
Module 06: Empowering the Client
Module 07: Ethics in Coaching
Module 08: Becoming an Effective Leader and Coach
NLP Lesson 1 – Introduction, Cause and Effect
NLP Lesson 2 – The Map is Not the Territory
NLP Lesson 3 – Sensory Acuity
NLP Lesson 4 – Rapport
NLP Lesson 5 – Representational Systems
NLP Lesson 6 – Anchoring
NLP Lesson 7 – State Elicitation
NLP Lesson 8 – Language Patterns
NLP Lesson 9 – Language Patterns 2
NLP Lesson 10 – Chunking
Order your Certificate
224791 Online Microsoft Office Beginner to Advanced Bundle Course with Lifetime Access 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 Formats
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
Check Accessibility
Save a Document to Other Formats
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
Format 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 Access
Create a Simple Access Database
Cover Your Assets And Your Customers
Modify Table Data
Sort and Filter Records
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query
Basic Knowledge on Billings
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
Navigate the Outlook Interface
Perform Basic E-mail Functions
Use Outlook Help
Create an E-mail Message
Check Spelling and Grammar
Format Message Content
Attach Files and Items
Enhance an E-mail Message
Manage Automatic Message Content
Customize Reading Options
Work with Attachments
Manage Your Message Responses
Manage Messages Using Tags, Flags, and Other Commands
Organize Messages Using Folders
View the Calendar
Manage Appointments
Manage Meetings
Print Your Calendar
Create and Update Contacts
View and Organize Contacts
Create Tasks
Manage Tasks
Manage Notes
Customize the Outlook Interface
Create and Manage Quick Steps
Order your Certificate
107989 Online Nannying and Childcare from Beginner to Expert What is a Nanny?
Time Management for Nannies
A Day in the Life of Martha, the Nanny
Caregiver and Team Player
It Takes a Village to Raise a Child
The Nanny’s Job Profile
Meet the Needs of the Child
Child Care Guidelines
Outdoor Safety
Plants That Poison
Guidelines for Food Preparation and Handling
Changing Diapers
Symptoms of Illness
Baby Products For Bath
Tips To Manage Your Baby Sleeping Schedules
Baby Weaning Difficulties And Tips To Cope With It
Choosing The Right Baby Care
Choosing The Right Baby Formula
Coping With Colic
Diaper Rash Help
Feeding Schedules Tips to Get it Right
How To Get Rid Of A Pacifier
Premature Baby Help
Reading To Baby
Reducing Baby’s Risk Of Choking
Safety Measures For Food Borne Illnesses
The Benefits of Breastfeeding
Why Do Babies Cry
Baby Car Seat Buying Tips
When You Spot Something Wrong
Baby Care and Breastfeeding
Baby Care And Television
Baby Hazards: Be Careful Or You May Not Know
Baby Pacifiers: Yes Or No
What’s In The Nursery
Baby Bathing Is This Hard To Do
5 Things To Keep In Mind With Baby Care
Babies At Work Good Or Bad
Bonding Time With My First Baby
Communicating With My First Baby
Fashion Tips For My First Baby
How To Change My First Baby’s Diaper
My First Baby Essentials
My First Baby Feeding Guide
My First Baby Learning The Basics
My First Baby: Understanding The Crying Game
Nutritious Bites For My First Baby
The Joys And Angst Of Holding My First Baby
Mock Exam – Online Diploma in Nannying and Childcare
Final Exam – Online Diploma in Nannying and Childcare
249308 Online Nutrition Course Module 01: Introduction to Nutrition
Module 02: Nutrients for Life – Nutrients for Life Macronutrients
Module 03: Nutrients for Life – Micronutrients
Module 04: Nutrition Requirements from Pregnancy to Teenage
Module 05: Nutrition Requirements for Adults and Various Groups
Module 06: Healthy Dieting
Module 07: Eating Disorders
Module 08: Diet and Nutrition Related Diseases
Module 09: Use of Nutrition in Different Illnesses/Diseases
Module 10: Weight Control Management
Module 11: Weight Loss Management
Module 12: Basics of Ketogenic Diet
Module 13: The Role of Nutritionist
230218 Online Paediatric First Aid Training – CPD Accredited Module 01: Aim of First Aid and the First Steps
Module 02: Resuscitation (CPR)
Module 03: Secondary Assessment, The Recovery Position And Shock
Module 04: Head and Eye Injuries, Fractures, and Amputation
Module 05: Choking, Wounds, Bleeding & Burns
Module 06: Secondary Conditions and Reactions I
Module 07: Secondary Conditions and Reactions II
Module 08: Chronic Conditions
Module 09: Medical Emergencies – Poisoning, Smoke inhalation, Hypothermia, Elect
Order your Certificate
238536 Online Personal Trainer Course Course Promo
Alternative Promo
Introduction & What You Will Learn
Get To Know Your Instructor
How to Get Your Certificate
The Roles & Responsibilities Of A Fitness Coach
Anatomy Introduction
Nervous System
Bones & Joints
Muscular System
The 2 Types Of Muscle Fibers
Muscle Contractions Explained
Muscle Agonist & Anatagonist
Cardiovascular System
Client Assessment Intro
The Client Interview
Fitness Assessment
Harvard Step Test
Strength Test: How To Estimate Your 1 Rep Max
Resistance Training Overview
Bodyweight Training vs Weight Training
Bodyweight Fundamentals
Muscle Building Formula
Fat Loss Formula
Hypertrophy Explained: The 3 Types Of Muscle Growth
Weight Training Fundamentals
Progressive Overload
How To Create The Perfect Resistance Training
The 4 Fundamental Exercises For Muscle Growth
How To Warm Up Before Lifting Weights
Bench Press
Squats
Deadlift
Overhead Press / Military Press
Barbell Row
Pull-Up 2
Push-Ups
Bodyweight Squat
Lunges
Pull-Up 2
Cardio Introduction
The Different Types Of Cardio
Creating The Right Cardio Workout
How To Measure Heart Rate During A Workout
Weight Loss Exercising Myths
Cardio vs Weight Training – Which Is Better For Weight Loss
Cardio For Weight Loss
HIIT Explained
Hiit Workout
How To Warm Up Correctly
Flexibility Introduction
Most Common Stretching Mistakes
Static vs Dynamic Stretching
Sample Stretching Routine
238454 Online Photography Course Is It Art
A Brief History Of Photography
The Great Debate
Activities
Introduction
The Ordered Universe
Beauty Detector
Let There Be Light
The Photographer’s Playground
Activities
Introduction
Seeing The Light
Hard Light
Soft Light
Colour Temperature
Activities
Introduction
Working The Scene
Moving Your Feet
Moving Your Subject
Move Your Light
Activities
Introduction
Your Camera
The Three Levers
ISO
The Shutter
The Aperture
Activities
Introduction
The Digital Darkroom
Lightroom Edit
Snapseed Edit
Activities
Introduction
The Language Of Composition
The Subject
The Environment
Leading The Eye
Evoking Emotion
Symmetry
Activities
Introduction
The Rule Of Thirds
Leading Lines
The Highest Point Of Contrast
Activities
Introduction
Adventures In Color
Hue, Saturation, Luminosity
The Color Wheel
Working With Color
Simple Color Edit
Activities
Introduction
Why Black And White
King Luminosity
A Zone System
Seeing In Black And White
A Simple Black And White Edit
Activities
Introduction
In The Frame
Isolating The Subject
Negative Space
Introduction
Abstract Images
Seeing Like An Architect
Strong Visual Elements
Activities
Introduction
The In Between Moments
The Eyes
Body Language And Gesture
Activities
Introduction To Finding Yourself As A Photographer
Creating An Image
Creating A Style
Framing Your Subject
Creating A Series
Creating A Body Of Work
Sharing Your Work
Introduction To Natural Light Portrait Photography
Finding Your Light
Hard Light And Soft Light – A Recap Of The Basics
Outside Soft Light
Inside Soft Light
Outside Hard Light
Inside Hard Light
Finding Your Background – Simple Backgrounds
Finding Your Background – Complex Backgrounds
Posing Your Subject – A Refresher
Projects For Natural Light Photography
Introduction To Home Based Photography Studio
Finding Your Studio Location
Camera Choices
Lens Choices
Equipment List
Additional Studio Equipment
Additional Studio Equipment
Finding Clients For Your Business
Recording Your Floor Plans
Dealing With The Public
Activities For Home Based Photography Studio
Introduction To Classic Studio Portrait Photography
Open Loop Lighting
Closed Loop Lighting
Butterfly Lighting
Split Lighting
Short Lighting
Broad Lighting
Rembrandt Lighting
Studio Backdrops
Preparing The Subject
Choosing The Facial Angle
Posing The Body
Body Poses And Posture
Body Poses – The Light Pose For Males
Body Poses – The Shadow Pose For Females
Group Shots – Basic Core Principles
Non Standard One Light Techniques
Non Standard One Light Techniques
Two Light Techniques
Couples Shots – Basic Core Principles
Black And White Portrait Tips – A Refresher
Lens Choices In The Studio
Classic Studio Course Activities
Introduction to Modern Studio Portrait Photography
Introduction to Modern Studio Portrait Photography
Studio Lighting Buying Tips
Strobe Modifers Explained
Three Light Techniques
Four Light Techniques
Hollywood Lighting- Advanced Lighting
Modern Studio Photography Activities
83582 Online Photoshop Training Level 2 Photoshop Interface Layout
Know the Tools
Palettes
How to Steps for Common Task
Using the Layers Panel
Color Correction, Enhancement & Adjustment
Adobe Photoshop Elements
Mock Exam – Online Photoshop Training Level 2
Final Exam – Online Photoshop Training Level 2
249621 Online Shiatsu Massage Course for Beginner Introduction
Before we get started
It’s time to learn the techniques
Proper technique is vital
How to apply pressure
Palming techniques
Rocking technique
Using your thumbs
Using your feet
Using your elbows
Stretching
Let’s get started
The back
The buttocks, legs and feet
Let’s get started face up now
The legs
The chest
The chest
The neck and head
The whole back of body sequence to music
Now the front
Adding advanced techniques
Knees
Stretching techniques
Using your feet
Congratulations
238474 Online Spanish Course For Beginners Introduction
Lesson 1a
Lesson 1b
Lesson 1c
Lesson 1d
Lesson 2a
Lesson 2b
Lesson 2c
Lesson 2d
Lesson 2e
Lesson 3a
Lesson 3b
Lesson 3c
Lesson 3d
Lesson 3e
Lesson 3f
Lesson 4a
Lesson 4b
Lesson 4c
Lesson 4d
Lesson 4e
Lesson 4f
Lesson 4g
Lesson 4h
Lesson 5a
Lesson 5b
Lesson 5c
Lesson 5d
Lesson 5e
Lesson 5f
Lesson 5g
Lesson 5h
Lesson 5i
Lesson 5j
Lesson 5k
Lesson 6a
Lesson 6b
Lesson 6c
Lesson 6d
Lesson 6e
Lesson 6f
Lesson 6g
Lesson 7a
Lesson 7b
Lesson 7c
Lesson 7d
Lesson 7e
Lesson 7f
Lesson 7g
Lesson 7h
Lesson 8a
Lesson 8b
Lesson 8c
Lesson 8d
Lesson 8e
Lesson 8f
Lesson 8g
Lesson 8h
Lesson 8i
Lesson 8j
Lesson 8k
Lesson 9a
Lesson 9b
Lesson 9c
Lesson 9d
Lesson 9e
Lesson 9f
Lesson 9g
Resources: Beginners Spanish Course
Assignment – Online Spanish Course For Beginners
Feedback Form
Order your Certificate
202452 Online Sports Massage Certificate Course Introduction to Sports Massage
Working as Sports Massage
Understanding Anatomy
Phases of Injury
Athlete History
Treatment Modification
Specific Treatments
Further Education
Mock Exam – Online Sports Massage Certificate Course
Final Exam – Online Sports Massage Certificate Course
82528 Online Teaching Diploma Level 3 Understanding the Development of Children and Young Person
Communication and Professional Relationships with Pupils and Family
Safeguarding the Welfare of Children and Young Person
Teaching in the UK
Teachers’ Standards in UK
Teachers Pay
The English School System
Evaluation of Schools and Teachers
School Governance
Inclusive Teaching
Chapter I
Chapter II
Chapter III
Chapter IV
Chapter V
Chapter VI
Chapter VII
Chapter VIII
Chapter IX
Chapter X
Chapter XI
Chapter XII
Chapter XIII
Chapter XIV
Chapter XV
WHY YOUNG PEOPLE DO NOT LEARN TO STUDY PROPERLY?
THE NATURE OF STUDY, AND ITS PRINCIPAL FACTORS
PROVISION FOR SPECIFIC PURPOSES, AS ONE FACTOR OF STUDY
THE SUPPLEMENTING OF THOUGHT, AS A SECOND FACTOR OF STUDY
THE ORGANIZATION OF IDEAS, AS A THIRD FACTOR IN STUDY
JUDGING OF THE SOUNDNESS AND GENERAL WORTH OF STATEMENTS, AS A FOURTH FACTOR IN STUDY
MEMORIZING, AS A FIFTH FACTOR IN STUDY
THE USING OF IDEAS, AS A SIXTH FACTOR IN STUDY
PROVISION FOR A TENTATIVE RATHER THAN A FIXED ATTITUDE TOWARD KNOWLEDGE, AS A SEVENTH FACTOR IN STUDY
PROVISION FOR INDIVIDUALITY, AS AN EIGHTH FACTOR IN STUDY
FULL MEANING OF STUDY: RELATION OF STUDY TO CHILDREN AND TO THE SCHOOL
Introduction to Special Educational Needs (SEN)
Understand Constructivism in the Classroom and know your role as a teacher
SEN Code of Practice
Get an understanding on SENCO
Classroom Management Strategies for Children with Special Needs
Physical Difficulties, Sensory Difficulties, Cognitive Impairments of Pupils
How to Deal with Pupils with Autism
Understanding Learning Difficulties
Anger Management Methods for Pupils With Special Needs
Teaching Children with Down Syndrome
Conclusion SEN
What is ADHD?
Causes of ADHD
Diagnosing ADHD
Treating ADHD
ADHD and Education
Reasonable Adjustments: ADHD
Adults with ADHD
STRATEGIES FOR TEACHING FIRST-YEAR COMPOSITION
TEACHING AND LEARNING STAATEGIES FOR THE THINKING CLASSROOM
Mock Exam- Online Teaching Diploma Level 3
Final Exam- Online Teaching Diploma Level 3
199660 Online TESOL Certificate – 120 Hours Course Introduction to Teaching English
Linguistics Basics
Teaching Speaking
Teaching Listening
Teaching Reading
Teaching Writing
Planning Pedagogy
Planning Lessons
Managing Classrooms
Getting a job
Mock Exam – Online TESOL Certificate – 120 Hours Course
Final Exam – Online TESOL Certificate – 120 Hours Course
256304 Online Video Marketing: Important Tips & Strategies Introduction Video
What is Video Marketing All About
Planning a Successfull Video Marketing Strategy
Creating Your Marketing Video Step by Step for Your Video Marketing Campaigns
Uploading Your Video To the Right Places for your Video Marketing Campaigns
Advertising Your Videos The Free Way for Video Marketing Campaigns
Advertising Your Videos The Paid Way for Video Marketing Campaigns
Running a Successful Video Marketing Campaign with YouTube
Running a Successful Video Marketing Campaign with Facebook
Running a Successful Video Marketing Campaign with Twitter
Running a Successful Video Marketing Campaign with Snapchat
Advanced Video SEO For Your Video Marketing Efforts
Video Marketing – Going Live Like A Pro
Popular Video Metrics You Should Track in Your Video Marketing Strategy
Using the Flywheel Model in your Video Marketing
Advanced Video Marketing On Social Media
Outsourcing Your Video Marketing The Right Way
Video Marketing Do’s And Don’ts
Video Marketing Tools and Services to Consider
Video Marketing Success Stories
Video Marketing FAQs
205454 Online Writing Course: Fiction and Children’s Story Writing Module 1 Part 1 – Getting Ideas and How to Develop Them
Module 1 Part 2 – Inspiration and Finding The Time
Module 2 – What It Means To Be A Writer
Module 3 – Characters
Module 4 – Plotting and Story Construction
Module 5 – Theme, Templates & Outlining
Module 6 – Show Don’t Tell
Module 7 – Punctuation, Grammar and some Basic Writing Rules
Module 8 – Scene Structure, Exposition and Story Rules
Module 9 – Chapter Structure, Vision and Focus
Module 10 – Fast Writing Without Fear or Censure
Module 11 – Editing, Re-writing & Polishing
Module 12 – Finishing, Submission & Publication
Introduction to Children’s Storybook Writing
Crucial Information
Keys to Success
A.I.M
Getting Ideas
Character Creation
Characters and Plotting
Planning Your Story
Storytelling
Point of View
Technical Writing Issues
Story Structure
Picture Books 1
Picture Books 2
Picture Books 3
Easy Readers
Transition Books
Chapter Books
Junior Novels
Young Adult Fiction
Dialogue
Show don’t Tell
Conclusion
270744 Online-Kurs Sicherheit von Webanwendungen Einführung und Motivation
Klassifizierte Schwachstellen Übersicht
Ursachen & Hintergründe
Sichere Programmierung allgemein
Code/Command Injection
(No)SQL Code Injection
Cross-Site Request Forgery (CSRF)
Cross-Site Scripting (XSS)
Open Redirection
File Inclusion / Directory Traversal
Clickjacking
Session-Hijacking
Information Disclosure
Authentifizierungsmechanismen
Denial of Service
Middleware
Third-Party Software
Abschluss & Zusammenfassung
262270 Onpage SEO Masterclass Introduction
On-Page SEO vs Off-Page SEO
Keyword Planner
Free Keyword Research Tool
Paid Keyword Research Tool
Website Ranking Factors
WordPress Permalink Settings
WordPress Fastest Cache Settings
WordPress Cache Speed Test
Optimize an Article
Optimize Readability
WordPress Yoast SEO Optimization Setup
Yoast Real-Time Analysis for Any Site
Real-Time Ranking Case Study
All In One SEO Plugin
Image File Size Optimization
Name and ALT SEO
JPG vs PNG
GIF Images
What is EXIF Data and How to Remove It
Captions for Conversion Optimization
Adding ALT Tags to Images
Create a Sitemap for Images
Audio SEO
Video SEO
266980 Operations Management Complete Training: Business Processes and Systems Module 01: Introduction to Operations Management
Module 02: Project Management
Module 03: Business Development and Succession Planning
Module 04: Process Management
Module 05: Supply Chain Management
Module 06: Planning & Forecasting Operations
Module 07: Procurement & Purchasing Management
Module 08: Manufacturing & Delivery Operations
Module 09: Quality Management
Module 10: Managing Risk and Recovery
Module 11: Performance Management
Module 12: Talent Management
Module 13: Communication Skills
Module 14: Negotiation Techniques
Module 15: Conflict Management
Module 16: Stress Management
Module 17: Time Management
Module 18: Business Environment
Module 19: Business Writing Skills
329998 Organic Chemistry Introduction to the Alkane Series
Conjugation and Homologous Series of the Alkane
Nomenclature of the Alkane Series
Chemistry of the Alkane Series
Relevance and Importance of the Alkene Family
Section Wrap Up
Introduction to the Alkene series
Nomenclature of the Alkene Series
Chemistry of the Alkene Series
Relevance and Importance of the Alkene Family
Section Wrap Up
Introduction to the Alkanol Series
Nomenclature of the Alkanol Series
Chemistry of the Alkanol Series
Relevance and Importance of the Alkanol Family
Section Wrap Up
Introduction to the Alkyne Series
Nomenclature of the Alkyne Series
Chemistry of the Alkene Series
Importance and Relevance of the Alkene Family
Section Wrap Up
Introduction to the Alkanals/Aldehydes and Ketones/Alkanones Family
Nomenclature Galore
Nomenclature Continued
Nomenclature Continued
2900 Organic Gardening Diploma Why Garden Organically?
Planning Your Organic Vegetable Garden
Growing Your Organic Vegetable Garden
Why Grow an Organic Herb Garden?
Growing an Organic Herb Garden
You Have Organically Grown Herbs, Now What?
Organic Garden Fertilizers
Organic Gardening Compost
Why Use Organic Pest Control?
How to Control Garden Pests Organically
How to Bring Your Organic Plants Indoors; for Easy Year Round Growth
Organic Container Gardening
Organic Hydroponic Gardening
STARTING WITH THE PLANTS
SOWING AND PLANTING
THE CULTIVATION OF VEGETABLES
THE VEGETABLES AND THEIR SPECIAL NEEDS
BEST VARIETIES OF THE GARDEN VEGETABLES
INSECTS AND DISEASES AND THE METHODS OF FIGHTING THEM
HARVESTING AND STORING
THE VARIETIES OF POME AND STONE FRUITS
PLANTING: CULTIVATION: FILLER CROPS
PRUNING, SPRAYING, HARVESTING
BERRIES AND SMALL FRUITS
CONCLUSION
Recommended Reading : Organic Gardening Diploma
Mock Exam – Organic Gardening Diploma
Final Exam – Organic Gardening Diploma
207993 Organic Skin & Body Care Online Course Module 1: Let’s Get Under Your Skin
Module 2: Your Skin and the Nutrients it Needs
Module 3: Practical Skincare Regimes for Different Skin Types
Module 4: Tips for Types – Skincare for Different Ethnicities
Module 5: Seasonal Skin Care
Module: On the Bright Side – Is the Sun Really That Bad?
Module 7: A Realistic Approach to Reducing Ageing Effects
Module 8: Treat Yourself – The Best Skin and Body Treatments
Module 9: Hair Removal Examined
Module 10: Reach Out and Touch – Hand and Foot Care
Module 11: Sleek, Fabulous Hair
Module 12: Skincare for Men
317176 Organisational Design: Know Your Organisation Personal Assistant
Admin Support
Organisational Skills
Telephone Etiquette
Business Writing
Time Management
Body Language and Effective Communication
Meeting Management
Assignment – Organisational Design: Know Your Organisation