Next steps

Contents

• Introduction Introduction

  • Make Excel data entry more visual

    57s
  • What you should know

    18s
  • Working with the exercise files

    49s
• 1. The Benefits of Moving to Access 1. The Benefits of Moving to Access

  • (Locked)
    Understanding the limitations of Excel

    2m 46s
  • (Locked)
    Understanding the limitations of Access

    3m 46s
  • Learning how queries, forms, and reports work with tables

    3m 11s
• 2. Understanding the Access Structure 2. Understanding the Access Structure

  • (Locked)
    Work with table views

    2m 10s
  • (Locked)
    Link data to Access

    5m 13s
• 3. Analyze Database Tables 3. Analyze Database Tables

  • (Locked)
    Learning the basics of normalization

    2m 15s
  • (Locked)
    Understanding table relationships

    1m 52s
  • (Locked)
    Identify keys

    1m 15s
  • (Locked)
    Understanding join types

    2m 55s
• 4. Build and Work with Queries 4. Build and Work with Queries

  • (Locked)
    Create queries

    3m 14s
  • (Locked)
    Sort and filter in a query

    3m 3s
  • Enhance queries

    4m 14s
  • (Locked)
    Build unique data queries

    3m 47s
  • (Locked)
    Work with SQL view

    6m 15s
  • (Locked)
    Build aggregate data queries

    4m 39s
• 5. Export and Link Data to Excel 5. Export and Link Data to Excel

  • (Locked)
    Import to and from Access

    2m 5s
  • (Locked)
    Link data to Excel

    2m 15s
  • (Locked)
    Work with external connections

    2m 15s
  • (Locked)
    Refresh data from other sources

    1m 39s
  • (Locked)
    Add data from connections

    1m 19s
  • (Locked)
    Change connections

    2m 8s
• 6. Charting and Pivots in Excel 6. Charting and Pivots in Excel

  • Build sunburst charts and treemaps

    5m 9s
  • (Locked)
    Build pivots and set refresh settings

    5m
  • (Locked)
    Build PivotCharts

    5m 23s
  • (Locked)
    Using slicers and timelines to filter

    2m 40s
  • (Locked)
    Set slicer options

    3m 3s
  • (Locked)
    Move charts

    6m 26s
  • (Locked)
    Work with page layout

    5m 8s
• 7. Build Excel Macros for Dashboard 7. Build Excel Macros for Dashboard

  • (Locked)
    Create macros that clear filters

    1m 27s
  • (Locked)
    Create macros for common filters

    2m 43s
  • (Locked)
    Create macros that navigate

    2m 27s
  • (Locked)
    Assign macros to buttons

    3m 54s
• Conclusion Conclusion

  • (Locked)
    Next steps

    15s