$500.00 CAD / 1 DAYS

1) Select Location for Dates in Your City:


Choose Date

  • No available dates.

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.

No available dates.
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,

Jump to Shopping Cart Continue shopping

CLICK L2 Focused Learning

 

CLICK Level 2
Complete Learning In Computer Knowledge
WINDOWS 10 / OFFICE 2016

DAY 1, WORD L2 Part 1
SORT TABLE DATA
Sorting tables
CONTROL CELL LAYOUT
Cell merging
Cell splitting
Cell alignment
Text Direction
PERFORM CALCULATIONS IN A
TABLE
Formulas in Word
CREATE AND MODIFY TEXT
STYLES
Types of text styles
Applying styles
Custom styles
Creating a new style
CUSTOM LIST OR TABLE STYLES
Tools for list styles
Tools for table styles
APPLY AND CUSTOMIZE
DOCUMENT THEMES
Applying Document Themes
Changing the style set
Creating custom styles sets
The document formatting group
Creating custom colour schemes
Creating custom font schemes
Saving custom themes
USING IMAGES IN A DOCUMENT
Resize and image
Resizing options
Cropping images
ADJUSTING IMAGE APPEARANCE
Corrections options
Colour options
Artistic effect options
Compression tools
Background removal tool
Applying picture styles
INTEGRATE PICTURES AND TEXT
Text wrapping styles
Picture positioning options
Rotating images
Adding captions
INSERT AND FORMAT
SCREENSHOTS
INSERT VIDEO
Video links
Inserting a video
Playing a video
REVISION/LAB SESSION

 

DAY 2, WORD L2 PART 2
CREATE TEXT BOXES AND PULL
QUOTES
Types of Text Boxes
Inserting a Text Box with the Text Box
Gallery
Drawing a Text Box
The Drawing Tools – Format Contextual Tab
Applying Text Box Styles
Formatting Text Boxes
Applying Shadow and 3-D Effects
Changing Text Direction
Saving the Selection to the Text Box Gallery
Arranging Text Boxes
DRAW SHAPES IN WORD
Shapes in word
Types of shapes
The drawing canvas
Text wrapping styles
Adding text to a shape
Modifying text in a shape
Adding captions
Setting shape styles
Resizing options
Positioning options
ADD WORDART AND DROP CAPS
Word art
Drop caps
CREATE COMPLEX ILLUSTRATIONS
WITH SMARTART
SmartArt Graphics
The Choose a SmartArt Graphic Dialog Box
Adding Text and Images to the Diagram
SmartArt Graphic Categories
The SmartArt Tools Contextual Tabs
INSERTING CONTENT USING QUICK
PARTS
Quick Parts
Building Blocks
The Building Blocks Organizer Dialog Box
CONTROL PARAGRAPH FLOW
Paragraph Flow Options
INSERT SECTION BREAKS
Sections and Section Breaks
When to Use Section Breaks
Inserting a Section Break
Types of Section Breaks
Creating Section Titles
INSERT COLUMNS
Text Columns
Text Column Options
LINKED TEXT BOXES TO CONTROL
TEXT FLOW
Linked Text Boxes
Inserting Text from a File
USING TEMPLATES
Templates in Word
Creating a Document from a Template
Template Storage Locations
MAIL MERGE
REVISION/LAB SESSION

DAY 3, EXCEL L2 Part 1
USE FLASH FILL
APPLY RANGE NAMES
Range Names
Adding Range Names Using the Name Box
Adding Range Names Using the New Name
Dialog Box
Editing a Range Name, Deleting a Range
Name
Using Range Names in Formulas
USE SPECIALIZED FUNCTIONS
Function Categories
The Excel Function Reference
Function Syntax
Function Entry Dialog Boxes
Using Nested Functions
USE TEXT FUNCTIONS
Text Functions
The LEFT and RIGHT Functions
The TRIM Function
The UPPER, LOWER, and PROPER Functions
USE DATE FUNCTIONS
The TODAY Function
The NOW Function
USE FINANCIAL FUNCTIONS
The PMT Function
The FV Function
CREATE AND MODIFY TABLES
Tables
Table Components
The Create Table Dialog Box
The Table Tools – Design Contextual Tab
Styles and Quick Style Sets
Customizing Row Display
Table Modification Options
SORT AND FILTER DATA
The Difference Between Sorting and
Filtering
Sorting Data
Advanced Filtering
Filter Operators
Removing Duplicate Values
USE SUBTOTAL AND DATABASE
FUNCTIONS TO CALCULATE DATA
SUBTOTAL Functions
The Subtotal Dialog Box
Summary Functions in Tables
REVISION/LAB SESSION

