- Cover Page
- Title Page
- Copyright Page
- Dedication Page
- Contents at a Glance
- Table of Contents
- About the Author
- Introduction
- Part I The Excel Interface
- Chapter 1 What’s New in Excel 2019
- Office 365 Is the Future
- Forward-Looking Features in Excel 2019
- Power Query Is Still the Best New Feature in Excel 2019
- Co-Authoring Allows Multiple People to Edit the Same Workbook at the Same Time
- Improvements to PivotTables
- New Calculation Functions in Excel 2019
- Two New Charts in 2019
- Inserting Icons and 3D Models
- Using the Inking Tools in Excel 2019
- Suggesting Ideas to the Excel Team
- Accessibility Improvements Across Office
- Changes to the Ribbon and Home Screen
- Collecting Survey Data in Excel Using Office 365
- Future Features Coming to Office 365
- Dynamic Array Functions in Office 365
- Chapter 2 Using the Excel Interface
- Using the Ribbon
- Using the Quick Access Toolbar
- Using the Full-Screen File Menu
- Using the New Sheet Icon to Add Worksheets
- Navigating Through Many Worksheets Using the Controls in the Lower Left
- Using the Mini Toolbar to Format Selected Text
- Expanding the Formula Bar
- Zooming In and Out on a Worksheet
- Using the Status Bar to Add Numbers
- Switching Between Normal View, Page Break Preview, and Page Layout View Modes
- Chapter 3 Customizing Excel
- Chapter 4 Keyboard Shortcuts
- Chapter 1 What’s New in Excel 2019
- Part II Calculating with Excel
- Chapter 5 Understanding Formulas
- Chapter 6 Controlling Formulas
- Chapter 7 Understanding Functions
- Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions
- Chapter 9 Using Powerful Functions: Logical, Lookup, and Database Functions
- Chapter 10 Other Functions
- Chapter 11 Connecting Worksheets and Workbooks
- Chapter 12 Array Formulas and Names in Excel
- Advantages of Using Names
- Naming a Cell by Using the Name Dialog Box
- Using the Name Box for Quick Navigation
- Avoiding Problems by Using Worksheet-Level Scope
- Using Named Ranges to Simplify Formulas
- Retroactively Applying Names to Formulas
- Using Names to Refer to Ranges
- Adding Many Names at Once from Existing Labels and Headings
- Using Intersection to Do a Two-Way Lookup
- Using Implicit Intersection
- Using a Name to Avoid an Absolute Reference
- Using a Name to Hold a Value
- Assigning a Formula to a Name
- Using Power Formula Techniques
- Combining Multiple Formulas into One Formula
- Part III Data Analysis with Excel
- Chapter 13 Transforming Data
- Chapter 14 Summarizing Data Using Subtotals or Filter
- Adding Automatic Subtotals
- Working with the Subtotals
- Subtotaling Multiple Fields
- Subtotaling Daily Dates by Month
- Filtering Records
- Using the Advanced Filter Command
- Excel in Practice: Using Formulas for Advanced Filter Criteria
- Using Remove Duplicates to Find Unique Values
- Combining Duplicates and Adding Values
- Chapter 15 Using Pivot Tables to Analyze Data
- Creating Your First Pivot Table
- Dealing with the Compact Layout
- Rearranging a Pivot Table
- Finishing Touches: Numeric Formatting and Removing Blanks
- Three Things You Must Know When Using Pivot Tables
- Calculating and Roll-Ups with Pivot Tables
- Formatting a Pivot Table
- Setting Defaults for Future Pivot Tables
- Finding More Information on Pivot Tables
- Chapter 16 Using Slicers and Filtering a Pivot Table
- Chapter 17 Mashing Up Data with Power Pivot
- Chapter 18 Using What-If, Scenario Manager, Goal Seek, and Solver
- Chapter 19 Automating Repetitive Functions Using VBA Macros
- Checking Security Settings Before Using Macros
- Recording a Macro
- Case Study: Macro for Formatting for a Mail Merge
- Everyday-Use Macro Example: Formatting an Invoice Register
- Understanding VBA Code—An Analogy
- Using Simple Variables and Object Variables
- Customizing the Everyday-Use Macro Example: GetOpenFileName and GetSaveAsFileName
- From-Scratch Macro Example: Loops, Flow Control, and Referring to Ranges
- Combination Macro Example: Creating a Report for Each Customer
- Chapter 20 More Tips and Tricks for Excel 2019
- Watching the Results of a Distant Cell
- Calculating a Formula in Slow Motion
- Inserting a Symbol in a Cell
- Editing an Equation
- Protecting a Worksheet
- Repeat the Last Command with F4
- Bring the Active Cell Back in to View with Ctrl+Backspace
- Separating Text Based on a Delimiter
- Auditing Worksheets Using Inquire
- Part IV Excel Visuals
- Chapter 21 Formatting Worksheets
- Chapter 22 Using Data Visualizations and Conditional Formatting
- Using Data Bars to Create In-Cell Bar Charts
- Using Color Scales to Highlight Extremes
- Using Icon Sets to Segregate Data
- Using the Top/Bottom Rules
- Using the Highlight Cells Rules
- Tweaking Rules with Advanced Formatting
- Combining Rules
- Extending the Reach of Conditional Formats
- Special Considerations for Pivot Tables
- Chapter 23 Graphing Data Using Excel Charts
- Chapter 24 Using 3D Maps
- Chapter 25 Using Sparklines
- Chapter 26 Formatting Spreadsheets for Presentation
- Chapter 27 Printing
- Chapter 28 Sharing Dashboards with Power BI
- Appendixes
- Appendix A DAX Functions
- Excel Functions and DAX Equivalents
- Date and Time Functions in DAX
- Time Intelligence Functions in DAX
- Filter Functions in DAX
- Information Functions in DAX
- Logical Functions in DAX
- Math and Trig Functions in DAX
- Other Functions in DAX
- Parent and Child Functions in DAX
- Statistical Functions in DAX
- Text Functions in DAX
- Appendix B Power Query M Functions
- Excel Functions with Power Query M Equivalents
- Accessing Data Functions in Power Query M
- Binary Functions in Power Query M
- Combiner Functions in Power Query M
- Comparer Functions in Power Query M
- Date Functions in Power Query M
- DateTime Functions in Power Query M
- DateTimeZone Functions in Power Query M
- Duration Functions in Power Query M
- Error Functions in Power Query M
- Expression Functions in Power Query M
- Function Functions in Power Query M
- Lines Functions in Power Query M
- List Functions
- Logical Functions in Power Query M
- Number Functions
- Record Functions
- Replacer Functions in Power Query M
- Splitter Functions in Power Query M
- Table Functions
- Text Functions
- Time Functions in Power Query M
- Type Functions in Power Query M
- URI Functions in Power Query M
- Value Functions in Power Query M
- Appendix A DAX Functions
- Index
- Code Snippets
Part IV
Excel Visuals
Chapter 21
Formatting Worksheets
Chapter 22
Using Data Visualizations and Conditional Formatting
Chapter 23
Graphing Data Using Excel Charts
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.