Automate your excel workflow, macro, vba, formula, function:
I can help you in any kind of tasks using MS Excel and/or google spreadsheet as follows:
- Data Charts, pivot tables, calculations, formulas, validation
- Function Excel, customized
- Custom Dashboards Toolbar, userform, button, keyboard shortcut
- Orchestration Interaction with other excel files or other types, macros, spreadsheets, folders
- Export Worksheet, workbook, conversion to other formats (ex. PDF), printing, emailing
- Formatting Font, style, alignment, layout
- Applying advanced filters and Complex formulas (including conditional formulas) like Vlookup, Hlookup,
- Countif, Countifs, Sumif, Sumifs)
- Excel functions like Data Validation, Conditional formatting, drop down list
- Beautiful charts (Bar, Pie etc.), graphs, dashboards and customized reports with Macros/VBA Programming/ Pivot tables.
- Convert any file to Excel (PDF, TXT, Word, image, ...)
- Data manipulation (remove duplicates, remove empty rows, sort data,...)
- Custom invoice template / Paystub template
- User forms
- Sorting & Filtering
- Links to Websites