PLATE FORM - EXCEL Vlookup, Hlookup, Pivot Table, Validation, Formatting, Macro, Len, Trim, Proper, True False, Sum, Count, Count A, Count Blank, Chart, Count if, Clean, Concatenate, Filter, Advance Filter, Custom Filter, Right, left, Upper, Lower, Proper, Convert, Tex To Column, Formatting and more excel functions. TYPING SPEED In English
We are looking for Bookkeeper/Accountant who can use Microsoft Excel functions, Vlookup, Tables, Pivot Tables. Tasks: Monthly Accounts Reconcile Inventory List Accounts Payable Bank Account Reconcile Cash Balancing Cash flow projections
We are looking for consultants to help us with some urgent short term projects. Using your well established, expert cosmetic formulation skills, you will assist us in reformulating existing products to meet key product performance criteria. This may including sourcing raw materials in line with our strict ethical requirements.
I need you to write some articles.
...and then create a function to export to a csv file in a certain format. This piece of work brings data together from 2 sources which we will download ourselves on a daily basis: Sheet 1 (AH Data) Sheet 2 (PF Data) Stage 1: Importing all data and merging 2 sheets Create a sheet which has 2 buttons which will allow us to import the 2 above spreadsheets
I need (IN EXCEL) to know when two times overlap. Please see image for visual example. Below is written example. 1) You will notice that Sales Person 3 and Sales Person 4 both worked a shift. 2) There was overlap from 08:03 thru 08:21 3) There was no overlap from 8:00 to 08:03 4) There was no overlap from 8:21 to 08:22 I need to know (REQUIRED) 1)
...Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by SKU # and put output
I need a mobile site. I already have a design for it, I just need it to be built.
...files, in one file is categories for opencart, in another file is products. Problem is, in categories file , all categories have numeric ID. but in product file categories have also numeric ID, but subcategories is just as text. i need it to import in opencart (i have module) , but i need it convert categories and subcategories in opencart>style>to>im...
I need some help with internet marketing. We need 50 or maybe even 100 or maybe even 150 ads per day placed on Facebook and other classified websites in the United States of America if this is something you're interested in let me know we have many many projects for you
I need you to write some content for a website.
...spreadsheet in a format that I want to automatically convert in another format in excel and calculate the total time. The source will always be in the "Employee attendance" format and should be converted to the Proper Format workbook. We should be able to copy new time data in the Employee Attendance format and the excel workbook Proper Format...
I need an excel expert to create an excel file that allows the follow: - I have 3 lists of words (40 words on each) - I need excel to randomly select 30 words (10 of each block) without repeating them. All in the same space (so I can easily copy and paste).
I am looking to take the example table and use the Records table to populate the Results tab with a kind of reports table based on date and getting distinct Name's automatically from the records tab The "Example Results I Want" tab shows what should be the end results you program into the Results tab This must work in Excel 2007 and Deadline is Thursday
There is 5 web sites with different content, including videos. Russian - English is must have.