Cart
You have no items in your shopping cart
Microsoft Excel Book Excel 2010 Basic Advanced Expert E-learning+Book
Book Excel 2010 Basic Advanced Expert E-learning+Book
€137,50 €127,50

Cheaper somewhere else?

Let us know!

+31367601019 [email protected]

Book Excel 2010 Basic Advanced Expert E-learning+Book

|
€137,50 €127,50 Excl. tax
€166,38 €154,28 Incl. tax
In stock
|
Order before 4:00 PM and start today.
You have got counting... hours
  • Bestellen op Factuur
  • Beste opleider 2019
  • Na Betaling Direct Starten
Information

Course package Excel 2010 Basic / Advanced / Expert incl. Excel 2010 Course book

With this course package you will receive an Excel 2010 course book as a reference work in addition to the online course.

Take this unique Microsoft Excel 2010 E-learning course. You get 1 year of 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, speech, subtitling, practical assignments with real-time analysis of your answers. After you have completed> 70% of the course with a pass, you will receive a certificate of participation by e-mail. This course has been developed by MOS Master teachers with more than 27 years of experience. This allows you to use this course to prepare yourself for the Microsoft Office Specialist (MOS) exam Excel Core and / or Excel Expert.

If you want to train your entire organization, we apply attractive special rates.
For pricing information please contact us. You will receive your customized quote / offer by e-mail within 1 working day.

Course content:

Basics:

What you should know about: Spreadsheets
General working environment
Opening workbooks
Movement in a workbook
What you should know about: Input assistance
Enter data
What you need to know about: Select, copy and move
Select and delete cells
Cancel and restore an operation
Column width / row height
What you should know about: Save files
Save workbooks
Adjust the contents of a cell
Create a new workbook
Use Excel Help
Zoom in and out
Apply a theme
What you should know about: Formatting characters
Formatting 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
Search and replace
Insert or delete rows, columns, and cells
Move cells
Copy to non-adjacent cells
Merge cells
Cell content orientation
Cell styles or formatting
Page layout
Print preview and printing
Print titles of columns and rows repeatedly
Hide items on a worksheet
Page break
Print range
What you should know about: Header and footer
Header and footer
Copy the layout of a cell quickly
What you should know about: Enter functions
System date and date format
Sort a table
Block columns / rows, split screen


Advanced:

Create and move a graph
Print a graph 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
Blank and duplicate values
What you should know about: Criterion range
Filter with a criterion range
Copy rows filtered through a criterion range
Calculations with criterion range
View multiple lines in a cell
An absolute reference in a formula
Copy and transpose calculation results and links
Name of a worksheet, color of the tab
Insert, remove, and set worksheets
Move, copy and hide worksheets
Create a graphic object
Select and delete objects
Copy and move objects
Insert an image
Manage a graph
Select chart elements
Add or remove elements
Layout of graph elements
Change text elements of the graph
Legend and drawing area
Data series and chart axes
Manage series
Chart types options
Management of chart templates
Create a sparkline graph
Manage 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 notation
Apply a conditional format
Managing conditional formatting
Cell range name
Validation criterion
Convert data
Create data series
Cell range in a function
Organize data into an overview
Custom views
Comment on a cell
Calculations with copies


Expert:

Hyperlink
Convert Excel files
Security of a workbook
Protect cells
Recover versions and files
What you should know about: Pivot tables and charts
Make pivot table
Change a pivot table
Select, copy, move and delete a PivotTable
Organize and format a pivot table
Filtering and searching in a pivot table
Pivot chart
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 adjust a theme
What you should know about: Styles and templates
Create and use a template
Edit and delete a template
Properties of a workbook
What you should know about: Personalize the ribbon
Error checking
Evaluate formulas
Check window
Financial functions
Table with double entry
Target search
The solver
Scenario management
Macro command
What you should know about: Data export
Transfer of Excel data: PDF, XPS, e-mail and web page
Import data
Update and manage imported data
Share a workbook
Track changes in a workbook
Merge workbooks
Complete a document
Digital signature
What you should know about: SharePoint site
What you should know about: Remote collaboration
What you should know about: Good habits for a spreadsheet

Heeft u niet gevonden wat u zocht?
Let us help!
Specifications
General properties
Delivery time: Within 1 working day
Online access: Standard 12 months
Lesson duration: variable
Study load: Variable because of practical assignments.
Certificate of participation: Yes, after 70% of the successful assignments
Learning methods: Instruction video, Demonstration video, Knowledge Base
Operating systems: Microsoft Windows, Google Chrome OS, Apple MacOS
Included services: Contact with teacher by e-mail and chat, Progress report, 24/7 online access
Supported browsers: Internet Explorer, Edge, Firefox, Safari en Chrome
Certification: Possible for corresponding exam number
MOS Exam:
Extra options: Virtual Labs (if available)
Access to teacher: By e-mail and chat
Reviews
average of 0 review(s)
No reviews found
Read or write a review
Write a review




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