Excel finance questionsงาน
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
I'm looking for a part-time professional with a proven track record in sales, strong negotiation skills, and experience in lead generation to enhance my team's capabilities on profit sharing basis. Key Requirements: - Proven Track Record: Your pa...expanding our reach and acquiring new customers. - Expand Into New Markets: I'm looking to explore and penetrate new markets. Your experience in doing so will be highly valuable. - Improve Revenue Generation: Ultimately, you'll be responsible for contributing significantly to the generation of revenue. While industry-specific experience is not mandatory, a background in technology, healthcare, or finance could be advantageous. Your expertise, however, in the core skills of negotiation, sales, and lead generation is w...
...create a Windows exe trading application that will leverage an API for automated trading strategies. Key Features: - Order Placement and Management: The primary function of the app is to place and manage trades based on predefined criteria. It should be able to execute trades automatically without the need for manual intervention. Ideal Candidate: I am seeking a developer with a background in finance and algorithmic trading who can bring the following skills and experience to the project: - Proficiency in Windows application development using Python or similar languages. - Experience with trading APIs, particularly in the context of order execution and management. - A solid understanding of trading strategies and the ability to translate these into functional code. - Knowledg...
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
...Key Responsibilities: - Extracting insights from unstructured text and numerical data - Utilizing machine learning techniques like LDA, NMF, etc. - Ensuring an ethical approach to data analysis - Asking the right questions for analysis and providing detailed insights Requirements: - Extensive experience in data analysis, particularly with unstructured data - Proficiency in machine learning techniques like LDA and NMF - Strong ethical understanding and the ability to consider ethical implications in data analysis - An analytical mindset with the ability to ask the right questions and provide detailed insights Ideal skills and experience for this job would include a background in data science, machine learning, natural language processing, and a strong foundation in data a...
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
...freelancer's remuneration is an agreed upon percentage of the NFT token sale amount minus applicable commissions and fees. All payments are made in the cryptocurrency accepted for payment for the NFT collection. The customer reserves the right to request additional information or documents necessary to confirm the fact of sale and the legitimacy of payments. Please let us know if you have any questions or need additional information....
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...
I am seeking a skilled professional for a B2B leads generation campaign within the finance industry. The primary objective of this project is to generate high-quality leads. Key aspects of the project include: - Target Market: The leads should be exclusively from the B2B sector in the finance industry. - Lead Quality: The main focus is on generating high-quality leads, which have a high potential for conversion or partnership. Ideal Skills and Experience: - Proficiency in B2B leads generation, particularly within the finance sector. - Proven track record of generating high-quality leads. - Excellent understanding of lead generation strategies and techniques. - Strong analytical and research skills to identify the right prospects. I'm looking for a profess...
I am on the hunt for an operations manager with a major focus in blockchain. Ideally, you will be able to help in: 1. Managing our supply chain effectively, 2. Coordinating team efforts, and most importantly, 3. Optimizing our processes. An additional plus if you have experience in the finance sector, as we intend to apply blockchain technology in this field. The main task will be integrating Web3 technology into our existing website to further enhance its operational efficiency. The perfect candidate would be someone who has a solid understanding of decentralized applications, Web3 technology, and prior experience in overseeing operational processes. Your skillset and expertise will be highly valuable in guiding our team to deliver the best results in a dynamic and fast-paced en...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...
I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I'm seeking a savvy social media marketer to elevate my trading stocks business through a dynamic and engaging social media campaign. Key Requirements: - Proficiency in Instagr...media accounts with consistent and engaging posts. - Monitoring the performance of our social media campaigns and making data-driven optimizations. - Collaborating with our team to ensure our social media efforts are aligned with our broader marketing strategies. The ideal candidate should be creative, results-driven, and have a keen understanding of the stock trading industry. Experience in the finance sector would be a plus. Your ability to drive brand awareness, website traffic, and generate leads will be crucial for this project. Let's work together to bring our business to the next level t...
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.
...optimize program metrics to measure effectiveness and adjust strategies accordingly. Lead knowledge-sharing and skill development workshops focusing on blockchain technology and decentralized finance. Spearhead community communication initiatives and engage actively with participants. Plan and execute targeted marketing strategies to promote the accelerator program effectively. Guide startups during their journey, making sure that they get the most out of the program and that they achieve great success. Functional Skills Required Comprehensive understanding of Web3 technologies and decentralized finance (DeFi) Experience in running complex projects to success including several moving parts. The candidate should have the working knowledge to plan, execute, and monitor the ...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
I'm looking for a professional who can convert my Amibroker AFL script into a TradingView Pine Script. The converted script should be able to generate buy/sell signals and provide backtesting capability. The ideal candidate should have experience in: - Amibroker AFL and TradingView Pine Script languages - Developing buy/sell signals - Implementing backtesting functionality Moreover, my tra...my trading strategy is based on breakout patterns. The converted script should reflect this strategy and incorporate the following indicators: - Moving Averages - Relative Strength Index (RSI) - Supertrend I'm looking for a freelancer who can deliver a polished and fully functional script that mirrors the performance of the original AFL script in TradingView. Feel free to ask any addition...
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...
I'm looking for an experienced Django developer to work on the backend of my project. Key Project Goals: - The primary focus of this project is on backend development. You should have a strong understanding of Django and be able to handle complex backend tasks. Ideal Skills and Experience: - Extensive experience with Django is a must. - Strong understanding of backend ...- Extensive experience with Django is a must. - Strong understanding of backend development. - Ability to work on complex backend tasks. - Good communication skills. - Previous experience with similar projects is a plus. Please note that the project is already defined and the focus will be solely on backend tasks. Your role will be to improve the backend of the website. Feel free to ask any questions for mo...
...extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row ...
Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP
...health-conscious individuals as primary audience The selected freelancer should have: - Demonstrable experience in creating educational motion graphic content - A portfolio showcasing previous work in the field - Understanding of the principles of designing for specific audiences, especially health-conscious individuals. Looking forward to seeing your bids, and please feel free to ask any questions if you need more details. Example of scrip: A low carb diet is great for reducing blood sugar levels. If you have diabetes or high insulin levels, reducing your carb intake can have a significant impact on your health, Studies have found that a low card diet can dramatically lower your blood sugar levels, and in some cases, help reverse type 2 diabetes.! "
I am in need of a skilled professional who c...Microsoft Word’s functionalities and be able to create a fully custom template. - Design Skills: The template should not only be functional but also visually appealing and in line with our brand image. - Attention to Detail: It is crucial that the template is designed specifically for external client communications. - Communication: I require clear communication on the progress and any potential questions or issues that may arise. Please note that I will provide you with the specifications that the template should adhere to. Your role will be to implement these requirements in a user-friendly, professional, and attractive manner. If you have experience in creating similar templates and are up for the task, I look forward to hea...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
I'm looking for a skilled professional to help me with advanced data processing tasks using Power BI and Macros. Key Responsibilities: - Data Cleansing: You will be responsible for ensuring that the data is clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and tra...clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and transform data effectively Please note that the main objective of this project is advanced data processing. The tasks would primarily involve data cleansing and transformation. Feel free to reach out if you have any ...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...
...professional textbooks across various subjects including finance, taxation, and costing. Key Qualifications and Experience: - Experience in editing textbooks is a must. - A Creative approach to editing is highly valued. The project is on a tight schedule, and ideally, I'd like the editing work to be completed in less than a month. The level of editing required is Substantive or structural editing, along with Rewriting to enhance clarity and style. Your task will be to: - Edit and enhance the text of professional textbooks. - Ensure the content is engaging and clear for the reader. - Implement changes that will help to improve the overall quality of the textbooks. To be successful in this role, you must be familiar with finance and taxation subjects. Your editin...
I am looking for an experienced writer who can create educational blockchain articles specifically focusing on supply chain finance. The aim of these articles is to inform and engage with academic researchers within the financial sector. Key Requirements: - Extensive knowledge and experience in blockchain technology and supply chain finance - Proven experience in creating educational content for an academic audience - Ability to explain complex concepts in a clear and accessible manner - Strong research skills to ensure accuracy and credibility of the content The perfect candidate should have a strong background in both blockchain technology and supply chain finance. Previous experience in creating educational content for an academic audience is highly desirable.
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
