Chrysalis Consulting Group/Monarch Data Prep Studio Essentials - Excel

  • Free

Monarch Data Prep Studio Essentials - Excel

  • Course
  • 19 Lessons

This course teaches how to import spreadsheets (two methods), preview data, clean and transform it, join or append files, create summaries, and export results. Designed for professionals who perform core data preparation—cleaning, combining, and transforming data—examples include accountants, analysts, auditors, and operations teams across industries; Banking, Healthcare Finance, and General Accounting Operations.

Contents

Introduction

Introduction
Monarch Overview
Monarch for Excel Overview
Excel Use Cases

Data Prep Studio Overview

Data Prep Studio Windows
File Types

Importing Spreadsheets

Importing Spreadsheets Intro
1. Single Excel File - Consistent Tab or Sheet Name
2. Single Excel File - Data Starts Several Lines Below Header
3. Single Excel File - Changing Tab or Sheet Name
4. Single Excel File - Multiple Tabs or Sheets
5. Multiple Excel Files - Consistent Tab or Sheet Name
6. Multiple Excel Files - Changing Tab or Sheet Names
7. Excel File Structured as a Report
Importing Spreadsheets Outro

Excel Exercises

Exercise 21 - Oracle NetSuite AR Aging Analysis
Exercise 44 - Fiserv Optis CD-072 Analysis
Exercise 22 - Salesforce Opportunities Analysis

Quiz

Monarch DPS Essentials - Excel