Mastering Business and Financial Modeling using Excel

Training Provided by Meirc Training and Consulting This program is designed for Business analysts and professionals, supervisors and staff from any function including finance who need to improve their understanding and use of Microsoft Excel as an important tool to produce more effective and efficient work. This program is worth 25 NASBA CPE s.Note: This is a hands-on training program using Laptops/Computers.Use Microsoft Excel in business finance more effectively.Perform analysis and evaluation to assist in enhancing the decision making process. Understand and create pivot tables and pivot charts.Analyze business data in no time.Prepare business and flash reports to senior management.'

Mastering Business and Financial Modeling using Excel Quick Review of Excel Business and Finance FunctionsBusiness WorkspaceConditional and Auto FormattingName RangesScenario Analysis and Formula AuditingGoal Seek and Break-Even AnalysisData Validation and ConsolidationBusiness FormPivot Tables and Pivot ChartsMacrosScenario AnalysisDefining a ScenarioMerging ScenariosMultiple Level ScenariosScenario Spinner and What-If-AnalysisAuditing Your Work in No TimeTrace PrecedentsTrace DependentsEvaluate Business FormulasBusiness and Financial Data ValidationSetting-Up Your Validation RulesSelecting Different Input VariablesUsing Lists to Restrict Data Input to Your Business ModelData ConsolidationUsing Appropriate FunctionSelecting Different ReferencesCreating Source to Consolidated DataPivot Table and Pivot Charts     A Must Learn ToolUsing Your Own DataUsing Your Imported DataUsing Consolidation RangesEnhancing Your Report with Data and Format OptionsMust Tools for Every Business and Finance ProfessionalIF STATEMENTMID, LEFT, RIGHTVALUE, DATE, and TRIMCONCATENATEVLOOKUPIS, and, ORMacros The Ultimate Efficiency ToolPlanning MacrosRecording MacrosEditing Macros'

About The Training Provider: Meirc Training and Consulting

More Finance Accounting Training from Meirc Training and Consulting

• Certified Accounts Assistant
• Certified Accounts Assistant
• Certified Financial Professional
• Certified Fixed Assets Professional
• Certified Fixed Assets Professional
• Chartered Financial Analyst CFA Level 1 Intensive Review
• Corporate Governance Transparency and Accountability
• Cost Management Strategies for Business Decisions
• Effective Budgeting and Cost Control
• Effective Budgeting and Cost Control
• Effective Budgeting and Cost Control
• Effective Budgeting and Cost Control
• Effective Budgeting and Cost Control
• Efficient Finance and Accounting Operations
• Efficient Finance and Accounting Operations
• Efficient Finance and Accounting Operations
• Efficient Finance and Accounting Operations
• Efficient Finance and Accounting Operations
• Fast Closing Monthly and Year-end Accounts
• Finance for Executives
• Finance for Non-Finance Professionals
• Finance for Non-Finance Professionals
• Finance for Non-Finance Professionals
• Finance for Non-Finance Professionals
• Finance for Non-Finance Professionals
• Financial Accounting and Reporting
• Financial Accounting and Reporting
• Generally Accepted Accounting Principles GAAP 2008 Update
• Generally Accepted Accounting Principles GAAP 2008 Update
• Intermediate Accounting Managing Business Transactions
• International Financial Reporting Standards IFRS 2008 Update
• Investment Analysis and Portfolio Management
• Mastering Business and Financial Modeling using Excel
• Mastering Business and Financial Modeling using Excel
• Mastering Business and Financial Modeling using Excel
• Mastering Business and Financial Modeling using Excel
• Principles of Accounting An Introduction to Concepts Uses and Methods
• Principles of Accounting An Introduction to Concepts Uses and Methods
• Professional Skills for Finance and Accounting
• Professional Skills for Finance and Accounting
• Reporting and Presentation Skills for Finance and Accounting Professionals
• The Analysis and Use of Financial Statements A Hands-on Approach