Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Essential

Essential cookies help make a website usable by enabling basic functions like course bookings and access to secure areas of the website. The website cannot function properly without these cookies.
Name Description Lifetime
gdpr_cookie_consent Stores the user's cookie consent state for the current domain 1 Year
gdpr_cookie_groups Stores the user's cookie consent state for the current domain 1 Year
FLL_FRONTEND Used for redirecting to sso client 1 Year
FLL_VIEW Used to remember the store view you were last on. 1 Year
form_key Ensures visitor browsing-security by preventing cross-site request forgery. This cookie is essential for the security of the website and visitor. 1 Day
mage-cache-sessid This cookie is used in context with load balancing - This optimizes the response rate between the visitor and the site, by distributing the traffic load on multiple network links or servers. 1 Day
mage-cache-storage This cookie is used in context with load balancing - This optimizes the response rate between the visitor and the site, by distributing the traffic load on multiple network links or servers. 1 Day
mage-cache-storage-section-invalidation This cookie is used in context with load balancing - This optimizes the response rate between the visitor and the site, by distributing the traffic load on multiple network links or servers. 1 Day
mage-cache-timeout This cookie is necessary for the cache function. A cache is used by the website to optimize the response time between the visitor and the website. The cache is usually stored on the visitor’s browser. 1 Day
mage-messages Necessary for the functionality of the website's chat-box function. 1 Day
PHPSESSID Preserves user session state across page requests. 1 Day
product_data_storage Necessary for the compare-products function on the website. 1 Day
recently_compared_product Necessary for the compare-products function on the website. 1 Day
private_content_version Appends a random, unique number and time to pages with customer content to prevent them from being cached on the server. 1 Year
__cf_bm This cookie is used to distinguish between humans and bots. This is beneficial for the website, in order to make valid reports on the use of their website. 1 Day
disableNewsletterPopup Used for disabling newsletter popup 1 Year
recently_compared_product_previous Collects information on which products have been viewed by the visitor - This is used for optimizing the specific visitor's navigation on the website. 1 Day
recently_viewed_product Collects information on which products have been viewed by the visitor - This is used for optimizing the specific visitor's navigation on the website. 1 Day
recently_viewed_product_previous Collects information on which products have been viewed by the visitor - This is used for optimizing the specific visitor's navigation on the website. 1 Day
section_data_ids Used in context with the shopping cart functionality. Remembers any wish-list products and visitor credentials when checking out. 1 Day

Functional

These cookies allow us to analyze your use of the sites, evaluate and improve our performance, and provide a better experience. For example, they help us to know which pages are the most popular and see how visitors move around the sites. They also help power optional features, like social sharing tools.
Name Description Lifetime
geo_country 29 Days
geo_country_name 29 Days

Marketing

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Name Description Lifetime
_ga Registers a unique ID that is used to generate statistical data on how the visitor uses the website. 1 Year
_gat Used by Google Analytics to throttle request rate 1 Day
_gid Registers a unique ID that is used to generate statistical data on how the visitor uses the website. 1 Day
_dc_gtm_UA_# Used by Google Tag Manager to control the loading of a Google Analytics script tag. 1 Year
_ga_# Used by Google Analytics to collect data on the number of times a user has visited the website as well as dates for the first and most recent visit. 1 Year
collect Used to send data to Google Analytics about the visitor's device and behavior. Tracks the visitor across devices and marketing channels. 1 Year
YSC Registers a unique ID to keep statistics of what videos from YouTube the user has seen. 1 Year
VISITOR_INFO1_LIVE Tries to estimate the users bandwidth on pages with integrated YouTube videos. 179 Days
Search
Advanced Search
My Cart
Microsoft Excel 2016

Microsoft Excel 2016

SON-BD-MSXLS2016-EN

GBP 40.00
excl. VAT

We bundled all Excel 2016 courses together for a special price.

This Bundle includes

  • Microsoft Excel 2016: Part 1 - Beginner,
  • Microsoft Excel 2016: Part 2 - Advanced,
  • Microsoft Excel 2016: Part 3 - Expert,
  • Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables,
  • Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

Do you want to finally understand the concept of Excel 2016 and learn basic skills? In the basic course you will learn to understand, in which scenarios the use of Excel 2016 makes sense. Create error-free tables and master the first calculations. You will also learn how data, values ​​and formulas are stored in cells and how you can do more calculations from here.

Excel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016. In the advanced course, you will learn how to organize, analyze, and visualize your data and calculations. We'll also show you how to apply formulas to solve tasks.

Would you like to become an Excel specialist and use the enormous functionality of Excel 2016 to your advantage? In the expert course, you will get to know especially helpful features, such as collaborative editing of workbooks and management of more complex Excel documents, through the implementation of tools such as formula tracking and reference functions.

Maybe you already discovered the power and versatility of PivotTables during previous lessons. The courses are an in-depth training to uncover the full potential of PivotTables and PivotCharts.

Write Your Own Review

Only registered users can write reviews. Please Sign in or create an account

GBP 40.00

Microsoft Excel 2016: Part 1 - Beginner

Module 1

Microsoft Excel 2016: Part 1 - Beginner

Microsoft Excel 2016: Part 1 - Beginner

SO-MSXLS2016-LVL1-EN
Free of Charge
eLearning | Online
English
365 days

Excel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016. 

The training starts with the absolute basics of creating your very first worksheet and progresses through learning numerous capabilities of this very powerful program. Practice files will help you follow the step-by-step training and you can check what you've learned with our quizzes. This course will help you to prepare for the official Microsoft Office Specialist exam. 

See more See less
Microsoft Excel 2016: Part 2 - Advanced

Module 2

Microsoft Excel 2016: Part 2 - Advanced

Microsoft Excel 2016: Part 2 - Advanced

SO-MSXLS2016-LVL2-EN
Free of Charge
eLearning | Online
English
365 days

In this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. 

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you.  

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam. 

See more See less
Microsoft Excel 2016: Part 3 - Expert

Module 3

Microsoft Excel 2016: Part 3 - Expert

Microsoft Excel 2016: Part 3 - Expert

SO-MSXLS2016-LVL3-EN
Free of Charge
eLearning | Online
English
365 days

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates. 

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam. 

See more See less
Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables

Module 4

Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables

Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables

SO-MSXLS2016-LVL4-EN
Free of Charge
eLearning | Online
English
365 days

The need to analyze data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved!

See more See less
Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

Module 5

Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

SO-MSXLS2016-LVL5-EN
Free of Charge
eLearning | Online
English
365 days

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. 

See more See less

* Required Fields

Save

Industry Partners

Sonic
E-learning Format
eLearning | Online
Language
English
Subscription duration
365 days
The time you will have access to the learning product once it has been activated.
Grace Period
30 days
Grace Period is the time between booking and automatic activation. After completing your order, you usually have 30 days until a product is automatically activated and the official subscription period begins.
Total effort
8h 23min
The estimated total effort it will take you to complete the learning product.