Microsoft Excel: Excel 2016 Advanced and Expert

Product type

Microsoft Excel: Excel 2016 Advanced and Expert

OEM Office Elearning Menu EN
Logo OEM Office Elearning Menu EN
Provider rating: starstarstarstarstar 10 OEM Office Elearning Menu EN has an average rating of 10 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

Excel 2016 Advanced and Expert.

  • Target group: Beginners with some basic knowledge who want to master the basic functionalities of Excel
  • Level: Advanced, Expert
  • Required knowledge level: Basic computer knowledge
  • Course duration: 8:55 (depending on personal speed)
  • Online access: 24/7, 365 days after activation
  • Online book included
  • Certificate of Participation included (after a minimum of 70% success rate)

Excel course

Order this unique E-Learning course Excel 2016 Advanced and Expert online and get 1 year 24/7 access to a virtual Office Cloud environment with rich interactive videos, voice, subtitles and practice assignments. Your answers are analyzed in real-time and pro…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Excel, E-commerce, Microsoft Word, Microsoft Powerpoint, and Microsoft Office.

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

Excel 2016 Advanced and Expert.

  • Target group: Beginners with some basic knowledge who want to master the basic functionalities of Excel
  • Level: Advanced, Expert
  • Required knowledge level: Basic computer knowledge
  • Course duration: 8:55 (depending on personal speed)
  • Online access: 24/7, 365 days after activation
  • Online book included
  • Certificate of Participation included (after a minimum of 70% success rate)

Excel course

Order this unique E-Learning course Excel 2016 Advanced and Expert online and get 1 year 24/7 access to a virtual Office Cloud environment with rich interactive videos, voice, subtitles and practice assignments. Your answers are analyzed in real-time and progress is tracked through reports. This E-Learning course also prepares for the Microsoft Office Specialist MOS exam thanks to its high quality. It is developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal LMS you will find reports and receive the course, among other things. A SCORM option is also available.

Course content

Advanced

  • Displaying several lines of data in one cell
  • Absolute reference in a formula
  • Copying values, copying with a link, transposing
  • You need to know: Calculating with functions
  • Control date, date formats
  • Simple conditions
  • Custom formats
  • Applying a conditional format
  • Managing conditional formats
  • Naming a range of cells
  • Validation rules
  • Multiple cell ranges and calculations in functions
  • You need to know: Charts
  • Creating and positioning a chart
  • Managing a chart
  • Selecting items in a chart
  • Adding and removing items
  • Formatting chart items
  • Modifying a chart's text items
  • Legend and plot area
  • Printing and page layout of a chart
  • Modifying data labels
  • Data series and chart axes
  • Managing series
  • Chart type options
  • Managing chart templates
  • Creating a sparkline
  • Managing sparklines
  • Creating a drawing object
  • Selecting and deleting objects
  • Copying and moving objects
  • Resizing a drawing object
  • Modifying a text box
  • Modifying a drawing
  • Formatting drawing objects
  • Inserting a picture
  • Managing pictures
  • Rotating and aligning objects
  • Stacking and grouping objects
  • Subtotal rows
  • Creating and managing a table
  • Presenting and sorting data in a table
  • Automatic calculations in a table
  • Automatic filtering
  • Custom filters
  • Blank cells and duplicates
  • You need to know: Advanced filtering with a criteria range
  • Criteria ranges
  • Copying rows filtered using a criteria range
  • Statistics with a criteria range
  • You need to know: Flash Fill
  • You need to know: Pivot tables and pivot charts
  • Creating a pivot table
  • Modifying a pivot table
  • Selecting, copying, moving or deleting in a pivot table
  • Defining the layout and the presentation of a pivot table
  • Filtering and searching for data in a pivot table
  • Pivot charts  

Expert

  • Converting data
  • Creating a data series
  • Custom views
  • Attaching a comment to a cell
  • Detecting errors
  • Evaluating formulas
  • The Watch Window
  • Lookup functions
  • Text functions
  • Time calculations
  • Date calculations
  • Condition with AND, OR, NOT
  • Nested conditions
  • Conditional functions
  • Array formulas
  • Calculating with copied values
  • Consolidation
  • Financial functions
  • Double entry data table
  • Goal seek
  • The Solver
  • Managing scenarios
  • Hyperlinks
  • Creating and customising a theme
  • You need to know: Styles and templates
  • Creating and working with templates
  • Modifying and deleting templates
  • You need to know: Exporting data
  • Diffusing Excel data: PDF, XPS, e-mail and Web page
  • Converting Excel files
  • Importing data
  • Updating and managing imported data
  • Workbook properties
  • Protecting workbooks
  • Protecting specific cells
  • Sharing a workbook
  • Tracking changes in a workbook
  • Merging workbooks
  • Finalising a workbook
  • Digital signatures
  • Creating a form
  • Protecting and using a form
  • Macros
  • Versions and recovery of files
  • You need to know: Customising the ribbon
  • You need to know: The SharePoint site
  • You need to know: Sharing a document over the internet
  • You need to know: Best practice with a spreadsheet application

What is Excel?

Microsoft Excel is Microsoft's spreadsheet program and part of Microsoft Office. A spreadsheet is a digital spreadsheet. Microsoft Excel is available in its current form for the Microsoft Windows operating system and for macOS

10 benefits of Excel

  1. Organization: Excel is a powerful organization tool that allows you to organize and analyze data in an organized way.
  2. Calculations: Excel offers simple to complex calculations, saving you time and maintaining accuracy.
  3. Graphs and charts: Excel includes an array of graph and chart functions that you can use to present data visually.
  4. Formulas: Excel contains numerous built-in formulas that you can use to perform various calculations.
  5. Database functionality: Excel can be used as a database through tables, making it an excellent tool for storing data.
  6. Automate: Excel can be programmed to perform tasks automatically, saving you time and energy.
  7. Data analysis: Excel includes powerful data analysis features that allow you to quickly understand your data.
  8. Accessibility: Excel is widespread and easily accessible, both at work and at home.
  9. Advanced features: Excel includes advanced features for working with large amounts of data, such as sorting, filtering, searching and replacing.
  10. User-friendly: Excel has an intuitive interface that is easy to use, even for beginners

Why is Excel important?

  • Organization of data: Excel is a powerful tool for organizing and structuring data. It provides the ability to display data in tables, graphs and charts, making it easier to understand and analyze information.

  • Calculations and formulas: Excel can perform complex calculations and formulas, making it a valuable tool for financial and mathematical analysis.

  • Time and task management: Excel provides the ability to keep track of schedules and task lists and can help plan and track projects.

  • Business applications: Excel is widely used in business environments for financial analysis, budgeting, billing, inventory management and more.

  • Data analysis: Excel offers the ability to analyze and visualize large amounts of data, making it a valuable tool for data mining and business intelligence.

In short, Excel is important because of its versatility and ability to organize, perform calculations and analyze data, making it a valuable tool for a wide range of tasks and applications.

Why OEM Office Elearning Menu?

OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more. 

OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.

Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.

OEM - Learn to Work

Choose from 1000+ training courses from 200+ brands for your personal and business development. 

An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.

We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.