關於 excel sheet name ，我們在網路上蒐集到這些相關的討論、資訊與評價

承上貼文 #無營養 #純發洩
點解我要問人啲好似好基本嘅concept?
其實就係咁嘅
之前請咗個巴基斯坦佬寫個交易記錄系統

每日要Upload 1k entry以上嘅excel
唔係好demanding啫

仆佢個街，佢同我每行query一次database 去verify，每行寫一次入database，成個file計返用成27分鐘先upload到，hi auntie我就算個server擺喺火星我用光速都行到兩轉返來啦。

而且無用transaction/atomic，中途time-out ，寫咗部份entries就中出即飛，入咗幾多都唔知。

最撚神奇係佢連個excel sheet name都係hardcode嘅，只要改個sheet name就會error 898，而read個excel佢居然唔係用個file嘅header，係用1,2,3,4,5,6 hard code曬啲column。

佢仲要話咁樣完全唔撚function嘅program 叫MVP，仲要寸寸貢，問佢兩句連個github repository都delete埋。

成件事用咗成皮港紙，三星期時間，揼舊屎俾我。

最後我用兩星期自學django揼咗個出來。

（自此我好有陰影，好驚再請到件垃圾返來。）

#nulo_career
Bi, Ba cái gương và thủy tinh cầu

Bi là gì?
dì mới thấy 1 job ở SG khá hay đang tuyển dành cho fresh nên dì muốn share cho các cháu thích làm việc với data, dân ngành nào cũng đâm sang được miễn thích data, tools và luôn thích tự học.
Bi là Business Intelligence
Ba là Business Analytics

2 bạn này là 2 môn phái giúp cho doanh nghiệp đưa ra 1 quyết định trọng đại (Decision making)
BI BA khác nhau chứ

BI là tạo ra một tấm gương từ dữ liệu từ 30 giây cho đến rất nhiều năm trước để doanh nghiệp nhìn vô xem lại cái nết ăn ở, tình hình kinh doanh vừa qua của mình để cải thiện sửa đổi

BA là tạo ra quả cầu thủy tinh cho thấy tương lai- từ data của thị trường và doanh nghiệp, để mí bác lãnh đạo hiểu và dự đoán những thứ sắp xảy ra vd như dự định market entrance- thâm nhập và làm ăn ở 1 thị trường mới chẳng hạn,
Người Bi và Ba kiểu gì cũng phải làm lấn sân nhau 1 xíu để có kiến thức kỹ năng toàn diện hơn

tạm vậy đã, cho các cháu biết và phân biệt 2 job tưởng là 1 mà là 2 này, khi nào rảnh dì viết thêm, các cháu có thể tự tìm hiểu thêm nhe

Bên dưới là job đang tuyển cho fresh, JD điển hình cho BI

Intrepid Vietnam is looking for
Junior BI Analyst (8-10 mil experience based)

Deadline for application: 26/2/2020

The role:
We are looking for a generalist, who is eager to learn and has an eye for detail. As a Junior BI Analyst, you will be using different tools to
- Develop and automate internal & external reports
Build dashboards to visualize quantitative information
- Maintain database and other documents
- Fulfill ad-hoc requests

Who we look for – the ideal profile:
- Intermediate English and above
- From 6 months of experience in Ecommerce or in a data-driven position of other industries.
- Advanced Excel and Google sheet is a must.
- Strong logical thinking and problem-solving skills is a must.
- Good communication & ability to probe for users’ data needs.
- Ability to operate independently as well as work in a team.
- Good fit with our company culture: collaborative, open, humble, driven, analytical, structured,
professional, fun, passionate, entrepreneurial with a hands-on - “Can do” mindset

Good to have
- Basic understanding of data modeling is preferred.
- Some experience with languages for ETL such as SQL, Python is a plus.
- Some experience with data visualization tools such as Data Studio, Power BI, Tableau, etc. is a
plus.

What we offer
- Competitive compensation (with 13th month annual bonus)
Opportunity to be a key part of a fast-growing leading Ecommerce enabler in SEA, offering
exciting career opportunities
- Ample opportunity for personal and professional development, both on the job and through
regular training (Ecommerce & (Digital) Marketing topics, soft skills and leadership training).
- English speaking international environment, open, collaborative and fun culture, and a nice & centrally located office (WeWork D4)
- Additional 2 annual leave (besides regular annual leave for all Vietnamese holidays recognized by Vietnamese labor law and 12 days personal annual leave).

About Intrepid Vietnam
Intrepid is a fast-growing and industry-leading ecommerce enabler, making sellers and brands successful in Ecommerce on all marketplace platforms across South East Asia through a combination of software solutions and value-added services across store management, online marketing, customer service (e.g. chat), data & intelligence, and fulfilment & logistics. The company operates in Indonesia, Philippines,Singapore, Vietnam, Thailand and soon Malaysia, was built by ex-Lazada founders and is run by a young, enthusiastic and energetic team, looking to help brands and sellers seize the full potential of the ecommerce opportunity in South East Asia

Application:
Email title [Job name] [YourName] [+ Badinulomember-để được ưu tiên xíu xíu <3 ]

contact:
[email protected]

แสดงการใช้ indirect ในการอ้างถึงเซลล์ที่อยู่ใน sheet ต่างๆ เพื่อนำมาแสดงใน sheet ที่ต้องการ

============
ดาวน์โหลดไฟล์ประกอบตัวอย่างได้ที่ http://goo.gl/YT23xS

============
playlist สอนการใช้งานฟังก์ชัน INDIRECT()
https://www.youtube.com/playlist?list=PLoTScYm9O0GG1Utc4ThLPA2OaefoWMNT4

============
playlist สอนเทคนิคการสร้างกราฟ แผนภูมิแบบต่าง ๆ ด้วย Excel
https://www.youtube.com/playlist?list=PLoTScYm9O0GExxZ3nlVmleu0wvlhGfs3j

============
playlist สอน Excel
https://www.youtube.com/playlist?list=PLoTScYm9O0GEMj5LpqxaxWWnanc55Epnt

============
เชิญสมัครเป็นสมาชิกของช่องนี้ได้ที่
https://www.youtube.com/subscription_center?add_user=prasertcbs