Complete mastery of Excel macros and VBA from basics to practical use
onwings
Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!
중급이상
Business Productivity, Excel, VBA
BEST
業務が100倍速くなるExcelデータ活用と分析ノウハウ
本コースは、Excelの機能を説明する教育ではなく、実際の業務現場で使用されるExcelの例を利用して、各状況ごとにどのような機能を組み合わせることで、最速かつ効率的に業務を遂行できるかを学習するプロセスです。
学習した受講者のレビュー
こんなことが学べます
システムからダウンロードしたRAWデータを100倍速く編集
データ分析レポートの作成に主に使用される関数アプリケーションの習得
ピボットテーブルを使用した高速で効率的な集計表の作成
多くのデータリストから選択した掲載結果のみを表示できる自動化分析表の作成
2つのリストを比較して、条件に合った項目を表示し、集計表を作成する
パワークエリを活用してExcelビッグデータを管理
エクセルは着実なアップデートを通じて現在、国内100大企業勤務者のうち80％以上が使用しているほど重要なプログラムとして位置づけられています。しかし、このようなExcelをうまく使うと言える会社員はどれくらいでしょうか？ Excelを使うことを知っていることも重要ですが、どのように使用するかがより重要です。他の人が2時間の作業を10分以内に終えることができれば、私はすぐにExcelをうまく使うことができる人です。
このコースは、Excelの機能を説明するトレーニングではなく、実際の業務現場で使用されるExcelの例を使用して、各状況ごとにどのような機能を組み合わせることで、最も迅速かつ効率的に業務を実行できるかを学習するプロセスです。
教育内容
練習の例
こんな方に
おすすめです
学習対象は
誰でしょう？
エクセルに関する基本的な知識がある方、エクセル実務者
前提知識、
必要でしょうか？
Excelで簡単な表作成や数式入力程度の事前知識
6,291
受講生
610
受講レビュー
155
回答
4.9
講座評価
6
講座
김경자 / 컴피플 대표, 연성대학교 겸임교수, 엑셀여신(http://blog.naver.com/onwings)
LG전자 LearningCenter에 근무하면서 IT교육과 인연을 맺어 현재는 삼성그룹, 기아그룹, 유데미, 금융감독원, 김앤장, 국가공무원인재개발원 등에서 강의하고 있습니다. IT/정보화 교육 전문회사인 컴피플 대표이며 연성대학교 겸임교수로 재직중입니다.
<저서>
- 회사에서 통하는 엑셀 데이터 활용 분석(한빛미디어, 2025)
- 회사에서 엑셀로 살아남기 (한빛미디어, 2023)
- 엑셀 실무 함수 + 수식 (한빛미디어, 2021)
- 엑셀 실무 매크로와 VBA (한빛미디어, 2020)
- 엑셀 실무 데이터 활용+분석 (한빛미디어, 2019)
- 엑셀 2016 기본+실무완성 (북스홀릭, 2018)
- 실무통 엑셀 함수 실무 강의 (한빛미디어, 2017)
- 회사 실무에 힘을 주는 엑셀 2016 매크로와 VBA (정보문화사, 2016)
- 회사에서 바로 통하는 엑셀 데이터 활용+분석 (한빛미디어, 2016)
- 엑셀 2013 기본 실무완성 (북스홀릭, 2014)
- 키노트 & 넘버스 무작정 따라하기 (길벗, 2014)
- 엑셀 2010 매크로와 VBA (영진닷컴, 2012)
- 엑셀 2010 기본 실무완성 (북스홀릭, 2011)
- 엑셀 2007 매크로 & VBA 기본+실무 (성안당, 2009)
- 엑셀 2007 기본 + 실무 (성안당, 2007)
- 실무에 강한 엑셀 매크로와 VBA (사이버출판사, 2005)
カリキュラム
全体
42件 ∙ (5時間 11分)
講座資料（こうぎしりょう）:
授業資料
講座掲載日:
最終更新日:
受講レビュー
全体
294件
4.9
294件の受講レビュー
goo3book0144受講レビュー 5
∙
平均評価 5.0
5
100% 受講後に作成If you follow along one by one, it will be a great help. My original Excel skills were not that great... but my Excel skills have definitely improved. I have gained a lot. I plan to listen to it again to learn it properly to reinforce it a bit more. I recommend it.
- onwings知識共有者
I'm glad it was helpful~ haha Thank you for your hard work.
- lypuppy3726
受講レビュー 16
∙
平均評価 3.9
5
100% 受講後に作成Regardless of your job, it explains only the essentials that you need to know in an easy way! I highly recommend it! I like this lecture because it teaches you the 'know-how' rather than the 'hard work' of data management. Please take an Excel lecture from a professional instructor like this! A person who was famous for being good at Excel at work became famous as an Excel YouTuber and created a lecture to sell it, but I was so disappointed when I took that lecture. It was a lecture that tried to teach you too much at once. It was as if he was saying, "I know how to do all this, I know all these functions." He even teaches you the functions that are only necessary for specific jobs.. I recommend this to those who don't want to know all the functions and features of Excel.
- dldudghk104964
受講レビュー 1
∙
平均評価 5.0
5
100% 受講後に作成As an intern and a job seeker, I need to get a computer skills certificate. I remember a famous lecture that I attended to study computer skills. This Excel lecture is not an Excel lecture for theory, but a lecture for practical practice based on practical practice. I was amazed the whole time I was watching it. I think I will come back to listen to it again even after I get a job. A famous lecture that will give wings to your work.
- kmookie
受講レビュー 1
∙
平均評価 5.0
5
100% 受講後に作成I listened to up to lecture 13. When I was frustrated with Excel, I searched the green window and YouTube to get by. I also bought the Pa**Cam*s lecture, but for some reason, the explanation didn't go into my head. But this lecture is completely focused on practical work, so it goes right into my head. It's so great that I can apply it right after listening to the lecture!!
- onwings知識共有者
Thank you for your good evaluation~^^ I am glad that the content related to my work is helpful to me. Thank you~^^
- jun17
受講レビュー 1
∙
平均評価 5.0
5
31% 受講後に作成It's good for learning and practicing because the core concepts are explained easily and well! I forgot many Excel features I used while doing marketing work for a year because I didn't use them. Feeling like I needed to reorganize, after taking the 3-hour core lecture, I'm now taking the data management lecture that makes things 100 times faster. Afterwards, I plan to try learning the 8 practical examples lectures or visualization expressions while reviewing at least twice! Thank you:)
￥5,192
onwingsの他の講座
知識共有者の他の講座を見てみましょう！
似ている講座
同じ分野の他の講座を見てみましょう！
![[Work Automation Using Free MS RPA] Power Automate Desktop - Excel Automation강의 썸네일](https://cdn.inflearn.com/public/courses/330201/cover/8adc841c-39de-4770-98d3-2439ed8881a3/330201-eng.png?f=avif&w=420)
![[First in Korea] ChatGPT × Word Practical Application: Document Automation Made Easy for Everyone강의 썸네일](https://cdn.inflearn.com/public/files/courses/338227/cover/01k0rxg0k0xk9q6vefywa4qnbn?f=avif&w=420)
![[Pass ITQ Excel A in One Go] in 3 days강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
