Lotus macrosKazi
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated r...can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated...
I need a Windows-compatible MS Word editor that has robust document formatting tools and advanced editing features. It should be a basic editor, without the need for advanced functionality such as macros and scripting capabilities. Ideal Skills and Experience: - Proficient with MS Word on Windows - Strong understanding of document formatting tools - Skilled in advanced editing features Please provide me a list of your previous projects and an example of your work if possible.
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.
...UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumber) - sender name (smsSenderDisplayName) - senders text (smsBody) - senders datetime (smsDatetime) MS3: help to publish on playstore and appstore MS4: implement the telegram integration (forwarding destination) MS5: implement the telegram integration (receiving telegram msgs and forward) MS6: implement sms sending (e.g. to forw...
I am in need of a whimsical and engaging logo/verbiage design for a social event. This should appeal to youth and incorporate black, gold, silver, deep purple. I attached a mock up of the desired font style/aesthetic. Would like a hummingbird, bunny, frog, lily pad, lotus near the word “earth” and jellyfish, stars, koi fish, and alien near the “galaxsea” In this project, I am looking for: - A unique and creative approach to the logo/verbiage design - Design expertise specifically geared towards social events - Strong communication skills to ensure the design aligns with the event's theme and target audience - A clear understanding of branding techniques to effectively capture the essence of the event - Ability to deliver on time and in a format that&...
I am in need of a proficient data analyst who can provide a comprehensive solution to our manufacturing workflow. The scope includes: - Developing an advanced order planning & costing mechanism specifically for our production unit. The system should be based on Excel and leverage the power of scripts and macros. - Certain features are a must-have: inventory management, production scheduling, cost optimization, and sales order management. - Following this, the mechanism will then be utilized to create a management dashboard on PowerBI. Core KPIs to be highlighted on the dashboard include production efficiency, inventory turnover rate, cost per unit produced. In addition, it should also provide a detailed overview of sales and profitability. The perfect candidate for this pro...
Tafadhali Jisajili ama Ingia ili kuona maelezo.
...needs and fitness goals, automatically generate shopping lists, and estimate costs. Key Features: Personalized Meal Plans: Automatically generate weekly meal plans that align with user-entered health metrics and goals. User can also enter specialized suggestions such as vegan, high protein, no dairy. Nutritional Information: Each recipe comes with detailed nutritional facts, helping users track macros, calories, and other dietary needs. Grocery List Generation: Compile grocery lists based on the week’s recipes, optimizing for cost, and minimizing food waste. Cost Estimation: Provide an estimated cost for the weekly groceries based on prices from local stores or average costs. Technologies: Frontend: Vue.js or React for a dynamic and responsive user interface. Backend: Pyth...
I am in crucial need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing all the subtasks. Speed and proficiency in Excel...
...and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: ...
...and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: ...
...and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: ...
I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule is extr...
Hola, estoy en la búsqueda de un book keeper con excelentes habilidades utilizando macros en excel esto es una de las habilidades importantes que me están pidiendo en el freelancer, indispensable también que tenga experiencia haciendo los libros para negocios en Canadá. Comunicación excelente en inglés. Me gustaría oír de ti. Saludos
I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the daily updates. I am open to discussing more about...
I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding of autom...
...primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start this project as soon as possible, and timely completion is essential. Thank you for your interest, and I loo...
Hello, we are working now on script/macros to be uploaded in Confluence, that will do following: 1. Call to Jira issues according to JQL format request (filter request) 2. Take data from pre-defined fields of each Jira issue 3. Create a report on the confluence page in form of table. This is for Data Center Confluence. We have developed the script attached (authotification tokens and some details were deleted due to confidential information), but it didn't work both on the cloud and data center versions. We don't know why. We suspect it may be connected to CORS configuration. So the applicant needs to be familiar with such issues. We will not provide access to the actual system, but can share screen, if required. We are looking for a consultation - troubles...
Tengo u a hoja de sheets muy completa para trabajar en la que quiero que se ejecuten las fórmulas a las 00, mediante macros de un bot externo, y como consecuencia no se puedan ver las formulas por parte del cliente pero si pueda el trabajar con ella.
As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal seek macro for my spreadsheet. He...seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to detail and a commitment to delivering a high-quality, error-free product. If you're confident in your ability to create a reliable, efficient macro for my needs,...
I need an Excel macro that will primarily handle formatting and sorting data, and to be used on a daily basis. Key Responsibilities: - Developing a macro to automa...macro that will primarily handle formatting and sorting data, and to be used on a daily basis. Key Responsibilities: - Developing a macro to automate formatting and sorting of data in Excel 2019. - Ensuring the macro is optimized for daily use, with minimal errors and efficient performance. Ideal Skills and Experience: - Strong expertise in Excel macro development. - Prior experience creating macros for daily use. - Proficiency with Excel 2019 is a must. - Attention to detail and thorough testing skills. Looking for a developer who can deliver a robust, reliable solution that can handle repeated daily use without a...
I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database ...workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data managemen...
I'm looking for a skilled JavaScript developer to create a function t...calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements such as interest rates and amortizations. The JavaScript function you create should be able to handle these complexities and produce accurate results. Ideal Skills: - Proficient in JavaScript and algorithmic problem-solving. - Experience with Excel macros and Goalseek is a plus. - Strong understanding of mathematical concepts, especially related to financial calculations. - Ability to design user-friendly input systems within the function. If you are confident in your ability to replace the Excel macro with a robust JavaScript function, I'd be ke...
...Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel. Key Specifications: - The tool needs to be able to automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, s...
...Plans: Nutrition recommendations and daily diet plans tailored to support strength training. These may include recommended meals, macro or calorie counts, and advice on supplements if necessary. 3. Progress Trackers: A system for tracking training progress, such as weight lifts, cardio fitness levels, and body measurements. A visually appealing, easy-to-understand format is important. 4. Daily Macros/Calories Checks: A straightforward way for clients to track their calorie intake and macronutrient ratios, which is crucial for those pursuing strength training. 5. Check In Form: A form that clients can fill out to monitor their weekly progress. It'll allow me and them to track their progression and make modifications if needed. These fitness sheets will be distributed via ...
Se realizará un script de python el cual permitirá automatizar un proceso de creación de libros de excel de acuerdo al flujo existente de unas macros, adicionalmente el programa debe ser capaz de ofuscar el código de vba e impedir la edición del mismo, El proyecto se realizará en google colab, de forma que pueda ser ejecutado desde cualquier dispositivo con conexión a internet y cuente con acceso al programa.
Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online
I'm looking to enhance my Microsoft Excel skills, focusing on data analysis, pivot tables, and macros, to efficiently manage project construction data and create insightful reports. Key Responsibilities: - Advanced Data Analysis: Interpret project construction data effectively. - Pivot Tables Mastery: Create complex reports with dynamic pivot tables. - Macro Proficiency: Automate repetitive data analysis and report generation tasks, boosting efficiency. Ideal Skills: - Proven expertise in Excel, particularly in data analysis, pivot tables, and macros. - Experience with project construction data, financial data or similar. - Strong analytical and problem-solving abilities. - Excellent attention to detail to ensure high-quality, accurate reports. - Graphical representat...
I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and accuracy.
-As discussed, documents to be prepared based on current version but with...Notifications: Onsite (web), Push (app), emails using AWS (transmail) email automation, Zendesk and MailerLite Log-in: Site, Google & Facebook Domain name: Ionos (SSL) **THIRD PARTY APPS** -Contabo or AWS server -AWS email -Braintree -PayPal -AWS email automation (all membership emails, notifications, requested reminders etc) -Zendesk (set up by Zendesk specialist in conjunction with web developer; API, macros, articles) -MailerLite (API syncing members for company newsletter) -Admin panel (custom) -Google Developer -Apple Developer -Facebook Developer -Userway (ADA) plug in -A few plug-ins text formatting etc. This project is for hire. Completed project is our intellectual property and will pass on t...
...Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ensure the mac...
I require assi...creation of simple macros to automate certain repetitive tasks. Key Requirements: - Proficiency in Excel: I need an expert who is well-versed in Excel and can help me set up basic formulas for tasks like addition, subtraction, multiplication, and division. - Macro Creation: I'm looking for assistance in creating simple macros that will help automate some of the repetitive tasks in my worksheet. Ideal Skills: - Proficient in Excel: The freelancer should be comfortable with Excel's advanced features. - Experienced in Macro Creation: The ideal candidate should have experience in creating simple yet effective macros for automation in Excel. - Excellent attention to detail: Accuracy is crucial, so the freelancer must be detail-oriented to avoid ...
I'm seeking an Excel Macro specialist to automate several repetitive tasks specific to engineering. The qualified individual needs to have: - Proven experience in creating efficient and complex macros - A solid grasp of engineering needs in relation to Excel functions - An ability to work with dense datasets and create tailored reports Tasks include, but are not limited to: - Automating repetitive engineering report creation - Streamlining data organization This project requires both expertise in Excel and understanding of engineering principles, hence any experience in the field can be a significant bonus. High efficiency and attention to details are of prime importance. Macro will need to be in word file and will change depending of the test - test A to J. Each report h...
I am in need of an expert data professional to handle distinct tasks pertaining to Excel spreadsheets. Here is a rundown of what you'll be required to do: - Upload numerous Excel files - Expertise in Excel VBA, Macros and VB Capabilities - Analyze data professionally, using descriptive statistics The ideal candidate for the project would be well-versed in using Excel to analyze data and create descriptive statistics. Familiarity with data cleaning and visualization techniques would be a bonus. I look forward to your submissions.
I am in urgent need of an expert Excel Macro developer who can generate a multidimensional tool for a restaurant setting. Key Responsibilities: - Design, build, and test a multifunction...calculate inventory, and analyze customer data. Ideal Candidate: A successful candidate should have exceptional Excel Macro development skills, with an advanced understanding of restaurant operations. The candidate should be able to handle complex functionalities in Excel. This project is not suitable for beginners or intermediates; instead, an expert developer with proven experience in creating Excel Macros is required. Please provide evidence of similar past work when you place your bid. This project requires a quick turnaround, thus prioritize efficiency without compromising on the qualit...
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
I'm in need of an Excel expert to Create Macros. I have two spreadsheets. On each spreadsheet i have an input form. When the form has been entered and the user clicks "Enter Asset" each of the filled out cells (as per the File - "Template Code Functions") should be transferred to the "Data Collection Spreadsheet". Just enter into the next unused row. When the asset has been added successfully the cells marked as "Yes" as per the "template code functions" for "Reset on data entry" shall be empty on the input form. There are two spreadsheets, they are slightly different from each other.
I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic...can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is p...
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that...Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ideal skills and experience for this project: - Proficiency in VBA: Expertise in designing intricate and efficient macros in Excel is a necessity. - Financial audit background: Experience in auditing financial records, particularly for Trusts, is highly desirable. - Attention to detail: A meticulous approach to ensuring the accuracy and precision of t...
I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me know if...
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that...Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ideal skills and experience for this project: - Proficiency in VBA: Expertise in designing intricate and efficient macros in Excel is a necessity. - Financial audit background: Experience in auditing financial records, particularly for Trusts, is highly desirable. - Attention to detail: A meticulous approach to ensuring the accuracy and precision of t...
I need a program that can interact with Fidelity Brokerage website, grab financial statement data and inject that data into an Excel worksheet. Key Requirements: - The prog...this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of financial statement data and the ability to accurately capture and translate this information. Please only apply if you have the required skills and e...
We want to change the old logo with a new one and change the name. - New logo needs to have current logo + a combination with a lotus inside of it. - New logo needs to be based on acupuncture instead of current one (current is Yoga) - New logo needs to have the new name "Acupunctuur Ming Li Ai" - New logo needs to have same color (same for text and logo itself) - Also .PSD file is required on delivery so i can edit myself if needed
I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and easy to understand, ...
...web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to In...
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves workin...in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project, pleas...
...RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scripting using excel Macros Other Functions: • The Quality Engineer IV participates in the development and implementation of procedures for maintaining and or enhancing the integrity of Santander-s system application • Ensuring the existence of development and service standards • Ensuring that requirements are clearly defined and testable • Responsible for the creation and execution of det...
Need an Excel combinations generator that can generate combinations into a list from multiple numbers. Need an input, numbers will have commas between them, for example (9,12,21,22,29,40). Input numbers 6* and need output of 3 numbers. the result should look like this list. Have the option for output, how many numbers of combinations to choose from. input can be up to 20 numbers and output can be from 1-19. 9,12,21 9,12,22 9,12,29 9,12,40 9,21,22 9,21,29 9,21,40 9,22,29 9,22,40 9,29,40 12,21,22 12,21,29 12,21,40 12,22,29 12,22,40 12,29,40 21,22,29 21,22,40 21,29,40 22,29,40 When multiple inputs are present, they should look like this. Input* 9,12,21,22,29,40 5,18,30,41,46,52 11,14,19,33,44,54 output* 9,12,21 9,12,22 9,12,29 9,12,40 9,21,22 9,21,29 9,21,40 9,22,29 9,22,40 9,29,...
