Udemy

Platform

English

Language

Other

Category

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)

3.50 (1 reviews)

Students

1 hour

Content

Oct 2020

Last Update
Regular Price

EXCLUSIVE SKILLSHARE OFFER
Exclusive  SkillShare  Offer
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

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


Description

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.


Screenshots

Data Processing and Analysis with MS EXCEL & MS ACCESS
Data Processing and Analysis with MS EXCEL & MS ACCESS
Data Processing and Analysis with MS EXCEL & MS ACCESS
Data Processing and Analysis with MS EXCEL & MS ACCESS

Content

Introduction

Introduction

Resources

Review the sample data files

Perfecting Skills within MS Excel and MS Access

Perfecting Skills within MS Excel and MS Access

Importing Data, Relationship Diagram, Queries, and Export Data

How to Import data/Create tables in MS Access

Create a Relationships Diagram in MS Access

Create Queries in MS Access

Export Data in MS Excel

Creating Pivot Tables and Charts

Create Pivot Tables and Charts in MS Excel

Creating Dashboard

creating a Dashboard


3566503

Udemy ID

10/13/2020

Course created date

2/27/2021

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram