Course curriculum

  • 1

    Course Guide

    • Course Q & A
  • 2

    Introduction

    • Introduction Manual
    • Introduction Handout
    • Introduction
  • 3

    Cell Sites & Networks

    • Cell Sites & Networks Manual
    • Cell Sites & Networks Handout
    • Cell Sites & Networks
  • 4

    Identify the Carrier

    • Identify the Carrier Manual
    • Identify the Carrier Handout
    • Identify the Carrier
  • 5

    Search Warrant

    • Search Warrant Manual
    • Search Warrant Handout
    • Search Warrant
    • AT&T Search Warrant Example 3-2018
    • Metro PCS Search Warrant Example 3-2018
    • Sprint Search Warrant Example 3-2018
    • T-Mobile Search Warrant Example 3-2018
    • Verizon Search Warrant Example 3-2018
  • 6

    Sending the Warrant

    • Sending the Warrant Manual
    • Sending the Warrant Handout
    • Sending the Warrant
  • 7

    Receiving the Records

    • Receiving the Records Manual
    • Receiving the Records Handout
    • Receiving the Records
  • 8

    File Types

    • File Types Manual
    • File Types Handout
    • File Types
  • 9

    Excel Functions

    • Excel Functions Manual
    • Excel Functions Handout
    • Excel Functions
  • 10

    Worksheets

    • Worksheets Manual
    • Worksheets Handout
    • Worksheets
    • Worksheets Practical Exercise
  • 11

    Cells

    • Cells Manual
    • Cells Handout
    • 10.1 Cells Intro
    • 10.2 Cells Select a Cells
    • 10.3 Cells Select Multiple Cells
    • 10.4 Cells Select Columns and Rows
    • 10.5 Cells Select All Cells
    • 10.6 Cells Borders
    • 10.7 Cells Highlight
    • 10.8 Cells Format Cells
    • Cells Practical Exercize Workbook
    • Cells Practical Exercise
  • 12

    Copy & Paste

    • Copy & Paste Manual
    • Copy & Paste Handout
    • 11.1 Copy and Paste Intro
    • 11.2 Copy and Paste Single Cell
    • 11.3 Copy and Paste Special Values
    • 11.4 Copy and Paste Selection
    • 11.5 Copy and Paste Column
    • 11.6 Copy and Paste Row
    • Copy and Paste Practical Exercise Workbook
    • Copy and Paste Practical Exercise
  • 13

    Columns & Rows

    • Columns & Rows Manual
    • Columns & Rows Handout
    • 12.1 Columns and Rows Intro
    • 12.2 Columns and Rows Resize Columns
    • 12.3 Columns and Rows Resize Rows
    • 12.4 Columns and Rows Insert Columns
    • 12.5 Columns and Rows Filter
    • 12.6 Columns and Rows Sort
    • 12.7 Columns and Rows Custom Sort
    • 12.8 Columns and Rows Text to Columns
    • 12.9 Columns and Rows Autofill Cells
    • 12.10 Columns and Rows Freeze Top Row
    • 12.11 Columns and Rows Remove Duplicates
    • Columns & Rows Practical Exercise Workbook
    • Columns & Rows Practical Exercise
  • 14

    Formulas

    • Formulas Manual
    • Formulas Handout
    • 13.1 Formulas Intro
    • 13.2 Formulas Concatenate
    • 13.3 Formulas VLookup
    • 13.4 Formulas If Then
    • Formulas Practical Exercise Workbooks
    • Formulas Practical Exercise
  • 15

    Time

    • Time Manual
    • Time Handout
    • 14.1 Time Intro
    • 14.2 Time How Excel Stores Time
    • 14.3 Time Add Subtract Days Hours
    • 14.4 Time Format Time
    • 14.5 Time Combine Time and Date
    • 14.6 Time Separate Time and Date
    • 14.7 Time Adjust for Time Zones
    • Time Practical Exercise Workbook
    • Time Practical Exercise
  • 16

    Pivot Tables

    • Pivot Tables Manual
    • Pivot Tables Handout
    • 15.1 Pivot Tables
    • 15.2 Pivot Tables Demo
    • Pivot Tables Practical Exercise Workbook
    • Pivot Tables Practical Exercise
  • 17

    Preparing the Records

    • Preparing the Records Manual
    • Preparing the Records Handout
    • 16 Preparing the records
  • 18

    Sprint Records

    • Sprint Records Manual
    • Sprint Records Handout
    • 17 Sprint Records
  • 19

    Sprint Preparation

    • Sprint Preparation Manual
    • Sprint Preparation Handout
    • 18.1 Sprint Prep Intro
    • 18.2 Sprint Prep CDR
    • 18.2.1 Sprint Prep CDR Demo
    • 18.3 Sprint Prep NEID
    • 18.4 Sprint Prep Called Number
    • 18.4.1 Sprint Prep Called Number Demo
    • 18.5 Sprint Prep Time
    • 18.5.1 Sprint Prep Time Demo
    • 18.6 Sprint Prep Cell Sites
    • 18.6.1 Sprint Prep Cell Sites Demo
    • 18.7 Sprint Prep Template
    • 18.7.1 Sprint Prep Template Demo
    • 18.8 Sprint Prep Target Number Connected To
    • 18.9 Sprint Prep Direction
    • 18.10 Sprint Prep Type
    • 18.11 Sprint Prep Timestamp Duration
    • 18.12 Sprint Prep First Last Cell Sector
    • 18.13 Sprint Prep Template Demo 1
    • 18.14 Sprint Prep Cell Site List
    • 18.14.1 Sprint Prep Cell Site List Demo
    • 18.15 Sprint Prep VLookup
    • 18.15.1 Sprint Prep VLookup Demo
    • 18.16 Sprint Prep Addresses
    • 18.16.1 Sprint Prep Addresses Demo
    • 18.17 Sprint Prep Template 2
    • 18.17.1 Sprint Prep Template 2 Demo
    • 18.18 Sprint Prep Conclusion
  • 20

    Verizon Records

    • Verizon Records Manual
    • Verizon Records Handout
    • 19 Verizon Records
  • 21

    Verizon Preparation

    • Verizon Preparation Manual
    • Verizon Preparation Handout
    • 20.1 Verizon Prep Intro CDR Element
    • 20.2 Verizon Prep Sectors
    • 20.3 Verizon Prep Time
  • 22

    T-Mobile Records

    • T-Mobile Records Manual
    • T-Mobile Records Handout
    • 21 T-Mobile Records
  • 23

    T-Mobile Preparation

    • T-Mobile Preparation Manual
    • T-Mobile Preparation Handout
    • 22.2 T-Mobile Preparation Duration 10DN Locations
    • 22.1 T-Mobile Preparation CDR Time
  • 24

    AT&T Records

    • AT&T Records Manual
    • AT&T Records Handout
    • AT&T Records
  • 25

    AT&T Preparation

    • AT&T Preparation Manual
    • AT&T Preparation Handout
    • 24.1 ATT Prep CDR
    • 24.2 ATT Prep Time 10DN
    • 24.3 ATT Prep Locations
  • 26

    Analysis

    • Analysis Manual
    • Analysis Handout
    • 25.1 Analysis Calls Analysis
    • 25.2 Analysis Subscribers Locations
  • 27

    Maps

    • Maps Manual
    • Maps Handout
    • 26.1 Maps Prepare List Import
    • 26.2 Maps Specific Sites Sectors
  • 28

    Presentation

    • Presentation Manual
    • Presentation Handout
    • 27.1 Presentation PP Map Streenshots
    • 27.2 Presentation Slides
  • 29

    Conclusion

    • Conclusion Manual
    • Conclusion Handout
    • Conclusion
    • Cell Phone Record Analysis Manual