Excel Macros For Dummies
Book image
Explore Book Buy On Amazon
Excel is everywhere. Companies in all types of industries hire Excel analysts to help provide insights and manage data. Knowing how to wrangle data and automate processes with macros will give you an advantage in the marketplace. These ten jobs are just some of hundreds of jobs available in the marketplace for Excel analysts with VBA macro skills.

Accounting specialist

  • Records operating transactions, performs month-end, and prepares financial statements

  • Performs financial and budget analysis by reviewing operating data and assessing historical trends

  • Helps coordinate budgeting and tracks monthly forecasts.

  • Average US salary: $45,000

Marketing analyst

  • Analyzes market penetration and integrates market research with CRM to create new leads

  • Develops customer segmentation models and helps management understand buying habits

  • Analyzes customer survey results and develops customer satisfaction dashboards

  • Average US salary: $55,000

Human resources analyst

  • Analyzes HR data and develops reporting related to time and attendance, attrition, diversity, and recruitment

  • Develops manpower planning models and tracks manpower forecasts

  • Routinely prepares dashboards and reports for quarterly management reviews

  • Average US salary: $65,000

Sales compensation analyst

  • Determines commission payments by analyzing sales transactions as they relate to organizational compensation rules

  • Creates financial reports outlining the actual and projected commission payouts

  • Develops sales incentive models, analyzing costs and advising sales and finance leadership on outcomes

  • Average US salary: $70,000

Supply chain analyst

  • Analyzes procurement and inventory data, ensuring warehouses are prepared for new items and appropriately stocked

  • Analyzes vendor performance and identifies areas of cost savings and improved inventory fill rates

  • Develops reports that track and forecast purchasing and inventory levels

  • Average US salary: $66,000

Investment banking analyst

  • Performs financial modeling and valuation analyses on public and private companies

  • Develops financial and investment models for partners and clients

  • Creates analytical and financial presentations for clients, management teams, and boards of directors

  • Average US salary: $80,000

Business intelligence analyst

  • Work with key personnel to understand business goals and relevant key performance metrics

  • Integrates disparate data sources and creates analytical views that highlight actionable insights

  • Synthesizes data into meaningful dashboards and visual reporting mechanisms

  • Average US salary: $85,000

Statistical analyst

  • Interprets quantitative data and designs statistical models for researching business questions

  • Identifies patterns and relationships in data, giving management insight to previously unseen perspectives

  • Summarizes statistical results into graphics and charts designed to convey results to the management team

  • Average US salary: $77,000

Excel VBA developer

  • Automates existing data integration and transformation processes

  • Conducts the rapid application development for new proof-of-concept solutions

  • Provides change/fix support for existing Excel add-ins and solutions

  • Average US salary: $95,000

Management consultant

  • Routinely conducts analysis on change management, financial performance, business restructuring, and cost management

  • Identifies patterns and relationships in data, giving management insight to previously unseen perspectives

  • Creates analytical and financial presentations for clients, management teams, and boards of directors

  • Average US salary: $120,000

About This Article

This article is from the book:

About the book author:

Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.

This article can be found in the category: