Data Analytics Using Excel® Microsoft® 365

- 1Introduction to Data Analytics and Microsoft Excel 365
- 2Essential Skills for Basic Data Analytics Projects
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 2.1Entering and Managing Data
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.2Formatting Worksheets
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.3Chapter Assignments and Tests
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 3Data Analytics Techniques for Basic Projects
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 3.1Introduction to Data Visualization
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 3.2Introduction to PivotTables and PivotCharts
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 3.3Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 4Using Mathematical Outputs for Analytics
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 4.1Formulas
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 4.2Basic Statistics Functions
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 4.3Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 5Scenario Analytics
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 5.1Loan and Lease Scenarios
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 5.2Investment Scenarios
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 5.3Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 6Exception Analytics
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 6.1Logical Functions
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 6.2Lookup Functions
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 6.3Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 7Summarizing Exception Analytics
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 7.1Statistical IF Functions
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 7.2Statistical IFS Functions
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 7.3Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 8Working with Big Datasets Case: Investigating Fraud
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 8.1Using the DATA Analytics Framework
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.2Data Audit Using PivotTables
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.3Analyzing the Data
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.4Summarizing Big Datasets in Custom Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.5Establishing Data Internal Controls
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.6Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 9Charts for Presentations and Data Visualization
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 9.1Chart Types
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 9.2Formatting Enhancements for Charts
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 9.3Using Charts in PowerPoint and Word
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 9.4The Scatter Chart and Motion Data Visualization
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 9.5Chapter Assignments and Test
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 10Predictive Analytics Case: Can You Predict the Stock Market?
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 10.1Assessing the Case
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 10.2Preliminary Analysis: Examining Assumptions
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 10.3Solving the Case
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 10.4Case Wrap Up: Prediction versus Reality
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 10.5Chapter Assignments and Tests
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- AKeyboard Only Commands from PC to Mac
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
- BVisual Differences between PC and Mac
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - B.1Visual Differences on the Ribbon
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - B.2ToolTip and Dialog Box Differences
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- CCommand and Feature Differences on a Mac
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - C.1Accessing Backstage Commands
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - C.2The Right-Click Menu
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - C.3Multi-Level Sorting
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - C.4Sorting Data in a PivotTable
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - C.5Charts: Assigning Data to X and Y Axes
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - C.6Conditional Formatting: New Formatting Rule
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- DCommand and Feature Omissions on a Mac
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now