TRAINING SESSION CALENDAR
  2. Courses
  3. Microsoft Excel - Working with Databases

Microsoft Excel - Working with Databases

Description

Analyze your data with Power Query
  • Power Query
    • Introduction to Power Query
    • How to install Power Query
    • Import options presentation
    • Import an Excel file
    • Import a series of files into a folder
    • Import data from an API
    • Power Query overview
    • Change the order of columns
    • Delete columns
    • Duplicate a column
    • Merge two columns
    • Delete rows
    • Remove duplicates
    • Split a column
    • Change the format of a column
    • Add a column off an example
    • Add a conditional column
    • Replace values
    • How to refresh your data after import
Analyze your data with Power Pivot
  • Power Pivot
    • Power Pivot Overview and Installation
    • Import a table into the data model
    • Create relationships between tables
    • Create measurement functions
    • Use Power Pivot in a PivotTable
Add-in: Use macros
  • Macros
    • Work with macros
    • Edit a macro
    • Save your macro
    • Assign a button to a macro

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
News
Analyze
Excel