[go: up one dir, main page]
Scribd
Upload
5 views1 page

Excel 12

The document outlines advanced analysis techniques in Excel, including business intelligence analysis, data modeling, and forecasting. It covers managing data with Power Pivot, creating visualizations, and defining key performance indicators. Additionally, it includes sections on keyboard shortcuts, a glossary, and an index for quick reference.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views1 page

Excel 12

The document outlines advanced analysis techniques in Excel, including business intelligence analysis, data modeling, and forecasting. It covers managing data with Power Pivot, creating visualizations, and defining key performance indicators. Additionally, it includes sections on keyboard shortcuts, a glossary, and an index for quick reference.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Part 4: Perform advanced analysis

15
Perform business intelligence analysis . . . . . . . . . . . . . . . . . . . . . . . . . . 373
Manage the Excel Data Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 374
Sidebar: Power View data visualizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375
Define relationships between data sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 380
Manage data by using Power Pivot . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 384
Display data on timelines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391
Import data by using Power Query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395
Skills review . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400
Practice tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 401

16
Create forecasts and visualizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 403
Create forecast worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .404
Linear forecasting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .404
Exponential smoothing forecasting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .404
Define and manage measures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410
Define and display key performance indicators . . . . . . . . . . . . . . . . . . . . . . . . . . . . 412
Create 3D data maps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 416
Skills review . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 421
Practice tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 422

Appendix Keyboard Shortcuts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 425


Excel for Microsoft 365 keyboard shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . 425
Excel function key commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 432
Microsoft 365 app keyboard shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 434
Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 441
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 447

xi

You might also like