Microsoft Office Specialist Excel Expert ( Office 2016 ) Exam 77-728 Study Guide

Anand Vemula

Summary

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

Available since: 06/17/2025.

Print length: 65 pages.

Other books that might interest you

30 Black Folklore Fable Bed time...

ian batantu

You should see this book as a celebration of the resilience, creativity, and wisdom of Black people and their ancestors, and a reminder of the importance of preserving and sharing these stories for generations to come. Whether you're looking for tales of adventure, humour, or wisdom, this has something for everyone. This book is a timeless and inspiring tribute to the enduring power of Black storytelling.

Show book

Financial Statements - A...

Thomas Ittelson

Simply the clearest and most comprehensive introduction to financial reporting available. No accounting background is required. “Finally, a handbook that takes the mystery out of accounting principles.” —Margi Gandolfi, VP Marketing/Strategic Planning of New York Blood CenterThis edition replaces all previous editions of this bestselling title based on the revised and expanded edition corrected and back to the basics.Financial Statements is a perfect introduction to financial accounting for non-financial managers, investors, business students, lawyers, lenders, entrepreneurs, and more. Financial Statements deftly shows that all this accounting and financial-reporting stuff is not rocket science and that anyone can understand it!Ittelson empowers non-financial managers by clearly and simply demonstrating how the balance sheet, income statement, and cash flow statement work together to offer a snapshot of any company’s financial health. Every term is defined in simple, understandable language. Every concept is explained with a basic, straightforward transaction example. And with the book’s uniquely visual approach, you’ll be able to see exactly how each transaction affects the three key financial statements of the enterprise. Each statement paints a different and essential picture—the “three-legged stool” of company reporting:• The income statement shows the manufacturing (or service offerings) and selling actions of the company that result in profit or loss during a period. It gives a very important perspective on the company’s performance, its profitability.• The cash flow statement details cash into and out of the company for a period. You need money to make money. Running out of cash is bad. Duh.• The balance sheet records at the end of a period, an instant in time, what the company owns and what it owes, including the owners’ stake, called shareholders’ equity.

Show book

Gifted - The Ultimate Guide to...

Angela Wayning

This is the ultimate bundle! The complete 10 in 1 book with all the anecdotes and thoughts about gifted children you can imagine! The following topics are only a handful of the many subjects that will be addressed here: 
Perfectionism 
IQ-tests and scores 
Bullying 
Choosing a school 
Homeschooling 
Accelerated programs 
Signs, symptoms and definitions 
Advice for introverts 
Dealing with overexcitement 
How to motivate them 
Underachievement problems 
Positive integration 
Sensitivity 
How to help with homework 
Problem-solving skills 
Creativity 
Bossiness in gifted children 
Why some gifted kids act like little adults 
Calming their fears from imagination 
Knowing their giftedness from the start 
Educational opportunities 
Bullying and targeting smart children 
Existential sadness and how to overcome it 
Asynchronous development 
Giftedness and empathy 
And lots more!!! 
Don’t wait and get this book at a discounted price. The bundle is an excellent concept of giving you more educational value for your money.

Show book

The Goop Directory

Frank Gelett Burgess

In this DIRECTORY you'll see just what you never ought to be; and so, it should direct your way to Good Behavior, every day. The children of whose faults I tell are known by other names, as well, so see that you aren't in this group of Naughty Ones. Don't be a Goop!(The author's introduction)

Show book

Passionate Learners - How to...

Pernille Ripp

Would you want to be a student in your own classroom? In this bestselling book, Pernille Ripp invites both novice and seasoned teachers to cocreate a positive, interactive learning environment with students. 
 
 
 
Based on honest reflections on her own teaching experience, Pernille offers a wide variety of ideas for sharing control, developing your intuition, learning how to fail, giving yourself grace, building community and trust, creating more choice, allowing time for student expertise, and letting go of the punish, behave, and reward cycle so that intrinsic motivation can thrive. This fully enhanced new edition is chock full of additional strategies and tools on topics such as centering students' identities, overcoming barriers when creating student-centered lessons to emphasize ownership of the learning cycle, shoring up your boundaries to manage your time and stop the intense prep work, changing your homework habits to reduce your load and give students more time, deemphasizing grades, and much more. 
 
 
 
With Pernille's heartfelt stories and practical strategies, you'll feel inspired to give your classroom back to your students and foster a community of truly passionate learners!

Show book

Level Up Your Lesson Plans -...

Teresa K. Kwant

Tired of spending hours on lesson plans? Discover strategies to streamline your planning process and maximize student engagement. Access exclusive templates, tools, and resources designed to help you create effective lessons that align with learning standards. Save time, reduce stress, and elevate your teaching game. In Level Up Your Lesson Plans: Ignite the Joy of Learning with Fun and Educational Materials, teacher Teresa Kwant delivers an exciting and practical instruction book for teachers interested in adding fun into their lesson plans, without sacrificing educational strategies. The book walks you through how to transform your teaching materials and lessons into interactive, collaborative, and enjoyable learning experiences for both the teacher and students. 
 
 
 
Kwant draws on personal and professional experiences to give actionable steps you can implement immediately. You'll also find: 
 
 
 
● Tips for aligning your lessons with standards to make them both fun and engaging 
 
 
 
● Strategies for building your own instructional plans for daily success with student learning 
 
 
 
● Techniques to develop your own lessons plans efficiently, and with high engagement

Show book