Excel for Microsoft 365 Functions & Formulas Quick Reference - Windows Version (4-page Cheat Sheet focusing on examples and context for the Intermediate-to-Adv Level - Laminated Guide)
Format:
Pamphlet
En stock
0.06 kg
Sí
Nuevo
Amazon
USA
- Geared toward the intermediate to advanced Excel for Microsoft 365 (formerly Office 365) user, this example-rich 4-page laminated card/guide provides explanations and context for many powerful Excel for Microsoft 365 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Excel for Microsoft 365. This guide is suitable as a training handout, or simply an easy to use reference guide. Topics include: Controlling Order of Precedence. Conditionally Summing/Counting Data (SUMIF, COUNTIF); Being Precise (Rounding functions ROUND, MROUND, ROUNDUP CEILING, CEiLING.PRECISE, EVEN, INT); Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT); (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH); New Functions in Excel for Microsoft 365 (CONCAT, TEXTJOIN, IFS, MAXIFS, MINIFS, SWITCH, XLOOKUP); Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE); Changing Results: IF, AND, OR, NOT; Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP); Error Recovery (ISNA, ISERROR); Array Formulas (Single Cell & Multi-Cell Arrays); Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE); Using a Formula for Data Validation; Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows. Examples: Summing Selected Data; Being Precise; Merging Text & Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays. This guide is one of multiple titles available for Excel for Microsoft 365, other Excel titles are: Excel for Microsoft 365 Introduction (ISBN 1944684786); Excel for Microsoft 365 Charts & Sparklines (ISBN 1944684905); Excel for Microsoft 365 Tables, PivotTables, Sorting, Filtering & Inquire (ISBN 1944684867).
IMPORTÁ FACIL
Comprando este producto podrás descontar el IVA con tu número de RUT
NO CONSUME FRANQUICIA
Si tu carrito tiene solo libros o CD’s, no consume franquicia y podés comprar hasta U$S 1000 al año.