Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
- ISBN-10
- 1509308105
- ISBN-13
- 9781509308101
- Category
- Computers
- Pages
- 99998
- Language
- English
- Published
- 2018-06-07
- Publisher
- Microsoft Press
- Author
- Chris Sorensen
Description
Prepare for Microsoft Exam 70-779–and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Microsoft Excel Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis
Get the book
Similar books
-
Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
By Daniil MaslyukPrepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization.
-
Exam Ref Da-100 Analyzing Data with Microsoft Power Bi
By Daniil MaslyukPrepare for Microsoft Exam DA-100, focusing on Power BI data analysis and visualization.
-
Excel 2019 Power Programming with VBA
By Michael Alexander, Dick KusleikaTHIS 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 ...
-
Exam Ref 70-761 Querying Data with Transact-SQL
By Itzik Ben-GanFocus 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 ...
-
The Messy Man
By Chris Sorensen" -- 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
-
Exam Ref 70-347 Enabling Office 365 Services
By Orin ThomasWhile 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 ...
-
Microsoft Office Inside Out (Office 2021 and Microsoft 365)
By Joe HabrakenRenowned Office expert Joe Habraken offers a complete tour, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, OneNote, and Teams.
-
Exam Ref MS-101 Microsoft 365 Mobility and Security
By Brian Svidergol, Robert ClementsPrepare 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.
-
Excel VBA Programming For Dummies
By Michael Alexander, John WalkenbachExcel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
-
T-SQL Fundamentals
By Itzik Ben-GanItzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic.