Mastering Employment Skills Power SuiteMastering Employment Skills Power Suite DVD-ROM Self-Study Training Course Product Name: Mastering Employment Skills Power Suite Manufacturer: TeachUcomp, Inc. Versions Covered: Microsoft Office: 2010 & 2007 | QuickBooks: 2013 through 2004 Course Length: 36 Hours Video Lessons: 869 Instruction Manuals: 10 (PDF) Included Courses: Accounting, Excel, Outlook, QuickBooks and Word Learn the skills you need to be competitive in today’s job market. We combined five our most popular courses that are essential skills everyone should know. Learn QuickBooks 2012, Microsoft Excel, Word and Outlook 2010 and Introductory Accounting with this comprehensive course from TeachUcomp, Inc. Mastering Employment Skills Made Easy features 869 video lessons with over 36 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our ten printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises. This course will empower you with the knowledge and skills necessary to be a proficient user in critical applications. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply insert the DVD-ROM into your computer to launch the easy-to-use interface, click to launch a video lesson or open one of the manuals and you’re on your way. This course also includes bonus material for Excel, Outlook and Word versions prior to 2010. Accounting Topics Introduction and Overview 1. Introduction to Accounting 2. Why Do I Need to Know Accounting? 3. Who Needs to Know Accounting? 4. Types of Businesses 5. Financial Statements What is Accounting? 1. Accounting vs. Bookkeeping 2. Accounting Methods 3. The Tax Year 4. Chart of Accounts Asset Accounts 1. Assets 2. Cash Accounts 3. Accounts Receivable 4. Inventory 5. Notes Receivable 6. Other Current Assets 7. Fixed Assets 8. Intangibles Liability and Equity Accounts 1. Liabilities 2. Accounts Payable 3. Accrued Expenses Payable 4. Notes Payable 5. Long-Term Liabilities 6. Officer Loans 7. Contingent Liabilities 8. Equity Income and Expense Accounts 1. Income Accounts 2. Expense Accounts Keeping Good Records 1. Keeping Good Records 2. Accurately Pricing Products and Services 3. Understanding Profit & Loss 4. Understanding Cash Flow 5. Working with Bankers 6. Understanding and Paying Taxes Accounting Basics 1. Identifying Expenses 2. The Double-Entry System 3. Double-Entry Accounting in Common Software The Accrual Principle 1. Understanding the Accrual Principle 2. Accrued Expenses and Accrued Liabilities 3. Accrued Revenues 4. The Matching Principle 5. Adjusting Entries Accounts Receivable 1. Accounts Receivable 2. Bad Debt Accounts Payable 1. Accounts Payable 2. Early Payment Discounts Making Basic Purchases 1. Making Purchases with Check, Cash or Credit Basic Banking 1. Making Deposits and Transfers 2. Reconciling Bank Accounts Fixed Assets 1. Depreciation 2. Selling a Fixed Asset Payroll 1. What is Needed to Start a Payroll? 2. Payroll Taxes 3. Payroll Tax Liabilities Financial Statements 1. Financial Statements 2. The Profit and Loss Statement 3. The Balance Sheet 4. The Statement of Cash Flows 5. Paper Trails, Audit Trails and Audit Reports 6. How Long Do I Need to Keep Records? 7. Prepare for Year-End Budgets 1. Why Create a Budget? 2. Budget Basics Financial Ratios and Quality Indicators 1. Financial Ratios and Quality Indicators 2. Liquidity 3. Safety 4. Profitability 5. Efficiency Where to Get Help 1. Where to Get Help 2. Finding an Accountant 3. www.irs.gov 4. Available Software 5. Small Business Administration 6. Small Business Associations Microsoft Excel Topics Getting Acquainted with Excel 1. The Excel Environment 2. The Title Bar 3. The Menu Bar 4. The Standard Toolbar 5. The Formatting Toolbar 6. The Ribbon 7. The File Tab and Backstage View 8. The Microsoft Office Button 9. The Quick Access Toolbar 10. Scroll Bars 11. The Formula Bar 12. The Workbook Window 13. The Status Bar 14. The Task Pane 15. The Mini Toolbar Creating Basic Spreadsheets 1. Creating a New Workbook 2. Saving Workbooks 3. Closing Workbooks 4. Opening Workbooks 5. Selecting Cells 6. Entering Text Into Cells 7. Entering Numbers Into Cells 8. AutoComplete 9. Pick From List 10. Using the "Window" Command Group 11. Zooming the Spreadsheet 12. Managing Multiple Workbooks 13. Renaming Workbooks 14. Working with Excel File Formats Using Ranges 1. Using Ranges 2. Selecting Ranges 3. Selecting Multiple Non-Adjacent Ranges 4. Entering Information Into a Range 5. Using AutoFill Creating Formulas 1. Using Formulas 2. Formula Functions 3. Using AutoSum 4. Inserting Functions 5. Editing a Range 6. Using the Formula Palette 7. Using the Paste Function 8. Editing a Range 9. Formula AutoCorrect 10. AutoCalculate Copying & Pasting Formulas 1. Absolute References and Relative References 2. Cutting, Copying & Pasting 3. AutoFilling Cells 4. Drag & Drop Cutting, Copying & Pasting 5. Using Undo 6. Using Redo Columns & Rows 1. Selecting Columns & Rows 2. Changing Column Width & Row Height 3. AutoFitting Columns & Rows 4. Hiding/Unhiding Columns & Rows 5. Inserting & Deleting Columns & Rows Formatting Spreadsheets 1. Using the Formatting Toolbar 2. Using the Format Cells Dialog Box 3. The Number Tab 4. The Alignment Tab 5. The Font Tab 6. The Border Tab 7. The Patterns Tab 8. Clearing All Formatting from Cells 9. Copying All Formatting from Cells to Another Area Conditional Formatting & AutoFormatting 1. Conditional Formatting 2. AutoFormatting Setting Spreadsheet Layout 1. Working with Page Breaks 2. Viewing the Header and Footer 3. The Page Setup Dialog Box Printing Spreadsheets 1. Using Print Preview View 2. Printing Your Spreadsheet Helping Yourself 1. Using Screen Tips 2. Using the Office Assistant 3. Using the Help Pane Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Moving to a Named Range 3. Using Named Ranges in Formulas 4. Creating Names from Headings 5. Deleting Range Names Spreadsheet Tools 1. Moving between Spreadsheets 2. Selecting Multiple Spreadsheets 3. Inserting and Deleting Spreadsheets 4. Renaming Spreadsheets 5. Coloring Spreadsheet Tabs 6. Switching to Full Screen View 7. Splitting the Screen 8. Freezing Panes 9. Copying and Moving Entire Worksheets 10. Cutting, Copying and Pasting Data between Spreadsheets 11. Printing Multiple Spreadsheets 12. Hiding Spreadsheets Using Workspaces 1. Creating Workspaces 2. Opening and Closing Workspaces 3. Selecting Workbooks in a Workspace 4. Organizing a Workspace Paste Special 1. Paste Special Options 2. Pasting Linked Formulas Sharing and Reviewing Workbooks 1. Sharing Workbooks 2. Highlighting Changes 3. Reviewing Changes 4. The Reviewing Toolbar 5. Inserting Comments 6. Managing Comments 7. Reviewing Comments 8. Printing Comments 9. Sending Spreadsheets for Review 10. Compare and Merge Workbooks Auditing Spreadsheets 1. Auditing Spreadsheets 2. The Formula Auditing Toolbar 3. Tracing Precedent and Dependent Cells 4. Tracing Errors 5. Error Checking 6. Using the Watch Window 7. Cell Validation Outlining Spreadsheets 1. Using Outlines 2. Applying and Removing Outlines Consolidating Spreadsheets 1. Using Data Consolidation 2. Consolidation Types Creating Spreadsheet Charts 1. Creating Charts 2. Moving and Resizing Charts 3. The Chart Toolbar 4. Formatting Chart Objects 5. Changing the Chart Type 6. Showing and Hiding the Legend 7. Showing and Hiding the Data Table 8. Shifting the Data Series 9. Angling Chart Text 10. Choosing a Chart Layout 11. Choosing a Chart Style 12. Printing Charts 13. Deleting Charts Editing and Formatting Charts 1. Changing Chart Sub-types 2. Changing the Data Range 3. Changing Chart Titles 4. Repositioning the Legend 5. Adding Data Labels 6. Adding Free-standing Text 7. Time-Scale Data Plotting 8. Formatting a Data Series 9. Changing the Data Series Plot Order 10. Chart A
