Excel - Excel 2016 Basic Advanced Expert - Excel voor Financials, Draaitabellen in Excel, Excel Draaitabellen, Excel basis / voor beginners, Data Analyse Excel, Draaitabellen

Type product

Excel - Excel 2016 Basic Advanced Expert - Excel voor Financials, Draaitabellen in Excel, Excel Draaitabellen, Excel basis / voor beginners, Data Analyse Excel, Draaitabellen

OEM Office Elearning Menu NL
Logo van OEM Office Elearning Menu NL
Opleiderscore: starstarstarstarstar_half 8,9 OEM Office Elearning Menu NL heeft een gemiddelde beoordeling van 8,9 (uit 180 ervaringen)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Beschrijving

Excel 2016 Course E-learning Beginner, Intermediate & Expert

Elearning Excel 2016 course online. An extraordinary e-learning methodology in a virtual office application. Practice 365 days at your own pace and in your own order (after activation). Varied, interactive multimedia lessons with video, audio and subtitles. Practical exercises with real-time analysis of the actions and results of the student. Exam preparation for Microsoft Office Specialist (MOS). E-learning developed by professional lecturers with more than 27 years of experience.

Publisher: Microsoft Gold Certified Partner.

On our learning portal you will receive a certificate of participation with a success rate of at least 7…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Excel 2016 Course E-learning Beginner, Intermediate & Expert

Elearning Excel 2016 course online. An extraordinary e-learning methodology in a virtual office application. Practice 365 days at your own pace and in your own order (after activation). Varied, interactive multimedia lessons with video, audio and subtitles. Practical exercises with real-time analysis of the actions and results of the student. Exam preparation for Microsoft Office Specialist (MOS). E-learning developed by professional lecturers with more than 27 years of experience.

Publisher: Microsoft Gold Certified Partner.

On our learning portal you will receive a certificate of participation with a success rate of at least 70%. Integration capability in LMS or ELO Platform (AICC, SCORM).

Content: Excel 2016 E-learning Course Beginner

  • 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, freeze a column/row
  • Repeating rows/columns on printed pages
  • Hiding elements of a sheet
  • Summarising data with an outline

Content: Excel 2016 E-learning Course Intermediate

  • Displaying several lines of data in one cell
  • Absolute reference in a formula
  • Copying values, copying with a link
  • 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
  • Defining the layout and the presentation of a pivot table
  • Filtering and searching for data in a pivot table
  • Pivot charts

Content: Excel 2016 E-learning Course 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
  • 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
  • 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: Office Online and Office 365
  • You need to know: Best practice with a spreadsheet application
  • You need to know: Sharing a workbook

Verrijk Uw Carrière met OEM's 1000+ ICT Trainingen en Certificeringen

Ontdek de wereld van mogelijkheden met OEM's uitgebreide aanbod van meer dan 1000 ICT trainingen, cursussen, en certificeringen. Of u nu op zoek bent naar E-Learning, Incompany trainingen of Virtual Classroom sessies, wij hebben alles om aan uw leerbehoeften te voldoen.

Waarom voor OEM Kiezen?

  • Uitgebreide Selectie: Kies uit een breed scala aan cursussen van meer dan 200 topmerken voor uw persoonlijke en professionele groei.
  • Hoge Tevredenheid: Onze cursisten hebben ons een indrukwekkende beoordeling van 8.9 op Springest gegeven.
  • Kwaliteitsgarantie: Profiteer van onze Award Winning E-learning en leer van gecertificeerde docenten die experts zijn in hun vakgebied.

Neem Nu Actie voor Uw Professionele Ontwikkeling:

  • Bezoek onze website om het volledige aanbod te verkennen en de training te kiezen die bij u past.
  • Schrijf u vandaag nog in en begin aan uw reis naar certificering en deskundigheid in de ICT.

Wacht niet langer om uw vaardigheden te verbeteren en uw carrière naar een hoger niveau te tillen. Met OEM's uitgebreide trainingsaanbod bent u slechts één stap verwijderd van het realiseren van uw professionele doelen.

Begin vandaag nog met leren – Uw toekomst wacht!

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.