Microsoft Office Specialist Excel Expert ( Office 2016 ) Exam 77-728 Study Guide
By Anand Vemula
Length1h 43m
About this audiobook
The Microsoft Office Specialist: Excel Expert (Office 2016) – 77-728 Study Guide 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.
Key topics covered include advanced charting and data analysis tools, 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 advanced formula creation, exploring logical functions (IF, IFS, AND, OR), lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP), and financial, statistical, and math functions.
Another critical focus is on data management: importing data from external sources, cleaning and transforming data, applying data validation rules, and utilizing Flash Fill. Users will also learn about advanced workbook management, including configuring workbook options, protecting worksheets, collaborating with others via OneDrive or SharePoint, and using macros for automation.
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 Excel's most sophisticated features in professional environments
Audiobook details
GenreEducation and Learning, Self-Help
Length1 hr 43 mins
Narrated byListen with 1,000+ voices
FormateBook with Audio
Publish dateJun 17, 2025
LanguageEnglish
Table of contents
11. Introduction
22. Manage Workbook Options and Settings
33. Apply Custom Data Formats and Layouts
44. Create Advanced Formulas
55. Apply Advanced Charting and Data Analysis Tools
Show all chaptersShow less
66. Work with Data in Excel
77. Create and Manage Macros
88. Collaborate and Protect Workbooks
9MCQ
Study Guide for Exam 77-730Anand Vemula3h 6m$16
DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Certification Exam GuideAnand Vemula2h 36m$13
DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Exam GuideAnand Vemula2h 8m$13
Study Guide - Microsoft Office Specialist: Word Expert (Microsoft 365 Apps) - MO 111Anand Vemula1h 45m$11
AZ-600 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub Study GuideAnand Vemula2h 24m$12
Study Guide -Exam 77-727: Microsoft Excel 2016Anand Vemula1h 28m$16
Study Guide -Microsoft Office Specialist Excel Expert (Office 2019) - Exam MO-201Anand Vemula1h 33m$13
Study Guide MO-500 Certification Exam Microsoft Access Expert ( Office 2019)Anand Vemula2h 36m$16
Study Guide for the Microsoft Office SpecialistAnand Vemula1h 35m$13
Study Guide Microsoft Office Specialist - Excel Associate (Office 2019)Anand Vemula1h 47m$13
Study Guide Microsoft Office Specialist 77-729Anand Vemula1h 39m$12
Introduction to Agentic AIAnand Vemula1h 36m$16
Mastering Agentic AIAnand Vemula1h 37m$14
Study Guide for Microsoft Office Specialist: PowerPoint Associate (Microsoft 365 Apps) MO-310Anand Vemula1h 2m$10
AZ-720 Troubleshooting Microsoft Azure Connectivity Study GuideAnand Vemula2h 1m$12
200-301 CCNA (Cisco Certified Network Associate) Study GuideAnand Vemula2h 47m$16
Study Guide Cisco Certified Design Expert (CCDE 400-007) ExamAnand Vemula2h 19m$13
Study Guide Cisco 300-515 SPVI Implementing Cisco Service Provider VPN Services Certification ExamAnand Vemula1h 15m$13
300-710 SNCF Securing Networks with Cisco Firewalls Study GuideAnand Vemula2h 57m$13
Testtrainer Logisches DenkenGRETA CRENSHAW10h 11m4.8 (121)$12.50 · $0.00
A Brief History of IntelligenceMax S. Bennett12h 18m4.6 (6.6K)$29 · $0.00
EXPERIENCE AND EDUCATION – Premium Edition (Including Democracy & Education) (Annotated)John Dewey19h 17m4.6 (1K)$2 · $0.00
WitnessAriel Burger8h 1m4.6 (1.3K)$20 · $0.00
EducationEllen G. White9h 41m4.6 (1.5K)$2 · $0.00
Parents and Children (Annotated)Charlotte Mason9h 23m4.6 (988)$2 · $0.00
Start Here Start NowLiz Kleinrock4h 20m4.6 (1K)$20
Children Under FireJohn Woodrow Cox10h 17m4.5 (1.6K)$29 · $0.00
En ComunidadCarla España, Luz Yadira Herrera6h 10m4.6 (309)$23
Textured TeachingLorena Escoto Germán4h 25m4.6 (559)$20
The State Must ProvideAdam Harris7h 15m4.5 (775)$24 · $0.00
The Call of the Wild and FreeAinsley Arment9h 7m4.4 (21.2K)$29 · $0.00
The Freelance WayRobert Vlach19h 48m4.5 (528)$40 · $0.00
Race to the BottomLuke Rosiak9h 20m4.5 (600)$29 · $0.00
We Got ThisCornelius Minor6h 28m4.5 (2.7K)$23
They Came for the SchoolsMike Hixenbaugh9h 5m4.5 (2.6K)$8 · $0.00
Find Me UnafraidKennedy Odede, Jessica Posner11h 11m4.5 (2.7K)$29 · $0.00
A Novel ApproachKate Roberts5h 22m4.5 (1.3K)$20
Being the ChangeSara K. Ahmed5h 27m4.5 (1.4K)$20
Asking for ItKate Harding8h 55m4.4 (5.3K)$20 · $0.00
Autism Out Loud: the instant New York Times Bestseller. Moving Stories and Parenting Lessons Learned from Three Mothers of Children with AutismKate Swenson, Carrie Cariello, Adrian Wood8h 41m4.8 (2.1K)$26 · $0.00
365 Days of Hope and Healing for Your Body, Mind, and SoulJoan Hunter8h 48m4.9 (158)$10 · $0.00
Rewrite the Mother CodeDr. Gertrude Lyons10h 55m4.9 (144)$25
The Best of Les Brown Audio CollectionLes Brown8h 12m4.7 (1.8K)$65
Swayam Ki AwaazPrem Rawat8h 34m4.7 (1.1K)$26 · $0.00
Finding Your VoiceMannette Morgan8h 10m4.8 (187)$20
Forever BoyKate Swenson9h 27m4.7 (5K)$29 · $0.00
You Are Worth ItKyle Carpenter, Don Yaeger8h 53m4.7 (4.8K)$29 · $0.00
The Happiest Man on EarthEddie Jaku3h 48m4.6 (178K)$7 · $0.00
Finding MeViola Davis9h 15m4.6 (256.4K)$29 · $0.00
AretéBrian Johnson19h 57m4.7 (2.2K)$35
Spiritual AnatomyDaaji Kamlesh D. Patel9h 47m4.7 (319)$29 · $0.00
The Dangerous Truth about Today’s MarijuanaLaura Stack CSP, MBA9h 57m4.7 (384)$20 · $0.00
Birdie & HarlowTaylor Wolfe7h 50m4.6 (6.5K)$26 · $0.00
Ghetto BastardK’wan7h 37m4.6 (2.9K)$20
Legally YoursManasi Chaudhari8h 52m4.7 (223)$29 · $0.00
CrossroadsKaleb Dahlgren7h 56m4.6 (4.9K)$26 · $0.00
Life on the BridgeKaelynn Partlow5h 40m4.6 (1.1K)$24 · $0.00
From Questioning to KnowingLisa Barnett5h 34m4.7 (244)$17
Keep Your Love OnDanny Silk9h 4m4.6 (8.1K)$10 · $0.00
You may also like
Day Trading AttentionGary Vaynerchuk8h 25m4.3 (1.8K)$28 · $0.00
Experiments with Alternating CurrentsNikola Tesla9h 6m4.3 (874)$1 · $0.00
The Universe in the Light of Modern PhysicsMax Planck3h 40m4.1 (787)$1 · $0.00
Blockchain : The technology that will transform commerceUnknown Author1h 9m$17 · $0.00
Linux For BeginnersRodrigo Montini3h 9m$7 · $0.00
Study of a reluctance magnetic gearbox for energy storage system applicationBruno Fensterseifer Dias2h 14m$20 · $0.00
On the Construction of Catalogues of LibrariesCharles C. Jewett4h$2 · $0.00
Thomas Alva Edison: A short biography5 Minutes, 5 Minute Biographies, George Fritsche5m$1 · $0.00
Eu Gmp Annex 13 (Investigational Medicinal Products , Complexity Meets Reality)Unknown Author1h 35m$19 · $0.00
Model aeroplanesF. J. Camm2h 55m$2 · $0.00
Pasta SaucesNaumann & Göbel Verlag3h 1m4.5 (12)$5 · $0.00
Erotic Art PhotographyAlexandre Dupouy1h 57m3.9 (47)$18 · $0.00
Party FoodNaumann & Göbel Verlag3h 25m4.4 (12)$5 · $0.00
Drawing Dogs. Practical guide to drawing dogsRoberto Fabbretti14m4.4 (12)$10 · $0.00
On Generation and CorruptionAristotle2h 58m3.5 (307)$1.80 · $0.00
The Ultimate Burger BookNaumann & Göbel Verlag2h 56m4.1 (19)$9 · $0.00
The Value of MoneyBenjamin M. Anderson18h 6m4.1 (21)$1 · $0.00
How to Play Chess (Annotated)Charlotte Boardman Rogers2h 43m4.1 (12)$2 · $0.00
Embryology human integratedWilmar Saldarriaga Gil, Carolina Isaza de Lourido, Julián Ramírez Cheyne12h 50m$28 · $0.00
The Renaissance EngraversJp. A. Calosse, Charmian Mezentseva5h 26m$18 · $0.00