Excel 2013 Intermediate & Expert

Methode
Logo von OEM Office Elearning Menu DE
Bewertung: starstarstarstarstar 9,7 Bildungsangebote von OEM Office Elearning Menu DE haben eine durchschnittliche Bewertung von 9,7 (aus 3 Bewertungen)

Tipp: Haben Sie Fragen? Für weitere Details einfach auf "Kostenlose Informationen" klicken.

Beschreibung

Rabatte und Rabattpreise finden Sie auf der Website des OEM Office Elearning Menu.

Excel 2013 Course E-learning Intermediate & Expert

Elearning Excel 2013 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%. Integr…

Gesamte Beschreibung lesen

Frequently asked questions

Es wurden noch keine Besucherfragen gestellt. Wenn Sie weitere Fragen haben oder Unterstützung benötigen, kontaktieren Sie unseren Kundenservice.

Noch nicht den perfekten Kurs gefunden? Verwandte Themen: Microsoft Excel, Microsoft Word, Microsoft Outlook, Microsoft Powerpoint und Microsoft Office.

Rabatte und Rabattpreise finden Sie auf der Website des OEM Office Elearning Menu.

Excel 2013 Course E-learning Intermediate & Expert

Elearning Excel 2013 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 2013 Course E-learning 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

Content: Excel 2013 Course E-learning 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

Werden Sie über neue Bewertungen benachrichtigt

Es wurden noch keine Bewertungen geschrieben.

Schreiben Sie eine Bewertung

Haben Sie Erfahrung mit diesem Kurs? Schreiben Sie jetzt eine Bewertung und helfen Sie Anderen dabei die richtige Weiterbildung zu wählen. Als Dankeschön spenden wir € 1,00 an Stiftung Edukans.

Es wurden noch keine Besucherfragen gestellt. Wenn Sie weitere Fragen haben oder Unterstützung benötigen, kontaktieren Sie unseren Kundenservice.

Bitte füllen Sie das Formular so vollständig wie möglich aus

Anrede
(optional)
(optional)
(optional)
(optional)
(optional)

Haben Sie noch Fragen?

(optional)
Damit Ihnen per E-Mail oder Telefon weitergeholfen werden kann, speichern wir Ihre Daten.
Mehr Informationen dazu finden Sie in unseren Datenschutzbestimmungen.