DAY 4, EXCEL L2 PART 2
APPLY CONDITIONAL
FORMATTING
Conditional Formatting
Conditional Formats
The Conditional Formatting Rules Manager
Dialog Box
The New Formatting Rule Dialog Box
Clear Rules
CREATE SPARKLINES
Sparklines
Types of Sparklines
The Sparkline Tools – Design Tab
CREATE CHARTS
Charts
Chart Types
Chart Insertion Methods
Resizing and Moving the Chart
Adding Additional Data
Switching Between Rows and Columns
MODIFY AND FORMAT CHARTS
The Difference Between Modifying and
Formatting
Chart Elements
Minimize Extraneous Chart Elements
The Chart Tools Contextual Tabs
Formatting the Chart with a Style
Adding a Legend to the Chart
CREATE A TRENDLINE
Trendlines
Types of Trendlines
Adding a Trendline
The Format Trendline Task Pane
CREATE ADVANCED CHARTS
Dual Axis Charts
Creating Custom Chart Templates
Viewing Chart Animations
INSERTING GRAPHICAL OBJECTS
Inserting Shapes
Grouping Shapes
Use SmartArt
MANAGE THEMES
About Themes
Customizing Themes
CREATE AND USE TEMPLATES
Templates
Template Types
Creating a Template
Modifying a Template
REVISION/LAB SESSION

DAY 5, Outlook L2
VIEW THE CALENDAR
Types of Calendar Entries
Calendar Grid Arrangement Options
The Weather Bar
The Daily Task List
Calendar Layout Options
Overlaying Calendars with Schedule View
Deleting Calendars
MANAGE APPOINTMENTS
The Appointment Form
Creating Recurring Events
Reminders
Show As Options
The Private Option
Categorizing Appointments
Setting Appointment Priority
Searching Appointments
Forwarding Appointments
MANAGE MEETINGS
The Meeting Scheduling Process
The Meeting Form
The Scheduling Assistant
Meeting Response Options
Updating a Meeting Request
Cancelling a Meeting
Proposing a New Time for a Meeting
PRINT YOUR CALENDAR
CREATE AND UPDATE CONTACTS
Contacts
The People Workspace
The Contact Form
Linking Contact Notes to a Contact
Tagging Contacts
Secondary Address Books
Importing Contacts
Forwarding Contacts
Deleting Contacts
VIEW AND ORGANIZE CONTACTS
Electronic Business Cards
Contact Views
The People Pane
The Search People Tool
CREATE TASKS
Tasks
Task Form
Creating Recurring Tasks
Task Views
Task Options
Print Tasks
MANAGE TASKS
Searching Tasks
Assign Tasks
Tagging Tasks
Marking a Task as Complete
Moving Tasks
MANAGE NOTES
Notes
Note Form
Note Views
Categorizing Notes
Printing Notes
CUSTOMIZE THE OUTLOOK
INTERFACE
Setting General Outlook Options
Customizing Quick Access Toolbar Buttons
Moving the Quick Access Toolbar
Minimizing the Ribbon Interface
Customizing the Ribbon
Resetting Customizations
REVISION/LAB SESSION

NAVIGATE POWERPOINT’S
INTERFACE
What is PowerPoint?
The Start Screen
The PowerPoint 2016 User Interface
The Ribbon
The Slides Pane
CREATE AND SAVE A POWERPOINT
PRESENTATION
The Default PowerPoint Presentation
Text Placeholders
The AutoCorrect Feature
USE HELP
Using Tell me
SELECT A PRESENTATION TYPE
Templates
The Open Category in Backstage View
BUILD A PRESENTATION
Insert a Slide Layout
Insert Slides from an Outline
Reuse Slides from a Presentation
Reuse Slides from a Slide Library
Duplicate Slides
Hide and Show Slides
Delete Slides
LAY OUT A PRESENTATION
Slide Layout
Types of Slide Layouts
Slide Size
Themes
Theme Variants
Theme Components
Background Styles
The Format Background Task Pane
EDIT TEXT
Text Boxes
Text Selection Methods
Cut, Copy, and Paste Options
The Paste Special Command
VIEW AND NAVIGATE A
PRESENTATION
Presentation Views
Color View Options
The Slide Show View
Slide Show Options
The Slide Navigator
Presenter View
The Protected View
FORMAT CHARACTERS
Character Formats
The Font Dialog Box
Create WordArt
The Format Painter
The Replace Fonts Option
FORMAT TEXT BOXES
Text Box Formatting Options
Shape Fills
Shape Outlines
Shape Effects
Set the Default Text Box
REVIEW/LAB SESSION

DAY 7, POWERPOINT L2 Part 2
INSERT IMAGES
Local Pictures
Online Pictures
The Photo Album Feature
The Screenshot Tool
Image Cropping
The Picture Tools – Format Tab
INSERT SHAPES
Insert Shapes
The Drawing Tools – Format Contextual Tab
Resizing Shapes
Customize Shape Fill, Outline, and Effects
The Merge Shapes Feature
FORMAT SHAPES
Object Selection Methods
GROUP AND ARRANGE OBJECTS
ANIMATE OBJECTS
Built-In Animation Effects
The Animation Painter Feature
APPLY TRANSITIONS
Transitions
Apply Transitions
Set Effect Options
Customize Transition Timing
Add a Sound
Preview Transitions
ADD AUDIO TO A PRESENTATION
Adding Audio
Audio File Formats
The Audio/Video Controls
The Audio Tools Contextual Tabs
The Trim Audio Dialog Box
ADD VIDEO TO A PRESENTATION
Adding a Video From a File
Adding a YouTube Video
Video File Formats
The Video Tools Contextual Tabs
INSERT MICROSOFT EXCEL
WORKSHEETS INTO POWERPOINT
PRINT YOUR PRESENTATION
The Print Command
Printing Selected Slides
Full Page Slides
Handouts
Outlines
CREATE AND MANAGE SECTIONS
Creating Sections
Moving Slides and Sections
Deleting Sections
Modify Slide Masters and Slide Layouts
SLIDE MASTERS
The Slide Master Tab
Custom Slide Layouts
Adding Background Images
Custom Themes
REVIEW/LAB SESSION

DAY 8, Windows Intermediate, PDFs, Adobe Reader and Outlook
WINDOWS 10 INTERMEDIATE
THE SETTINGS WINDOW
OPENING THE SETTINGS WINDOW
CHANGING THE SIZE OF SCREEN ITEMS
CHANGING THE ORIENTATION
CHANGING THE BRIGHTNESS
CHANGING THE RESOLUTION
WORKING WITH MULTIPLE MONITORS
THE CONTROL PANEL
Opening the Display Sub-Category
Changing the Text Size
Changing the Resolution
Working with Multiple Monitors
WORK WITH VIRTUAL DESKTOPS
CREATING A NEW DESKTOP
SWITCHING DESKTOPS
MOVING APPS BETWEEN DESKTOPS
CLOSING DESKTOPS
WORD
Export a Word file as a PDF
Open a PDF in Word
Possible discrepancies of backwards
compatibility
ADOBE READER
Opening a PDF in Adobe Reader
How to use Adobe Reader
Exploring the toolbar
Exploring the Page Thumbnail panel
Finding specific text in a PDF
Using Advanced Search
Adding Sticky notes in a PDF
Highlight text in a PDF
Using the Comment pane
Using the Zoom tools
Saving changes to a PDF
EXPORTING A PDF
Export an Excel file as a PDF
Export a PowerPoint file as a PDF
OUTLOOK
Creating a New Email
Formatting text in an email
Attaching a Word document to an email
Attaching multiple files to an email
Attaching a PDF to an email
REVIEW/LAB SESSION

DAY 9, PRACTICE SKILLS
OPTION 1: PRACTICE RESEARCH, MEMORY AND CRITICAL THINKING SKILLS
WORD PRACTICE
Modify Page Layout
Modify Lists
Customize a Table and Chart
Format a picture
Use Graphics
Create and apply Custom Styles
Perform a Mail Merge
EXCEL PRACTICE
Work with Basic and Math Functions
Create and use Named Ranges
Calculate Across Worksheets
Sorting, Filtering and Subtotals
Work with Excel Charts
Conditional Formatting
POWERPOINT PRACTICE
Work with Slides
Apply Transitions and Animation
Create a Template
OPTION 2: FINISH INCOMPLETE ACTIVITIES
If there are any activities that were not completed or started, take this opportunity to finish
them.
OPTION 3: REPEAT THE ACTIVITIES
If you have completed all the activities, and you have started the Word and Excel practice files,
but those files feel like a knowledge overload, then download the Activities and repeat them.
Focus on areas of interest to you and/or areas where you feel you can improve.

Day 10, PRACTICE SKILLS COMPLETION & POWERPOINT PROJECT
MORNING – COMPLETION OF PRACTICE SKILLS FILES, FINISHING
INCOMPLETE ACTIVITIES OR REPEATING ACTIVITIES
WORD PRACTICE
Modify Page Layout
Modify Lists
Customize a Table and Chart
Format a picture
Use Graphics
Create and apply Custom Styles
Perform a Mail Merge
EXCEL PRACTICE
Work with Basic and Math Functions
Create and use Named Ranges
Calculate Across Worksheets
Sorting, Filtering and Subtotals
Work with Excel Charts
Conditional Formatting
POWERPOINT PRACTICE
Work with Slides
Apply Transitions and Animation
Create a Template
OPTION 2: FINISH INCOMPLETE ACTIVITIES
If there are any activities that were not completed or started, take this opportunity to finish
them.
OPTION 3: REPEAT THE ACTIVITIES
If you have completed all the activities, and you have started the Word and Excel practice files,
but those files feel like a knowledge overload, then download the Activities and repeat them.
Focus on areas of interest to you and/or areas where you feel you can improve.
AFTERNOON – POWERPOINT PRESENTATION
Create a PowerPoint presentation between 5 – 10 slides
Must have images
Must have text boxes and shapes
Must have animations
Must have transitions