inflearn logo
inflearn logo

Chief Choi's Excel Pivot Table Master Class

This course will teach you how to use Excel Pivot Tables to quickly and easily analyze data and create dynamic automated reports in your daily life and practice. Pivot Tables are easy and powerful. Through this course, you can begin the process of solving problems through data analysis.

(4.8) 수강평 114개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

Excel
Excel
MS-Office
MS-Office
Excel
Excel
MS-Office
MS-Office

새소식

11 개

  • hicrhodus님의 프로필 이미지

    484918405_9403238436388700_3950469291039060205_n.jpg.webp

    Hello, this is Choi Jae-wan, CEO of Hikrodos.

    We are launching our first internship program in 2025 to recruit people who are interested in data analytics, visualization, and automation and want to gain real, hands-on experience.

    Company Information

    Our company name is 'HicRhodus' and our main business is as follows.

    1. Corporate Training: Excel, Power BI, Generative AI

    2. Content Creation: Book Publishing, BI/DT Training Videos

    3. BI/DT Consulting/Development: Power BI dashboard, project/enterprise operation system or app development

    Scope of work

    This internship is for a BI/DT consulting/development position and will primarily be responsible for the following tasks:

    1. BI/DT Consulting

    2. Assisting with Power BI dashboard development tasks

    3. No-code app development

    4. Corporate lecture support and assistance

    Required skills

    1. Required skills: At least one of Power BI, Power Apps, or App Sheet

    2. Preferred skills: Data analysis languages and tools such as SQL, GA, Python, R, Tableau, etc.

    Recruitment guidelines

    1. Recruitment period: March 17 (Mon) ~ March 30 (Sun) (may close early if vacancies are filled)

    2. Number of recruits: 1 person

    3. Duration of employment: 4 months (April 1 - July 31, negotiable)

    4. Working arrangements: in-person, remote, or hybrid (negotiable)

    5. Working hours: Negotiated based on the applicant's circumstances

    6. Workplace: Hikrodos Namyangju Office (20 Dasan Circulation Road, Namyangju-si, Gyeonggi-do, Dasan Hyundai Premier Campus)
      (If you work face-to-face)

    How to apply

    1. Submit by email: hicrhodus@hicrhodus.com

    2. Documents to be submitted: One free-form resume and a self-introduction letter


    ※ This internship program is not a simple office assistance or abstract assignment program, but a practical program where you will participate in the entire process from data analysis planning to design, development, and visualization to solve problems for actual clients in various domains.

    ※ As a basic rule, employment contracts are prepared in compliance with the Labor Standards Act prior to employment/hiring.

    * Details have been omitted as this is for SNS announcement purposes.
    You can check the full job posting at the link below.

    https://hicrhodus.liveklass.com/boards/19791/posts/305665/view

    * If you have any questions, please send us an email and we will respond as quickly as possible.

    * Salary conditions will be negotiated based on the type of work, and the type of work will be decided through negotiation based on a hybrid of telecommuting and face-to-face work.

    We ask for your interest and participation.
    thank you

    0
  • hicrhodus님의 프로필 이미지

    수정됨

    image

    Today, with excitement and anticipation, we are announcing the launch of a new data learning platform service.

    Rhodus Analytics Rhodus Analytics

    Rhodes Analytics is a professional learning platform specializing in Excel, spreadsheets, and BI that aims to make data easy for anyone to use through systematic and professional education.

    https://www.rhodusanalytics.com/

    Discover professional online classes for any practitioner looking to leverage data more powerfully in their work.

    1) Excel & Spreadsheet
    2) Data Engineering Data Engineering
    3) Business Intelligence

     

    In practice, a lot of knowledge and practice are required to perform various tasks from data extraction to processing, editing, and visualization. In order to develop such continuous and diverse abilities, professional learning with a systematic structure is required. Rhodes Analytics will create this in the future.

    We are currently running various events to celebrate our opening, including discounts on paid lectures.

    We ask for your continued interest.

    thank you

    January 15, 2024

    Dream from Choi Jae-wan, CEO of Hikrodos

     

    image

    image

    image

    0
  • hicrhodus님의 프로필 이미지

    image

    hello.

    My name is Choi Jae-wan (Team Leader), and I provide lectures, consulting, and content creation on Excel and work productivity.

    I had a vague idea of wanting to help people who don't know Excel or have difficulty learning it, and then I met sign language interpreter Jae-seon Yoon, and after much discussion and planning, I ended up producing a 'Barrier-Free Excel Lecture.'

     

    Now that I'm taking my first steps, I need advice and help from many people.

    1) Video

    I put a lot of thought into making a video that would be good for farmers, but since I am an amateur, I think there are many areas where I am lacking. If you can give me advice on video layout, etc., I will study hard and practice to reflect it in my next production.

    2) Follow-up production

    Currently, we have prepared several pilot videos and are planning to open them sequentially. I am worried about how to continue after that. I am worried about whether to prepare them as a regular course or to continue them on platforms such as YouTube. Regardless of the direction, I think I will have to prepare the production cost through the process of support, investment, and funding, but I am worried about this because I lack experience. If you have any ideas, opinions, or suggestions about this, please contact me at any time.

     

    In particular, I would really appreciate it if farmers who actually watch this video could give me feedback.

    If you would like to give your opinion, you can leave a comment or message on YouTube or SNS where you saw this article, or contact me by email ( jaewan.choi@hicrhodus.com ).

     

    I don't think you can do everything with Excel, but I think you can get started with a lot of things with Excel.

    I hope this content gives you the courage and motivation to get started.

    I would also like to take this opportunity to express my deepest gratitude to Smile Sign Language Interpreter Jae-seon Yoon, who willingly joined us in writing this article.

     

    thank you

    0
  • hicrhodus님의 프로필 이미지

    Hello. This is Team Leader Choi.

    An 'Appendix' lesson has been added to the Pivot Table Master Class.
    We have added various lectures for utilizing the 7 pivot tables as shown below, so we hope that it will be helpful for your studies and work.
    (The appendix lectures can also be viewed on YouTube. Click on each title to link.)

    1. Change label names at once

    2. Creating a Frequency Chart and Histogram with PivotTables

    3. Creating multiple subtotals in a pivot table

    4. Setting a filter on pivot table values

    5. Sorting by Pivot Table Typing

    6. Analyze increase and decrease with pivot table (increase and decrease rate)

    7. Show blank labels

    Excel & Power BI professional training service Hikrodos is coming soon.

    0
  • hicrhodus님의 프로필 이미지

    Hikrodos Business Excel Club: Harmonious Excel

    Hello. This is Team Leader Choi.
    It's already the second quarter of 2023!

    We are excited to announce the launch of a new format of offline Excel classes that combine lectures and networking.
    We prepared this in the hope that it would be an opportunity for us to study and grow together.

    Application - Hikrodos Business Excel Club: Harmonious Excel - Eventus ( event-us.kr )

    image

    0
  • hicrhodus님의 프로필 이미지

    E-X, Startup Talzuma X Chief Choi Collaboration Event

    image

     

    Chief Choi's Practical Excel with Pivot Table
    We are holding a free giveaway event to celebrate the publication of the second edition!

    1. Listen to the podcast

    2. Enter the open chat room (password is 0514)

    3. If you fill out the application form (Google Form)

    Chief Choi's Practical Excel with Pivot Table Volume 5
    5 free coupons for the Pivot Table Master Class from the Chief Choi
    We will send it through a lottery!
    ※ Event period: Until February 28, 2023
    ※ All prizes will be sent out in bulk through a drawing in early March

    We support your wonderful pivot!

    Detailed information about the event can be found here.
    https://www.instagram.com/p/CpJhIZdpJOz/?igshid=YmMyMTA2M2Y=

     

    0
  • hicrhodus님의 프로필 이미지

    Hello. This is Team Leader Choi (Choi Jae-wan).

    Books for Excel Data Analysis for Practitioners
    'It's done! Chief Choi's Practical Excel with Pivot Table' has been published!

    Starting with essential Excel data preprocessing techniques
    Learn how to analyze data using pivot tables through hands-on practice.
    This is an Excel book for practitioners that covers everything from how to create Excel reports and dashboards.

    Based on my experience using Excel in the field for about ten years
    It faithfully contains the contents of Excel pivot tables that can be used powerfully in real work.
    It is structured so that you can practice by following along, and the practice content is also provided through the author's YouTube channel, NepTV .

    Thank you for your interest.

    thank you

     

    《It's possible! Chief Choi's practical Excel with pivot table》 ✅ YES24: https://vo.la/Nm0ES ✅ Aladdin: https://vo.la/j1Zm7 ✅ Kyobo Bookstore: https://vo.la/TEaTQ 🛒Download the practice file: https://bit.ly/3M9kouI ✨ Excel collective intelligence open chat room [Excel 119] https://open.kakao.com/o/gJYBQQjd

     

    0
  • hicrhodus님의 프로필 이미지

    Hello. This is Team Leader Choi.
    Summer is really starting. It looks like it's going to be a tough summer with a lot of rain, so I hope you stay healthy!

    We've created a KakaoTalk open chat room where you can ask and answer questions about Excel and share information.
    It was opened without any special rules or passwords.

    I created this channel to provide help when you need Excel urgently or find Excel difficult, so please use it conveniently.

    thank you

    Excel Open Chat Room [Excel 119]
    https://open.kakao.com/o/gJYBQQjd

    1

강의상세.할인문구

$30.80

28%

$42.90