VLOOKUPS + HLOOKUPS, LOOP THROUGH VBA AND FORMAT SPREADSHEETS, VBA CODING, SCATTER PLOTS, CHARTS W// FILTERED DATA, SELECT / JOINS, FLASK, CREATE AGGREGATE QUERIES, CREATE SUBQUERIES, NORMALIZE DATA, IDENTIFY DATA RELATIONSHIPS, CREATE VISUAL REPRESENTATIONS BY USING ERDS, SQLALCHEMY, MONGO DATABASE, PANDAS, JUPYTER NOTEBOOKS, MATPLOTLIBS, NUMPY, REGEX, BEAUTIFULSOUP, WORK WITH JSON AND CSV FILES, API'S, SPLINTER, CREATE DATAFRAMES, CREATE TABLES WITH DATA PROVIDED, FILTER DATA, MODIFY DATA, PREPARE PRESENTATIONS AND EXPLAIN CURRENT TRENDS