Excel Modeling Projects
Looking for freelance Excel Modeling jobs and project work? PeoplePerHour has you covered.
featuredopportunity
Scrape supplier Excel stock levels & sync with my stock sheet
Project Requirements: Data Upload and Integration: Allow uploading of our latest Shopify stock export file (XLS) and the stock data files from various suppliers. I also need to update a second file in a different format for Google and mark each product in a particular column with either the text 'in_stock' (for items in stock of with a known ETA, or 'backorder' where the item is out of stock and the ETA is not known.) Stock Level Analysis: Process the uploaded files to check and scrape stock numbers or estimated time of arrival (ETA) for out-of-stock items. Stock Update Mechanism: Update a column in our Shopify export file with predefined status messages based on availability: - In Stock: 7-14 day delivery (for suppliers' items that are in stock) - Stock Due Imminently: Delivery within 2-4 weeks (for suppliers' items that are due to arrive back in stock soon) - Stock Due {Early/Mid/Late} {Month}: Pre-order today to secure yours (to encourage pre-orders for items due back in stock at a known future date - the data in {} here should reflect what the stock sheets are advising) - Out of Stock: Please get in touch for a pre-order discount (to offer incentives for pre-orders when items are out of stock) The updated Excel file should be ready to import back into Shopify to reflect the changes in stock levels. End Goal: To streamline our stock management process, making it more efficient and less prone to errors due to software instability. Requirements: A robust app that doesn't crash, works on Mac or online if possible (or Windows if it can't be done another way), graceful error handling that picks up any expected syntax changes in the supplier sheets, and shows a pop-up at the end telling me how many products have been updated. Also good documentation to help us use the app. I have attached a screenshot of my current app, which needs replacing.
Game Descriptions Copywriting / Text re-writing
Seeking Talented Writer for Engaging Slot Game Reviews with SEO Expertise Are you passionate about casino games, particularly slots, and possess a talent for captivating writing? We're on the lookout for a skilled writer to create comprehensive reviews of slot games. Our ideal candidate is not only adept in SEO practices but also enthusiastic about crafting content that resonates with our audience. What You'll Be Doing: Writing multiple texts, each 1000 words in length, that provide insightful reviews of various slot games. Crafting a compelling 150-character meta description for each review to capture the essence and intrigue of the content. Integrating specific keywords seamlessly into your texts, maintaining their natural flow and readability. Keywords are provided for each assignment, and their usage is crucial for our SEO strategy. This is More Than a Gig – It’s a Long-term Opportunity: This role offers regular assignments on a weekly basis, continuing a tradition of excellence that began back in 2013 with our current freelancer. We're looking for someone who's interested in a stable, long-term collaboration to grow with our platform and contribute to our community's love for slot games. Your Content Must: Be 100% original, passing Copyscape verification with flying colors. Adhere to SEO best practices, ensuring the content is not only optimized for search engines but also engaging for readers. Follow Yoast SEO guidelines for readability—avoiding an overuse of passive voice (limiting it to less than 25% of sentences) and ensuring no more than 25% of sentences exceed 25 words. About You: You have a keen understanding of SEO and how to write content that ranks well. You’re creative, detail-oriented, and have a genuine interest in slot games and casino culture. You're committed to producing original, high-quality content that provides value to our readers. How to Apply: If you’re excited about the opportunity to combine your love for writing and slot games, and meet the above criteria, we’d love to hear from you! Please send your resume, a short cover letter explaining why you’re the perfect fit for this role, and writing samples that showcase your ability to write engaging and SEO-friendly content. Questions? We’re here to answer them! Feel free to reach out if you have any questions or need further clarification about the role.
a month ago29 proposalsRemoteSeo and improve website visability and google ranking
About Brandum: Brandum is at the forefront of the custom apparel industry, offering unparalleled quality in t-shirt, hoodie, and garment printing, along with supplying cutting-edge Direct to Film (DTF) transfers. Our commitment to excellence and innovation has cemented our status as a premier choice for customized apparel solutions. As we continue to grow, our focus remains on quality, creativity, and customer satisfaction. Discover more about our journey at www.brandum.com. Job Summary: Brandum is in search of an experienced and passionate SEO Specialist to elevate our online visibility and search engine ranking. The ideal candidate will possess a robust understanding of SEO tactics, including comprehensive backlinking strategies with relevant websites and crafting SEO-driven content. This role demands a proactive approach to optimizing our website, with a strong emphasis on analytics, creativity, and strategic planning to boost organic search results and enhance our brand's digital footprint. Responsibilities: Conduct thorough keyword research and competitive analysis to uncover SEO opportunities. Implement advanced on-page SEO techniques, focusing on optimizing content, titles, meta descriptions, and images. Develop and execute a strategic off-page SEO plan, with a strong emphasis on building high-quality backlinks from websites relevant to our industry. Coordinate with content creators to suggest topics for blogs and articles that align with SEO goals and audience interests. Utilize analytical tools like Google Analytics and SEMrush to track website performance, identify trends, and make informed decisions to refine SEO strategies. Ensure SEO best practices are integrated into all aspects of our website, working closely with content and web development teams. Keep abreast of SEO trends and algorithm updates, applying new tactics to maintain and improve our website’s search engine ranking. Generate regular reports detailing SEO performance, including rankings, traffic metrics, and conversion rates. Qualifications: Demonstrable experience as an SEO Specialist, with a strong portfolio showcasing successful SEO projects and backlinking efforts. In-depth knowledge of search engine algorithms, ranking methods, and SEO best practices. Proficiency in SEO and web analytics tools (Google Analytics, SEMrush, Ahrefs). Basic understanding of HTML/CSS, with experience in website administration. Exceptional analytical, organizational, and communication skills. Previous experience in the apparel or e-commerce sector is a plus. Candidates must provide a list of previous websites they have optimized for SEO and describe their process for achieving results to be considered for this position. How to Apply: To apply for this exciting opportunity, please submit your resume, a cover letter outlining your experience and fit for the role, a list of previous websites you have optimized for SEO (including outcomes), and a brief description of your SEO process.
20 days ago34 proposalsRemotepre-funded
Remote TikTok Influencer Specialist - Lux Beauty Industry
Location: Remote (global or own local online market) Department: Influencer Marketing https://www.exmoorcaviar.com/copy-of-our-caviar Overview We are on the hunt for Remote TikTok Influencer Marketing Specialists with a passion for beauty, social media marketing, and the digital landscape. This role is ideal for someone who excels at creating engaging content, building authentic relationships with influencers, and staying ahead of digital trends. As part of our team, you will leverage the power of TikTok to promote our beauty brand and products, developing and executing influencer marketing campaigns that drive brand awareness, engagement, and sales. Key Responsibilities Strategy Development: Work in tandem with our marketing team to craft influencer marketing strategies that align with our brand’s goals, focusing on TikTok. This includes identifying target audiences, key messaging, and setting clear campaign KPIs. Influencer Outreach: Identify and engage with TikTok influencers who resonate with our brand values and target demographic. Initiate partnerships and collaborations that align with our campaign objectives. Campaign Management: Oversee all aspects of the influencer campaigns, from negotiating terms to managing timelines and deliverables. Ensure compliance with brand guidelines and FTC regulations. Content Creation: Collaborate with influencers to generate content that captivates their audience and highlights our products. Offer creative direction and feedback to maximize content impact. Relationship Building: Foster and maintain robust relationships with TikTok influencers, ensuring smooth communication throughout campaigns. Aim for long-term collaborations and continuous partnership opportunities. Performance Tracking: Closely monitor campaign outcomes, analysing key metrics like reach, engagement, and conversions. Share insights and recommendations for campaign optimization. Trend Monitoring: Keep abreast of the latest TikTok trends, challenges, and features to integrate into our brand strategy. Explore innovative influencer partnership and content creation opportunities. Requirements Experience in influencer marketing, particularly on TikTok, with a strong understanding of the platform, its audience, and content trends. Exceptional communication skills, capable of fostering relationships with influencers and working collaboratively with our marketing team. Creativity and a keen eye for storytelling, able to conceptualize engaging content that aligns with our brand and resonates with TikTok users. Organizational prowess, able to manage multiple campaigns efficiently and meet deadlines. Analytical skills to evaluate campaign performance and extract actionable insights for future strategies. Self-driven and adaptable, comfortable working remotely and navigating a dynamic, fast-paced industry. .... The product to be marketed is ( https://www.exmoorcaviar.com/copy-of-our-caviar, https://www.amazon.co.uk/Mother-Pearl-Caviar-Serving-Plate/dp/B00E3S3SCC/ref=sr_1_3?crid=34VSSJQ1X42OR&dib=eyJ2IjoiMSJ9.-uPYBplRsQhsrGUtPnLQH7N_iveo-HLy72gsUIjuZayVVv-kOBwCgw6zB7a4FcPIH0wg5NJ_ql-HxGm2CLwdAp3Q50FHQyjSYTYGYSEfwQ4jBWE2YNHEBvkoHpj1EVgl4-xgaGxOwIX8fYuvojFZcqnkGQzQypufvahjWlrJi287LgHjUm_HwnGGvgY8A2fyvYMtZnjFuEWXFPqiBw5Pnc5UBEadBYUiK-ZTF01DD6Y3dvUa39ndhO72Afq9VZ-qaKG06VEA0o2LUn7YrbRqpm6ZeXUGl6qU8K_vv54_kJU.uhAcpqmnV8Serr9t-tlcR44gpZuUKw1ARVMjn2PQyXE&dib_tag=se&keywords=exmoor+caviar+pearls&qid=1712674286&rnid=1642204031&s=beauty&sprefix=exmoocaviar+pearls%2Caps%2C338&sr=1-3) Caviar Pearls Pure 'Caviar Oil' health supplement The exclusive 'Caviar Pearls' pure caviar oil supplement, which represent the epitome of dietary innovation and embody the luxurious essence of wellness. Caviar Oil has recently (2023) undergone several comprehensive trials in South Korea, conducted by the leading Korean College of Medicine, and has been scientifically proven to have significant skin benefits and effectiveness. Caviar Pearls are a revolutionary breakthrough in the health supplement market, as they contain Pure Caviar Oil extracted from the placenta of sustainably farmed sturgeon, and combined with a meticulous extraction process to ensure the highest purity and quality, positioning our pearls at the forefront of luxury wellness. Each Caviar Pearl (equivalent to 5g's of actual caviar) delivers a rich, buttery essence akin to high-quality caviar, without any of the fishy odour aftertaste found in many marine supplements, making them a pleasure to consume and setting a new benchmark for dietary supplements. The nutritional profile of each 300mg pearl is robust, offering Oleic and Linoleic Acid to promote a heart-healthy Mediterranean diet (clinically proven by Southampton University in 2022) alongside a full spectrum of essential omega fatty acids.
22 days ago11 proposalsRemote