
Microsoft Excel 2016 for Mac E-Learning
Bestellen Sie diesen großartigen Elearning-Kurs Microsoft Excel 2016 for Mac online, 1 Jahr rund um die Uhr Zugriff auf umfangreiche interaktive Videos, Reden, praktische Aufgaben, Fortschrittsüberwachung durch Berichte und Tests pro Proband, um das Wissen direkt zu testen. Dieses E-Learning ist von sehr hoher Qualität. Entwickelt von zertifizierten Lehrern. Im Learning Portal (LMS) Fortschrittsberichte und nach> 70% des Kurses eine Teilnahmebescheinigung.
Kursinhalt
Microsoft Excel 2016 for Mac: Opening and Setting Up Excel
- Finding & opening the application
- Using Excel 2016
- Using the zoom function
- Using the view modes
- Moving between documents
Microsoft Excel 2016 for Mac: Creating, Saving, and Sharing Workbooks
- Creating & opening a document
- Using document templates
- Managing your worksheets
- Saving your document
- Saving your document as a PDF
- Returning to a previous version of your document
- Inserting headers & footers
- Setting your print area
- Adjusting your print page layout
- Printing your document
- Creating an accessible document
- Editing your document properties
- Protecting your document
- Sending your document via email
- Sharing your document via OneDrive
- Following & tracking document changes
- Commenting on a document
Microsoft Excel 2016 for Mac: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Inserting dropdown menus
- Using the spell check tool
- Configuring spell check & AutoCorrect options
- Transferring data
- Copying & pasting data
Microsoft Excel 2016 for Mac: Formatting Data
- Setting your data type
- Formatting your data
- Aligning your data
- Using colors
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Transferring format styles
- Inserting borders
Microsoft Excel 2016 for Mac: Custom and Conditional Formatting
- Customizing the date & time formats
- Customizing your number formats
- Using custom text formats
- Creating conditional custom formats
- Using conditional formatting tools
- Using advanced conditional formatting
Microsoft Excel 2016 for Mac: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image or a screenshot
- Inserting shapes
- Inserting a hyperlink
- Using Smart Lookup
Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data
- Using the Find tool
- Using the Replace tool
- Sorting your data
- Filtering your data
- Sorting & filtering using colors
- Using the advanced filter options
- Freezing & unfreezing panes
- Grouping items & creating an outline
- Hiding duplicate values
Microsoft Excel 2016 for Mac: Referencing Data
- Referencing your cells
- Using data across multiple worksheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Microsoft Excel 2016 for Mac: Basic Formulas
- Inserting a formula using the function library
- Performing simple formulas
- Creating automated cumulative totals
- Using automated formulas in a table
- Inserting subtotals
- Counting cells in a range
- Ranking a value
- Rounding a number
- Using replacement formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Using IF & OR in conditional formulas
Microsoft Excel 2016 for Mac: Working with Formulas
- Calculating the interest on a loan
- Reaching a target value
- Solving a problem
- Creating automatic reports
- Finding identical values in your spreadsheet
- Finding duplicates in your document
Microsoft Excel 2016 for Mac: Charts and Graphs
- Inserting a chart
- Labeling a chart
- Formatting a chart
- Customizing your graphics
- Customizing your chart axes
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trendlines
Microsoft Excel 2016 for Mac: PivotTables
- Creating a PivotTable
- Editing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting data in your PivotTable
- Filtering your table data
- Grouping data in your PivotTable
- Inserting a slicer in your PivotTable
- Comparing values in a PivotTable
- Formatting your PivotTable
- Copying & reusing your PivotTable
Microsoft Excel 2016 for Mac: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data values in a single cell
- Inserting data automatically
- Retrieving information on a cell
- Retrieving information on your text
- Finding data in a database
- Performing calculations using your database
Microsoft Excel 2016 for Mac: Configuring Excel
- Installing & managing add-ins
- Adjusting your input options
- Configuring your default formula options
- Customizing your document view settings
- Customizing your interface
- Customizing the ribbon & quick access toolbar
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
Lassen Sie uns helfen!
Studiengebühr: | 5 Stunden Dauer plus Übungen (variabel) |
Sprache: | Englisch |
Online-Zugang: | 1 Jahr |
Teilnahmebescheinigung: | Ja, nach 70% der erfolgreichen Einsätze |
Fortschrittsüberwachung: | Ja |
Geeignet für Handys: | Ja |
Preisgekröntes E-Learning: | Ja |
Lesen oder schreiben Sie einen Kommentar