👀LOOKING FOR AN E-commerce Operations Specialist 👀
.
🔍「電商營運專員」職務說明
1. 負責商品頁面資料建檔與後台活動設定，並維持電商網站活動的正常運作。
2. 訂單管理及追蹤，執行退換貨作業與系統操作。確保電商發貨配送、物流流程管理與金流對帳處理完成，提供顧客良好的購物體驗。
3. 業績報表製作，電子商務相關資料分析。
4. 負責電商平台線上客服處理。
5. 負責電商相關行政事務及其他主管交辦事項。
.
🔍 徵求條件：
一年以上電子商務相關經驗
熟悉Excel，會操作VLOOKUP、樞紐分析
做事細心、有效率，喜歡團隊合作
喜歡時尚產業者加分
.
📧歡迎將履歷/作品集，寄至 hr@sktextile.com.tw
-
🔍Job Description
1. As an e-commerce specialist, you will organize, develop, and execute website marketing plans and take charge of daily online platform operations. Responsible for all online product content organization and site merchandising activities.
2. Monitoring the day-to-day activity on the site and its overall performance. Track all e-commerce marketing efforts, analyze data (including accounting data), and use your findings to improve your strategies.
3. Monitor changes in product sales by using web analytics and Excel spreadsheets (vlookups, etc) to stay organized.
4. In charge of online customer service.
5. Work with sales, marketing, operations, and other relevant departments.
.
🔍 Requirements
1. Minimum of 1+ year experience in a fast-paced, e-commerce business.
2. Hands-on experience in managing and maintaining e-commerce websites/portals.
3. Proficiency in Microsoft Office: Word, Excel, Outlook.
4. Analytical and multitasking skills.
.
📧Please send your CV to hr@sktextile.com.tw
vlookup 樞紐分析 在 [算表] 樞紐分析表新增計算項目- 看板Office 的推薦與評價
軟體:excel
版本:2016
如圖
由出勤統計工作表，插入樞紐分析表(如工作表1)，計算出每個員工的加班時數
但每個員工的加班費時薪不同
時薪另列在別的工作表，如圖
要如何在樞紐分析表裡計算出每個員工的加班費?
謝謝:)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.138.31.125
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1537848288.A.51A.html
謝謝SO大，已靠上述方法解決。
※ 編輯: luving (220.138.31.44), 09/25/2018 15:11:01
... <看更多>