Excel 2016 Advanced for Mac
Spreadsheet application for Mac10 H 52 M
Take your Excel skills to the next level with advanced Excel 2016 training for macOS. Learn about analyzing data, formatting tables, collaboration and more.
Just you? Training a whole team? There's an ITProTV plan that fits.
Start Training TodayEpisodes
Episodes
- Analyze Data
- Overview
- Sort and Filter
- Conditional Formatting
- Outline and Subtotals
- Tables
- Data Tables
- Consolidate Data
- Scenarios
- Goal Seek
- Remove Duplicates
- Advanced Filter
- Shapes: Add and Format
- Graphical Elements
- Images: Basics
- Images: Format
- Arrange Images and Shapes
- SmartArt
- Collaboration and Security
- Shared Workbooks
- Track Changes
- Collaborate with Co-authoring
- Co-authoring: Troubleshooting
- Co-Authoring: Troubleshooting Part 2
- Version History
- Data Validation
- Workbook Security
- Document Properties
- Additional Topics
- Customize Interface
Overview
8 M



- Episode Description
- Transcript
Excel 2016 Advanced for Mac explores ways to enhance Excel workbooks with topics in analyzing data, collaborating and workbook security, and adding graphical elements. This series covers important Excel functionality such as format as table, conditional formatting, shared workbooks and tracked changes, and data validation. While Excel 2016 Advanced for Mac is a continuation from the Excel 2016 Essentials for Mac series, it can be viewed as a standalone show for users looking to take their Excel skills to the next level. This series is specifically for locally installed Excel 2016 on Mac OS.