Get $1 credit for every $25 spent!

Microsoft Office Mastery Bundle

Courses
7
Lessons
163
Enrolled
4,712

What's Included

Product Details

Access
12 months
Content
100 hours
Lessons
38

Microsoft Excel Course

Save Time & Work Smarter w/ This Powerful Spreadsheet Engine

By Skillsology | in Online Courses

  • Over 100 hours of learning material
  • Essential Excel functions (doesn't waste your time w/ useless functions)
  • Basic terminology & setup
  • Data analysis basics w/ PivotTables & more
  • In-depth data handling: sorting, filtering, lookup & more
  • Formatting options & training
This course is brought to you by the expert team at Skillsology. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all level

Compatibility

  • Internet required
  • All main versions of Excel:
    • PC: 2003, 2007, 2010, & 2013
    • Mac: 2011

Course Outline

  • Microsoft Excel Course Section 1: Foundation
    • Unit 1.1 - Excel Introduction
    • Unit 1.2 - The Excel Interface
    • Unit 1.3 - Basic Navigation and Editing
    • Unit 1.4 - Getting Going
  • Section 2: Orientation & efficiency
    • Unit 2.1 - Editing
    • Unit 2.2 - Viewing
    • Unit 2.3 - Spreadsheet Structure
    • Unit 2.4 - Cell References
    • Unit 2.5 - Named Ranges
    • Unit 2.6 - Basic Macros
    • Unit 2.7 - Design
  • Section 3: Administration
    • Unit 3.1 - Customising Excel
    • Unit 3.2 - Housekeeping
    • Unit 3.3 - Connecting Workbooks
    • Unit 3.4 - Documentation
    • Unit 3.5 - Protecting and Sharing
    • Unit 3.6 - Google Docs
    • Unit 3.7 - Excel Troubleshooting
  • Section 4: Data Handling
    • Unit 4.1 - Sorting and Filtering
    • Unit 4.2 - Controlling User Input
    • Unit 4.3 - Working with Dates & Times
    • Unit 4.4 - Working with Text
    • Unit 4.5 - Lookup and Reference
    • Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    • Unit 5.1 - Working with Numbers
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - PivotTables 1 - Simple Summaries
    • Unit 5.4 - PivotTables 2 - Manipulating Data
    • Unit 5.5 - PivotTables 3 - Interpreting Data
    • Unit 5.6 - PowerPivot: Handling Big Data
    • Unit 5.7 - Formula Auditing
    • Unit 5.8 - Advanced Macros and VBA
    • Unit 5.9 - Modelling
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Graphs and Charts
    • Unit 6.5 - Page and print setup

View Full Curriculum


Access
12 months
Content
27 hours
Lessons
20

Advanced Microsoft Excel Course

Supercharge Your Productivity & Handle Data Like It's Your Business

By Skillsology | in Online Courses

  • Over 160 videos & tons of practice exercises
  • Use advanced graphs & presentation techniques to maximize impact
  • Learn how macros & VBA automate your spreadsheets and increase interactivity
  • Harness functions to solve complex problems
  • Explore PivotTables & PowerPivots to turn raw data in to clear information
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications: Access, Word, PowerPoint and Excel, about which he speaks frequently at conferences. He is also a prolific writer and published Excel author, contributing Excel articles to many websites and publications. Simon has been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis. He is able to bring these years of practical experience to our Advanced Excel course, ensuring that the course explains advanced concepts clearly and concisely, and with real, practical applications and even the occasional joke. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required
  • All main versions of Excel:
    • PC: 2003, 2007, 2010, & 2013
    • Mac: 2011

Course Outline

  • Advanced Excel Course Section 1: Design and Risk
    • Unit 1.1 - Templates
    • Unit 1.2 - Efficiency and Risk
    • Unit 1.3 - Data Validation
  • Section 2: Advanced Techniques
    • Unit 2.1 - Functions and Superpowers
    • Unit 2.2 - Array Formulae
    • Unit 2.3 - Tables
    • Unit 2.4 - Advanced Range Names
    • Unit 2.5 - What If?
    • Unit 2.6 - Problem Solving
  • Section 3: Excel Interactivity
    • Unit 3.1 - Form Controls
    • Unit 3.2 - Visual Basic and Macros
  • Section 4: Spreadsheet Impact
    • Unit 4.1 - Practical Interactivity with VBA
    • Unit 4.2 - Conditional Formatting
    • Unit 4.3 - Charts that Inspire
    • Unit 4.4 - Sparklines
    • Unit 4.5 - Graphics Tricks and Techniques
    • Unit 4.6 - Working with External Data
  • Section 5: Turning Data into Decisions
    • Unit 5.1 - Advanced Uses of PivotTables
    • Unit 5.2 - PowerPivot
    • Unit 5.3 - Reporting with PowerPivot

View Full Curriculum


Access
12 months
Content
20 hours
Lessons
23

Microsoft PowerPoint Course

Command Your Audience's Attention w/ Impressive, Effective Slides

By Skillsology | in Online Courses

  • 20 hours of learning materials
  • Utilize a blend of text-based articles, practice exercises, video tutorials & assessments
  • Learn the basics of the PowerPoint interface & slide structure
  • Gain familiarity w/ using art & graphics
  • Edit, print & collaborate
  • Create charts to express complex ideas
  • Optimize the flow of your presentation
  • Incorporate images, animations & presentations aids
  • Earn a certificate of attainment and test certificate
This course is brought to you by the expert team at Skillsology. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Compatibility

  • Internet required
  • Microsoft PowerPoint

Course Outline

  • Section 1: Foundation
    • Unit 1.1 - The PowerPoint interface
    • Unit 1.2 - Getting started
    • Unit 1.3 - Terminology and overview
    • Unit 1.4 - Templates and Slide Masters
    • Unit 1.5 - Principles of slide design
  • Section 2: Basic slide editing
    • Unit 2.1 - SmartArt
    • Unit 2.2 - Drawing shapes and lines
    • Unit 2.3 - Text boxes
    • Unit 2.4 - Aligning objects
    • Unit 2.5 - Tips and shortcuts
  • Section 3: Administration and efficiency
    • Unit 3.1 - Editing and working collaboratively
    • Unit 3.2 - Printing and other output
    • Unit 3.3 - Customising PowerPoint
    • Unit 3.4 - Housekeeping
  • Section 4: Communicating Analysis
    • Unit 4.1 - Tables
    • Unit 4.2 - Graphs & charts - How
    • Unit 4.3 - Graphs & charts - When and why
    • Unit 4.4 - Making a presentation flow
    • Unit 4.5 - Slide-type toolkit
  • Section 5: Making an impact
    • Unit 5.1 - Incorporating images
    • Unit 5.2 - Transitions and animation
    • Unit 5.3 - Presenting your slides
    • Unit 5.4 - What not to do

View Full Curriculum


Access
12 months
Content
20 hours
Lessons
26

Microsoft Word Course

Not the Average Joe's Word Course. Optimize Your Word Skills for Business Success.

By Skillsology | in Online Courses

  • Over 20 hours of learning materials
  • Utilize a blend of text-based articles, exercises, video tutorials & assessments
  • Review paragraph formatting, letter formatting & more
  • Create lists, tables, schedules, labels, newsletters & more
  • Master tips & shortcuts
  • Customize your usage
  • Learn complex functions like long documents & forms
  • Gain highly practical, under-used methods
This course is brought to you by the expert team at Skillsology. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all level

Compatibility

  • Internet required
  • Microsoft Word

Course Outline

  • Section 1: Foundation
    • Unit 1.1 - The Word Interface
    • Unit 1.2 - A Simple Letter
    • Unit 1.3 - Typing in the Right Place
    • Unit 1.4 - Simple Paragraph Formatting
    • Unit 1.5 - Templates
    • Unit 1.6 - A Simple Letter, Better, Faster
  • Section 2: Basics
    • Unit 2.1 - Font Formatting
    • Unit 2.2 - Paragraph Formatting
    • Unit 2.3 - Styles and Themes
    • Unit 2.4 - Pages and Sections
    • Unit 2.5 - Automating Word
    • Unit 2.6 - Spelling and Grammar
  • Section 3: Common Tasks
    • Unit 3.1 - Lists, Tables and Schedules of Figures
    • Unit 3.2 - Envelopes and Labels
    • Unit 3.3 - Mail Merge
    • Unit 3.4 - Graphics
    • Unit 3.5 - Create a Newsletter
    • Unit 3.6 - Tips and Shortcuts
  • Section 4: Administration
    • Unit 4.1 - Working Collaboratively
    • Unit 4.2 - Printing and Other Output Formats
    • Unit 4.3 - Customizing Word
    • Unit 4.4 - Housekeeping
    • Unit 4.5 - Basic Use of Macros
  • Section 5: Taking Word Further
    • Unit 5.1 - Forms and Form Fields
    • Unit 5.2 - Complex Numbering
    • Unit 5.3 - Coping with Long Documents

View Full Curriculum


Access
12 months
Content
15 hours
Lessons
21

Effective Outlook Course

Quickly Impact Your Day-to-Day Productivity w/ Email Management

By Skillsology | in Online Courses

  • Video summaries, screencast examples & practice tasks
  • Learn to optimize Outlook for a whole team & train your staff
  • Efficiently interact w/ email, contacts, calendars & notes
  • Prevent junk mail
  • Minimize email errors
  • Quickly find emails
  • Automate email management & presentation
  • Consolidate your notes
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years, during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications: Access, Word, PowerPoint, Excel and Outlook about which he speaks frequently at conferences. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all level

Compatibility

  • Internet required
  • Microsoft Outlook

Course Outline

  • Section 1: Introduction
    • Unit 1.1 - Introduction
    • Unit 1.2 - Personal Productivity
    • Unit 1.3 - Outlook Structure
    • Unit 1.4 - Categories
    • Unit 1.5 - Section Plenary
  • Section 2: Email
    • Unit 2.1 - Dealing with Basic Emails
    • Unit 2.2 - Making email better
    • Unit 2.3 - Email Management
    • Unit 2.4 - Searching for Emails
    • Unit 2.5 - Process Emails Manually
    • Unit 2.6 - Processing Email Automatically
    • Unit 2.7 - Section Plenary
  • Section 3: Other Outlook Items
    • Unit 3.1 - Appointments
    • Unit 3.2 - Meetings
    • Unit 3.3 - Contacts
    • Unit 3.4 - Tasks and To Do List
    • Unit 3.5 - Section Plenary
  • Section 4: Outlook Advanced
    • Unit 4.1 - Linking
    • Unit 4.2 - Synchronisation
    • Unit 4.3 - Section Plenary
  • Section 5: Course Plenary
    • Unit 5.1 - Course Plenary

View Full Curriculum


Access
12 months
Content
10 hours
Lessons
12

PivotTable Course

Quickly Summarize & Understand Data w/ Excel's Powerful Tool

By Skillsology | in Online Courses

  • Identify the primary uses of PivotTables &when to use them
  • Identify 'best" and 'worst' entries in data sets
  • Present clearly & compellingly using PivotCharts and Conditional Formatting
  • Filter, sort, and group PivotTable data to maximize effectiveness
  • Work with PivotTables based on OLAP cubes
  • Learn to build interactive dashboards
This course is brought to you by the expert team at Skillsology. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all level

Compatibility

  • Internet required
  • Microsoft Excel

Course Outline

  • PivotTable Course Section 1: PivotTables
    • Unit 1.1 - Introduction - Finding the Best or the Worst
    • Unit 1.2 - Filter and Group to Compare and Contrast
    • Unit 1.3 - Presentation - Clarity and Impact
    • Unit 1.4 - Calculations - Adding Value to Values
    • Unit 1.5 - Your Data Your Way - Flexible Reporting
    • Unit 1.6 - Power to the User - Interactivity
  • Section 2: PivotTables for Data Analysis
    • Unit 2.1 - Dominate Your Data
    • Unit 2.2 - PowerPivot and Big Data
    • Unit 2.3 - Make Your Data Work Harder
    • Unit 2.4 - From Data to Decisions
    • Unit 2.5 - Present Data Analysis with Impact

View Full Curriculum


Access
12 months
Content
15 hours
Lessons
23

SharePoint Course

Join Over 100 Million Happy Users & Learn to Collaborate Across Teams Seamlessly

By Skillsology | in Online Courses

  • 15 hours of learning materials
  • Learn techniques & tricks from SharePoint experts
  • Utilize collaboration w/ communities, wikis, blogs & more
  • Study business intelligence & reporting using an integration w/ Excel
  • Utilize practice exercises, downloadable templates & assessments
Don A. Cox has been a Project Management Professional (PMPĀ®) since 1999, and has more than thirty years experience in successful integration and implementation of large scale IT systems in both the public and private sectors. Mr. Cox has successfully managed multi-year programs and projects ranging from $70M to more than $650M. For more details on this course and instructor, click here.

Details & Requirements

  • Length of time users can access this course: 12 months
  • Access options: web streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all level

Compatibility

  • Internet connection required
  • Microsoft SharePoint Access

Course Outline

  • Section 1: Introduction and Course Structure
    • Unit 1.1 - Introduction
    • Unit 1.2 - A Brief Discussion of SharePoint
    • Unit 1.3 - Course Structure
    • Unit 1.4 - Section Plenary
  • Section 2: SharePoint Basics
    • Unit 2.1 - Understanding SharePoint Architecture and Versions
    • Unit 2.2 - SharePoint Site Structure
    • Unit 2.3 - SharePoint Site Navigation
    • Unit 2.4 - Basic SharePoint Access Levels
    • Unit 2.5 - Section Plenary
  • Section 3: Sharing Content With SharePoint
    • Unit 3.1 - Using SharePoint Libraries
    • Unit 3.2 - Using SharePoint Lists
    • Unit 3.3 - Organising and Managing Documents
    • Unit 3.4 - Using SharePoint Search
    • Unit 3.5 - Section Plenary
  • Section 4: Sharing Knowledge with SharePoint
    • Unit 4.1 - Social computing
    • Unit 4.2 - Section Plenary
  • Section 5: Sharing Work with SharePoint
    • Unit 5.1 - Key Features of a Team / Project Site
    • Unit 5.2 - Managing Tasks
    • Unit 5.3 - Using Workflows for Business Processes
    • Unit 5.4 - Section Plenary
  • Section 6: Sharing Information with SharePoint
    • Unit 6.1 - Overview of SharePoint Business Intelligence (BI)
    • Unit 6.2 - Using Excel and Excel Services
    • Unit 6.3 - Section & Course Plenary

View Full Curriculum



Terms

  • Instant digital redemption
  • Redemption is for 12-month access once activated

15-Day Satisfaction Guarantee

We want you to be happy with every course you purchase! If you're unsatisfied for any reason, we will issue a store credit refund within 15 days of purchase.