Fun excel tricksงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
** Only freelancers in Pattaya, Thailand ** ** รับสมัครแค่จากคนอยู่พัทยา ** We want to do something for a friend's birthday in Pattaya. However, none of us are in Pattaya, so we need some help. The job will involve wearing a costume, going to see our friend (around Pattaya Nua/Sukhumvit), and saying "Happy Birthday" plus a couple other silly things (inside jokes). พวกเราอยากทำบางสิ่งสำหรับวันเกิดของเพื่อนที่อยู่พัทยานะครับ แต่จากเราไม่มีใครที่พัทยาแล้วก็ต้องการคนช่วย งานนี้เป็นแต่งตัวแบบสนุกและไปหาเพื่อนและบอก "happy birthday" กับสองสามสิ่งอีกครับ
** Only freelancers in Pattaya, Thailand ** ** รับสมัครแค่จากคนอยู่พัทยา ** We want to do something for a friend's birthday in Pattaya. However, none of us are in Pattaya, so we need some help. The job will involve wearing a costume, going to see our friend (around Pattaya Nua/Sukhumvit), and saying "Happy Birthday" plus a couple other silly things (inside jokes). พวกเราอยากทำบางสิ่งสำหรับวันเกิดของเพื่อนที่อยู่พัทยานะครับ แต่จากเราไม่มีใครที่พัทยาแล้วก็ต้องการคนช่วย งานนี้เป็นแต่งตัวแบบสนุกและไปหาเพื่อนและบอก "happy birthday" กับสองสามสิ่งอีกครับ
** Only freelancers in Pattaya, Thailand ** ** รับสมัครแค่จากคนอยู่พัทยา ** We want to do something for a friend's birthday in Pattaya. However, none of us are in Pattaya, so we need some help. The job will involve wearing a costume, going to see our friend (around Pattaya Nua/Sukhumvit), and saying "Happy Birthday" plus a couple other silly things (inside jokes). พวกเราอยากทำบางสิ่งสำหรับวันเกิดของเพื่อนที่อยู่พัทยานะครับ แต่จากเราไม่มีใครที่พัทยาแล้วก็ต้องการคนช่วย งานนี้เป็นแต่งตัวแบบสนุกและไปหาเพื่อนและบอก "happy birthday" กับสองสามสิ่งอีกครับ
...globe and sun into the design. The globe could resemble the sun or be surrounded by it but are open - Lastly, the style is open-ended since we skipped that detail. As long as it's visually compelling and suits our company's ethos, we're open to suggestions. -this should be designed so it can have. a color theme, be small in a Facebook page image, be able to be embroidered on a shirt, etc. We have a fun, breeze "sunny" brand but would look at different styles including simple, professional, etc, etc. Here are some chatGPT prompts that we liked: Sunny Horizon: A minimalist design featuring a simple horizon line with a sun rising above it. The company name could be integrated into the design, perhaps as part of the horizon line or positioned below it. Sunn...
...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required Strong emotional intelligence (EQ) and interpersonal skills required Experience with workflow design required Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel: Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements: This role frequently communicates with others, must be able to exchange accurate information in these situations This role routinely uses standard office equipment such as computers, p...
I'm looking for a unique logo design that is fun and playful. Logo needs to be vector so can be used in all formats. The ideal freelancer for this project should have: - A strong portfolio showing both fun and playful, as well as professional designs - Experience in creating logos that are suitable for both online and print use - A great understanding of color and visual appeal, to ensure the logo stands out on merchandise. - Needs to be developed in Adobe Illustrator. This is the STYLE of logo we're looking for - Please note: I
I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive sprea...should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions, ...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
I'm looking for an innovative graphic designer to create a dynamic logo design with 3 distinct concepts. Here's what I need: This logo will be the face of our app and social media campaign. Must be high quality fun and high end logo. The app is a dumpster rental brokering app. dumpster owners register their dumpsters, and users request dumpsters services immediately. The logo is a high end fun caricature of a dumpster in 3d getting to its destination very fast. Delivery must include Include source file Logo transparency Printable file Include 3D mockup Vector file Include social media kit - Designing a source file that can be edited in AI (Adobe Illustrator), PSD (Photoshop), and saved as PDF. - Preparing a printable file, ensuring its scalable to various sizes ...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
I have a storyboard to turn into an Articulate Storyline module. The target audience: new employees of a company. They must follow e-learning introducing them to the fundamentals of Retail. Your mission will be to create some interactive sequences (characters who introduce themselves, an interactive timeline, etc.) and to make the Storyline module fun and pleasant to follow. I'm used to creating Storyline modules, but I don't have the time right now. I estimate the time to create this Storyline at around 3h30. My budget is limited to around 70 to 110 euros.
As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a detailed b...
We are looking to design a t-shirt with the slogan SUMMERTIME FOREVER for a children's Summer camp. We want it to be fun and whimsical but not too busy looking. If you can incorporated our logo (attached) on the front, that would be great, but it not, we will put it on the back of the t-shirt. Can you please create something with a 2 colour design. Can't wait to see what you come up with!
I am seeking an experienced developer for my upcoming Roblox gambling site designed for adults aged 18 or above. The site's ambiance should be developed with a fun and playful theme to garner user interest. Key Features: - The website would encompass various gambling games, which include Blackjack, Roulette, Case Battles, Slide, Dice, Cases, Limbo, and Mines. Ideal Skills: - Proficiency in Roblox game development - Prior experience in online gambling site creation - Ability to create an engaging and playful site design Looking forward to finding a determined and experienced freelancer to fulfil these requirements.
My main objective is to create engaging Instagram ads to drive sales for my arcade game ...to shoot and remake videos that can appeal to my target audience - adults and families. I want these ads to convey a unique selling point (USP) - 'Fun and entertainment for all ages.' I believe this message could harness the power of social media to draw customers to my arcade game zone. Ideal Skills and Experience: - Experience in creating content for social media, particularly Instagram - Capable of shooting and editing high-quality videos - Understanding of marketing and advertising strategies - Proven track record in driving sales through Instagram - Experience in targeting ads at adults and families - Ability to convey the message 'Fun and entertainment for all a...
I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your ideas an...
I'm in need of a logo design that perfectly captures the essence of summer on the beach. It should be alive with color, blending tones that evoke feelings of fun energy, peaceful relaxation, and vibrant playfulness. The design elements should be modern and minimalist, with a specific focus on the colors red and blue. Ideal Skills: - Strong understanding of color psychology - Experience in modern, minimal design - Ability to convey complex feelings through logo design If you're excited by color and adept at evoking emotion through your designs, then this project is your perfect canvas. Can't wait to see what you create!
As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. If you feel suited for this ...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
I need a video editor to create a wedding reel that captures the fun and emotional essence of the day. I am looking for someone with a lot of creativity and experience in creating captivating, short-form wedding reels. Key requirements: - Edit a 30-50 sec wedding reel - Style: Fun, Emotional - Ability to tell a story through editing - Attention to detail to capture the mood Your skills and experience in cinematic or storytelling style editing would be a great match for this project. Please share examples of your previous work in your proposal.
I am urgently seeking a professional dubbing artist capable of translating and dubbing content from English to Arabic for a children's animation. The voice-over should be educational and informative. Key requirements are: - Proficient in English to Arabic translation - Ability to perform multiple voice characters - Experience in dubbing animated content - Ability to deliver a fun and energetic voice style - Comfortable with fast-paced projects and delivering under short timelines The perfect candidate would have previous experience with dubbing projects for children's content, particularly animated ones. The talent should be able to interpret script pages and perform them with multiple voice tones to perform multiple characters and be suitable for children. A quick turn...
Winner picked within 24 hours I'm in need of a fun mascot logo for my meme crypto project. The logo should be modern but still carry a sense of playfulness. Please read all! We are looking for a logo for a cryptocurrency project about the law of attraction. The logo has to be a caricature of Albert Einstein. The logo has to have a blue theme. We are launching on Base Chain, which has a blue theme, and we want to match the colouring where possible (see base logo). Einstein could be holding a coin (but not essential). The coin would be called the "Law of Attraction Coin" with the ticker symbol $LOA. Time is of the essence with this one and we really need it completed by the end of today. Example below- Albert Einstein example below also Winner picked today Shor...
I'm in need of a professional developer who can create a web-based part navigation system for my business. The site should be user-friendly and similar to a few examples I can provide for reference. Key Features: - Search Function: The website should have an easy-to-use search function that allows u...c=TOYOTA00&ssd=%24%2AKwHh1cTP4ruKk-bk467w57mtjYqU5ern5vTb6KCmlYGdmZuY3crmjKKmopOFnI3L1tzh6JKYkpyPlvTq2Kjwofbp8I_1pqb78ejkqa2nvLPK_7qwu7H26eP59ezt_PHo9-Xi4uD1pqbxvfDv9uLjkOS5t7qurKO9t5Ku9ennuuny9-Xg4Obmuqa08_C8oPHo9fXaxcqSn_f48_C4tKi-uPGZ5OaegPiQwtzfmIr3-PPwo7Sovrjx6uTshPD596ji8bfw7_ThrwAAAABNkruS%24&vid=0&cid=1&uid=29070&q= The Wire Frame and navigation will be designed by us. The PDF along with Excel files with reference and page number will be provides...
I require an expert graphic designer to breathe new life into my Google Presentation Slides, transforming them into a vibrant, professional, and engaging visual resource about dogs and cats. Skills and Experience: - Mast...design and using vibrant color palettes - Expertise in creating adorable illustrations - Proficiency in modern design trends - A strong understanding of visual communication in educational content Project Specifications: - The primary focus must be on educational content about dogs and cats, using cute illustrations. - The color scheme should be vibrant to make the presentation attractive and fun to learn from. - You should balance cuteness and professionalism to appeal to a wide demographic. - Deliverables: Optimized Google Presentation Sheets with design imp...
I am in need of a dedicated, smart, and detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis o...detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis on data entry and analysis. Key tasks will include: - Data input - Data categorizing and sorting - Providing analytical summaries of data - Exploring trends and patterns - Collaborative problem-solving based on findings The ideal candidate should have strong experience with data entry, analysis, and Microsoft Excel, along with solid administrative skills. Attention to detail, strong organizational skills, and the ability to work independently are crucial for this role. If you're versatile, motivated, and have an analytical mind, I would love to have ...
Anda bisa bekerja kapan saja dan di mana saja! Bigo Live sedang mencari freelancer untuk menjadi affiliator yang bertugas membagikan link unduhan Bigo Live di platform online dan sosial media. Tanggung jawab Anda termasuk membagikan link, menciptakan caption kreatif, Gaji pokok $10 dengan bonus hingga puluhan juta Rupiah untuk setiap klik dan unduhan yang dihasilkan. Kualifikasi: -Pen...unduhan Bigo Live di platform online dan sosial media. Tanggung jawab Anda termasuk membagikan link, menciptakan caption kreatif, Gaji pokok $10 dengan bonus hingga puluhan juta Rupiah untuk setiap klik dan unduhan yang dihasilkan. Kualifikasi: -Pengalaman dalam pemasaran afiliasi atau promosi online -Kemampuan komunikasi yang baik dan orientasi pada target. - Bisa mengoperasikan Google Sheet/ ...
