Skip to main content
FlatWorld HomeFlatWorld Home
  • My Bookshelf

Table of Contents

    • About the Author
    • Acknowledgments
    • Dedication
    • Preface
    • 1Introduction to Data Analytics and Microsoft Excel 365
      • 1.1A Working Model for Data Analytics
      • 1.2A Review of Excel 365
      • 1.3Chapter Assignments and Tests
    • 2Essential Skills for Basic Data Analytics Projects

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 2.1Entering and Managing Data

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.2Formatting Worksheets

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.3Chapter Assignments and Tests

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 3Data Analytics Techniques for Basic Projects

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 3.1Introduction to Data Visualization

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 3.2Introduction to PivotTables and PivotCharts

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 3.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 4Using Mathematical Outputs for Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 4.1Formulas

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 4.2Basic Statistics Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 4.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 5Scenario Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 5.1Loan and Lease Scenarios

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 5.2Investment Scenarios

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 5.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 6Exception Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 6.1Logical Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 6.2Lookup Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 6.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 7Summarizing Exception Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 7.1Statistical IF Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 7.2Statistical IFS Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 7.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 8Working with Big Datasets Case: Investigating Fraud

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 8.1Using the DATA Analytics Framework

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.2Data Audit Using PivotTables

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.3Analyzing the Data

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.4Summarizing Big Datasets in Custom Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.5Establishing Data Internal Controls

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.6Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 9Charts for Presentations and Data Visualization

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 9.1Chart Types

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 9.2Formatting Enhancements for Charts

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 9.3Using Charts in PowerPoint and Word

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 9.4The Scatter Chart and Motion Data Visualization

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 9.5Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 10Predictive Analytics Case: Can You Predict the Stock Market?

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 10.1Assessing the Case

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 10.2Preliminary Analysis: Examining Assumptions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 10.3Solving the Case

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 10.4Case Wrap Up: Prediction versus Reality

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 10.5Chapter Assignments and Tests

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • AKeyboard Only Commands from PC to Mac

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

    • BVisual Differences between PC and Mac

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • B.1Visual Differences on the Ribbon

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • B.2ToolTip and Dialog Box Differences

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • CCommand and Feature Differences on a Mac

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • C.1Accessing Backstage Commands

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • C.2The Right-Click Menu

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • C.3Multi-Level Sorting

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • C.4Sorting Data in a PivotTable

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • C.5Charts: Assigning Data to X and Y Axes

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • C.6Conditional Formatting: New Formatting Rule

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • DCommand and Feature Omissions on a Mac

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code