sangyoullee2236

Expanding Excel's data processing capabilities and enhancing data handling performance through integration with external systems (SQL Server, Access, etc.)
- Utilizing core Excel features such as Power Pivot (Excel Data Model)
- Ultimately extending usability beyond the various limitations and inefficiencies of Excel

excelanddatabase

Excel and Database (Introduction) [Subtitles included]

excel

Excel

파워 피벗

Excel-Power-Pivot

입문

초급

중급이상

엑셀

브이비에이

Excel Power Pivot

Excel and Database (Introductory) Course Introduction

Excel and Database (Introductory) Instructor Introduction

What is the lecture about?

I. Introduction to Excel

II. Excel Tips for Databases

III. Excel Table Features

IV. MS Query Utilization

V. Excel vs Access Comparison (and Access 2010)

VI. Excel Data Model (Power Pivot Data Model)

VII. VBA for Databases

VIII. Excel BI (Power Pivot, Power Query, etc.)

IX. Miscellaneous (and Introduction to Follow-up Lectures)