Cinque Terre
Thomas K.

Excel & WordPress expert: VBA macro automation, Power BI, WooCommerce

Knoxville, Knoxville, United States
$ 22/hr


0 Jobs completed
Hire to work


Search for others


Excel & WordPress expert: VBA macro automation, Power BI visualization, WooCommerce I'm a skilled Excel VBA programmer and web developer & designer with 15 years of experience. I graduated with highest honor from the College of Engineering at the University of Michigan. I've worked for Fortune Global 500 companies as well as start-ups. My experience spans diverse industries including ecommerce, retail, technology, chemical, automotive, pharma and nutrition, logistics, oil & gas, marketing and advertising. My expertise: ++ VBA / VB Macro Development for MS Office Excel, Word, PowerPoint, Access I perform task automation, data manipulation and visualization using VBA, macros, Visual Basic, formulas. * Automate repetitive tasks in Excel and Word * Design userforms with advance controls to manage data inputs into Excel spreadsheets and databases * Transform Excel files into various formats (CSV, txt, etc.) and vice versa * Develop robust, stand-alone Excel and Word desktop applications * Build Excel dashboards and visualizations using PivotTables, slicers, graphs, charts, tables, dropdowns, controls * Create Excel calculators of any complexity * Develop spreadsheets to track inventory, manage operations, etc. * Programmatically transfer data between Word and Excel * Auto-generate Word and PDF documents from Excel * Design fillable Word forms * Convert Excel calculators to web-based ++ QuickBooks Data Import and IIF File Creation I have experience in converting Excel and CSV files into IIF format for importing into QuickBooks. I create Excel VBA programs that can take transaction data from various sources, aggregate and manipulate the data, and generate an iif file for quick, easy upload into QuickBooks, saving a tremendous amount of time spent on manual entries. ++ Power BI Desktop & Power BI Service As an extension to my Excel VBA expertise, I'm also trained in Microsoft Power BI, a powerful tool to analyze, visualize and share data insights and business intelligence. * Build visual and interactive reports * Build interactive dashboards and drill-downs * Connect to variety of external and on-premise data sources including Excel, CSV, databases (Access, SQL, ERP, etc.) * Manipulate data * Schedule data refreshes * Share dashboards, view data on mobile * Query data using natural language and Power query (M) * Create measures using Data Analysis Expressions (DAX) ++ Web development and web design for WordPress CMS and WooCommerce e-commerce websites I've helped launch many online stores, blogs and websites from the ground up. I have expertise in PHP, HTML, CSS, JQuery, Javascript. * Design and develop responsive, mobile-friendly websites and blogs from conception to launch * Fully configure WooCommerce including products, shipping and payment methods * Integrate social media into website or blog * Design landing page/splash page * Maintain and update website content and design * Troubleshoot theme and plugin issues * Design graphics, incorporate stock photos, Photoshop * Move sites to new host or URL * Implement SEO best practices * Design banner/button ads * Implement third party services such as CDN, Google Analytics * Build membership sites, photo galleries * Assist in all phases of website creation including -- domain name registration -- hosting recommendations -- DNS name server set up -- cPanel configuration -- FTP setup -- WordPress content management system and WooCommerce shopping cart installation

Work History & Feedback

No Content Found


No Content Found

Trusted Site Seal