| Description |
1 online resource (826 p.) |
| Contents |
Intro -- Preface/Forward/Intro -- Microsoft 365 Excel: The Only App That Matters -- Dedications -- About the Author -- Acknowledgements -- Introduction -- Who This Book Is For -- PC Versus Mac Excel -- Following Along with Excel Files -- Chapter 1: Why Excel 365? -- The Worksheet Formula Calculation Engine -- Array Formulas -- New Array Functions: UNIQUE and FILTER -- The New XLOOKUP and LET Functions -- Power Query and the M Code Formula Language -- Power Pivot, the Data Model, and DAX Formulas -- Power BI Desktop for Creating Visualizations and Reports -- Key Concepts in Chapter 1 |
|
Chapter 2: Why the Spreadsheet Was Invented -- Key Concepts in Chapter 2 -- Chapter 3: What Does Excel Do? -- Key Concepts in Chapter 3 -- Chapter 4: Key Concepts Used to Create Excel Solutions -- Key Concepts in Chapter 4 -- Chapter 5: The Structure of Excel Files and Worksheets -- The Two-Way Grid: Cells, Worksheets, and Workbooks -- Worksheet Navigation -- Excel Data and Default Alignment in Cells -- The Excel Command Environment -- The Quick Access Toolbar -- The File Menu and Backstage View -- File Management -- Key Concepts in Chapter 5 -- Keyboard Shortcuts Learned in Chapter 5 |
|
Chapter 6: Keyboard Keys and Shortcuts -- Keyboard Shortcuts -- Key Concepts in Chapter 6 -- Keyboard Shortcuts Learned in Chapter 6 -- Chapter 7: Worksheet Efficiency Tricks -- Using Worksheet Mouse Cursors -- Entering Content into Cells with Five Different Keyboard Shortcuts -- Selecting a Range of Cells -- Jumping Around in a Worksheet -- Key Concepts in Chapter 7 -- Chapter 8: Worksheet Formulas, Formatting, and Setup to Solve Problems -- Creating a Sample Worksheet -- Using the Proper Dataset Format -- Adding Style Formatting -- Entering the Data |
|
Using Worksheet Formulas, Functions, Cell References, and Aggregate Operations -- Checking Your Work and Verifying Your Formulas -- Using Relative Cell References -- Adding Number Formatting -- Using the Format Painter -- Inserting Rows into a Worksheet -- Calculating Percentages -- Understanding Absolute Cell References -- Documenting Your Work -- Spilling Dynamic Array Formulas and Array Operations -- Using the Excel Table Feature -- Sorting and Filtering -- Setting Up a Page for Printing -- Adding New Data to a Dynamic Solution by Using a Text File -- Converting a Solution to a PDF File |
|
Key Concepts in Chapter 8 -- Keyboard Shortcuts Learned in Chapter 8 -- Practice Problems for Chapter 8 -- Chapter 9: A Golden Rule for Building Excel Models -- How Violating the Golden Rule Can Get You into Trouble -- Benefits of Following the Golden Rule -- Example 1: Commission Pay Worksheet Formula -- Example 2: Monthly Expense Formula with Hard-Coded Formula Input -- Example 3: COUNTIFS Worksheet Function to Count with a Condition -- Example 4: UNIQUE Array Function and Data Validation List -- Example 5: Conditional Formatting -- What-If Analysis and Excel Models -- Key Concepts in Chapter 9 |
| Note |
Keyboard Shortcuts Learned in Chapter 9 |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Electronic spreadsheets.
|
|
Electronic spreadsheets |
| Other Form: |
Print version: Girvin, Mike Microsoft 365 Excel: The Only App That Matters Chicago : Holy Macro! Books,c2021 9781615470709 |
| ISBN |
9781615471560 electronic book |
|
1615471561 electronic book |
|
