Hello everyone,
I've had my first encounter with Excel as a young teenager for a simple data entry job. I didn't know more about it than it's what the 'professionals' use and that I wanted to be proficient in it.
Fast forward a few years, during my studies I had three courses on Excel, VBA and VB and was an outlier my class for those courses for simply 'getting it' and even making this the subject of one of my project works.
What used to be merely a tool for getting the work done, gradually turned into my main occupancy: Creating worksheets and formula for calculations and workflows to be used by my colleagues and me for the job, then creating an Excel AddIn for various tasks.
Followed by moving Excel data silos (mainly lookup / reference data) into a DB and access via DAO and later ADO, as well as creating data reports for higher level business decisions.
In regards to Access, I've got several years of experience on the SQL/data side with so far just a small application for maintenance / updating of the migrated data.
Now I'm in the process of creating my first 'proper' application to be used by the team.
This includes restructuring & migrating several Excel data silos into the DB, as well as creating the UI to access and alter the data.
Our work is in a rather small, highly regulated niche. We do have SAP as well, but only for the likes of HR and accounting.
Besides my obvious 'hammers' Excel, VBA, SQL and Access DB design & UI, I like to add more into my toolbox. My regex hammer is already rusting, but I still like it a lot.
I've had my first encounter with Excel as a young teenager for a simple data entry job. I didn't know more about it than it's what the 'professionals' use and that I wanted to be proficient in it.
Fast forward a few years, during my studies I had three courses on Excel, VBA and VB and was an outlier my class for those courses for simply 'getting it' and even making this the subject of one of my project works.
What used to be merely a tool for getting the work done, gradually turned into my main occupancy: Creating worksheets and formula for calculations and workflows to be used by my colleagues and me for the job, then creating an Excel AddIn for various tasks.
Followed by moving Excel data silos (mainly lookup / reference data) into a DB and access via DAO and later ADO, as well as creating data reports for higher level business decisions.
In regards to Access, I've got several years of experience on the SQL/data side with so far just a small application for maintenance / updating of the migrated data.
Now I'm in the process of creating my first 'proper' application to be used by the team.
This includes restructuring & migrating several Excel data silos into the DB, as well as creating the UI to access and alter the data.
Our work is in a rather small, highly regulated niche. We do have SAP as well, but only for the likes of HR and accounting.
Besides my obvious 'hammers' Excel, VBA, SQL and Access DB design & UI, I like to add more into my toolbox. My regex hammer is already rusting, but I still like it a lot.
