Microsoft Excel Visual Basic for Applications | ProSidian Consulting, LLC | Remote (United States) ID-16085

May 27, 2025

ProSidian Seeks a Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020] – DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Key Personnel | Analyst 4 Labor Category – High Level Exempt [1099] Professional aligned under services related to NAICS: 541611 – DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis located CONUS: Washington, DC | Reston, VA | Memphis, TN | Raleigh, NC | Charlotte, NC Across The South East Region supporting responsible for overseeing farming, ranching, and forestry industries, as well as regulating aspects of food quality and safety and nutrition labeling.

Other Jobs You May Be Interested In

Seeking Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist candidates with relevant Agriculture And Food Sector Experience (functional and technical area expertise also ideal) to support professional services engagement for Agriculture And Food Sector Clients such as USDA. This as a Technical Element or Contract W-2 (IRS-1099) Position and ProSidian reserves the right to convert to a Full-Time ProSidian employed W-2 Position.

JOB OVERVIEW

Provide services and support as a Information Technology Center Support (Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist) in the Agriculture And Food Industry Sector focussing on IT Effectiveness Solutions for clients such as United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T] Generally Located In CONUS: Washington, DC | Reston, VA | Memphis, TN | Raleigh, NC | Charlotte, NC and across the South East Region.

RESPONSIBILITIES AND DUTIES – Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020]

Develop and deliver training on Expert Microsoft Excel with Visual Basic for Applications (VBA), including complex automation tasks. Create VBA macros, custom Excel functions, and automated workflows. Lead hands-on training sessions for advanced Excel users.

Requirements

Desired Qualifications For Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist | Excel Spreadsheet Modernization [USDA015020] (USDA015020) Candidates:

Proficiency in Advanced Microsoft Excel features (Power Query, Power Pivot, Macros) and advanced VBA programming for automation. Expertise in developing custom Excel solutions and delivering technical training.

Job Title: Microsoft Excel Visual Basic for Applications [VBA] Developer and Training Specialist

Labor Category: Microsoft Excel Automation Specialist

This role combines expertise in Advanced Microsoft Excel features, VBA programming, and training delivery, ensuring the individual can not only develop complex VBA solutions but also effectively teach others how to leverage advanced Microsoft Excel functionalities and automation. The Microsoft Excel Automation Specialist category reflects the advanced technical skills required for VBA programming and Microsoft Excel automation, as well as the ability to conduct high-level training.

To fulfill the technical requirements for the specified Course: Expert Microsoft Excel with Visual Basics training courses, each course would require specific labor categories, expertise, skillsets, certifications, and experience.

Expert Microsoft Excel with Visual Basics (Item No.: 35)

— Labor Category: Microsoft Excel Automation Specialist, Visual Basic for Applications [VBA] Developer, Data Analyst, Training Specialist

Expertise:

— Proficiency in Advanced Microsoft Excel features, including Power Query, Power Pivot, Advanced Formulas, and Macros.

— Strong understanding of VBA programming for automating complex tasks such as dynamic reporting, data cleaning, and form development in Microsoft Excel.

— Experience with creating Custom Microsoft Excel Functions, User Forms, and complex data automation through VBA.

Skillsets:

— Proficiency in writing, debugging, and optimizing VBA code.

— Expertise in teaching advanced Microsoft Excel functionalities, including the creation and management of Microsoft Excel dashboards, automated reports, and complex workflows.

— Ability to guide users through hands-on exercises in VBA development.

Certifications:

— Microsoft Office Specialist (MOS) Microsoft Excel Expert Certification – Required for advanced and intermediate courses.

— Microsoft Office Specialist (MOS) Microsoft Excel Expert.

— Advanced VBA Certification or significant demonstrated experience with Visual Basic programming – Preferred for the expert-level course.

Experience:

— 5+ years of experience working with Advanced Microsoft Excel and VBA scripting.

— Demonstrated ability to automate processes using VBA for real-world applications.

— Proven track record of conducting Expert Microsoft Excel and VBA training for technical and non-technical audiences.

— Experience in delivering corporate or government training on Microsoft Excel, with a proven ability to engage learners and customize the course content to meet specific organizational needs.

Education / Experience Requirements / Qualifications

Bachelor’s degree in Business, IT, or related field. 5+ years of experience working with advanced Excel and VBA development. Proven ability to automate real-world applications and conduct corporate or government training.

Skills Required

Proficiency in VBA code writing, debugging, and optimization. Expertise in creating custom functions, Excel dashboards, and automating reports. Strong ability to guide users in VBA development exercises.

Competencies Required

Strong communication and instructional skills. Ability to translate complex VBA concepts into understandable lessons for diverse learners. Ability to manage time and prioritize training objectives.

Ancillary Details Of The Roles

Experience delivering advanced Excel training in a corporate or government environment. Ability to manage multiple training sessions while maintaining engagement and content quality.

Familiarity with training methodologies and the use of modern technologies for delivering technical content. Proven ability to balance technical content with practical instructional delivery.

Other Details

This role is critical for training users in advanced Excel and VBA automation, ensuring they can streamline workflows and improve productivity. The role requires both technical development skills and instructional expertise.

#VBATraining #ExcelAutomation #ExcelMacros #AdvancedExcel #ExcelVBA #TrainingSpecialist #VBADeveloper #MicrosoftExcel #MOSCertification

