Bundle – Microsoft Office Suite

Enjoy the convenience and cost savings with this Microsoft Suite Bundle from GoSkills.

Bundle – Microsoft Office Suite

Course Description

Get access to all Microsoft Office courses in one place with the Microsoft Office Suite Bundle from GoSkills!   The following courses are included in this bundle: These online courses are designed to give you a solid foundation in the basics, intermediate and advanced Excel techniques. Microsoft Excel - Basic Microsoft Excel - Advanced These online courses are designed to give you a solid foundation in the basics, intermediate and advanced  Word techniques. Microsoft Word - Basic Microsoft Word - Advanced Whether you are new to PowerPoint or have some experience and want to improve your skills, this online course has something for everyone, covering beginner, intermediate and advanced lessons in PowerPoint. Microsoft PowerPoint Whether you are new to Outlook or need a refresher, these p... Read More »

Get access to all Microsoft Office courses in one place with the Microsoft Office Suite Bundle from GoSkills!

 

The following courses are included in this bundle:

These online courses are designed to give you a solid foundation in the basics, intermediate and advanced Excel techniques.

  • Microsoft Excel – Basic
  • Microsoft Excel – Advanced

These online courses are designed to give you a solid foundation in the basics, intermediate and advanced  Word techniques.

  • Microsoft Word – Basic
  • Microsoft Word – Advanced

Whether you are new to PowerPoint or have some experience and want to improve your skills, this online course has something for everyone, covering beginner, intermediate and advanced lessons in PowerPoint.

  • Microsoft PowerPoint

Whether you are new to Outlook or need a refresher, these practical tutorials will benefit anyone who uses email regularly to communicate.

  • Microsoft Outlook

This online course is designed to give you a solid foundation in the fundamentals of MS Project.

  • Microsoft Project Fundamentals

This online course is designed for a beginner and includes intermediate and advanced topics to put you on the road to becoming a master with Microsoft Access.

  • Microsoft Access Basics

Whether you are new to Publisher or need a refresher, these practical tutorials will benefit anyone who uses Publisher to create items for publication.

  • Microsoft Publisher
Read Less
Certificate Info:

Type of Certification

A Certificate of Training is awarded for completing all lessons within the course. An Accredited Certificate of Achievement is awarded if the learner passes the skills test at the end of the course. The skills test can be taken as many times as needed. The Certificate of Achievement will reflect the highest score achieved.

Format of Certification

Digital and Print

Professional Association/Affiliation

GoSkills is a member of the Continuing Professional Development Certification Service (CPD UK). GoSkills courses have been accredited by the CPD UK, which means that they meet the industry-wide guidelines for continuing professional development.

Method of Obtaining Certification

Once the learner has earned the certificate they can be downloaded from their GoSkills dashboard.  The certificates are in a pdf format, so they can be printed or emailed.  The certificate can also be added to LinkedIn if the learner has an account.
About Instructor:

Ken Puls - Microsoft MVP

