
MOS 2016 Study Guide for Microsoft Excel Expert
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
Hone your advanced Excel 2016 skills. And earn the credential that proves it!
Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2016 certification, this official Study Guide delivers:
In-depth preparation for each MOS objective
Detailed procedures to help build the skills measured by the exam
Hands-on tasks to practice what you've learned
Ready-made practice files
Sharpen the skills measured by these objectives:
Create and Manage Workbooks
Apply Custom Formatting and Layouts
Create Advanced Formulas
Perform Data Analysis
Create Advanced Charts and PivotTables
More details
Other editions
Additional editions

Person
Content
1.1 Manage workbooks
1.2 Manage workbook review
Chapter 2 - Apply custom formats and layouts
2.1 Apply custom data formats
2.2 Apply advanced conditional formatting and filtering
2.3 Apply custom styles and templates
2.4 Prepare workbooks for internationalization and accessibility
Chapter 3 - Create advanced formulas
3.1 Apply functions in formulas
3.2 Look up data by using functions
3.3 Apply advanced date and time functions
3.4 Perform data analysis and business intelligence
3.5 Troubleshoot formulas
3.6 Define named ranges and objects
Chapter 4 - Create advanced charts and tables
4.1 Create advanced chart elements
4.2 Create and manage PivotTables
4.3 Create and manage PivotCharts
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.