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 Book Excel 2013 Basic Advanced Expert E-Learning + Book

7% sale
Product description
E-Learning Book Excel 2013 Basic Advanced & Expert + Book Online With this course package you will receive an Excel 2013 course book as a reference book in addition to the online course.Follow this unique E-Learning course Microsoft Excel 2013. You get 1 year 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, spe...

E-Learning Book Excel 2013 Basic Advanced & Expert + Book Online

With this course package you will receive an Excel 2013 course book as a reference book in addition to the online course.Follow this unique E-Learning course Microsoft Excel 2013. You get 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. After you have passed> 70% of the course, 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. 

Course content

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 format
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 Volume discount Would you like to register several people at once for this online course? Then we offer special graduated prices (excluding 21% VAT). If you want to train your entire organization, we use rates that are even more attractive.
In both cases, please contact us or request your offer here in 3 easy steps.
You will receive your customized quote / offer by e-mail within 1 working day.

Product specifications

Online access
365 days

Reviews

0 / 5Based on 0 reviews

There are no reviews written yet about this product..

Create your own review

Eerder bekeken door jou

Microsoft Excel Book Excel 2013 Basic Advanced Expert E-Learning Book
Microsoft ExcelBook Excel 2013 Basic Advanced Expert E-Learning Book

Train yourself online in Excel 2013 at Basic, Advanced and Expert level and also receive the Excel 2013 course book more cheaply. Interactive E-Learning in combination with a Course book.

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