Microsoft Excel - Working with Databases

Description

Microsoft Excel - Working with Databases

Time Length Icon 1h25min Pictogram view Viewed 511 times
Button

Simple or complex calculations can be performed using a database. In this course, we will see how Excel can be used to compose information using multiple tables using Power Query, Power Pivot, and some macros.

Session Theme:
Data transformation via Power Query and Power Pivot query editors

Target Audience:
Any experienced Excel user who wants to start integrating data from an external database to build dashboards in Excel.

Startup Level:
Advanced

Prerequisite:
Have in-depth knowledge of Excel and database concepts.

Means and methods:
100% video course

Objectives:

  • Use Power Query and Power Pivot to search for data sources and make connections to analyze and conceptualize data models.
  • Use macros to automate actions and calculations.

Course Outline:

  • Introducing Power Query and Power Pivot
  • Importing data
  • Working with macros