NLU Meghalaya Library

Online Public Access Catalogue (OPAC)

Building Interactive Dashboards in Microsoft 365 Excel. (Record no. 14302)

MARC details
000 -LEADER
fixed length control field 03744nam a2200277uu 4500
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20250617120602.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 250616s||||||||||||||||o||||||||||| |d
024 80 - OTHER STANDARD IDENTIFIER
Standard number or code 9781803247472
040 ## - CATALOGING SOURCE
Original cataloging agency PACKT
Transcribing agency PACKT
041 ## - LANGUAGE CODE
Language code of text/sound track or separate title en
044 ## - COUNTRY OF PUBLISHING/PRODUCING ENTITY CODE
MARC country code GB
100 0# - MAIN ENTRY--PERSONAL NAME
Personal name Michael Olafusi
Relator term author.
245 00 - TITLE STATEMENT
Title Building Interactive Dashboards in Microsoft 365 Excel.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. GB:
Name of publisher, distributor, etc. Packt,
Date of publication, distribution, etc. 2024-02-29.
263 ## - PROJECTED PUBLICATION DATE
Projected publication date 2024-02-29
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Place of production, publication, distribution, manufacture GB:
Name of producer, publisher, distributor, manufacturer Packt,
300 ## - PHYSICAL DESCRIPTION
Extent 420.
377 ## - ASSOCIATED LANGUAGE
Language code en
520 ## - SUMMARY, ETC.
Summary, etc. <p><b>Unleash the full potential of Microsoft Excel's latest version and elevate your data-driven prowess with this comprehensive resource</b></p><h4>Key Features</h4><ul><li>Create robust and automated dashboards in Excel for M365</li><li>Apply data visualization principles and employ dynamic charts and tables to create constantly updated and informative dashboards for your organization</li><li>Uncover the best practices for effective dashboard creation</li><li>Purchase of the print or Kindle book includes a free PDF eBook </li></ul><h4>Book Description</h4>M365 Excel is a modern Excel version that is constantly updated with features that make creating and automating analyses, reports, and dashboards very easy compared with older Excel versions. This book will help you leverage its full capabilities, beginning with a quick overview of what dashboards are and how they are different from other types of reports. Then, you’ll familiarize yourself with the different standard dashboards currently available and what they are meant to accomplish for organizations. As you progress, you’ll get to grips with the use of new powerful tools such as Power Query and dynamic array formulae in the automation of analysis, gaining insights into the right approach to take in building effective dashboards. You’ll equip yourself with not only all the essential formulae, charts, and non-chart visuals but also learn how to set up your dashboard perfectly. Along the way, you’ll build a couple of awesome dashboards from scratch to utilize your newfound knowledge.<br/>By the end of this book, you will be able to carry out an impressive and robust level of analysis on business data that may come from multiple sources or files, using better processes, formulae, and best practices in M365 to create insightful dashboards faster.<h4>What you will learn</h4><ul><li>Understand the importance of dashboards in today's business analytics environment</li><li>Delve into the various essential formulae in Excel</li><li>Utilize Power Query to shape and transform data to extract insights easily</li><li>Explore the power of the new dynamic array functions in M365</li><li>Employ PivotTable and Power Pivot to automate your dashboards</li><li>Master the setup and optimization of your dashboard canvas</li><li>Discover best practices for visualization, charts, and effective dashboard creation</li><li>Consolidate your knowledge through a hands-on concluding project</li></ul><h4>Who this book is for</h4>This book is for Microsoft Excel users, especially those tasked with creating dynamic reports and dashboards that require data and help support to decision-makers within an organization with visually engaging and actionable insights. Financial analysts, data analysts, business analysts, and BI professionals will also greatly benefit from this book. Some familiarity with the Microsoft Excel interface is a prerequisite. .
538 ## - SYSTEM DETAILS NOTE
System details note Data in extended ASCII character set.
538 ## - SYSTEM DETAILS NOTE
System details note Mode of access: Internet.
700 0# - ADDED ENTRY--PERSONAL NAME
Personal name Olanrewaju Oyinbooke
Relator term author.
710 2# - ADDED ENTRY--CORPORATE NAME
Corporate name or jurisdiction name as entry element PACKT
773 0# - HOST ITEM ENTRY
Title Building Interactive Dashboards in Microsoft 365 Excel
Place, publisher, and date of publication GB,Packt,2024-02-29
Physical description 420
856 40 - ELECTRONIC LOCATION AND ACCESS
Uniform Resource Identifier <a href="https://learning.packt.com/product/461899">https://learning.packt.com/product/461899</a>

No items available.