Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel & PowerPoint 2019/365 – Huge value combined course

Video Introducing this tutorial


Excel 2019 Beginner: Intro to Excel :
Intro to Excel
Essential Information for a Successful Training Experience
Course exercise files
What's New In Excel 2019
Course Overview
Overview of the Excel window
Mouse-Features
Back Stage View
Section 1 - Quiz
4 questions

Excel 2019 Beginner: Creating Workbooks :
Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working with Ranges
Module 2 - Practice Exercise
Section 2 Quiz
3 questions

Excel 2019 Beginner: Saving Workbooks :
Working with the Save and Save As Commands
File Extensions, Share, Export and Publish Files
Module 3 - Practice Exercise
Section 3 Quiz
1 question

Excel 2019 Beginner: Navigating Workbooks :
Opening a File
Working with Larger Files
Freeze Panes Option
Split Screen Option
Module 4 - Practice Exercise
Section 4 Quiz
1 question

Excel 2019 Beginner: Page Setup & Print Options :
Headers and Footers
Print Titles
Comments
Page Setup Options
Fit to Print on One Page
Printing Workbooks
Module 5 - Practice Exercise
Section 5 Quiz
3 questions

Excel 2019 Beginners: Working with Rows, Columns and Cells :
Adding and deleting rows columns and cells
Changing Column and-Row Widths
Module 6 - Practice Exercise
Section 6 Quiz
2 questions

Excel 2019 Beginners: Moving Data :
Cut, Copy and Paste
Copying Formulas
Module 7 - Practice Exercise
Section 7 Quiz
1 question

Excel 2019 Beginners: Formulas & Functions :
Overview of Formulas
Create Formulas Using Functions Part 1
Create Formulas Using Functions Part 2
Absolute Values
Module 8 - Practice Exercise
Section 8 Quiz
4 questions

Excel 2019 Beginner: Working with Sheets :
Adding Deleting and Renaming Sheets
Additional Sheet Tab Options
3 Dimensional Formulas
Module 9 - Practice Exercise
Section 9 Quiz
3 questions

Excel 2019 Beginner: Formatting Worksheets :
Formatting Cells Part 1
Formatting Cells Part 2
Formatting Numbers
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Module 10 - Practice Exercise
Section 10 Quiz
2 questions

Excel 2019 Beginner: Charts :
Creating Charts
Types of Charts
Editing Charts Part 1
Editing Charts Part 2
Using Graphics to Enhance Charts
Linking Chart Titles
Module 11 - Practice Exercise
Section 11 Quiz
2 questions

Excel 2019 Beginner: Working with Names :
Creating Range Names
Managing Names
Using Names in Formulas
Module 12 - Practice Exercise
Section 12 Quiz
1 question

Excel 2019 Beginner: Sorting and Filtering :
Remove Duplicates
Sort Data
Filter Data
Advanced Filters
Module 13 - Practice Exercise
Section 13 Quiz
1 question

Excel 2019 Beginner: Outlining and Subtotaling :
Creating an Outline
Subtotals
Module 14 - Practice Exercise
Section 14 Quiz
2 questions

Excel 2019 Beginner: Working with Views :
Arranging Files
New Window Option
Custom Views
Module 15 - Practice Exercise
Section 15 Quiz
1 question

Excel 2019 Beginner: Linking Files :
Creating Formulas Between File
Working with Links
Consolidating Data
Module 16 - Practice Exercise
Section 16 Quiz
3 questions

Excel 2019 Beginner: Advanced Formula Creation :
If Statements
VLookups
Data Validation
Formula Auditing
Module 17 - Practice Exercise
Section 17 Quiz
1 question

Excel 2019 Beginner: Pivot Tables :
Pivot Tables
Pivot Charts
Module 18 - Practice Exercise
Section 18 Quiz
1 question

Excel 2019 Beginner: Additional Excel Features :
Slicers
Goal Seeker
Text to Columns
Watch Window
Customizing Ribbons and Tabs
Module 19 - Practice Exercise
Section 19 Quiz
3 questions

Excel 2019 Beginner: Shortcuts :
Excel Shortcuts Every User Should Know

Excel 2019 Beginner: Closing :
Closing Video

PowerPoint 2019: Course Introduction :
Welcome and Overview
Essential Information for a Successful Training Experience
Course Exercise Files

PowerPoint 2019: Overview :
Navigate a PowerPoint Presentation
Overview of the Screen and Views
Exercise 1

PowerPoint 2019: Getting Started :
Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Saving a Presentation
Exercise 02
Section 24 Quiz
6 questions

PowerPoint 2019: Text and Bullet Editing Options :
Formatting Text
Working with Bullets and Numbered Lists
Exercise 03
Section 25 Quiz
4 questions

PowerPoint 2019: Adding Graphics :
Inserting Shapes
Inserting Graphics
Inserting Icons and 3D Models
Inserting Pictures
Exercise 04
Section 26 Quiz
6 questions

PowerPoint 2019: Working with objects :
Selecting Objects
Editing Objects
Formatting Objects - Part 1
Formatting Objects - Part 2
Arranging Objects
Grouping Objects
Exercise 05
Section 27 Quiz
6 questions

PowerPoint 2019: Editing pictures :
Picture Options
Cropping Pictures
Formatting Pictures
Things You Can Do with Pictures
Exercise 06
Section 28 Quiz
5 questions

PowerPoint 2019: Working with SmartArt :
Creating SmartArt
Modifying SmartArt
Creating a Flowchart using SmartArt
Exercise 07
Section 29 Quiz
3 questions

PowerPoint 2019: Working with Tables :
Creating Tables
Formatting Tables
Inserting Tables
Exercise 08
Section 30 Quiz
5 questions

PowerPoint 2019: Working with Charts :
Adding Charts
Formatting Charts
Inserting Charts from Microsoft Excel
Exercise 09
Section 31 Quiz
5 questions

PowerPoint 2019: Unlocking the Power of Masters :
Using Master Slides
Modifying Master Slides
Creating a New Master Design Template
Exercise 10
Section 32 Quiz
6 questions

PowerPoint 2019: Adding Media :
Adding Video to a Presentation
Adding Audio to a Presentation
Exercise 11
Section 33 Quiz
4 questions

PowerPoint 2019: Working with Transitions :
Applying Transitions
Transition Options
Exercise 12
Section 34 Quiz
4 questions

PowerPoint 2019: Animation :
Animating an Object
Effect Options
Working with the Animation Pane
Motion Paths
Triggers
Exercise 13
Section 35 Quiz
6 questions

PowerPoint 2019: Hyperlinks and Action Buttons :
Working with Action Buttons
Working with Hyperllinks
Exercise 14
Section 36 Quiz
5 questions

PowerPoint 2019: Slideshow Options :
Onscreen Presentation Options
Hiding Slides
Changing the order of slides
Copying slides
Slideshow Options
Exercise 15

PowerPoint 2019: Preparing a presentation for delivery :
Rehearse Timings
Recording a Presentation
Slide Show Settings
Creating a Custom Slide Show
Exercise 16

PowerPoint 2019: Exploring the Backstage Area :
Exporting options
The Backstage Area
Printing a Presentation
Exercise 17

PowerPoint 2019: Course Close :
Conclusion