Microsoft Excel 2016 Course for Mac E-Learning





Microsoft Excel 2016 Course for Mac E-Learning
Microsoft Excel 2016 for Mac E-Learning - Online E-Learning training. Order and start immediately for the best price.
Read more- Brand:
- Microsoft
- Discounts:
-
- Buy 2 for €122,50 each and save 2%
- Buy 3 for €121,25 each and save 3%
- Buy 5 for €116,25 each and save 7%
- Buy 10 for €112,50 each and save 10%
- Buy 25 for €106,25 each and save 15%
- Buy 50 for €97,50 each and save 22%
- Buy 100 for €87,50 each and save 30%
- Buy 200 for €62,50 each and save 50%
- Availability:
- In stock
- Delivery time:
- Ordered before 5 p.m.! Start today.
- Award Winning E-learning
- Lowest price guarantee
- Personalized service by our expert team
- Pay safely online or by invoice
- Order and start within 24 hours
Microsoft Excel 2016 Course for Mac E-Learning Online
Order this great E-Learning Microsoft Excel 2016 for Mac online, 1 year 24/7 access to rich interactive videos, voice, practice assignments, progress monitoring through reports and tests per subject to test the knowledge directly. After the course you will receive a certificate of participation. Microsoft Office for Mac 2016
Course content
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
Language | English |
---|---|
Qualifications of the Instructor | Certified |
Course Format and Length | Teaching videos with subtitles, interactive elements and assignments and tests |
Lesson duration | 9:18 Hours |
Progress monitoring | Yes |
Access to Material | 365 days |
Technical Requirements | Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge. |
Support or Assistance | Helpdesk and online knowledge base 24/7 |
Certification | Certificate of participation in PDF format |
Price and costs | Course price at no extra cost |
Cancellation policy and money-back guarantee | We assess this on a case-by-case basis |
Award Winning E-learning | Yes |
Tip! | Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform. |
There are no reviews written yet about this product.
OEM Office Elearning Menu Top 2 in ICT-trainingen 2024!
OEM Office Elearning Menu is trots op de tweede plaats in de categorie ICT-trainingen 2024 bij Beste Opleider van Nederland (Springest/Archipel). Dank aan al onze cursisten voor hun vertrouwen!
Reviews
There are no reviews written yet about this product.