Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Take your Microsoft Office presentations and spreadsheets to the next level with this Excel + PowerPoint combined course
**This course includes practice exercises and LIFETIME access**
Learn to use Microsoft Excel and PowerPoint 2019, master spreadsheets, and deliver outstanding presentations in this two-course bundle.
The Excel 2019 Course:
With this 7-hour Microsoft Excel 2019/365 course, you’ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if you’re brand new to Excel or are upgrading from an older version.
What You'll Learn:
What's new in Excel 2019
Creating workbooks
Entering text, numbers and working with dates
Navigating workbooks
Page setup and print options
Working with rows, columns and cells
Cut, Copy and Paste
Introduction to functions and formulas
Formatting in Excel, including formatting cells and numbers
Creating charts and graphs
Sorting and Filtering
Introduction to PivotTables
Logical and lookup formulas - the basics
***Exercise and demo files included***
The PowerPoint 2019 Course:
In this in-depth PowerPoint 2019 course, we not only teach you through the most business-relevant PowerPoint techniques, you then get to put into practice what you learn through exercises at the end of each chapter.
This PowerPoint 2019 course will help you:
Utilize templates to improve your efficiency
Create professional looking presentations using PowerPoint's new Icons function
Include multi-media to take your presentations up a notch
What You'll Learn:
How to navigate around PowerPoint
Presentation dos and don'ts
Text and bullet edition options
How to use graphics, images, objects and shapes
Using SmartArt
Working with Charts and Graphs
How to utilize Master Slides and just how much time this could save you
How to add audio and video to a presentation
All about transitions between slides
Animation, the animation pane and motion paths
Setting your slideshow options
Presentation preparation and delivery
The backstage area of PowerPoint including printing a presentation
This 2-course bundle includes:
14-hours of video tutorials
170+ individual video lectures
Exercise files to practice what you learned
Certificate of completion
Here’s what our students are saying…
“As someone who has no experience with Microsoft Excel I am finding this course very easy to understand and follow. Great pace and the modules don't overwhelm you. So glad I purchased this.”
- Sharon Knight
“Yes of course, it was a wonderful learning. This will be very much beneficial in my professional life. Thank you !”
- Armesh Kamble
“I had learned excel a long time ago, but never used it much or worked with formulas. Most of the "work"was more for inventory. This was very helpful and I will be using it more for the applications described. Thank-you!”
- Wendy Gonigan
Did you know?
Simon Sez IT teaches all sorts of software, including:
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Project
- Microsoft Outlook
- QuickBooks
- Photoshop Elements
- Web Development Languages
- And so much more!
Course Content
- 42 section(s)
- 187 lecture(s)
- Section 1 Excel 2019 Beginner: Intro to Excel
- Section 2 Excel 2019 Beginner: Creating Workbooks
- Section 3 Excel 2019 Beginner: Saving Workbooks
- Section 4 Excel 2019 Beginner: Navigating Workbooks
- Section 5 Excel 2019 Beginner: Page Setup & Print Options
- Section 6 Excel 2019 Beginners: Working with Rows, Columns and Cells
- Section 7 Excel 2019 Beginners: Moving Data
- Section 8 Excel 2019 Beginners: Formulas & Functions
- Section 9 Excel 2019 Beginner: Working with Sheets
- Section 10 Excel 2019 Beginner: Formatting Worksheets
- Section 11 Excel 2019 Beginner: Charts
- Section 12 Excel 2019 Beginner: Working with Names
- Section 13 Excel 2019 Beginner: Sorting and Filtering
- Section 14 Excel 2019 Beginner: Outlining and Subtotaling
- Section 15 Excel 2019 Beginner: Working with Views
- Section 16 Excel 2019 Beginner: Linking Files
- Section 17 Excel 2019 Beginner: Advanced Formula Creation
- Section 18 Excel 2019 Beginner: Pivot Tables
- Section 19 Excel 2019 Beginner: Additional Excel Features
- Section 20 Excel 2019 Beginner: Shortcuts
- Section 21 Excel 2019 Beginner: Closing
- Section 22 PowerPoint 2019: Course Introduction
- Section 23 PowerPoint 2019: Overview
- Section 24 PowerPoint 2019: Getting Started
- Section 25 PowerPoint 2019: Text and Bullet Editing Options
- Section 26 PowerPoint 2019: Adding Graphics
- Section 27 PowerPoint 2019: Working with objects
- Section 28 PowerPoint 2019: Editing pictures
- Section 29 PowerPoint 2019: Working with SmartArt
- Section 30 PowerPoint 2019: Working with Tables
- Section 31 PowerPoint 2019: Working with Charts
- Section 32 PowerPoint 2019: Unlocking the Power of Masters
- Section 33 PowerPoint 2019: Adding Media
- Section 34 PowerPoint 2019: Working with Transitions
- Section 35 PowerPoint 2019: Animation
- Section 36 PowerPoint 2019: Hyperlinks and Action Buttons
- Section 37 PowerPoint 2019: Slideshow Options
- Section 38 PowerPoint 2019: Preparing a presentation for delivery
- Section 39 PowerPoint 2019: Exploring the Backstage Area
- Section 40 PowerPoint 2019: Course Close
- Section 41 Extras
- Section 42 Additional Training
What You’ll Learn
- Discover new and improved features in Excel 2019
- Learn how create, save, and open an Excel workbook
- Learn how to personalize your use of Excel 2019 using Excel Options.
- Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
- Learn the basics of entering and editing data in a workbook.
- Discover how to format dates and numbers in Excel.
- Learn practical methods to backup and recover your Excel spreadsheets and never lose data.
- Learn about the amazing autofill and flashfill in Excel to enhance your productivity
- Discover the essentials of using fomulas and functions
- How to rename, insert, move, and reference an Excel worksheet.
- Discover how to create stunning charts and graphs in Excel
- Learn practical methods to sort and filter your data
- Discover new features in PowerPoint 2019 including Icons and 3D Models
- Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint
- Add charts, graphs and tables to present information in a non-text format
- Wow your audience by adding animations, audio and video
- Learn time saving techniques including how to copy slides, and exporting your presentation
- Discover practical tips to present your presentation to your audience
- Discover templates and how to use them to reuse your PowerPoint designs
Skills covered in this course
Reviews
-
GGiorgos Rodousakis
Keep up the great work! This looks very interesting!
-
AAkash Meesarapu
good course and nice explanation with good exercises
-
AAshwin Ramu
good
-
VVinod Thomas
I am loving the way you are teaching me power point step by step so that I may be able to learn it properly