KEY FEATURES

Learn advanced Excel formulas and functions by writing robust formulas and functions from scratch. This course gives you a deeper understanding of the advanced formulas that transform Excel from a basic spreadsheet program into a dynamic, powerful analytics tool. We'll dive into diverse topics, including lookup/reference functions, statistical functions, formula-based formatting, date and time functions, logical operators, array formulas, and text functions.

• Access 209 lectures & 8 hours of content 24/7
• Easily build dynamic tools & Excel dashboards to filter, display & analyze your data
• Go rogue & design your own formula-based formatting rules
• Join datasets from multiple sources in seconds with lookup, index & match functions
• Pull real-time data from APIs directly into Excel
• Manipulate dates, times, text, & arrays
• Automate tedious & time-consuming analytics tasks using cell formulas & functions in Excel

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop or mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Certificate of completion included
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

Maven Analytics
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

KEY FEATURES

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. So whether you're exploring product sales, analyzing marketing tactics, or wondering how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

• Access 50 lectures & 5 hours of content 24/7
• Cover raw data structure, table layouts & styles
• Explore design & formatting options
• Understand sorting, filtering & grouping tools
• Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics & more

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2010-2019 or Office 365
• Basic knowledge with Excel functionality

THE EXPERT

Maven Analytics
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

KEY FEATURES

Ask people what comes to mind when they think of Excel, and odds are they'll say, "spreadsheets." However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel's latest data visualization tools and techniques. You'll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

• Access 23 lectures & 2 hours of content 24/7
• Understand when, why & how to use 20+ chart types in Excel
• Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, & more
• Master unique tips, tools, and case studies that you won't find in any other Excel course
• Build 10+ Excel projects designed to take your data visualization skills to the next level

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016+ or Office 365

THE EXPERT

Maven Analytics
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

KEY FEATURES

The most important thing you can do to get more done is to be able to work more efficiently. Having a great deal of information accessible at any given time is crucial to being productive and successful in your role. With OneNote, you have everything from meeting minutes and client reports all the way down to recipes that can be accessed anywhere on an iPad or computer.

In this course, you will learn step-by-step how to set up OneNote for your business or personal use. By setting up a key document that has all the essential information for your organization, you will be able to access it from anywhere and move quickly through tasks on any device.

• Access 42 lectures & 7 hours of content 24/7
• Copy cut text & split and merge containers
• Create subpages & section groups
• Learn how to insert attachments, tables, & more

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop or mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Publisher

THE EXPERT

Earn and Excel
Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

KEY FEATURES

This course will teach you how to use Microsoft Publisher in a quick, easy, and most importantly effective manner. By the end of this course, you will learn how to maximize your efforts with tips and tricks to speed up your work. You will see how to create mail merges that can distribute your publications at the click of a button.

• Access 28 lectures & 9 hours of content 24/7
• Learn how to insert tables & pictures
• Organize your data by moving & deleting pages
• Import text & create columns

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop or mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

Earn and Excel
Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

KEY FEATURES

Teams is the hub for teamwork in Microsoft 365, providing a centralized workspace for teams to communicate and collaborate. It features persistent and threaded chats, file sharing, and the ability to hold meetings. Students will learn to create teams, add users, manage a team, start a team conversation, reply to a conversation, and add files. In addition, students will explore channels, create new channels, create and share files, work with meetings, schedule team meetings, integrate with SharePoint, add tabs to keep files, notes, and apps available, and connectors to access content and get updates.

• Access 31 lectures & 2+ hours of content 24/7
• Communicate with your colleagues using Microsoft Teams
• Learn how to create or join a meeting via Teams
• Schedule your next virtual meeting

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop or mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

Intellezy
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From their change management consulting to their learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Their online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Their library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

KEY FEATURES

This course is designed to teach students the basics of Microsoft Outlook 365 and help them gain familiarity with the Outlook environment and basic functionality. You will learn the basics of email, how to create and send messages, and how to work with attachments. You will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures.

• Access 43 lectures & 1 hour of content 24/7
• Send professional emails to your clients, business partners, or colleagues
• Filter, sort & categorize messages for easy access
• Manage meeting responses
• Create & edit contacts

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop or mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

Intellezy
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From their change management consulting to their learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Their online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Their library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

KEY FEATURES

In this course, you will expand upon your existing knowledge and learn and use advanced features of Microsoft Outlook 365. You will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. You will also review rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up your Outlook data.

• Access 26 lectures & 2 hours of content 24/7
• Set up accounts & work w/ messages
• Organize & manage your mails
• Attach files, photos & graphics in Outlook

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop or mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

