Banner Image

All Services

Programming & Development

Writing MS Excel Macros

I specialize in Excel programming, reporting systems, working with massive amounts of data and interactive dashboards.
Macro programming in MS Excel to apply logic and Interact with Other Office Applications like MS Word, Outlook & PowerPoint, Emailing with attachments etc
Programming complex macro based formulas, connecting to databases and pulling pages from external web pages for providing reminders whenever something changes in them.
High level of expertise in writing Visual Basic (VBA) codes for Microsoft Excel files viz.
(1) Automation
(2) Data manipulation
(3) Designing Userforms
(4) Generating reports
(5) Folder management (Creating/Deleting folders, opening/closing/moving/copying files.
(6) Excel-PDF interface
(7) Excel-Outlook interface
(8) Excel-Word interface
(9) VBA Custom Excel Applications
(10) VBA Automate Excel Tasks
(11) VBA Pivot Tables
(12) VBA Import Files/Sheets
(13) VBA Save Files/Sheets
(14) VBA Combine Files/Sheets
(15) VBA Compare Files/Sheets

Skills & Expertise

AlgorithmsCopy & PasteCreativeData Import/exportData ManagementData ManipulationDesignExcelExcel MacroExcel ProgrammingManagementMicrosoft Excel DashboardsMicrosoft Excel PowerpivotMsMs ExcelMs Excel Pivot TablesMs WordOutlookPowerpointProgrammingReportsUser Interface DesignVBAVisual BasicWriting

Related Work Collections

39 Reviews for This Service

Sign up or Log in to see more.