Ken is a Certified Management Accountant (CMA) in Canada, who never remembers life without spreadsheets and computers! Since the late 1990s, he has spent his career in the hospitality and tourism industry, in the finance and IT fields. Ken is currently the Director of IT at a resort on Vancouver Island.To this day, he dedicates a significant portion of his time to developing automated solutions and internal controls, as well as focusing time and energy on improving Business Intelligence systems. Through his work, he designs and develops new systems, using such technology as Excel spreadsheets and VBA (Excel's programming language), automating as many tasks as possible, and thereby saving significant costs and maximizing efficiencies. Ken says, “I love the power that Excel puts at my finger tips and I’m still amazed by the things it can do.”Ken has worked as a freelance MS Office developer, mainly in Excel, but also with Access, Word and Outlook, and currently teaches courses whenever he can. Ken’s true passion lies with sharing his knowledge about Excel, and teaching people how to get the most from it.Ken runs a popular site solely dedicated to Excel training. Even NASA has made use of it, using some of his PDFCreator examples to automate the production of PDF reports that monitor the power supply levels on the International Space Station!Ken was awarded the prestigious Microsoft Most Valuable Professional – Excel award in 2006; a distinction he has won every year since! The Microsoft MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise with others. In Microsoft's words, "MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others." Worldwide, there are over 100 million participants in technical communities; of these participants, there are fewer than 4000 active Microsoft MVPs. Of this pool of MVPs, fewer than 200 hold the distinction of MVP-Excel globally.


Andy Lanning - Presenter

Andy has 20 years of experience in the computer industry and has been training individuals and groups since 1996. As a self professed computer 'nerd', Andy believes in using computer programs like Word to maximize efficiency and solve common workflow issues.Andy is a Certified Microsoft Office Specialist. She is proficient in Microsoft programs including Word, Excel, Outlook, PowerPoint, and Publisher. Andy has taught computer VoTech classes at Boise State University and College of Western Idaho, and owns a computer consulting business.


Glen Millar - Microsoft MVP

Glen is qualified in science and often uses PowerPoint to communicate complex topics to a wide range of audiences. He became frustrated with bad presentations, particularly in 2001 at a conference where he saw a very good topic presented badly. Determined to fix his own presentations (and then the world’s) he commenced working with presentation professionals to understand the presentation profession, PowerPoint as a tool, and the good and bad of presentations he encountered.Today, Glen can look back at many improvements in the software, as well as his own knowledge of presenting. Glen is a popular speaker at the Presentation Summit in the US, known for extracting many graphic and animation effects many believed PowerPoint could never do.Glen was first awarded the prestigious Microsoft Most Valuable Professional Award – PowerPoint in 2003 and has been awarded every year since then. At that time, Glen was the first to be awarded for PowerPoint in the southern hemisphere, but is pleased to share the award with some of the world’s best thinkers and practitioners of presenting. Currently, Glen is one of some 37 PowerPoint MVPs world wide.


Geetesh Bajaj - Course design and review

Geetesh Bajaj is an awarded Microsoft PowerPoint MVP (Most Valuable Professional) for over a decade now. He has been designing and training with PowerPoint for 15 years and heads Indezine, a presentation design studio and content development organization based out of Hyderabad, India.Geetesh believes that any PowerPoint presentation is a sum of its elements – these elements include abstract elements like concept, color, interactivity, and navigation – and also slide elements like shapes, graphics, charts, text, sound, video, and animation. He explains how these elements work together in his best-selling book Cutting Edge PowerPoint for Dummies. He has also authored three subsequent books on PowerPoint 2007 for Windows, and two on Microsoft Office for Mac.His Indezine.com site attracts more than two million page views each month and has thousands of free PowerPoint templates and other goodies for visitors to download. In addition, Geetesh also issues a bi-weekly PowerPoint newsletter on Indezine.com that has over a hundred thousand subscribers.He has authored content for the Microsoft, Presentations.com, Presenters University, TechTrax, Infocomm and other web sites, undertakes training and consultancy for PowerPoint, creates custom PowerPoint presentations and templates and is a featured speaker on presentation technologies.In addition, Geetesh has also been part of the PowerPoint Live industry event since its conception and a contributing editor to the Presentations magazine for which he has authored several Creative Techniques columns.


Bill Raymond - Microsoft MVP

Bill Raymond is an author, public speaker, trainer, and consultant. While working in the product development, portfolio and project management markets, his personal objective is to help companies and individuals strategically plan and deliver business growth.Bill is the proud recipient of the prestigious Microsoft Most Valuable Professional award in MS Project for the past 13 years. The Microsoft MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise with others. In Microsoft's words, "MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others."Bill has also been honored with speaking awards from organizations such as MPUG and NASA.Bill has written five books and counting on Microsoft Project, project management, and portfolio management.


Crystal Long - Presenter

Crystal has always loved to teach. As a college student headed to a BSc. in Petroleum Engineering, she tutored her peers in physics, chemistry, math, and writing. She is passionate about sharing her knowledge and empowering learners.Crystal has provided remote and face to face training in the MS Office suite of applications for 30 years, including Access, Excel, Word and PowerPoint.Crystal was awarded the prestigious Microsoft Most Valuable Professional award for Access in 2006; a distinction she has won every year since! The Microsoft MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise with others. In Microsoft's words, "MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others."Crystal was chosen to present about Access at the 2015 Microsoft MVP Virtual Conference, a prestigious 2 day event designed by Microsoft to "showcase how the best and brightest independent technology experts are using Microsoft technologies today."


Course Outline

  • The Ribbon
  • The Work Surface
  • Navigation
  • First File
  • Formatting
  • Basic Math
  • Formula Anatomy
  • Cell Referencing
  • Function Anatomy
  • Math Functions
  • Basic Statistics
  • Logic Functions
  • Text Functions
  • Conditional Math
  • External Links
  • Sorting
  • Filtering
  • Contiguous Data
  • Cell Formatting
  • Building Column Charts
  • Building Bar Charts
  • Building Pie Charts
  • Building Line Charts
  • Understanding Dates
  • Understanding Time
  • Formula Auditing
  • Temporal Functions
  • VLOOKUP with Approximate Match
  • VLOOKUP with Exact Match
  • Other Lookup Methods
  • Naming Ranges
  • Excel Tables
  • Recording Macros
  • Creating PivotTables
  • Formatting PivotTables
  • Calculated Fields in PivotTables
  • What-If Analysis
  • Outlining
  • Custom Number Formats
  • Conditional Formats with Built-In Rules
  • Conditional Formats with Custom Rules
  • Building Combination Line and Area Charts
  • Data Validation
  • Data Validation Lists
  • Styles
  • Custom Views
  • Page Setup Options
  • Security Considerations
  • The Ribbon and Word Screen
  • Quick Access Toolbar
  • Navigating the Page
  • Your First Document
  • Formatting Fonts
  • Basic Letter Layout
  • Basic Cut, Copy, Paste
  • Styles Gallery
  • Format Text with Fonts and Colors
  • Format Painter
  • Practice with the FONT Group
  • Basic Paragraph Formats
  • Fun and Functional Paragraph Formats
  • Bullets and Numbering
  • Indents
  • Line Spacing
  • The Find/Replace Function
  • File, New
  • File, Recent
  • File, Share
  • File, Info and Security Considerations
  • Inserting Page Breaks and Blank Pages
  • Add a Cover Page
  • Working with Pages
  • Inserting Pictures and Clip Art
  • Basic Use of Shapes
  • Screenshots
  • Headers and Footers
  • Page Numbers and File Location Notes
  • Word Art
  • Symbols
  • Margins
  • Paper Orientation and Size
  • Using Columns
  • Paragraph Spacing
  • Printing
  • Document Views
  • Navigation Pane
  • Show and Zoom Controls
  • Use Multiple Windows
  • Table of Contents
  • Update the Table of Contents
  • Mark Entry for Table of Contents
  • Footnotes
  • Citations and Bibliography
  • Using Captions
  • Create an Index
  • Create and Apply a Style
  • Rename, Modify and Remove Styles
  • Reveal Formatting
  • Selection Tool and Format Pane
  • Envelopes and Labels
  • Mail Merge to Labels
  • Mail Merge to Envelopes
  • Mail Merge to Form Letters
  • Mail Merge to Emails
  • Mail Merge Tips from Experience
  • Proofing
  • Language and Translation
  • Comments
  • Track Changes
  • Compare Documents
  • Launching PowerPoint and Choosing a Theme
  • Adding Slides, Changing Layouts and Exploring the Outline
  • Exploring PowerPoint’s Views
  • Getting Familiar with the Notes Pane
  • Customizing the PowerPoint Interface
  • Changing Themes and Colors
  • The Content Placeholder and Bullet Levels
  • Formatting Text
  • Adding and Manipulating Shapes
  • Duplicate and Add Multiple Shapes
  • Align and Distribute Shapes
  • Group and Ungroup Shapes
  • Working with Pictures
  • Remove Picture Backgrounds
  • Photo Album
  • Introducing SmartArt
  • Adding and Editing Charts
  • Advanced Chart Options
  • Structure Your Tables
  • Adding Audio
  • Adding Video
  • Less is More
  • Basic Animation Types
  • Events and Speed
  • Motion Path Animations
  • Transitions
  • Duplicating and Reordering Slides
  • Reusing and Copying Slides
  • Working with Slide Sections
  • Reset – the Magic Button
  • Printing Slides
  • Rehearsing Slides
  • Exploring Slide Show Options
  • Using Presenter View
  • Outlook Screen Overview
  • Office Management
  • Drag & Drop
  • Second Window
  • Email Dos and Don’ts
  • Autofill, Importance, and Email Format
  • Email Signatures
  • Handling Attachments
  • Recall a Message
  • Quick Steps Gallery
  • Email Options
  • View Ribbon, Layout Group
  • Groups and Conversations
  • Search for and Color Code emails
  • Inbox Sticky-Notes
  • Follow up Flags and Categories
  • Folders and Search Folders
  • Rules and Alerts
  • Calendar Views
  • Calendar Display Options
  • Appointments, Meetings and Events
  • Schedule Resources and Schedule View
  • Recurring Appointments
  • Color Code Appointments
  • Search the Calendar
  • Printing and Calendar Best Practices
  • New Contacts
  • Contact Groups aka Distribution Lists
  • Search Contacts and People Pane
  • Contact Folders and Groups
  • Contact Categories
  • Contact Views
  • Contacts Backup
  • Tasks, New and Recurring
  • Assign Tasks, Add Column Headers
  • View and Filter Task To-Do Pane
  • Using Notes
  • Email Merge
  • Email Merge, Personalized
  • Email Merge, Full Color Flyers
  • Backup Outlook Folder
  • Store Emails Outside of Outlook
  • An Introduction to Project Management
  • Your Role as a Project Manager
  • Project Negotiations
  • About Microsoft Project
  • Run Microsoft Project for the First Time
  • About the Microsoft Project User Interface
  • About the Ribbon
  • Using the Ribbon
  • Using the Backstage
  • Using Views and Tables
  • Constraint Based Scheduling
  • Critical Path and User-controlled Scheduling
  • Configure Project Options
  • Create a New Project
  • Configure a Project Calendar
  • Add Tasks to the Project
  • Add Durations to Each Task
  • Add Predecessors to Each Task
  • Create the Critical Path
  • Add Resources to the Project
  • Create Resource Assignments
  • Build a Work Breakdown Structure
  • Add Costs to the Project
  • Add Milestones to the Project
  • Add Lag and Review the Critical Path
  • Adjust Resource Allocations
  • Create a Baseline
  • Task Status Updates
  • Resource Assignment Status Updates
  • Create Custom Views and Tables
  • Create Custom Fields
  • Create Graphical Indicators
  • Working with the Timeline
  • Working with the Reporting Module
  • Tips and Tricks for Copying Views
  • Tips and Tricks for Replacing Resources
  • Tips and Tricks for Printing
  • Conclusion
  • Welcome to Access
  • Enter Data into Tables
  • Create a Form and Combo Box
  • Modify Form Design
  • Customize Form with Colors and Close Button
  • Create a Query, Grouped Report and Auto Report
  • Import Objects from Access
  • Import Data from Excel
  • The Navigation Pane
  • Create a Query with Calculations
  • Perspective on Access Objects
  • Number Data Types
  • Text Data Types
  • Currency Data Type and Windows Region Settings
  • Yes/No Data Type
  • Date/Time Data Type
  • Data Type Review
  • Relationships and Relationships Diagram
  • Mainform and Subform
  • Customize Quick Access Toolbar for Form and Report Design
  • Complex Query for Grouped Report
  • Creating Reports in Access
  • Design Report from Scratch
  • Group and Sort
  • Modify Relationship Properties to Show All Records
  • Report View, Design View, Layout View and Print Preview
  • Calculated Controls and Control Names
  • Page Breaks and Page Setup
  • Back Color, Alternate Back Color and Themes
  • Running Sum and Hide Duplicates
  • Repeat Sections, Show or Hide Continued Label
  • Change Sort to Group, Set Default View to Print Preview
  • Hide Sections and Controls, Key Fields
  • Page Header, Page Numbers, Date & Time, Report Caption
  • Command Buttons to Open Forms Using a Macro or VBA
  • Command Buttons to Open Reports Using VBA
  • Open Report with Criteria
  • Open Report with Multiple Criteria that is Optional
  • Open Tables and Queries with VBA, Startup Form
  • Add Logo to Main Menu Form, Wrap Up
  • Publisher Screen Overview
  • File Ribbon - Info
  • File Ribbon - New
  • File Ribbon - Other Features
  • Quick Access ToolBar
  • Identify Parts of Pre Made Template
  • Manage Picture Tools
  • Pictures - Crop
  • Pictures - Placeholders
  • Pictures - Size, Layers, Group
  • Pictures - Align
  • Pictures - Adjust, Swap
  • Pictures - Styles, Frames, Captions
  • Pictures - Find online, Copyright free
  • Text box - Word Art
  • Text box - Identify Parts
  • Text box - Formatting Tools
  • Text box - Business Information
  • Text box - Building Blocks
  • Page Design - Header Footer
  • Page Design - Ribbon a
  • Page Design - Ribbon b
  • Shapes
  • Shapes with Pictures
  • Shapes, Control Placement
  • Shapes, Arrange
  • Shapes, Edit Wrap Points
  • Ribbon - Review
  • Ribbon - View
  • Ribbon - Home
  • Ribbon - File, Save-Print-Export
  • Creative Ideas - Mail Merge
  • Creative Ideas - Catalog
  • Creative Ideas - QR Codes in Catalogs
  • Creative Ideas - Tables
  • Creative Ideas - Create Picture Files
  • Creative Ideas - Keyboard Shortcuts
  • Creative Ideas - Color Codes

DON'T HAVE TIME?

We can send you everything you need to know about this course through email.
We respect your privacy. Your information is safe and will never be shared.