# IT and Desktop Videos

Select a category

## Business Skills for IT Professionals (15)

Title Speaker Summary ID
Minitab 16: Assessing Process Capability Wesley Miller In Minitab 16; you can carry out process Capability Analysis by calculating the process; performance capability indicators; and indices of a given process. In this video; Wesley Miller demonstrates how to use Minitab 16 to obtain a process capability report using a sample data set. 55262
Minitab 16: Conducting a Normality Test Wesley Miller In Minitab 16; you can perform Normality tests to determine how well a given data set fits a normal distribution model. In this video; Wesley Miller demonstrates how to carry out a Normality test on a sample data set in Minitab 16. 55263
Minitab 16: Conducting a One-Way ANOVA Test Wesley Miller In Minitab 16; One-Way ANOVA tests are used to observe how the means of two or more groups of data vary with each other. In this video; Wesley Miller discusses how to conduct a One-Way ANOVA test by using a sample data set. 55255
Minitab 16: Conducting a Two-Sample T-Test Wesley Miller In Minitab 16; T-Tests are used to determine whether the statistical difference between two normally distributed variables is significant. In this video; Wesley Miller discusses how to conduct a Two-Sample T-Test on a sample data set. 55259
Minitab 16: Conducting a Two-Way ANOVA Test Wesley Miller In Minitab 16; you can conduct a Two-Way ANOVA test to measure the significant effect of multiple independent variables; in addition to multiple observations for each independent variable. In this video; Wesley Miller discusses how to conduct a Two-Way ANOVA test and analyze the results by using a sample data set. 55260
Minitab 16: Conducting an ANOVA Test Using the General Linear Model Wesley Miller In Minitab 16; you can use the General Linear Model for conducting an ANOVA test when the data is unbalanced and/or when multiple comparisons are required. In this video; Wesley Miller explains how to use the General Linear Model to conduct a Two-Way ANOVA test. 55254
Minitab 16: Creating an X-bar Chart with R Chart Wesley Miller In Minitab 16; an X-bar and R Chart pair is a control chart that is used to monitor process; mean; and standard deviation when the process sample size is less than 10 samples. In this video; Wesley Miller discusses how to generate an X-bar and R Chart pair. 55257
Minitab 16: Creating an X-bar Chart with S Chart Wesley Miller In Minitab 16; an X-bar and S Chart pair is a control chart that is used to monitor process; mean; and standard deviation when samples are collected at regular intervals and the sample size is greater than 10 samples. In this video; Wesley Miller discusses how to generate an X-bar and S Chart pair. 55258
Minitab 16: Exporting Data Columns to a File Wesley Miller Minitab 16 allows users to export data in select columns to external applications. In this video; Wesley Miller explains how to export select columns of data from a Minitab worksheet to an Excel spreadsheet. 55252
Minitab 16: Exporting Data to a File Wesley Miller Minitab 16 allows users to export data to external applications. In this video; Wesley Miller explains how to export Minitab data to a Microsoft Excel spreadsheet. 55250
Minitab 16: Generating a P-Chart Wesley Miller In Minitab 16; P-Charts are used to observe the proportion of nonconforming or defective items in a given test sample. In this video; Wesley Miller discusses how to generate a P-Chart for monitoring the proportion of defective items in several separate test cases. 55256
Minitab 16: Importing Data from Excel Wesley Miller Minitab 16 allows users to import external data and conduct additional statistical analysis. In this video; Wesley Miller explains how to import an Excel spreadsheet into a Minitab project. 55251
Minitab 16: Obtaining Descriptive Statistics Wesley Miller Minitab 16 allows users to obtain basic statistical information for a given data set. In this video; Wesley Miller explains how to obtain basic descriptive statistics. 55253
Minitab 16: Using Minitab Sample Data Sets Wesley Miller In Minitab 16; you can access a vast range of Sample Data Sets that can be used to aid in exploring Minitab statistical reports and capabilities. In this video; Wesley Miller demonstrates how to work with the Sample Data Sets provided by Minitab 16. 55249
Minitab 16: Using the Minitab Assistant Wesley Miller In Minitab 16; you can use the Assistant tool to determine the appropriate test to apply to a given data set. In this video; Wesley Miller discusses how to use the Minitab Assistant to conduct hypothesis tests on various sample data sets. 55261

