Microsoft Excel Automation / Visual Basic for Applications [VBA] Training Specialist | Excel Spreadsheet Modernization [USDA014019]

Microsoft Excel Automation / Visual Basic for Applications [VBA] Training Specialist | Excel Spreadsheet Modernization

ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Enterprise Service Solutions for Risk Management | Compliance | Business Process | IT Effectiveness | Engineering | Environmental | Sustainability | and Human Capital. We help forward-thinking clients solve problems and improve operations.

Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals globally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies. Our solution-centric services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies, and people delivering value.

ProSidian clients represent a broad spectrum of industries including but not limited to Aerospace And Telecommunications | Consumer Products, Services, And Retail | Development And Sustainability | DOD/Military | Energy, Resources, & Industrials | Financial Services | Government & Public Services | Information Technology, Media, And Telecommunications | Life Sciences & Health Care | Manufacturing And Operations | Nuclear and Environmental | Professional Services, etc.

Job Description

ProSidian Seeks a Microsoft Excel Automation / Visual Basic for Applications [VBA] Training Specialist | Excel Spreadsheet Modernization - 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.

Seeking Microsoft Excel Automation / Visual Basic for Applications [VBA] 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 Automation / Visual Basic for Applications [VBA] 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 Automation / Visual Basic for Applications [VBA] Training Specialist | Excel Spreadsheet Modernization [USDA014019]

Conduct Intermediate Microsoft Excel with Visual Basic for Applications (VBA) training sessions, teaching both manual processes and VBA automation. Develop training materials and guide learners through creating macros for data automation, report generation, and formatting.

Qualifications

Desired Qualifications For Microsoft Excel Automation / Visual Basic for Applications [VBA] Training Specialist | Excel Spreadsheet Modernization [USDA014019] Candidates:

Proficiency in Intermediate Microsoft Excel and basic VBA scripting. Expertise in teaching Excel data analysis, automating tasks using VBA, and guiding students through macro development.

Job Title: Microsoft Excel Automation Training Specialist

Labor Category: Microsoft Excel Automation Specialist

This role encompasses both teaching expertise and technical skills in Intermediate Microsoft Excel and basic VBA scripting, which are necessary for guiding learners through Microsoft Excel processes and VBA automation. The Microsoft Excel Automation Specialist category reflects the dual focus on both Microsoft Excel proficiency and VBA macro development, making it ideal for delivering this course.

To fulfill the technical requirements for the specified Course: Intermediate Microsoft Excel (with intro to Visual Basic for Applications [VBA])

Course: Expert Microsoft Excel with Visual Basics training courses, each course would require specific labor categories, expertise, skillsets, certifications, and experience.

Intermediate Microsoft Excel with Introduction to Visual Basic for Applications [VBA] (Item No.: 34)

--- Labor Category: Microsoft Excel Automation Specialist, Data Analyst, Training Specialist

Expertise:

--- Proficiency in Intermediate Microsoft Excel features, including PivotTables, Data Validation, Advanced Formulas, and Conditional Formatting.

--- Basic understanding of VBA (Visual Basic for Applications), including recording and editing macros.

--- Knowledge of Macro automation and basic scripting for repetitive tasks in Microsoft Excel.

Skillsets:

--- Ability to write and edit VISUAL BASIC FOR APPLICATIONS [VBA] macros for common tasks such as automating data entry, creating dynamic reports, and formatting.

--- Teaching skills in guiding students through both manual Microsoft Excel processes and basic VISUAL BASIC FOR APPLICATIONS [VBA] scripting.

Certifications:

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

--- Familiarity or certification in VISUAL BASIC FOR APPLICATIONS [VBA] scripting (preferred).

Experience:

--- 3+ years of experience with Intermediate Microsoft Excel and basic VISUAL BASIC FOR APPLICATIONS [VBA] automation Training.

--- Experience developing custom macros and conducting Microsoft Excel with VISUAL BASIC FOR APPLICATIONS [VBA] training for users unfamiliar with programming.

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

Education / Experience Requirements / Qualifications

Bachelor's degree in Business, IT, or related field. 3+ years of experience teaching Microsoft Excel and VBA in a corporate or government setting. Proven ability to customize training for various audiences.

Skills Required

Strong knowledge of Excel PivotTables, Advanced Formulas, Conditional Formatting, and VBA macro development. Ability to troubleshoot VBA scripts and guide learners through hands-on exercises.

Competencies Required

Excellent communication and instructional skills, with the ability to simplify technical concepts for learners at different levels. Ability to manage time effectively and ensure successful delivery of training sessions.

Ancillary Details Of The Roles

Experience working in a training environment that includes VBA scripting and automation. Ability to manage multiple training sessions while maintaining quality and engagement.

Familiarity with using training technologies and methodologies to improve engagement and learning outcomes. Proven ability to handle both technical content and instructional delivery effectively.

Other Details

This role is essential for training government and corporate employees in Excel automation and VBA programming, helping them streamline workflows and improve productivity.

#ExcelAutomation #VBATraining #IntermediateExcel #MicrosoftExcel #ExcelMacros #TrainingSpecialist #VBA #DataAutomation #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