De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Microsoft Excel Excel 2013 Basic Advanced & Expert E-Learning

Product description
E-Learning Course Excel 2013 Basic Advanced & Expert Online Order this unique E-Learning course Excel 2013 Basic Advanced & Expert, 1 year 24/7 access to a virtual Office Cloud environment with rich interactive videos, speech, subtitles, practical assignments with real-time analysis of your answers, progress monitoring through reports. Th...

E-Learning Course Excel 2013 Basic Advanced & Expert Online

Order this unique E-Learning course Excel 2013 Basic Advanced & Expert, 1 year 24/7 access to a virtual Office Cloud environment with rich interactive videos, speech, subtitles, practical assignments with real-time analysis of your answers, progress monitoring through reports. This E-Learning also prepares you for the Microsoft Office Specialist MOS exam thanks to its high quality. Developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal LMS including reports and after 70% of the course a certificate of participation. SCORM capability.

Course content

Excel 2013 Basic, Advanced & Expert Online

Basic:

What you need to know about: Spreadsheets
Open workbooks
General work environment
Move in workbook
What you need to know about: Input help
Enter data
What you need to know about: Select, copy and move
Select and clear cells
Cancel operation and restore
Column width / row height
What you should know about: Saving files
Save workbooks
Customize cell contents
Create new workbook
Enter formulas
Sum and other simple calculations
Calculate percentage
Copy to adjacent cells
Simple number formats
Apply theme
What you need to know about: Format characters
Character formatting
Font and font size
Align cell contents
Cell color
Cell edges
Page layout
Print preview and print
Page break
Print range
What you need to know about: Header and footer
Header and footer
Using Excel Help
Spell check
Find and replace
Zoom in and out
Insert or delete rows, columns and cells
Move cells
Copy to non-adjacent cells
Quickly copy cell formatting
Merge cells
Cell contents orientation
Cell Styles
Sort a table
Worksheet name, tab color
Insert, delete worksheets and set background
Move, copy and hide worksheets
Block columns / rows, split screen
Print titles columns and rows repeatedly
Hide items on worksheet
Organize data in an overview  

Advanced:

Display multiple lines in cell
An absolute reference in formula
Copy, transpose calculation results and links
What you need to know about: Entering functions
System date and date format
Simple condition
Custom format
Apply a conditional formatting
Control conditional formatting
Range of cells name
Validation criterion
Range of cells in functions
What you need to know about: Charts
Create and move a chart
Managing a chart
Select chart elements
Add or remove elements
Format chart elements
Change graph text elements
Legend and plot area
Print a chart and page layout
Change data labels
Data series and chart axes
Manage sequences
Chart type options
Manage chart templates
Create a sparkline chart
Managing sparklines
Create a graphic object
Select and delete objects
Copy and move objects
Determine the size of a graphic object
Edit a text box
Edit a drawing
Format drawing objects
Insert a picture
Manage images
Rotate and align objects
Overlap and group objects
Calculate subtotals
Create and manage a table
View and sort table data
Automatic calculations in table
Automatic filtering
Custom filters
Empty and duplicate values
What you need to know about: Criteria ranges
Filter with criteria range
Filter and copy rows with criteria range
Criteria range calculations
What you need to know about: Autofill
What you need to know about: Pivot Tables and Charts
Create pivot table
Modify a pivot table
Select, copy, move, and delete a pivot table
Organize and format a pivot table
Filter and search in a pivot table
PivotChart


Expert:

Convert data
Create data series
Custom Views
Note to cell
Error checking
Evaluate formulas
Window Control
Search table and functions
Text functions
Calculate time
Calculate dates
Conditions with AND, OR, NOT
Nested conditions
Conditional functions
Matrix formula
Calculations with copies
To merge
Financial functions
Double entry table
Goal Seeking
Solver
Scenario management
Hyperlink
Create and modify a theme
What you need to know about: Styles and templates
Create and use a template
Edit and delete a template
What you need to know about: Data export
Excel data transfer: PDF, XPS, email and web page
Convert excel files
Import data
Update and manage imported data
Workbook properties
Workbook security
Protect cells
Share a workbook
Track changes to workbook
Merge workbooks
Finalize a document
Digital signature
Create a form
Secure and use a form
Macro command
Restore versions and files
Know Before You Go: Personalize the ribbon
What you need to know about: SharePoint site
What you need to know about: Microsoft account
What you need to know about: Good spreadsheet habits

Product specifications

Online access
365 days

Reviews

4.2 / 5Based on 8 reviews
  • 5 / 5
    Posted by: Lupa Alam-Chand on 21 November 2019
    Weet niet of 5 goed of als slecht beoordeeld wordt. De beoordeling die ik wil geven is goed. Goede opbouw, goede uitleg en goede manier van oefenen. Heb hier niks op aan te merken.
  • 3 / 5
    Posted by: Robbert Houtveen on 1 July 2019
    Inhoud van de training sloot goed aan bij het geen ik wou leren.
    Echter de digitale leeromgeving werkte helaas niet na behoren. Bij de start waren er problemen met het afspelen van de instructie filmpjes. Sommige opdrachten m...
    Inhoud van de training sloot goed aan bij het geen ik wou leren. Echter de digitale leeromgeving werkte helaas niet na behoren. Bij de start waren er problemen met het afspelen van de instructie filmpjes. Sommige opdrachten moesten precies volgens bepaalde instructies uitgevoerd worden terwijl via een andere manier de opdracht ook uitgevoerd kon worden. Verder zijn de instructies niet allemaal even duidelijk.
  • 4 / 5
    Posted by: Vera van Miert on 4 May 2019
    In een Eigen tempo vertrouwd raken met Excel.
Create your own review

Excel 2013 + naslagwerk

Microsoft Excel 2013 course Book

Microsoft Excel Excel 2013 Basic Advanced & Expert E-Learning

Excel 2013 Basic Advanced & Expert E-Learning

You save 2%
€137,50
€135,13

Excel 2013 + naslagwerk

Excl. tax
I'm going to order

USP underneath buy button

Eerder bekeken door jou

Microsoft Excel Excel 2013 Basic Advanced Expert E-Learning
Microsoft ExcelExcel 2013 Basic Advanced Expert E-Learning

Take an online course Excel 2013 Basic / Advanced / Expert. You will learn to enter formulas, copy calculation results and links, transpose and create and adjust a theme. Order easily online or on invoice.

€90,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »