Building Interactive Dashboards in Microsoft 365 Excel
Building Interactive Dashboards in Microsoft 365 Excel
Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards
Olafusi, Michael; Oyinbooke, Olanrewaju
Packt Publishing Limited
02/2024
420
Mole
Inglês
9781803237299
15 a 20 dias
Descrição não disponível.
Table of Contents
Dashboards, Reports, and M365 Excel
Common Dashboards in Large Companies
The Importance of Connecting Directly to the Primary Data Sources
Power Query: the Ultimate Data Transformation Tool
PivotTable and Power Pivot
Must-Know Legacy Excel Functions
Dynamic Array Functions and Lambda Functions
Getting Comfortable with the 19 Excel Charts
Non-Chart Visuals
Setting Up the Dashboard's Data Model
Perfecting the Dashboard
Best Practices for Real-World Dashboard Building
Dashboards, Reports, and M365 Excel
Common Dashboards in Large Companies
The Importance of Connecting Directly to the Primary Data Sources
Power Query: the Ultimate Data Transformation Tool
PivotTable and Power Pivot
Must-Know Legacy Excel Functions
Dynamic Array Functions and Lambda Functions
Getting Comfortable with the 19 Excel Charts
Non-Chart Visuals
Setting Up the Dashboard's Data Model
Perfecting the Dashboard
Best Practices for Real-World Dashboard Building
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
Microsoft Excel; microsoft excel 2023; Excel book; Power BI; microsoft power bi; Tableau; tableau book
Table of Contents
Dashboards, Reports, and M365 Excel
Common Dashboards in Large Companies
The Importance of Connecting Directly to the Primary Data Sources
Power Query: the Ultimate Data Transformation Tool
PivotTable and Power Pivot
Must-Know Legacy Excel Functions
Dynamic Array Functions and Lambda Functions
Getting Comfortable with the 19 Excel Charts
Non-Chart Visuals
Setting Up the Dashboard's Data Model
Perfecting the Dashboard
Best Practices for Real-World Dashboard Building
Dashboards, Reports, and M365 Excel
Common Dashboards in Large Companies
The Importance of Connecting Directly to the Primary Data Sources
Power Query: the Ultimate Data Transformation Tool
PivotTable and Power Pivot
Must-Know Legacy Excel Functions
Dynamic Array Functions and Lambda Functions
Getting Comfortable with the 19 Excel Charts
Non-Chart Visuals
Setting Up the Dashboard's Data Model
Perfecting the Dashboard
Best Practices for Real-World Dashboard Building
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.