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 2016
      • 1.1A Working Model for Data Analytics
      • 1.2A Review of Excel 2016
      • 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

      • 2.1Entering and Managing Data

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 2.2Formatting Worksheets

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 2.3Chapter Assignments and Tests

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 3Data Analytics Techniques for Basic Projects

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 3.1Introduction to Data Visualization

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 3.2Introduction to PivotTables and PivotCharts

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 3.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 4Using Mathematical Outputs for Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 4.1Formulas

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 4.2Basic Statistics Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 4.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 5Scenario Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 5.1Loan and Lease Scenarios

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 5.2Investment Scenarios

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 5.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 6Exception Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 6.1Logical Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 6.2Lookup Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 6.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 7Summarizing Exception Analytics

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 7.1Statistical IF Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 7.2Statistical IFS Functions

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 7.3Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 8Working with Big Datasets Case: Investigating Fraud

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 8.1Using the DATA Analytics Framework

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 8.2Data Audit Using PivotTables

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 8.3Analyzing the Data

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 8.4Summarizing Big Datasets in Custom Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 8.5Establishing Data Internal Controls

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 8.6Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

    • 9Charts for Presentations and Data Visualization

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now

      • 9.1Chart Types

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 9.2Formatting Enhancements for Charts

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 9.3Using Charts in PowerPoint and Word

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 9.4The Scatter Chart and Motion Data Visualization

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now

      • 9.5Chapter Assignments and Test

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now