MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners
Learn the essentials of Microsoft Office in this 4-course bundle for Office 365 or Office 2019 users.
What you will learn
Learn the essential Microsoft Office Skills in this four-course bundle: Excel, Word, PowerPoint and Access
Learn practical methods to backup and recover your Excel spreadsheets and never lose data.
Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
Discover the essentials of using formulas and functions in Excel
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data in Excel
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 your PowerPoint presentation information in a non-text format
Wow your audience by adding animations, audio and video to PowerPoint
Discover practical tips to present your PowerPoint presentation to your audience
Learn time saving techniques including how to copy slides, and exporting your presentation
Master the most common uses of Microsoft Word
Learn Word tools including using columns, indents, footers, borders and watermarks.
How to create a mail merge in Microsoft Word
Learn how to correctly Print envelopes and labels in Word
Learn to protect your Word document from changes
Insert professional pictures and graphics in your Word document
Make your Word documents look amazing by inserting and editing tables
Sorting information and running queries in Access
Navigating the Access 2019 interface
Discover how to into import data from Excel in Access
Learn Queries, use validations, how to create and print reports in Access
How to compact, repair and backup your Access database
How to create a linked table in Access
Description
**This course includes practice exercises and LIFETIME access**
Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT.
Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential.
We’re here to make sure you aren’t one of those people.
In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals.
What's included?
Excel 2019
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
PowerPoint 2019
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
Word 2019
How to get started with Word 2019
Word 2019 basics including navigation, editing and saving
Character formatting in Word including Format Painter and AutoCorrect
How to properly work with bullets and numbering in Microsoft Word
All about formatting paragraphs and managing lists
Working with Tables in Word including formatting, converting data and formulas
Page appearance including page-breaks, watermarks and styles
All about Sectioning a document
Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)
How to work with envelopes and labels
All about mail-merge and operating Word at scale
How to create an Index or Contents page
Reviewing and Printing in Word and Page Setup
Protecting a Word document and basic macros in Word
Microsoft Access
Where to start in Microsoft Access and whether to use a template or not
How to modify Access to suit your needs
All about importing data and the datasheet view
How tables work in Access and how to create relationships between them
Creating forms and sub-forms that feed data into your tables
How to run queries in Access
Setting up validations and calculations using expressions in Access
Printing from Access
To start to use macros and Modal Dialog
The basics of the Access web app
Exporting and reporting in Access
***Exercise and demo files included***
This bundle includes:
29+ hours of video tutorials
300+ individual video lectures
Exercise files to practice what you learned
Certificate of completion
Here’s what our students are saying…
"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course."
- Yunesh Garusinghe
"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."
- Cavin Macwan
"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"
- Coreen Teoh
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!
Content
Excel 2019: Introduction
Excel 2019 Beginner: Creating Workbooks
Excel 2019 Beginner: Saving Workbooks
Excel 2019 Beginner: Navigating Workbooks
Excel 2019 Beginner: Page Setup & Print Options
Excel 2019 Beginners: Working with Rows, Columns and Cells
Excel 2019 Beginners: Moving Data
Excel 2019 Beginners: Formulas & Functions
Excel 2019 Beginner: Working with Sheets
Excel 2019 Beginner: Formatting Worksheets
Excel 2019 Beginner: Charts
Excel 2019 Beginner: Working with Names
Excel 2019 Beginner: Sorting and Filtering
Excel 2019 Beginner: Outlining and Subtotaling
Excel 2019 Beginner: Working with Views
Excel 2019 Beginner: Linking Files
Excel 2019 Beginner: Advanced Formula Creation
Excel 2019 Beginner: Pivot Tables
Excel 2019 Beginner: Additional Excel Features
Excel 2019 Beginner: Shortcuts
Excel 2019 Beginner: Closing
Word 2019: Introduction
Word 2019: Getting Started with Word
Word 2019: Character Formatting
Word 2019: Paragraph Formatting
Word 2019: Managing Lists
Word 2019: Tables
Word 2019: Styles
Word 2019: Controlling Page Appearance
Word 2019: Sectioning
Word 2019: Graphics
Word 2019: Envelopes and Labels
Word 2019: Mail Merges
Word 2019: Page Setup Options
Word 2019: Indexing and Table of Contents
Word 2019: Review and Printing
Word 2019: Other Word Options
Word 2019: Wrap Up
PowerPoint 2019: Course Introduction
PowerPoint 2019: Overview
PowerPoint 2019: Getting Started
PowerPoint 2019: Text and Bullet Editing Options
PowerPoint 2019: Adding Graphics
PowerPoint 2019: Working with objects
PowerPoint 2019: Editing pictures
PowerPoint 2019: Working with SmartArt
PowerPoint 2019: Working with Tables
PowerPoint 2019: Working with Charts
PowerPoint 2019: Unlocking the Power of Masters
PowerPoint 2019: Adding Media
PowerPoint 2019: Working with Transitions
PowerPoint 2019: Animation
PowerPoint 2019: Hyperlinks and Action Buttons
PowerPoint 2019: Slideshow Options
PowerPoint 2019: Preparing a presentation for delivery
PowerPoint 2019: Exploring the Backstage Area
PowerPoint 2019: Course Close
Access 2019 Beginners: Introduction
Access 2019 Beginners: Getting Started with Access 2019
Access 2019 Beginners: The Ribbon and Toolbars
Access 2019 Beginners: Keyboard Shortcuts and Key Tip
Access 2019 Beginners: Access Options
Access 2019 Beginners: Tables
Access 2019 Beginners: Importing Data
Access 2019 Beginners: Backup, Restore and Repair
Access 2019 Beginners: Datasheet View
Access 2019 Beginners: Relationships
Access 2019 Beginners: Forms
Access 2019 Beginners: Subforms
Access 2019 Beginners: Queries
Access 2019 Beginners: Expressions
Access 2019 Beginners: Reports
Access 2019 Beginners: Printing
Access 2019 Beginners: More Data Types
Access 2019 Beginners: More About Forms
Access 2019 Beginners: Exporting
Access 2019 Beginners: Application Parts
Access 2019 Beginners: More Access Options
Access 2019 Beginners: Info Tab
Access 2019 Beginners: Course Close
Screenshots
Reviews
Coupons
Submit by | Date | Coupon Code | Discount | Emitted/Used | Status |
---|---|---|---|---|---|
- | 6/22/2022 | C57F0829B4C0D28FC5F8 | 91% OFF | expired |