Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam. Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully consume, transform, model, and visualize data with Excel 2016. Coverage includes: Importing data from external data sources Working with Power Query Designing and implementing transformations Applying business rules Cleansing data Creating performance KPIs And much more Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pro's job role For more information on Exam 70-779 and the MCSA: BI Reporting credential, visit microsoft.com/learning.
Prepare for Microsoft Exam 70-779 and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization.
For information regarding permissions, request forms, and the appropriate contacts within the Pearson Education Global Rights & Permissions Department, please visit www.pearsoned.com/permissions/. No patent liability is assumed with ...
Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization.
Prepare for Microsoft Exam DA-100, focusing on Power BI data analysis and visualization.
" -- Rachel, Shades of Orange "Think of your absolute favorite sequel, no matter the franchise. Got it in mind? This is what Sorensen has accomplished for me with The Hungry Ones." -- Tracy Robinson, Sci-Fi & Scary
Focus on the expertise measured by these objectives: • Filter, sort, join, aggregate, and modify data • Use subqueries, table expressions, grouping sets, and pivoting • Query temporal and non-relational data, and output XML or JSON ...
THIS BOOK SHOWS YOU HOW TO: Go beyond recording simple macros Dynamically manipulate workbooks and worksheets Automate pivot table and chart features Manage external data and wrangle external files Send emails directly from Excel Create ...
While this first edition will still help you with the first four ODs, in order to fully prepare for the new portion of the exam, you should consult other resources for the following: Implement Microsoft Teams Configure and manage OneDrive ...
Renowned Office expert Joe Habraken offers a complete tour, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, OneNote, and Teams.
Prepare for Microsoft Exam MS-101–and help demonstrate your real-world mastery of skills and knowledge needed to manage Microsoft 365 mobility, security, and related administration tasks.