Skill Sets

My Skills

With my expertise in MS Excel and MS Access, I have extensive data collection and data analysis skills to offer.  I also provide customized spreadsheets and charts with Excel or Power BI or personalised database solutions.

Microsoft Excel Skills:

  • Specialization in using ‘Get and Transform Data’ function for data import.
  • Utilization of Power Query Editor for transforming data with ability to create custom columns.
  • Knowledge of tables, charts (pivot and regular), formulas, macros, and Excel VBA.
  • Use of Power Pivot for joining dissimilar tables.
  • Highly skilled in the use of Pivot Tables and Charts.
Microsoft Access Skills:
  • Over 20 years experience working with numerous versions of Access.
  • Specialization in database creation.
  • Table, form, and report creation for data entry and review.
  • Query creation for filtering data.
  • Macro creation for automation.
  • Exportation of data for visualization inside MS Excel or Power BI.
  • Utilization of Access VBA for advanced record manipulation and form creation.
  • Ability to reverse engineer existing databases for repair, modification, or optimization.
  • Capable of using Access as a front end for a MS SQL database structure.
Data Analytics:
  • Over eight years in working as a data collections and data analysis professional.
  • Highly motivated in developing systems to import, blend, clean, and categorize data from multiple sources.  These systems will incorporate the use of MS Access, MS Excel, or a combination of both.
  • The ability to prepare data in a visualized manner to create insights that drive decision making.
Up and Coming.  With the ever advancing state of technology and data analysis, I am always striving to increase my skillsets.  I am currently learning or increasing my knowledge in the following software:
  • MS SQL and Microsoft SQL Server Management Studio.
  • MS Power BI.
  • Python and PyCharm.
  • MS Power Automate.
  • MS PowerShell.