We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Order this great Elearning 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

Duration: 14 hours
Language: English
Certificate of participation: Yes
Online access: 365 days
Progress monitoring: Yes
Award Winning E-learning: Yes
Suitable for mobile: Yes

Outline

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

 

Special Offer

https://www.officeelearningmenu.nl/en/microsoft-excel-2016-for-mac.html
Reviews
Be the first to write a review about this course.
Write a Review
Work Smarter, more efficient and productive

We are an international Microsoft training Partner, Microsoft Office Specialist (MOS) and authorised exam centre, with over 10 years experience in supporting organisations and individuals with their Microsoft Office training needs.

OEM Office Elearning Menu is an international Microsoft training centre and Microsoft Partner. With over 10 years experience in supporting organisations and individuals with their Microsoft Office training needs. In the Netherlands we have over 3500 satisfied customers and this number is growing daily.

Our speciality is providing the exact solution to your needs.


Do you use Microsoft Office for your daily work? Our learning programme not only saves time but can also save money and motivate you, by following our online courses and training programmes, tailored specifically to all levels.
Would you like to become a specialist in Microsoft Office, learning skills that will enable you to be able to improve your efficiency but also your knowledge?

OEM provides online training/courses for individuals and companies working with Microsoft Office. These courses are developed by certified Microsoft Office teachers. They enable you to go at your own pace and fully supported by OEM. ...

OEM Office Elearning Menu - Microsoft Partner
P.J. Oudweg 4, Almere, Flevoland, Netherlands 1314 CH
+3136-7601019
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.