Data Processing and Analysis with MS EXCEL & MS ACCESS

Learn Creating Dashboard and Analyze data with MS Access and MS Excel in an hour (Crash Course)

The course is about data analysis and creating a dashboard using the easily available tools such as Excel and Access.

What you’ll learn

  • Creating a Dashboard in Excel, MS Access Queries, Access relationships, Import Data & Export Data from MS Access.

Course Content

  • Introduction –> 1 lecture • 2min.
  • Resources –> 1 lecture • 3min.
  • Perfecting Skills within MS Excel and MS Access –> 1 lecture • 3min.
  • Importing Data, Relationship Diagram, Queries, and Export Data –> 4 lectures • 33min.
  • Creating Pivot Tables and Charts –> 1 lecture • 8min.
  • Creating Dashboard –> 1 lecture • 14min.

Data Processing and Analysis with MS EXCEL & MS ACCESS

Requirements

  • Basic knowledge of MS Access and MS Excel.

The course is about data analysis and creating a dashboard using the easily available tools such as Excel and Access.

This  course will walk you through the process to convert your raw data into an attractive dynamic dashboard. Each video links together the process required to create a dashboard and allows students to have the ability to master their skills without taking away from their busy schedules.

Get Tutorial