Opleiding: Microsoft Excel 2016 Expert - Excel voor Financials, Draaitabellen in Excel, Excel Draaitabellen, Excel basis / voor beginners, Data Analyse Excel, Draaitabellen

Microsoft Excel 2016. 

Elearning Excel 2016 course online. An extraordinary e-learning methodology in a virtual office application. Practice 365 days at your own pace and in your own order (after activation). Varied, interactive multimedia lessons with video, audio and subtitles. Practical exercises with real-time analysis of the actions and results of the student. Exam preparation for Microsoft Office Specialist (MOS). E-learning developed by professional lecturers with more than 27 years of experience.

Publisher: Microsoft Gold Certified Partner.

On our learning portal you will receive a certificate of participation with a success rate of at least 70%. Integration capability in LMS or ELO Platform (AICC, SCORM).

Content: Excel 2016 E-learning Course Expert

• 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
• 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
• 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: Office Online and Office 365
• You need to know: Best practice with a spreadsheet application
• You need to know: Sharing a workbook