강의

멘토링

커뮤니티

NEW
Productivity

/

Office

Excel and Database (Introduction) [Subtitles included]

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

28 learners are taking this course

Level Beginner

Course period Unlimited

  • excelanddatabase
Excel
Excel
VBA
VBA
Excel Power Pivot
Excel Power Pivot
Excel
Excel
VBA
VBA
Excel Power Pivot
Excel Power Pivot
Thumbnail

What you will gain after the course

  • Utilizing Power Pivot (Excel Data Model), a core feature of Excel.

  • Expanding data processing capabilities by leveraging Excel and database functions

This course provides a comprehensive introduction to Excel's database-related features and applications, including the following topics. [Subtitles included for all lectures]

I. Introduction to Excel

  • Introduction to major versions of Excel and database-related content (VBA-ADO, Power Pivot, etc.)


II. Excel Tips for Databases

  • Explanation of key tips for data processing, such as data cleansing

III. Excel Table Features

  • Explanation of key Table features closely related to database functions

IV. Utilizing MS Query

  • General introduction to MS Query

V. Excel vs Access Comparison (and Access 2010)

  • Comparison of Excel and Access (Introduction of key features in Access 2010 - ADP, Pivot Forms)

VI. Excel Data Model (Power Pivot Data Model)

  • Introduction to modeling and general overview of the Excel Data Model

VII. VBA for Database

  • Introduction and demonstration of SQL Server integration using ADO in VBA

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

  • Overall summary of Excel BI content


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

  • Excel Data Security and Information on Upcoming Courses

Recommended for
these people

Who is this course right for?

  • Excel users who repeatedly process large amounts of data through Excel manipulation.

  • Excel users who have used the software for a long time but still spend significant time and effort on manual tasks every time.

Need to know before starting?

  • Must have a basic understanding of Excel (1+ years of experience)

  • Power Pivot for Excel (Excel COM Add-in) must be installable.

Hello
This is

▣ Worked at KB Kookmin Bank - Corporate Loans sector - Data analysis/processing for headquarters departments and intranet development - Development of various solutions using MS Office - Extensive experience using Excel, etc.

▣ Worked at KB Kookmin Bank

— Corporate Loans / Corporate Credit Sector

ㅡ Data analysis processing and intranet development for headquarters departments

— Development of various solutions using MS Office

ㅇ Approximately 30 years of experience using Excel and other tools

▣ OfficeTutor MVP

ㅡ Areas of Activity: Excel, Access, Word, PowerPoint, etc.

▣ Other Qualifications and Certifications

— Korea Data Agency: SQLD, ADsP

ㅡ Finance-related: Derivatives, Funds, Insurance, Foreign Exchange, etc.

ㅡ Others: E-Commerce Administrator, current OJCP (Oracle)

— Completed database training courses

ㅇ DBian: SQL Basic and Advanced Courses, Practical Data Modeling Course

ㅇ KG ITBank: Completed Oracle Certified Training Course

Curriculum

All

37 lectures ∙ (6hr 1min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

Free

Similar courses

Explore other courses in the same field!