Basic and financial accounting concepts will be utilized to assist the students to acquire the knowledge to achieve their objectives. Concepts and topics includes but not limited to: The Accounting Process, The Balance Sheet, The Income Statement and Statement of Cash Flows, Profiatbility Analysis, Time Value of Money, Inventories, Property Plant and Equiptment, Intangible Assets, Investment, Current & Longterm Liabilities, Bonds, Accounting for Income Taxes, Pensions, Shareholders' Equity, Accounting for Changes & Erros and Leases.
The objective is to use the Advance Functions in Excel to perform Financial, Business and Data Analysis. The Focus will on the following but not limited to: Creating Formulas, Using Functions, Creating Conditional Formulas, Retrieval of Row & Column Figures, Using VLOOKUP, Using Financial Functions, Rate of Returns, Depreciation, Present & Future Values, Using Statistical Functions & Tools, Organizing Worksheet Data, Custom Sort, Complex Filters, Using PivotTables, Charting Data, Working Data, Using Data Analysis Tools & Techniques, Working with External Data, Automating with Macros, Importing a Database, Performing "What-If Analysis", Optimizing Goal Seek, and Using Solver.
There are three main reasons to study economics, which are (1) to help one understand the world (2) to become a better active citizen in the economy and (3) to gain a better understanding of the potential and limitation of of certain economic polices, at least on the macro level. Therefore, it is my objective to utilize my expertise to assist students by way of explaining the various economic concepts and theories in a manner that will be easily understood. Areas of concentration includes but not limited to: macroeconomics, microeconomics and money and banking. Concepts include but are not limited to The Principles of Ecomonics, The Circular Flow Model, how Markets work, Principle Comparative Advantage, Markets and Competition, Elasticities, Competition vs Monopoly, Market Efficiency, Demand Concepts and analyses, International Trade, Analysis of Macroeconomic Data, GDP - Real vs Nominal, Long Run and Short Run Equilibrium, the role of Financial Institutions, the Federal Reserve and the Banking System Demand and Supply of Funds, Aggregate Demand and Aggregate Supply in the long run, Monetary Theory and Growth and Inflation.
The focus here is to assist the student in the a general overview of Excel an it's various uses. This includes but not limited to: Tour of the Excel Window, Exploring the Ribbon, Using the Mini Toolbar, Entering Data, Uploading Files, Formatting Cells & Numbers, Adding Borders, Adding Background Color, Hide Columns & Row, Aligning Data, Cut, Copy & Paste, Find & Replace, Move & Copy Worksheets, Freeze Worksheet Titles, Understanding Formulas, Linking Worksheets, and Creating Basic Formulas.
As a Certified QuickBooks ProAdvisor I will utilize my expertise in the various aspect of the Quickbooks programs to assist students in reaching their required knowledge base. Topics will include but not limited to: determining the correct version of QuickBooks to use, setting up QuickBooks file for the first time, setting-up users, passwords and preferences, setting-up customers & vendors, the connections between lists and the chart of accounts, setting-up payroll, correcting errors, recording various transactions, A/R, A/P, job costing, banking overview, reporting in QuickBooks, resolving issues between reports, year-end procedures, processing payroll, importing & exporting data, troubleshooting & special consideration and analysis and reconciliations.