Financial formulas vbapekerjaan
Saya memerlukan servis untuk designkan interface system. System ini menggunakan microsoft excel VBA. Cod Macro sudah ada, just untuk tukar design sahaja
Membuat dokumen list kertas A3 Membuat template dokumen laporan harian Menggunakan kertas ncr Membuat template dokumen laporan mingguan kertas legal Membuat tenplate dokumen laporan bulanan / rekap kertas legal Membuat template dokumen RAP Membuat template curva s Intinya membuat template dokumen Antara sheet dan sheet terhubung antara 1 dan lainnya menggunakan rumus atau vba dan menggunakan pivot
Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan tanggal masuk 5. Record data tiap transaksi pada portofolio
belajar menggunakan excel dan beberapa formulas excel
Saya ingin membuat aplikasi Financial Accounting. Saya perlu orang yang sudah terbiasa membuat aplikasi Financial Accounting. Yang menjadi tujuan utama saya adalah kecepatan untuk menghasilkan laporan2 dan fleksibilitas untuk Master Data Chart of Account dalam arti panjang dari Chart of Account bisa dinamis tanpa perlu merubah coding program. Yang saya perlukan adalah : 1. Desain database untuk Financial Accounting (mySQL based) 2. Query untuk menghasilkan laporan yang diinginkan : - Laporan Jurnal - Laporan General Ledger - Laporan Trial Balance - Laporan Balance Sheet - Laporan Profit & Loss
Pembuatan Blog Dengan penulisan pengembangan financial
speed data entry, data processing and audit report, financial report and taxation Melakukan data entry laporan harian dan bulanan, cash and bank report, export and import, inventory control report, data analysis and as a translator english to indonesia,
Sila Dafter atau Log masuk untuk melihat butiran.
...writer and designer looking to collaborate on an exciting project? We're Epiidosis Investments LLC, a leading investment firm focused on empowering investors with lucrative opportunities in energy infrastructure and NBFC sectors. We're seeking skilled professionals to create a compelling pitch deck presentation that showcases our investment campaign. Video Clip: Footage of bustling city streets, financial district buildings, and individuals engaged in business meetings. Slide 1: Opportunity Overview - We're looking for a creative individual or team with expertise in pitch deck writing and design. - This is an opportunity to collaborate on a high-impact project that aims to attract investors seeking ROI of 24-30% annually. Slide 2: Role Requirements - As a pitch ...
I'm in need of a competent Python programmer with experience in working with real-time market data streaming to assist me in the development of a Zerodha Kite Live Websocket project. Key Features: - Real-time market da...updates on market data. - Order placement functionality: Enable easy and prompt order placement. - Trade execution notifications: Immediate notifications should be sent out once a trade is successfully executed. Design: The interface should be customizable and user-friendly, to simplify data analysis for end users. Ideally, the chosen freelancer should have prior experience working on similar financial projects and a solid understanding of market data streaming. Proficiency in Python is a non-negotiable as the entirety of this project will be built using...
...have less than a year's worth of financial data to review. Key Areas for Audit: - Accounts Receivable - Accounts Payable - General Ledger - Inventory Your role will be to scrutinize these areas with the aim of ensuring accuracy and identifying any discrepancies or areas that need improvement. Ideal Skills: - Proficiency in Odoo ERP - Extensive experience in financial auditing, particularly for manufacturing companies - Strong knowledge of accounting principles and practices - Attention to detail and ability to spot inconsistencies - Good communication skills for reporting findings Please note that I'm specifically looking for a review and analysis of our current financial records. The goal is to gain a clear and accurate understanding of our financ...
I'm looking for a professional to assist in assigning shares for equity distribution. The assignment will involve a single round of distribution only, with the shares intended to be transferred to my spouse. Key Requirements: - Experience in equity distribution and share assignment - Familiarity with legal and financial implications of share transfer - Ability to handle the process efficiently and with discretion Your role in this project will be pivotal as it involves a sensitive matter. Therefore, I'm looking for someone with a proven track record in handling such situations with professionalism and integrity. Please provide your relevant experience and suggested approach to this task in your proposal.
We're lookin...ultimately, leads to our investment service. - Product details: We offer investment products that need to be presented attractively and informatively, demonstrating their value and potential return. Knowledge in the financial sector will be an advantage. - Audience: The videos will be targeted at Millennials, High-net-worth individuals, and Retirees. Understanding their motivations, pain points, and financial goals will be critical in the success of these ads. The ideal candidate should have: - Proven experience creating successful social media ad campaigns - Understanding of the financial sector and investment products - Ability to research and target audience insights (Millennials, High-net-worth individuals, Retirees) - Excellent storytell...
I am seeking a professional to conduct a comprehensive financial audit of our Odoo ERP system. The audit should focus on the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. Key Responsibilities: - Reviewing and assessing the accuracy of data in the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. - Ensuring the completeness of financial data in the system. - Conducting data reconciliation to identify any discrepancies. - Producing detailed findings on the Balance Sheet, Income Statement, and Cash flow statement. Ideal Skills and Experience: - Proven track record in financial auditing, particularly within ERP systems. - Strong understanding of financial reporting and reconciliation. - Experience with Od...
...my own architecture for the paper and a series of 70 videos fed into chatgpt on the subject matter. - Key Tasks: The selected candidate will need to translate complex finance topics into easily understandable content for the general public based on video content and transcripts provided from YouTube videos and already entered into chatgpt. It would be beneficial if the writer could simplify financial jargon while keeping the document engaging and informative. - Skills and Experience: As the topic is finance, having a basic understanding of finance is essential. Experience in ghost writing or writing white papers is preferred but not mandatory. The ability to write in a manner that engages and educates the lay audience is a must-have. Overall, I seek a professional and dedicat...
...experience with integrating Financial Statements, Credit Bureau Data, and Market Data would be a huge plus. - Reporting & Monitoring: The software should offer a range of reports and dashboards including: - Historical Credit Risk Analysis: We need to be able to view and analyze the historical credit risks we've undertaken. - Real-time Risk Monitoring: This is crucial for our proactive risk management approach. Being able to monitor real-time risks is a priority. - Portfolio Risk Summary: The ability to generate a concise summary of our portfolio risks would be very helpful. The ideal candidate for this job should have a strong background in finance, credit risk management, algorithm development, and data integration. Experience with developing similar software for...
I am looking for a skilled presentation designer who can assist in restructuring my PowerPoint pitch deck. The current version suffers from a disorganized structure and lacks a clear flow. The end goal of this project is to refine the content in a way that it effectively communicates the company's value proposition and drives home the key ...Retain a fine balance between necessary detail and avoiding overwhelming the audience. - Align the content with the primary goal of securing funding. Ideal Skills & Experience: - Proven track record in creating successful pitch decks - Strong understanding of content structuring and flow - Excellent communication skills to convert complex ideas into simple, appealing slides - Experience with financial and investment related presentatio...
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 a proficient developer capable of integrating an API that reflects financial statistics onto a visual dashboard. Key components of this task include: - Integration of an API that conveys financial figures. - Representation of Investment performance stats in a table format. - Visualization of portfolio return via a line chart along with portfolio assets and diversification. Experience and skills ideal for this task are: - API integration knowledge - Experience in financial data representation - Advanced proficiency in creating visual dashboards A ready-made template will be used so as not to have to develop the visual part.
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 task, please place a bid. I will be...
As an established driving school, my goal is to navigate expansion intelligently and efficiently. We require a comprehensive business plan and financial projections to guide our growth strategy. Key Deliverables: - Business Plan: A detailed roadmap for our future development, including strategy, marketing, operations, and organizational structure. - Financial Projections: A careful analysis of future finances, including revenue, expenses, capital requirements, and key financial forecasts. Ideal Candidate Skills and Experience: - Extensive experience in strategic planning and financial modeling. - Familiarity with the education or driving school industry would be a bonus. - Pragmatic and results-focussed approach to business growth. - Strong understanding of ...
I'm seeking a pr...seeking a professional CV writer to craft a compelling and polished CV for a senior financial manager position. - You must be experienced in crafting CVs specifically for financial managers. This is because you need to understand what makes a senior financial manager CV stand out in a competitive job market. - You should be able to highlight my senior-level experience and expertise in the finance industry. - The CV should be tailored towards a job application, so it should be concise, engaging and designed to make a strong impression on potential employers. In your bid, please include examples of previous CVs you have written for senior professionals in the finance industry. Understanding of specific financial jargon and a good eye ...
I am in need of an experienced accounting professional who can assist me with the comprehensive analysis of my business's financial statements. Key Requirements: - Expertise in financial statement analysis - Proficiency in analyzing balance sheets and cash flow statements Ideal Skills and Experience: - Proven track record in conducting intricate financial analyses - Strong grasp of accounting principles and best practices - Background in [industry specific experience, if you have any] could be beneficial, but not mandatory. - Familiarity with [specific accounting software, if needed] I have attached sample sheet. My required company is NESTLE.
I'm in need of an experienced finance expert who can help me calculate financial ratios for Nestle over a period of 3 years. These figures will be vital in evaluating the financial health and performance of the company. Key Project Requirements: - Calculating profitability, liquidity, and solvency ratios for Nestle for 3 years - Presenting the calculated ratios in tables - No need for a comparative analysis with other companies, just Nestle Ideal Skills and Experience: - Proven experience in finance and accounting - Deep understanding of financial ratios - Experience in presenting financial data in clear and organized tables I'm looking forward to working with a professional who can provide accurate and reliable financial analysis. I will att...
...Arab Emirates. Introducing GCC Tax Laws GPT GCC Tax Laws GPT leverages the power of Generative Pre-trained Transformers (GPT) technology to create an intelligent and user-friendly solution for GCC Tax Laws compliance. Here's how it will work: • Automated Data Analysis: GCC Tax Laws GPT will be trained on vast amounts of GCC Tax Laws data, enabling it to analyze invoices, receipts, and other financial documents accurately. • Personalized GCC Tax Laws Guidance: GCC Tax Laws GPT will analyze your company's specific GCC Tax Laws profile and generate customized reports and recommendations for optimized GCC Tax Laws compliance. • Reduced Errors: GCC Tax Laws GPT's ability to analyze complex GCC Tax Laws rules will significantly minimize errors in calcul...
...manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excell...
...author a detailed white paper. The document should investigate: - The impact of deepfakes, - The proliferation of misinformation, - The use of fake bots in election campaigns, - Particular focus on the global and Indian contexts. The goal of this white paper is threefold: - Understand the purpose behind these actions, shedding light on the motives behind their rampant use, - Explore the financial implications for organizations, campaign budgets, and the overall economy, - Discuss the effects on reputation due to these tactics. Ideal candidates should have: - Strong research capabilities, - Excellent written communication skills, - Keen interest in technology and its societal impacts, - Prior experience with cybersecurity or political science is a plus, - Understanding of ...
I'm in need of a skilled developer with expertise in Yii framework to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu items using the language file - Bank statement mapping - Bank statement import - Bank statement transaction allocation A full specification is available for the selected candidate. Ideal skills and experience for this job include: - Proficiency in Yii framework - Strong PHP skills I look forward to your proposal for this project.
...media in both the native language and English. - Significant news in the last 10 years, eg, Merger & acquisition, New business/project announcement / new joint-venture - Changes in organization structure, including changes of shareholders, board of directors, key executives, etc. - Major announcements on the company as well as related companies (eg. secured new projects, incurred substantial financial losses, etc.) - Significant news on the subject company as well as related companies e.g subsidiaries, branch offices, associated companies, joint ventures, etc. - Any litigation and bribery information English. SUBJECT: 2 individuals, 4 companies SKILLSETS: - Experienced in Internet research - Strong in both local and English language proficiency DELIVERY ELEMENTS: - All rel...
I'm seeking a skilled entry-level Investment Banking Analyst to assist with a range of tasks within the Financial Services sector. Key Responsibilities: - Conducting comprehensive financial modeling - Carrying out company valuations - Performing in-depth market research Experience: - Ideal candidate should have a strong academic background in finance, economics or related field - Ability to use financial models and valuation methods is crucial - Prior experience in the financial services sector would be an advantage Skills: - Proficiency in Excel and financial modeling software - Strong analytical and problem-solving skills - Excellent research and report-writing capabilities If you're a finance graduate with a knack for numbers and a pass...
...various aspects of project management such as task assignments, progress tracking, resource management, and reporting. - Customer Relationship Management (CRM): This is another vital aspect of the ERP. The system should be able to manage customer interactions, track leads, and facilitate marketing and sales processes. - Financial Management: While not the primary focus, financial management features should be integrated into the system to enable invoicing, budget tracking, and financial reporting. I'm also looking for the ERP system to be accessible on both web and mobile platforms. The system should be responsive and easy to use on various screen sizes and devices. The ideal candidate should have experience in developing cross-platform applications and posses...
I am looking to create an Excel tool that will streamline our disbursement process. The tool needs to handle data entry automation, calculation of disbursement amounts, and generation of disbursement reports. Key Features: - Data Entry Automation: This will help us input information quickly and without errors. The tool should automat...relatively high-volume transactions. Especially the discrimination of "for invoicing", "forecasted" and work done due" is crucial in a ratio as actual budget available is less than the required budget to satisfy above at 100%. Given that no integration with external systems is needed, a strong background in Excel automation and data processing is essential. Experience with creating similar tools for financial or administrat...
...videos. - The content needs to be accessible and engaging to a diverse audience. - The writer should be able to simplify complex financial concepts for beginners while also providing valuable insights for experienced traders. - A passion for finance and a proven track record of creating engaging, shareable content in the field is highly desirable. Ideal Skills & Experience: - Proven experience in writing finance and stock market content. - Ability to cater to a diverse audience. - Proficiency in creating blog articles, infographics, and videos. - Strong understanding of personal finance and stock market analysis. - Prior experience in simplifying complex financial concepts for beginners would be a bonus. If you have a knack for creating engaging, informative conten...
I'm in need of a proficiency in graphic design to create a compact, yet visually engaging web banner fo...capture website visitors' attention. Required elements: - Incorporates our company's Contact Info. - Utilize a refreshing green and yellow color scheme. Ideal Skills: - Demonstrative background in graphic design. - Knowledge on making web banners stand out. - High appreciation for detail, and can effectively incorporate information without comprising the visual appeal. - Previous experience with financial or similar industry would be beneficial. In your bid, kindly provide a brief explanation of your strategy to approach this task and a collection of your similar, past work. I'm enthusiastic to collaborate with those with innovative ideas to represent our ...
I need a letter written to my ex-girlfriend addressing some unauthorized transactions, and demanding reimbursement. The letter should be firm in tone, clearly explaining the situation and the expectation for reimbursement. Key elements include: - A clear and concise explan...include: - A clear and concise explanation of the unauthorized transactions. - A firmly-worded demand for reimbursement. - Professional language and tone throughout. Ideal skills for this job include: - Strong writing skills, particularly in the realm of demand letters or similar formal communication. - Ability to draft professional and persuasive correspondence. - Understanding of legal or financial terminology, particularly in relation to unauthorized transactions. Please provide samples of similar work if...
I need a comprehensive android-based cheat sheet that includes all necessary oilfield formulas for drilling, production and well control. Key Features: - I would like to have drilling formulas such as Weight on Bit, Rotary Speed and Mud Pump Output. This will make it easier for me to perform drilling related calculations on the go. - The production formulas should be included as well, to help me with my production related calculations. - The cheat sheet should also have well control formulas. This will help me make important calculations in case of an emergency. My Requirement: - I need this cheat sheet to be user-friendly. This will allow me to plug in numbers easily and have the app compute the results seamlessly. Ideal Skills: - Android development - Oil...
...also an innovative approach to design and functionality. Project Requirements: Custom Layout and Design: The sheets should have a unique, user-friendly layout that efficiently organizes client information, workout plans, and progress tracking. The design must be intuitive and specifically tailored to support a fitness coaching environment. Advanced Functionality and Formulas: The developer will need to implement complex formulas that automatically calculate metrics such as client progress, session counts, and other relevant data. Knowledge of Google Sheets scripting may be necessary to achieve desired functionalities. Interactive Elements: The sheets should include interactive features like dropdown menus for exercise selection, checkboxes for session completion, and per...
Seeking a talented individual or team to create a dynamic and customizable spec sheet template for our furniture collection. The template must include slots for pictures, names, company info, and various pieces from different styles. Must support auto-fill functionality based on pre-defined formulas but allow manual data entry. It would be even better if the sizes could use a formula to auto fill some numbers that have a relationship with each other (but also be able to be overwritten if needed) - As an example, there are certain relationships between alot of styles. If a sofa has 24" cushions, so does the loveseat and chair. The ch1.5, sofa 2, and extra long sofa would have 32" cushions. If the sofa has 22" cushions the bigger ones are 30". So once the sofa ...
...missions. - Financial tracking and reporting dashboards for project costs and valuations. - Historical logs and comments section designs for internal team use. 5. Payment and Invoicing System - Automated invoicing and billing interfaces for companies and candidates. - Financial dashboards for tracking payments and financial details. - Designs for automatic calculation and generation of payment receipts and invoices. 6. Quality Assurance and Feedback - Tools for performance feedback and service quality surveys. - Designs for a rating system where companies can provide feedback on candidates and missions. 7. Administration and Analytics - Administrative dashboard designs for platform management. - Detailed analytics and reporting interface designs for user activiti...
...market indices, and substantial factors playing roles in the efficiency. • Investigate technical analysis impact Leaning on your experience in financial research, dig deep into how technical analysis affects the efficiency of the stock market. • Compare differing market indices Similarly, gauge the efficiency of different stock market indices, exploring their individual strengths and challenges. • Identify efficiency-affecting factors Lastly, determine and analyze the factors that directly impact the efficiency of the stock market. Data for this project should be drawn from the: • Examination of historical stock market data • Analysis of financial statements from various companies • Review of relevant academic research papers At the cl...
...Separate Dashboards: Intuitive and distinct interfaces for lenders and borrowers to navigate postings and offers accordingly. This project demands a developer with a strong background in WordPress and plugin development. Ideal candidates should have experience creating plugins with similar functionalities. They must understand the crucial aspects of user engagement and UX design. Knowledge of financial systems would be a distinct advantage. The process goes like this: 1. A jotform is being filled up with the loan request information 2. All loans are added to a searchable data base on the site that allows lenders to login, and choose a loan that they like to send a bid on. When the lender choose a loan, they are going to enter their loan offer Loan to Value, Pre Payment Penalty,...
analyze and evaluate the financial implications of different asset classes
...project involves comprehensive research into the intricate relationship between the gold and stock markets within emerging economies. As a financial researcher or data analyst, your task is to: - Collect historical pricing data of gold and stock markets in these growing economies. - Identify and analyze the economic indicators that directly influence these markets. - Review existing research studies that delve into the correlation between gold and stocks in these markets. Expected Output: In-depth analysis with detailed insights on the interplay between the two markets, with potential implications for investment strategies. You should have experience in financial research, competent analytical skills, and a solid understanding of the stock market, gold market, and emer...
I am seeking a qualified, creative designer to create a simple yet ingeniously crafted black text logo for my financial gold trade company. I prefer text only, no symbols, icons, or images. I aim for a modern feel, though the style wasn't specifically chosen. Delivering a tastefully appealing, discerning design within the shortest time possible is essential. Ideal Skills: - Mastery in typography - Experience in modern text logo design. - Understanding of the finance niche, particularly gold trade. - Ability to deliver fast, without compromising quality. The name of the logo you fin in the attached file
I'm in the process of launching AdvisorCRM, a new CRM software company for financial advisors. I'm looking for a bold and colorful logo that communicates our principles and ethos. • Style Preference: Although AdvisorCRM leans towards technology solutions, I want our logo to be colorful, vibrant, and minimalist/modern. • Logo Elements: A representative icon must be included in the design. This could be anything that signifies customer relations, technology, or service. Designers are encouraged to think outside the box. Color Scheme leaning towards bold orange, but open to other ideas. Good Luck, Leibel
...customer satisfaction by providing problem-solving resources. Maximizes customer operational performance by providing help desk resources and technical advice. Accomplishes customer service human resource objectives by recruiting, selecting, training, and coaching employees. Manages customer service staff, communicates job expectations, and performs appraisals and job reviews. Meets customer service financial objectives by forecasting requirements, prepares annual budgets, and schedules expenditures. Improves customer service quality results by conducting surveys and studying, evaluating, and re-designing processes and establishing and communicating service metrics and monitoring and analyzing results. Implements production, productivity, quality, and customer-service standards. ...
