강의

멘토링

커뮤니티

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

22 learners are taking this course

Level Beginner

Course period Unlimited

  • excelanddatabase
Excel
Excel
Excel-Power-Pivot
Excel-Power-Pivot
VBA
VBA
Excel Power Pivot
Excel Power Pivot
Excel
Excel
Excel-Power-Pivot
Excel-Power-Pivot
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

▣ KB 국민은행 근무

ㅡ 기업여신 분야

ㅡ 본부부서 데이터분석 처리 및 인트라넷 개발

ㅡ MS 오피스를 이용한 각종 솔루션 개발

ㅇ 엑셀 등 사용 경력 약 30 년

▣ 오피스튜터 MVP

ㅡ 활동분야 : 엑셀 , 액세스 , 워드 , 파워포인트 등

▣ 기타 보유 자격 등

ㅡ 한국데이터산업진흥원 : SQLD, ADsP

ㅡ 금융관련 : 파상상품 , 펀드 , 보험 , 외환 등

ㅡ 기타 : 전자상거래관리사 , 현 OJCP, Oracle)

ㅡ 데이터베이스 교육과정 수료

ㅇ 디비안 : SQL 기본 및 고급과정 , 실무 데이터모델링과정

ㅇ KG 아이티뱅크 : 오라클 공인 교육과정 수료

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!