[Remote] Future Opening: Microsoft Excel for Business Finance SME Curriculum Development
Note: The job is a remote job and is open to candidates in USA. Moore Solutions, Inc. is seeking a Microsoft Excel for Business Finance Subject Matter Expert (SME) to collaborate with their Curriculum Development Team. The role involves creating skills-based courseware aligned with the Microsoft Office Specialist: Excel for Business Finance certification, focusing on designing lessons and activities that prepare learners for academic success and industry-recognized certification.ResponsibilitiesReview the course manuscript to determine where handsâon Excel activities should be placed within each lessonFor each activity, produce a complete package that includes:An Excel workbook (starter file and solution file) that reflects realistic business finance scenariosStepâbyâstep written instructions for students on how to complete the activity in Excel 365A simple screenârecorded walkthrough of you completing the activity in Excel 365 and explaining the key steps and features (no professional editing required)Clear, highâquality screenshots that show important formulas, tools, and intermediate resultsDesigned activities should directly map to the MOâ230 objective domains, including but not limited to:Preparing financial data for analysis: importing data from various sources, removing duplicates, deleting or hiding rows/columns, formatting for consistency, using text and date functions, and applying Data Validation and protectionPerforming financial analysis: horizontal and vertical analysis, budget vs actual variance, variance vs benchmarks, financial metrics and pricing analysis, financial ratios, and time value of money calculations using Excel formulas and functionsPerforming loan and investment analysis: calculating loan values with financial functions, building loan amortization schedules, analyzing loan scenarios, calculating bond prices and yields, and creating stock valuation models in ExcelCreating financial forecasts: analyzing historical data using formulas, creating Forecast Sheets, applying growth rates, projecting interest payments and cash budgets, and using WhatâIf Analysis tools (Goal Seek, Data Tables, Scenario Manager)SkillsExpertâlevel proficiency with Microsoft Excel 365, specifically applied to business finance (not just general spreadsheet use)Strong working knowledge of financial statement analysis, including horizontal analysis, vertical analysis, budget vs actual variance, and variance against benchmarksStrong working knowledge of financial metrics, pricing analysis, key financial ratios, and timeâvalueâofâmoney concepts implemented with Excel functionsStrong working knowledge of loan modeling in Excel: payment calculations, loan values using financial functions, amortization schedules, and loan scenario analysisStrong working knowledge of investment modeling in Excel: calculating bond prices and yields using financial functions and building stock valuation modelsStrong working knowledge of forecasting and projections: analyzing historical data, using Forecast Sheet, applying growth rates, projecting interest and cash budgets, and using WhatâIf Analysis toolsStrong working knowledge of dashboard and chart creation for financial KPIs, including identifying and correcting chart errors and improving accessibility and usabilityExperience teaching or developing curriculum for business, finance, accounting, or financial modeling (Kâ12, Higher Ed, or professional education)Proven ability to explain complex financial concepts clearly using written instructions, visuals, and short videosHigh attention to detail and accuracy in formulas, calculations, financial logic, and presentationBenefitsCompetitive salaryFlexible scheduleOpportunity for advancementCompany OverviewWe offer hands-on, instructor-led training to anyone interested in continuing education or just looking for quality computer training. It was founded in 1996, and is headquartered in Port St Lucie, Florida, US, with a workforce of 11-50 employees. Its website is https://gomsi.net/.