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

Excel 2016 Intermediate.

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 Intermediate

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