Find a local Microsoft Excel helper in Newcastle

Develop a excel spreadsheet that reports and automatically calculates data for a HR Report. Already have some templates and opportunities. - Due date: Before Monday, 30 October 2023

I need a Microsoft excel expert that can create a template in Excel that connects to Microsoft Word. There will be several formulas and macros required. - Due date: Before Sunday, 16 April 2023

I get a couple of excel sheets eah week from a supplier. I Need an excel sheet that can analyze the best weeks of year to buy products from them. I need the excel sheet to tell me the best deal and the worst deal, best deal frequency and whats coming up on best deal in the next 2 weeks. Sheet needs to be easy to ad / import new info into each week - Due date: Before Sunday, 24 July 2022

Hi! I just need the written data typed into an Excel sheet with the following columns: Column 1. Date Column 2. HICAPS or EFTPOS Column 3. On Spreadsheet Column 3. Actual in Bank And that’s the order they are across the page the date in column 1 • Hicaps or Eftpos in Column 2 (add in the fate next to Hicaps if I have written it) • the amounts in black ink to be in column 3 • the amounts in green ink to be in column 4 Thank you!

Support for developing analytics and graphing around social trends

I have a spreadsheet of employees who have various registrations which have expiry dates. Want to set up a program which will give me warnings of when these dates fall due. Also I would like some help in setting up One Drive for different clients. You must have a ABN for this task.

I have an excel spreadsheet with 6 pages and the cells are not summing correctly in the summary sheet.

Help required using excel for data analysis, creating charts and preparing reports.

I have a bag of receipts I need documented with details placed in an excel spreadsheet by Monday, June 1. I need the items picked up and dropped back by Tuesday June 2

require a workbook manipulated with data inc merging cells transferring data between 2 workbooks drop down lists formulas data entry Goal To create a workbook with dropdown items that populate the “per unit rates ($)”, “Unit” of Measure and “Description” and calculate the cost of a small project. Task 1 All data from workbook “SORs” to be sorted and tidied up – this workbook has ben created by converting a PDF to excel and the data is a bit all over the place. Cells need merging KEEPING all the data in multiple cells. Each item must be on one line – ie no merged cells across 2 lines. All data must be kept in the correct category. Task 2 Place all this data into workbook “subcontractor payment claim” Sheet “invoice Matrix” This data must be integrated into the dropdown list in “item number” and populate the “description” “UOM” and “Rate” PLEASE NOTE THE DOCUMENT “Subcontractor Claim Template” has been pre created by others and could contain hidden formulas and actions etc. Please ensure all existing links formulas etc have been removed.

Need to reformat without destroying data. Previous admin has since retired, and has forgotten the password to unlock the protection on most of the workbook. Need someone to Unlock sheets using the recoding/resetting of password protection and to reprotect certain data with new password.

I need to setup a spreadsheet that accesses data from a website that I need to login to use. When I enter the correct credentials into excel web query it says The credentials provided are invalid' but they are in fact correct. Shouldn't be a huge task, just need some help.

I need to set up excel to make invoices for an assignment firstly and then to use in my business