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 2010 Custom E-Learning

Product description
E-Learning Course Excel 2010 Customization Online Follow this unique Excel 2010 course via tailor-made E-Learning. An Excel 2010 course on basic, advanced and Expert level with a practical (pre-test) in advance, the result of this test is imported into your course so that you have a tailor-made course. The progress report of your course shows whic...

E-Learning Course Excel 2010 Customization Online

Follow this unique Excel 2010 course via tailor-made E-Learning. An Excel 2010 course on basic, advanced and Expert level with a practical (pre-test) in advance, the result of this test is imported into your course so that you have a tailor-made course. The progress report of your course shows which knowledge you have not yet mastered, but also in which parts you can work more efficiently. This only learns what you need to know about Excel 2010

.
Order this unique E-Learning course Microsoft Excel 2010, 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

Basic:

What you need to know about: Spreadsheets
General work environment
Opening workbooks
Movement in a 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 and restore an operation
Column width / row height
What you should know about: Saving files
Save workbooks
Adjust the contents of a cell
Create a new workbook
Using Excel Help
Zoom in and out
Apply a theme
What you need to know about: Format characters
Formatting of characters
Font and font size
Align cell contents
Color of the cells
Cell edges
Enter formulas
Sum and other simple calculations
Calculate a percentage
Copy to adjacent cells
Simple number formats
Spell check
Find and replace
Insert or delete rows, columns and cells
Move cells
Copy to non-adjacent cells
Merge cells
Orientation for cell contents
Cell styles or formatting
Page layout
Print preview and print
Repeatedly print column and row titles
Hide items on a worksheet
Page break
Print range
What you need to know about: Header and footer
Header and footer
Quickly copy the formatting of a cell
What you need to know about: Entering functions
System date and date format
Sort a table
Freeze columns / rows, split screen

Advanced:

Create and move a chart
Print a chart and determine the page layout
Calculate subtotals
Create and manage a table
Display and sorting of table data
Automatic calculations in a table
Automatic filtering
Custom filters
Empty and duplicate values
What you need to know about: Criteria range
Filter with a criteria range
Copy rows filtered by a criteria range
Criteria range calculations
Display multiple lines in a cell
An absolute reference in a formula
Copy, transpose calculation results and links
Name of a worksheet, color of the tab
Insert, delete worksheets and set background
Move, copy and hide worksheets
Create a graphic object
Select and delete objects
Copy and move objects
Insert a picture
Manage a chart
Select chart elements
Add or remove elements
Format of chart elements
Change text elements of the chart
Legend and plot area
Data series and chart axes
Manage sequences
The options of chart types
Chart template management
Create a sparkline chart
Managing sparklines
Determine the size of a graphic object
Edit a text box
Edit a drawing
Format drawing objects
Manage images
Rotate and align objects
Overlapping and grouping of objects
Simple condition
Custom format
Apply a conditional formatting
Controlling conditional formatting
Range of cells name
Validation criterion
Convert data
Create data series
Range of cells in a function
Organize data in an overview
Custom Views
Comment on a cell
Calculations with copies


Expert:

Hyperlink
Convert excel files
Security of a workbook
Protect cells
Restore versions and files
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
Search table and functions
Text functions
Calculate time
Calculate data
Condition with AND, OR, NOT
Nested conditions
Conditional functions
Matrix formula
To merge
Create and modify a theme
What you need to know about: Styles and templates
Create and use a template
Edit and delete a template
Properties of a workbook
Know Before You Go: Personalize the ribbon
Error checking
Evaluate formulas
Window Control
Financial functions
Double entry table
Goal Seeking
The solver
Scenario management
Macro command
What you need to know about: Data export
Excel data transfer: PDF, XPS, email and web page
Import data
Update and manage imported data
Share a workbook
Track changes to a workbook
Merge workbooks
Finalize a document
Digital signature
What you need to know about: SharePoint site
What you need to know about: Remote collaboration
What you need to know about: Good spreadsheet habits

Product specifications

Online access
365 days

Reviews

4.9 / 5Based on 8 reviews
  • 5 / 5
    Posted by: Eline on 30 March 2020
    Duidelijke opdrachten en antwoorden > filmpje als check. Enige nadeel is de spreekster van de video's, deze is erg monotoon. Maar voordeel is dat je ook bij elke video kan meelezen en op elk gewenst moment stop kan zetten.
  • 5 / 5
    Posted by: Jan Franssen on 20 November 2019
    Zeer goede cursus!
  • 5 / 5
    Posted by: Mirjam on 4 March 2019
    Fijn op eigen tijd en in eigen tempo alle onderdelen door te kunnen lopen! Heel compleet; veel geleerd waarvan ik niet wist dat het kon in Excel.
Create your own review

Eerder bekeken door jou

Microsoft Excel Excel 2010 Custom E-Learning
Microsoft ExcelExcel 2010 Custom E-Learning

Start an Excel 2010 course online now. You start before the course with a practical (pre-test), the result of this test is imported into your course so that you have a tailor-made course. Order easily online or by invoice.

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