ProSidian Consulting, LLC
Microsoft Excel Automation / Visual Basic for Applications [VBA] Training Specia
ProSidian Consulting, LLC, Charlotte, NC, US
Job Description
Job Description:\n\nCompany Description 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. Learn More About ProSidian Consulting at https://www.prosidian.com.Job Description ProSidian Seeks a Microsoft Excel Automation / Visual Basic for Applications [VBA] Training Specialist | Excel Spreadsheet Modernization [USDA014019] - 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] (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 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. 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 #MOSCertificationAdditional Information CORE COMPETENCIESTeamwork – ability to foster teamwork collaboratively as a participant, and effectively as a team leaderLeadership – ability to guide and lead colleagues on projects and initiativesBusiness Acumen – understanding and insight into how organizations perform, including business processes, data, systems, and peopleCommunication – ability to effectively communicate to stakeholders of all levels orally and in writingMotivation – persistent in pursuit of quality and optimal client and company solutionsAgility – ability to quickly understand and transition between different projects, concepts, initiatives, or work streamsJudgment – exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramificationsOrganization – ability to manage projects and activity, and prioritize tasks ------------ ------------ ------------ OTHER REQUIREMENTSBusiness 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 sectorsCuriosity – 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 togetherHumility – exhibits grace in success and failure while doing meaningful work where skills have impact and make a differenceWillingness - 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 incentivesGroup 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 ApplyProSidian 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 appl