Sale!

Advanced Excel for Productivity 1st edition by Chris Urban ISBN 9780997877304 0997877308

Original price was: $70.00.Current price is: $24.99.

Instant download Advanced Excel for Productivity (eBook PDF) after payment

SKU: EB_107892 Category:

Advanced Excel for Productivity 1st edition by Chris Urban – Ebook PDF Instant Download/Delivery:9780997877304, 0997877308

Instant download Full Chapter of Advanced Excel for Productivity 1st edition after payment

Product details:

ISBN 10: 0997877308
ISBN 13: 9780997877304
Author:   Chris Urban 

This book is for those who are familiar with Microsoft Excel and use it on a regular basis. You know there’s more out there, a way to do more, faster, and better. Learn to step up your game with Advanced Excel for Productivity, a readable and useful guide to improving everything you do in Excel. Learn advanced techniques for Microsoft Excel, including keyboard shortcuts, functions, data analysis, VBA, and other advanced tips.
 

Table of contents:

  1. Introduction
  2. Acknowledgements
  3. Quick Start with Advanced Excel
  4. Keyboard Navigation
    1. The Essentials: [Arrows], [CTRL], [SHIFT]
    2. Example: Filling Formulas in an Entire Column
    3. Other Keyboard Navigation
    4. Entering and Editing Formulas
    5. Recap of Keyboard vs. Mouse
  5. Keyboard Shortcuts
    1. The [ALT] Key
    2. Paste Special
    3. Insert and Delete Cells
    4. Practice: Rearranging with the Keyboard
    5. Working with Formulas
    6. Basic Formatting with Keyboard
    7. Grouping and Hiding Columns and Rows
    8. Other Shortcuts
  6. Functions
    1. Logic Functions: IF, AND, OR, NOT, MAX, MIN
    2. Math Functions
    3. Nested Functions
    4. VLOOKUP
    5. Text Functions
    6. Date Functions
    7. Data Types
    8. Financial Functions
    9. Practice: Amortizing Cash Flows
    10. ISBLANK, ISNUMBER, IS-Whatever
    11. OFFSET and INDIRECT
  7. Advanced Formulas
    1. Named References
    2. Calculation Options
    3. Circular References
    4. Formula Errors
    5. Debugging Formulas
    6. External References
  8. Data, Pivot Tables, and Charts
    1. Cleaning Up Data
    2. Filtering and Data Tables
    3. Duplicate Data
    4. Pivot Table Basics
    5. Pivot Table Error Messages
    6. Advanced Pivot Tables
    7. Charts
    8. Cleaning Up Data Using External Tools
  9. Excel Modeling
    1. Modeling Mistakes and Risks
    2. Golden Rules of Modeling
    3. Making Models Look Better
    4. Other Modeling Advice
    5. Quickly Understanding How an Excel Sheet Works
    6. Data Validation: Restricting Inputs
    7. Protect Workbook: Locking Cells
    8. Scenarios, Sensitivity Analysis, and “What-If” Analysis
  10. Macros and VBA
    1. If You Need Something, Google It!
    2. Quick Start: Recording Macros
    3. Quick Start: VBA Code
    4. VBA Interfacing with the Excel Sheet
    5. VBA Variables and Simple Math
    6. VBA Math Functions: Min, Max, Average
    7. Variables Versus Ranges
    8. Debugging VBA Code
    9. Three Golden Rules of VBA
    10. Example VBA Exercises
    11. Practice: Delete Empty Rows Macro
    12. Custom Functions within Excel
    13. Other VBA and Macro Topics
  11. Cool Excel Tricks
    1. Speed Up a Big Slow File
    2. Repair a Corrupted File
    3. Fix Annoying Errors
    4. Avoid Array Formulas
    5. Approximate Matching for Text
    6. Two-Dimensional Lookup Table
    7. Custom Number and Date Formats
    8. Printing Tips
    9. Find/Replace Tips
    10. Excel Settings Tips
    11. Excel Security and Cracking Passwords
    12. Great Add-Ins
  12. Conclusion

People also search:

advanced excel spreadsheet examples
advanced excel examples
is advanced excel useful
excel spreadsheet for productivity
advanced excel for dummies

Reviews

There are no reviews yet.

Be the first to review “Advanced Excel for Productivity 1st edition by Chris Urban ISBN 9780997877304 0997877308”