- Cover Page
- Title Page
- Copyright Page
- Contents
- Acknowledgments
- About the Author
- Introduction
- Part 1: Create and format workbooks
- Part 2: Analyze and present data
- 5 Manage worksheet data
- 6 Reorder and summarize data
- 7 Combine data from multiple sources
- 8 Analyze alternative data sets
- Examine data by using the Quick Analysis Lens
- Define an alternative data set
- Define multiple alternative data sets
- Analyze data by using data tables
- Vary your data to get a specific result by using Goal Seek
- Find optimal solutions by using Solver
- Analyze data by using descriptive statistics
- Skills review
- Practice tasks
- 9 Create charts and graphics
- Create charts
- Perform business intelligence analysis using charts
- Customize chart appearance
- Find trends in your data
- Create combo charts
- Summarize your data by using sparklines
- Create diagrams by using SmartArt
- Create and manage shapes
- Create and manage mathematical equations
- Skills review
- Practice tasks
- 10 Use PivotTables and PivotCharts
- Part 3: Collaborate and share in Excel
- Part 4: Perform advanced analysis
- Keyboard Shortcuts
- Glossary
- Index
- Code Snippets
Microsoft Excel 2019
Step by Step
By Curtis Frye
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.