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.
Responsibilities
- Review the course manuscript to determine where hands‑on Excel activities should be placed within each lesson
- For each activity, produce a complete package that includes:
- An Excel workbook (starter file and solution file) that reflects realistic business finance scenarios
- Step‑by‑step written instructions for students on how to complete the activity in Excel 365
- A 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 results
- Designed 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 protection
- Performing 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 functions
- Performing 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 Excel
- Creating 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)
Skills
- Expert‑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 benchmarks
- Strong working knowledge of financial metrics, pricing analysis, key financial ratios, and time‑value‑of‑money concepts implemented with Excel functions
- Strong working knowledge of loan modeling in Excel: payment calculations, loan values using financial functions, amortization schedules, and loan scenario analysis
- Strong working knowledge of investment modeling in Excel: calculating bond prices and yields using financial functions and building stock valuation models
- Strong 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 tools
- Strong working knowledge of dashboard and chart creation for financial KPIs, including identifying and correcting chart errors and improving accessibility and usability
- Experience 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 videos
- High attention to detail and accuracy in formulas, calculations, financial logic, and presentation
Benefits
- Competitive salary
- Flexible schedule
- Opportunity for advancement
Company Overview
We 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/.