Intellezy
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From their change management consulting to their learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Their online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Their library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

KEY FEATURES

Microsoft Excel is the most advanced spreadsheet software in the world. Whether you're a data scientist, finance professional, or accountant, Excel has the tools to help you create anything.

In this course, you'll get all the skills necessary to be a complete professional in no time. You'll learn how to perform basic worksheet operations, work with ranges and tables, use formulas for common mathematical operations, master advanced charting techniques, and analyze data with the Analysis ToolPak.

• Access 30 lectures & 3 hours of content 24/7
• Perform basic worksheet operations
• Work with Excel ranges & tables
• Use formulas for common Mathematical operations
• Master advanced charting techniques
• Analyze data with the Analysis ToolPak

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

LearningWhilePracticing

LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

At the beginning of this course, you may start as a complete novice in Microsoft Word. However, as you go along with this course, you will learn how to do basic operations, like copying and pasting texts. You will also be introduced to eBook publishing, which is very useful for aspiring writers.

At the end of this course, you will master all the tools, shortcuts & other basic functionalities found in Microsoft Word, which can make your work much easier and faster.

• Access 157 lectures & 3 hours of content 24/7
• Learn how to prepare documents for printing & exporting
• Properly work w/ layouts & templates
• Format documents effectively using Microsoft Word Styles
• Control page formatting & flow with sections & page breaks

NOTE: Software NOT included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

LearningWhilePracticing

LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

If you want to get started on a career in database management, Microsoft Access is the best place to start. It's used for everything from storing data to producing reports and analyses.

This course will teach you all you need to know about creating and managing databases, tables, and fields, and printing out your data. You'll also learn how to manage security when working with databases.

• Access 188 lectures & 10 hours of content 24/7
• Create & modify databases
• Control user data entry effectively
• Print & export data
• Build an efficient database table design
• Create reports for sharing & presenting your data in a clear, professional way

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

LearningWhilePracticing

LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

If you want to create an outstanding presentation for your next meeting, this course is for you. The course features multimedia content and hands-on exercises that show you how to use Microsoft PowerPoint in a fast-paced environment. Also, you’ll learn to create graphics that invite your audience into your slides. In the Using Graphics and Multimedia Content section, you will get the chance to know how photos and other images are used in presentations, as well as discussions about various types of animating objects and sound effects.

• Access 13 lectures & 4 hours of content 24/7
• Build a powerful PowerPoint presentation
• Boost your presentation using graphics & multimedia content
• Master animation effects & transitions to wow your audience

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Updates included
• Have questions on how digital purchases work? Learn more here

Requirements

• Any device with basic specifications

THE EXPERT

LearningWhilePracticing

LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

Everything a pro needs, all in one suite — that’s Microsoft Office 2021 Professional.

Microsoft Office 2021 Professional is the perfect choice for any professional who needs to handle data and documents. It comes with many new features that will make you more productive in every stage of development, whether it’s processing paperwork or creating presentations from scratch – whatever your needs are!

The tools within this suite have been redesigned so they can be used equally by designers looking for inspiration on how best to present their work, as well as data analysts working with large sets of data for their company reports; there really isn’t anything left out when using these applications.

The ribbon-based user interface provides quick access to all its available features, tools, and customizations. Users can easily customize font, layout, indentation size of type in documents as well as many other details. Make more aesthetically pleasing documents without sacrificing functionality for work-related needs like formatting emails or creating presentations.

• Lifetime license for MS Word, Excel, PowerPoint, Outlook, Teams, OneNote, Publisher, & Access
• One-time purchase installed on 1 Windows PC for use at home or work
• Instant Delivery & Download – access your software license keys and download links instantly
• Free customer service – only the best support!

Office Professional 2021 includes:

• Microsoft Office Word
• Microsoft Office Excel
• Microsoft Office PowerPoint
• Microsoft Office Outlook
• Microsoft Office Teams
• Microsoft Office OneNote
• Microsoft Office Publisher
• Microsoft Office Access

PRODUCT SPECS

System Requirements

• Windows 10, 11
• Recommended 1 GB of RAM
• 4 GB available of hard disk formatting such as HFS + (also known as Windows OS Extended or HFS Plus)
• A monitor with 1280×800 resolution or higher

Important Details

• ONE-TIME PURCHASE FOR 1 PC
• Redemption deadline: redeem your code within 30 days of purchase
• Access options: desktop
• No subscriptions – no monthly/annual fees
• Version: 2021
• All languages supported
• Updates included
• Have questions on how digital purchases work? Learn more here