Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »
Item number: 27920686

Excel 2016 Course Advanced E-Learning

Item number: 27920686

Excel 2016 Course Advanced E-Learning

80,00 96,80 Incl. tax

Take an online Excel 2016 Advanced course now. You learn, among other things, how to select and delete objects, filter and copy rows with the criterion range and make pivot charts.

Read more
Discounts:
  • Buy 5 for €75,00 each and save 6%
  • Buy 11 for €70,00 each and save 13%
  • Buy 31 for €65,00 each and save 19%
  • Buy 61 for €60,00 each and save 25%
  • Buy 101 for €50,00 each and save 38%
  • Buy 251 for €40,00 each and save 50%
Availability:
In stock
Delivery time:
Ordered before 5 p.m.! Start today.
  • Award Winning E-learning
  • Lowest price guarantee
  • Personalized service by our expert team
  • Pay safely online or by invoice
  • Order and start within 24 hours

Excel 2016 Course Advanced E-Learning 

  • Target group: Beginners with some basic knowledge who want to master the basic functionalities of Excel
  • Level: Advanced
  • Required knowledge level: Basic computer knowledge
  • Course duration: 4:50 (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 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

  • You need to know: About your spreadsheet application
  • Opening a workbook
  • Overview of the environment
  • Moving around a workbook
  • You need to know: Text made easy
  • Entering data
  • You need to know: Selecting, copying, moving
  • Selecting and deleting cells
  • Undoing and redoing an action
  • Column width/row height
  • You need to know: Saving files
  • Saving a workbook
  • Modifying the contents of a cell
  • Creating a new workbook
  • Entering a calculation formula
  • Calculating a sum and other basic functions
  • Calculating a percentage
  • Reproducing data in adjacent cells
  • Simple numerical formats
  • Applying a theme
  • You need to know: Formatting characters
  • Formatting characters
  • Character font and size
  • Aligning cell content
  • Cell colour
  • Cell borders
  • Page layout
  • Print preview and printing
  • Page breaks
  • Print areas
  • You need to know: Headers and footers
  • Headers and footers
  • Using Microsoft Excel Help
  • Checking spelling
  • Find and replace
  • Zoom
  • Inserting/deleting rows, columns and cells
  • Moving cells
  • Copying to non-adjacent cells
  • Copying cell format quickly
  • Merging cells
  • Orientation of cell content
  • Cell styles
  • Sorting data
  • Sheet name, tab colour
  • Inserting and deleting sheets, sheet background
  • Moving, copying, hiding sheets
  • Splitting the window, freezing a column/row
  • Repeating rows/columns on printed pages
  • Hiding elements of a sheet
  • Summarising data with an outline

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.

Online access 365 days
Total
9.3/10 (3 Reviews)

    "Cursus is helder en erg leerzaam. Video uitleg wordt stap voor stap gegeven en als je de vraag niet goed hebt beantwoord, wordt er in de uitleg heel duidelijk aangegeven wat je moet doen.

    Zeker een aanrader voor mensen die iets meer willen deep diven in hun Excel skills."

    Iris Bruinsma on 27 Feb 2020

    "Leerzame training. Soms is de vraagstelling een beetje onduidelijk"

    Melissa van HETTEN on 31 Oct 2018

    "Een zeer volledige, maar ook wel pittige training, waarbij ik heel veel heb geleerd over Excel. Doordat je stapje voor stapje mee wordt genomen door Excel is het erg goed te doen en was het voor mij erg leerzaam. De onderwerpen worden in kleine hoofdstukken behandeld. Ik vond dat erg prettig werken. Dat maakt het erg overzichtelijk."

    Van Essen on 23 Jan 2017

Excel 2016 + Naslagwerk

  • Normally: 129,95
  • You save: (4% korting) 5,-
  • Total: 124,95
Add to cart
Loading...

OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.

Reviews

Total
9.3/10 (3 Reviews)

    "Cursus is helder en erg leerzaam. Video uitleg wordt stap voor stap gegeven en als je de vraag niet goed hebt beantwoord, wordt er in de uitleg heel duidelijk aangegeven wat je moet doen.

    Zeker een aanrader voor mensen die iets meer willen deep diven in hun Excel skills."

    Iris Bruinsma on 27 Feb 2020

    "Leerzame training. Soms is de vraagstelling een beetje onduidelijk"

    Melissa van HETTEN on 31 Oct 2018

    "Een zeer volledige, maar ook wel pittige training, waarbij ik heel veel heb geleerd over Excel. Doordat je stapje voor stapje mee wordt genomen door Excel is het erg goed te doen en was het voor mij erg leerzaam. De onderwerpen worden in kleine hoofdstukken behandeld. Ik vond dat erg prettig werken. Dat maakt het erg overzichtelijk."

    Van Essen on 23 Jan 2017

Combideals

Grab a bundle and receive a discount

Excel 2016 + Naslagwerk

  • Normally: 129,95
  • You save: (4% korting) 5,-
  • Total: 124,95
Add to cart

25.000+

Deelnemers getrained

Springest: 9.1 - Edubookers 8.9

Gemiddeld cijfer

3500+

Aantal getrainde bedrijven

20+

Jaren ervaring

Even more knowledge

Read our most recent articles

View blog