Envío gratis siempre a todo México.
Haz clic para hacer zoom
Not Available
Anand Vemula
Microsoft Office Specialist: Excel Expert (Office 2016) - Exam 77-728 Study Guide
Cargando comentarios…
Comparte
$368
Envío gratis siempre
Comentarios
Cargando el resumen…
Cargando comentarios…
product
7483214Microsoft Office Specialist: Excel Expert (Office 2016) - Exam 77-728 Study Guidehttps://www.gandhi.com.mx/microsoft-office-specialist--excel-expert--office-2016----exam-77-728-study-guide-9798318049125/phttps://gandhi.vtexassets.com/arquivos/ids/7086805/image.jpg?v=638812834976970000368368MXNGandhiInStock/Audiolibros/<p>This audiobook is narrated by a digital voice.</p><p>The <strong>Microsoft Office Specialist: Excel Expert (Office 2016) 77-728 Study Guide</strong> provides comprehensive preparation for individuals aiming to achieve certification in advanced Excel skills. This guide is designed for users who are proficient in Excel basics and wish to demonstrate their expertise in more complex tasks such as creating advanced formulas, managing large datasets, and optimizing Excel workbooks for collaboration and analysis.</p><p>Key topics covered include <strong>advanced charting and data analysis tools</strong>, such as creating and modifying PivotTables and PivotCharts, applying data slicers and timelines, and performing what-if analysis with tools like Goal Seek and Scenario Manager. The guide also delves into <strong>advanced formula creation</strong>, exploring logical functions (IF, IFS, AND, OR), lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP), and financial, statistical, and math functions.</p><p>Another critical focus is on <strong>data management</strong>: importing data from external sources, cleaning and transforming data, applying data validation rules, and utilizing Flash Fill. Users will also learn about <strong>advanced workbook management</strong>, including configuring workbook options, protecting worksheets, collaborating with others via OneDrive or SharePoint, and using macros for automation.</p><p>The study guide includes step-by-step explanations, real-world examples, and practice questions that mirror the certification exam format, ensuring thorough preparation for both theoretical and practical Excel tasks. By mastering these advanced skills, candidates can confidently sit for the 77-728 exam, demonstrating their ability to handle Excels most sophisticated features in professional environments</p>...7107557Microsoft Office Specialist: Excel Expert (Office 2016) - Exam 77-728 Study Guide368368https://www.gandhi.com.mx/microsoft-office-specialist--excel-expert--office-2016----exam-77-728-study-guide-9798318049125/phttps://gandhi.vtexassets.com/arquivos/ids/7086805/image.jpg?v=638812834976970000InStockMXN99999DIAudiolibro20259798318049125_W3siaWQiOiJlMzQ0ODk1ZS1mMmMwLTQ2MzItYTg3My01NDQ3YjAzZTBmMzQiLCJsaXN0UHJpY2UiOjM4OSwiZGlzY291bnQiOjAsInNlbGxpbmdQcmljZSI6Mzg5LCJpbmNsdWRlc1RheCI6dHJ1ZSwicHJpY2VUeXBlIjoiV2hvbGVzYWxlIiwiY3VycmVuY3kiOiJNWE4iLCJmcm9tIjoiMjAyNS0wNi0xN1QwMTowMDowMFoiLCJ0byI6IjIwMjUtMDYtMzBUMjM6NTk6NTlaIiwicmVnaW9uIjoiTVgiLCJpc1ByZW9yZGVyIjpmYWxzZSwiaXNFbGlnaWJsZUZvckNyZWRpdFRyaWFsIjp0cnVlLCJjcmVkaXRQdXJjaGFzZVByaWNlIjoxfSx7ImlkIjoiMzlmMzZkMzMtM2U0Zi00YThhLWFiYzUtOTdhZjg0M2JhZDFjIiwibGlzdFByaWNlIjozNjgsImRpc2NvdW50IjowLCJzZWxsaW5nUHJpY2UiOjM2OCwiaW5jbHVkZXNUYXgiOnRydWUsInByaWNlVHlwZSI6Ildob2xlc2FsZSIsImN1cnJlbmN5IjoiTVhOIiwiZnJvbSI6IjIwMjUtMDctMDFUMDA6MDA6MDBaIiwicmVnaW9uIjoiTVgiLCJpc1ByZW9yZGVyIjpmYWxzZSwiaXNFbGlnaWJsZUZvckNyZWRpdFRyaWFsIjp0cnVlLCJjcmVkaXRQdXJjaGFzZVByaWNlIjoxfV0=9798318049125_<p>This audiobook is narrated by a digital voice.</p><p>The <strong>Microsoft Office Specialist: Excel Expert (Office 2016) 77-728 Study Guide</strong> provides comprehensive preparation for individuals aiming to achieve certification in advanced Excel skills. This guide is designed for users who are proficient in Excel basics and wish to demonstrate their expertise in more complex tasks such as creating advanced formulas, managing large datasets, and optimizing Excel workbooks for collaboration and analysis.</p><p>Key topics covered include <strong>advanced charting and data analysis tools</strong>, such as creating and modifying PivotTables and PivotCharts, applying data slicers and timelines, and performing what-if analysis with tools like Goal Seek and Scenario Manager. The guide also delves into <strong>advanced formula creation</strong>, exploring logical functions (IF, IFS, AND, OR), lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP), and financial, statistical, and math functions.</p><p>Another critical focus is on <strong>data management</strong>: importing data from external sources, cleaning and transforming data, applying data validation rules, and utilizing Flash Fill. Users will also learn about <strong>advanced workbook management</strong>, including configuring workbook options, protecting worksheets, collaborating with others via OneDrive or SharePoint, and using macros for automation.</p><p>The study guide includes step-by-step explanations, real-world examples, and practice questions that mirror the certification exam format, ensuring thorough preparation for both theoretical and practical Excel tasks. By mastering these advanced skills, candidates can confidently sit for the 77-728 exam, demonstrating their ability to handle Excels most sophisticated features in professional environments</p>...9798318049125_Anand Vemulaaudiolibro_9798318049125_9798318049125Anand VemulaInglésMéxicoNoMINUTE2025-04-26T00:00:00+00:00Anand Vemula