QuickBooks (15)
Title Speaker Summary ID
QuickBooks Pro 2013: A "One-Touch" Approach to Excellence Using CICO-ART Peter Walls QuickBooks Pro 2013 offers a flexible bookkeeping and accounting solution for your business; and by combining it with the sound operating principles of a one-touch approach and CICO-ART; you'll be able to improve the efficiency of your bookkeeping effort; saving time and money. In this video; Peter Walls highlights QuickBooks' flexibility before describing one-touch principles and CICO-ART. 48086
QuickBooks Pro 2013: Bank Reconciliation Made Exceptionally Easy Peter Walls In QuickBooks Pro 2013; doing your bank reconciliations is very easy; especially if you mirror QuickBooks to your bank statements. In this video; Peter Walls demonstrates how to use the Banking menu to reconcile your bank and create a detailed reconciliation report. 48097
QuickBooks Pro 2013: Control Opening Balances: Bank Reconciliation Peter Walls QuickBooks Pro 2013 enables you to you to quickly and easily import and control your company's opening bank reconciliation from a manual or computerized bookkeeping system. In this video; Peter Walls creates a bank control account and uses QuickBooks Pro 2013's drilldown and reports features to demonstrate how to successfully import and control your opening bank reconciliation. 48087
QuickBooks Pro 2013: Control Opening Balances: Customer Balances Peter Walls In QuickBooks Pro 2013; you can import and effectively control your opening customer balances when you move from a manual or a computerized bookkeeping system. In this video; Peter Walls demonstrates how to use QuickBooks 2013 to import your opening customer balances from Excel. 48094
QuickBooks Pro 2013: Control Opening Balances: Trial Balances Peter Walls QuickBooks Pro 2013 allows you to import and control your opening Trial Balance; be it from a computerized or manual bookkeeping system; using Excel. In this video; Peter Walls specifies the data required for your Excel worksheet's Trial Balance; journalizes the data in QuickBooks Pro - specifying control accounts; generates a Trial Balance report; and reviews it against the Excel worksheet. 48098
QuickBooks Pro 2013: Control Opening Balances: Vendor Balances Peter Walls In QuickBooks Pro 2013; you can import and control your opening vendor balances when you move from a manual or a computerized bookkeeping system. In this video; Peter Walls demonstrates how to use QuickBooks 2013 to import your opening vendor balances from Excel. 48096
QuickBooks Pro 2013: Distinguishing Bookkeeping; Management Accounts and Compliance Accounting Peter Walls QuickBooks Pro 2013 assists in coordinating the different aspects of your company's accounting demands by providing bookkeepers; management accountants; and compliance accountants with easy access to the data and tools they require. In this video; Peter Walls highlights features that QuickBooks Pro 2013 offers to bookkeeping; management; and compliance accounting and how to distinguish between these different; yet dependant roles. 48085
QuickBooks Pro 2013: Getting Started the Easy Way - With a Blank Company File Peter Walls Creating a new company file can be an arduous and sometimes complicated task; however by starting with a blank chart of accounts in QuickBooks Pro 2013; you'll be able to significantly simplify the process and add; modify; and delete the accounts as needed. In this video; Peter Walls uses the Setup wizard to create a new blank company file. 48084
QuickBooks Pro 2013: How to Manage Expenses; Advances and Floats Peter Walls QuickBooks Pro 2013 enables you to treat employees incurring expenses as vendors or banks; thereby allowing you to create an ongoing; detailed history of advances; expenses; and balances. In this video; Peter Walls demonstrates how to pay advances to and raise bills against employees designated vendors as well as monitor the expense accounts of employees designated banks. 48090
QuickBooks Pro 2013: How to Save Time Using Management-By-Exception Principles Peter Walls QuickBooks Pro 2013 enables you to use the Management by Exception principle to account for items missing information. In this video; Peter Walls accounts for a blank check stub and a supplier invoice he cannot code by writing a check and raising a bill; both of which he allocates to an exception account until further information becomes available. 48100
QuickBooks Pro 2013: Importing PayPal Transactions Peter Walls QuickBooks Pro 2013 enables you to use Microsoft Excel to import your PayPal transactions. In this video; Peter Walls demonstrates how to import PayPal data into QuickBooks Pro for review in the Trial Balance. 48092
QuickBooks Pro 2013: Making Journal Entries Using an Easy "From-To" Approach and Drilldown Peter Walls QuickBooks Pro 2013 automatically creates journal entries for transactions but allows you; should you need to offset expenses against accruals to generate accounts or reports; to create journal entries yourself. In this video; Peter Walls explains QuickBooks Pro 2013's background generation of journal entries; before demonstrating simple journal entries that reflect in the Trial Balance. 48091
QuickBooks Pro 2013: Recording Standing Orders and Direct Debits Peter Walls In QuickBooks Pro 2013; it is easy to record standing orders and direct debit orders. In this video; Peter Walls demonstrates how to use the Write Check feature to create standing orders; direct orders; and reminders for your monthly payments. 48093
QuickBooks Pro 2013: The Best Way to Control Petty Cash Peter Walls QuickBooks Pro 2013 enables you to use the imprest system to record and control your petty cash. In this video; Peter Walls draws a check and codes it to his internal Petty Cash account; establishing a control total. He then draws a check against receipts; coding the check to the appropriate accounts; including Review Control; owing to illegible receipts. 48088
QuickBooks Pro 2013: Transferring Files to an Accountant Who Doesn't Have QuickBooks Peter Walls QuickBooks Pro 2013 allows you to quickly and easily transfer - in print or via Excel; e-mail; or in PDF format - a full set of accounts to recipients lacking access to QuickBooks Pro. In this video; Peter Walls generates a full set of year-end reports and exports them to an Excel workbook; and e-mails it to his accountant. 48101