Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
1 Hands-on experience with accounting software 2 Advanced knowledge of Excel (using financial formulas and creating spreadsheets) 3 Solid data entry skills with an ability to identify numerical errors 4 Good organizational and time-management abilities
...payroll template to ensure all hours are paid and accounted Requirements: • Microsoft Office Proficiency: • Excel - must be able to create and maintain spreadsheets with basic formulas • Word - must be able to create and azword documents • Outlook - must be able to use outlook, set meetings and manage calendars •
In my work i mostly use the same excel file template. because of the fact that it's full of numbers and formulas, it's hard to interact with it and i lose much time waiting for it to calculate/update
I have two excel files with a lot of macros and formulas and different things and I can't figure out how to merge them into one file. One file has like 20+ sheets and the other file just has one sheet and I want to have them all in one file (you can move the 20+ sheets to the 1 sheet file, or move the 1 sheet to the 20+ sheet file, or vice versa).
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I need a formula to calculate average days shipped. For example, I shipped 35 units between 1 to 10 days. 112 units 11 to 12 days. 137 units 13 to 14 days. 152 units 15 to 16 days. 113 units 17 to 18 days. 236 units 19 to 25 days and over 26 days 80 units.
...to cover: 1) Basics of Excel Interface: e.g. Quick Access Toolbar, Ribbon, Tell Me Box 2) Basic of Cells and Sheets e.g. Insert, delete, drag & drop cells or Fill, cut, copy, and paste functions. 3) Modify & Format Rows, Columns, Cells & Numbers 4) Working with Multiple worksheets 5) Creating simple and complex formulas (including nested functions)