Get $1 credit for every $25 spent!

Microsoft Office Mastery Bundle

Ending In:
Add to Cart - $39
Add to Cart ($39)
$1,559
97% off
wishlist
(36)

What's Included

Product Details

Access
12 months
Content
100 hours
Lessons
38

Microsoft Excel Course

Save Time & Work Smarter with This Powerful Spreadsheet Engine

By Skillsology | in Online Courses

Microsoft Excel is the most popular spreadsheeting software on planet Earth, used by businesses in all types of industries to crunch numbers, organize data, and much more. No matter your skill level with Excel, this massive course will help you reinforce your knowledge, and expand it to new heights.

  • Access 38 lectures & 100 hours of content 24/7
  • Learn essential Excel functions (doesn't waste your time w/ useless functions)
  • Understand basic terminology & setup
  • Explore data analysis basics w/ PivotTables & more
  • Dive into in-depth data handling: sorting, filtering, lookup & more
  • Discover formatting options & training
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. 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

Advanced Microsoft Excel Course

Master the Most Powerful Spreadsheet Software in Industry

By Skillsology | in Online Courses

Microsoft Excel is the leading spreadsheet software, allowing you to process and manage large amounts of business data, all from the same platform. Through this huge course, you'll go from the absolute basics to performing the most complex Excel functions fast. Start organizing data more effectively and new doors are sure to open not far behind.

  • Access over 160 videos & approximately 27 hours of content 24/7
  • Use advanced graphs & presentation techniques to maximize impact
  • Learn how macros & VBA automate your spreadsheets & increased interactivity
  • Discover how superpower functions can solve complex functions
  • Use PivotTables & PowerPivots to turn raw data into clear information that supports key decisions
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. For more details on this course and instructor, click here.

Details & Requirements

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

Compatibility

  • Internet required
  • Microsoft Excel 2007 or later required

Course Outline

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

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

Microsoft Word is pretty straightforward, right? You just type the words you want and they come out on a document. Well, sure, that's the most basic usage. However, Word has a huge range of accessible tools and secrets that can let you completely customize formatting, integrate charts and tables, and much, much more. This course puts you on the path to becoming a Word savant.

  • Access 26 lectures & 20 hours of content 24/7
  • 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
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. 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

Microsoft Outlook is one of the most commonly used email platforms in business, making it an important tool to be familiar with. Email is a constant form of communication, but remains one of the main causes of productivity loss in the workplace. That's because people don't know how to harness the full power of their services. This course teaches you how to manage tasks, schedules, and your inbox with Outlook so you can work as productively as possible.

  • Access 21 lectures & 15 hours of content 24/7
  • Fortify your learning through 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
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. 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

Harness the Power of Excel. Master PivotTables in Just 10 Hours!

By Skillsology | in Online Courses

In the digital world, data is king. This course will teach you to utilize PivotTables to analyze and present data quickly and easily. You'll learn to manage data sets, big and large, and draw conclusions that'll spur the success of whatever you're looking accomplish.

  • Understand how & when to use PivotTables w/ 10 hours of instruction
  • Identify ‘best’ & ‘worst’ entries in data sets
  • Filter, sort & group PivotTable data to maximize success
  • Present your findings clearly w/ PivotCharts & Conditional Formatting
  • Customize calculations according to your requirements
  • Summarize data for reporting purposes
  • Work w/ PivotTables based on OLAP cubes
  • Use Slicers to synthesize & emphasize data across multiple PivotTables
  • Use PivotTables to build interactive dashboards
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. 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, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required
  • Excel required

Course Outline

  • PivotTable 2013 PC
    • Introduction and Basics
    • Filter and Group to Compare and Contrast
    • Presentation - Clarity and Impact
    • Calculations - Adding Value to Values
    • Your Data Your Way - Flexible Reporting
    • Power to the User - Interactivity
  • PivotTables for Data Analysis
    • Dominate Your Data
    • PowerPivot and Big Data
    • Make Your Data Work Harder
    • From Data to Decisions
    • Present Data Analysis with Impact
    • Give me more Power

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

Microsoft SharePoint has over 100 million users worldwide and is used by over 78% of Fortune 500 companies due to its outstanding capacity to integrate with the rest of the Microsoft Office suite. This web-based document management and storage system makes sharing business information and collaborating internally a breeze. In this course, you'll learn how to optimize SharePoint so you can add this powerful software to your resume.

  • Access 23 lectures & 15 hours of content 24/7
  • 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
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. 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


Access
12 months
Content
20 hours
Lessons
23

Microsoft PowerPoint Course

Command Your Audience's Attention with Impressive, Effective Slides

By Skillsology | in Online Courses

Microsoft PowerPoint is one of the most popular presentation tools on Earth, and an exceedingly important skill to have if you want to set yourself apart in the workplace. This course will teach you how to optimize this program to create impressive, effective presentations that utilize a wide range of tools to communicate information clearly.

  • Access 23 lectures & 20 hours of content 24/7
  • 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
Skillsology offers comprehensive online training for beginners, intermediate and advanced users across a variety of subjects. We carefully select the areas we teach and search the globe to find the most knowledgeable subject matter experts to be our the authors. All courses are hosted on our custom built and mobile responsive learning platform.

All Skillsology courses are certified, most are CPD (UK) accredited and many can be personalized to your learning needs using Filter technology. This Filter is a diagnostic that creates a tailor-made learning experience so your course is as unique as you are. 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



Terms

  • Instant digital redemption

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 credit refund within 15 days of purchase.