MOS Study Guide for Microsoft Excel Expert...

Dekorationsartikel gehören nicht zum Leistungsumfang.

Sprache: Englisch

21,80 €

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 4-7 Werktage

Kategorien:

Beschreibung

Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objectiveDetailed procedures to help build the skills measured by the examHands-on tasks to practice what you’ve learnedReady-made practice files Sharpen the skills measured by these objectives:Manage Workbook Options and SettingsManage and Format DataCreate Advanced Formulas and MacrosManage Advanced Charts and Tables About the MOS: Expert Certification A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market. See full details at: [...] Practice Files Available at: [...]/ MOSExcelExpert201/downloads

Über den Autor

Paul McFedries is a full-time technical author who has worked with computers in one form or another since 1975. He is the author of more than 90 computer books that have sold more than 4 million copies worldwide. His recent Office-related titles include My Office 2016, My Office 2016 for Mac, and Formulas and Functions for Microsoft Excel 2016. His other titles include Windows 10 In Depth, (with Brian Knittel), PCs for Grownups, and Fixing Your Computer Absolute Beginner's Guide.

Inhaltsverzeichnis

Chapter 1 – Manage workbook options and settings
Objective 1.1: Manage workbooks
Objective 1.2: Prepare workbooks for collaboration
Objective 1.3: Use and configure language options
Chapter 2 – Manage and format data
Objective 2.1: Fill cells based on existing data
Objective 2.2: Format and validate data
Objective 2.3: Apply advanced conditional formatting and filtering
Chapter 3 – Create advanced formulas and macros
Objective 3.1: Perform logical operations in formulas
Objective 3.2: Look up data by using functions
Objective 3.3: Apply advanced date and time functions
Objective 3.4: Perform data analysis
Objective 3.5: Troubleshoot formulas
Objective 3.6: Create and modify simple macros
Chapter 4 – Manage advanced charts and tables
Objective 4.1: Create and modify advanced charts
Objective 4.2: Create and modify PivotTables
Objective 4.3: Create and modify PivotCharts

Details

Erscheinungsjahr:	2020
Genre:	Importe , Informatik
Rubrik:	Naturwissenschaften & Technik
Medium:	Taschenbuch
Inhalt:	Kartoniert / Broschiert
ISBN-13:	9780136627524
ISBN-10:	0136627528
Sprache:	Englisch
Einband:	Kartoniert / Broschiert
Autor:	McFedries, Paul
Auflage:	1. Auflage
Hersteller:	Pearson Microsoft Press Pearson Education Limited
Verantwortliche Person für die EU:	Pearson, St.-Martin-Str. 82, D-81541 München, salesde@pearson.com
Maße:	235 x 195 x 11 mm
Von/Mit:	Paul McFedries
Erscheinungsdatum:	14.05.2020
Gewicht:	0,378 kg