Microsoft Excel 2016 Course E-learning Intermediate & Expert

Product type
Level
Logo OEM Office Elearning Menu EN
Provider rating: starstarstarstarstar 10 OEM Office Elearning Menu EN has an average rating of 10 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

Course Excel 2016

Microsoft certified online Excel 2016 courses (Elearning):

• Certificate of participation when at least 70% of the course is successfully completed
• 365 days access to Elearning platform to train at your own pace and order
• A unique Elearning method in a virtual Microsoft Excel environment
• Interactive multimedia lessons. (video’s with spoken explanations and subtitles)
• Practical Assignments with real- time analysis of the actions and results
• 24/7 accessible in an online environment .You can use any computer connected to the Internet
• Results and progress reports
• Can be integrated in LMS or ELO platform (AICC, SCORM)
• Exam Preparation : Microsoft Office Special…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Excel, Internet Security, E-commerce, Microsoft Word, and Microsoft Powerpoint.

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

Course Excel 2016

Microsoft certified online Excel 2016 courses (Elearning):

• Certificate of participation when at least 70% of the course is successfully completed
• 365 days access to Elearning platform to train at your own pace and order
• A unique Elearning method in a virtual Microsoft Excel environment
• Interactive multimedia lessons. (video’s with spoken explanations and subtitles)
• Practical Assignments with real- time analysis of the actions and results
• 24/7 accessible in an online environment .You can use any computer connected to the Internet
• Results and progress reports
• Can be integrated in LMS or ELO platform (AICC, SCORM)
• Exam Preparation : Microsoft Office Specialist ( MOS )
• Exam Preparation : European Computer Driving Licence ( ECDL )
• Elearning course developed by professional teachers with over 27 years of experience
• Published by a Microsoft Certified Gold Partner

Online Course Excel 2016 Advanced & Expert

In Excel 2016, you will learn everything that Excel 2016 has to offer. Discover Excel and carry out simple tasks: creating a new workbook, saving it, opening a workbook, entering and modifying data etc…
Advanced techniques for presenting tables and defining calculations. Not everyone will need all of these; choose the ones that fit what you do.
Now that you are at ease with the basic commands, see how Excel can help you to work better, faster.

Advanced
Allocated time : 04:50:00

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

Expert
Allocated time : 04:00:00

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, OR, NOT
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, XPS, e-mail and Web page
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: Sharing a document over the internet
You need to know: Best practice with a spreadsheet application

 

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.