Additional information

CORE COMPETENCIES

Teamwork – ability to foster teamwork collaboratively as a participant, and effectively as a team leader
Leadership – ability to guide and lead colleagues on projects and initiatives
Business Acumen – understanding and insight into how organizations perform, including business processes, data, systems, and people
Communication – ability to effectively communicate to stakeholders of all levels orally and in writing
Motivation – persistent in pursuit of quality and optimal client and company solutions
Agility – ability to quickly understand and transition between different projects, concepts, initiatives, or work streams
Judgment – exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramifications
Organization – ability to manage projects and activity, and prioritize tasks

———— ———— ————

OTHER REQUIREMENTS

Business Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.
Business Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.
Commitment – to work with smart, interesting people with diverse backgrounds to solve the biggest challenges across private, public and social sectors
Curiosity – the ideal candidate exhibits an inquisitive nature and the ability to question the status quo among a community of people they enjoy and teams that work well together
Humility – exhibits grace in success and failure while doing meaningful work where skills have impact and make a difference
Willingness – to constantly learn, share, and grow and to view the world as their classroom

———— ———— ————

BENEFITS AND HIGHLIGHTS

At ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. Our team members receive a comprehensive benefits package that includes Competitive Compensation, Group Health Insurance Health Benefits, 401(k) Retirement Savings Plan Contributions, Vacation and Paid Time off (PTO) Benefits, Pre-Tax Payment Programs, Purchasing Discounts & Savings Plans, a ProSidian Employee & Contractor Referral Bonus Program, Performance Incentives, etc. Our comprehensive benefits package includes a medical, dental and vision plan. Our growing list of benefits currently include the following:

Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level (Tier 1) Group Medical Benefits, Pretax Employee Benefit Plan, plus performance incentives
Group Health Insurance Health Benefits: Group Health Insurance Including Medical, Dental And Vision Insurance: Contributions are deducted from pay on a Pretax basis – Employee and family coverage is available with employer contribution of 50% of Employee (only) premiums under the Health and Vision Plan through Blue Cross Blue Shield NC (Blue Options Medical Plan Code: PB07840 / Metallic Level: Gold – – bcbsnc.com‎) and Dental Plan (Ameritas – www.ameritas.com).
401(k) Retirement Savings Plan: 401(k) Retirement Savings Plans help you save for your retirement. Eligible employees can make before-tax contributions to the 401(k) Retirement Savings Plan to help you save for retirement. Contributions are deducted from pay on a pretax basis. A wide range of investment options are available with a personal financial planner available to assist you. The Plan is a Safe Harbor 401(k) Retirement Savings Plan.
Vacation And Paid Time Off (PTO) Benefits: The flexibility of Paid Time Off (PTO) lets you set your own priorities. Eligible employees use PTO for vacation, a parent-teacher conference, a doctor’s appointment, or any number of events in your life. Currently these benefits include Vacation/Sick days – 2 weeks | Holidays – 10 Federal Government.
Pre-Tax Payment Programs: Pre-Tax Payment Programs currently exist in the form of a Premium Only Plan (POP). These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees.
Purchasing Discounts & Savings Plans: We want you to achieve financial success. We offer a Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program – Helping You Do More With Less: https://ProSidian.CorporatePerks.com. This provides special discounts for eligible employees on products and services you buy on a daily basis.
Security Clearance: Due to the nature of our management and operations consulting engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes; oftentimes there are Security Clearance requirements for Engagement Teams handling sensitive Engagements in the Federal Marketplace. A Security Clearance is a valued asset in your professional portfolio and adds to your credentials based on past, present, and future work.
Leverageable Experience and Thought Leadership: By collaborating with firm leadership, other members of the team, as well as Fellows and collaborating partners in what is a flat organization, you’ll make valuable professional connections, interact with clients daily, gain leverageable Experience, and contribute to Thought Leadership while you build a basket of marketable experiences.
ProSidian Employee & Contractor Referral Bonus Program: ProSidian Consulting will pay up to $5k for all referrals (payments made after new hire has been employed for 90 days) for candidates submitted through our Employee Referral Program.
Performance Incentives: Due to the nature of our management and operations consulting engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes there are performance incentives associated with each new client that each employee works to pursue and support.
Flexible Spending Account: Pending

———— ———— ————

ADDITIONAL INFORMATION – See Below Instructions On The Best Way To Apply

ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor. All your information will be kept confidential according to EEO guidelines.
ProSidian Consulting has made a pledge to the Hiring Our Heroes Program of the U.S. Chamber of Commerce Foundation and the “I Hire Military” Initiative of The North Carolina Military Business Center (NCMBC) for the State of North Carolina. All applicants are encouraged to apply regardless of Veteran Status.
Furthermore, we believe in “HONOR ABOVE ALL” – be successful while doing things with the right way. The pride comes out of the challenge; the reward is excellence in the work. FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON http://www.ProSidian.com/ OR SEND YOUR RESUME’S, BIOS, AND SALARY EXPECTATION / RATES TO CAREERS @ PROSIDIAN.COM. ONLY CANDIDATES WITH REQUIRED CRITERIA ARE CONSIDERED. Be sure to place the job reference code in the subject line of your email. Be sure to include your name, address, telephone number, total compensation package, employment history, and educational credentials.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...