Products
-
Hangout: How to Use AND and OR in an IF Statement in Excel
CourseTechnique: How to Use AND and OR in an IF Statement in Excel | Why: Consider multiple values for the truth of an IF statement | Step 1: Create or import a list of items | Step 2: Use the IF statement along with AND or OR
$4.99
-
Hangout: Another Application of the IFERROR Function
CourseTechnique: Another Application of the IFERROR Function | Why: Show blanks in cells without having to delete formulas | Step 1: Create your formulas | Step 2: Add the IFERROR function
$4.99
-
Hangout: How to Use a Pivot Table to Troubleshoot Xero GL Accounts
CourseTechnique: How to Use a Pivot Table to Troubleshoot Xero GL Accounts | Why: Provides a quick way to narrow down bad data | Step 1: Ensure that your data is in table format | Step 2: Create and analyze the pivot table
$4.99
-
Hangout: How to Use Named Ranges to Make Your Excel Spreadsheet Flexible
CourseTechnique: How to Use Named Ranges to Make Your Excel Spreadsheet Flexible | Why: Use named ranges to allow for variables in your data | Step 1: Create your table and named ranges | Step 2: Create your formulas that point to the named ranges
$4.99
-
Hangout: How to Find Unused List Items in Your Accounting File
CourseTechnique: How to Find Unused List Items in Your Accounting File | Why: Clean up your accounting file to simplify data entry | Step 1: Export your list items | Step 2: Export transactions for applicable date range | Step 3: Use COUNTIF...
$4.99
-
Hangout: How to Open a .CSV File with Leading Zeros in Excel
CourseTechnique: How to Open a .CSV File with Leading Zeros in Excel | Why: Leading zeros in a .CSV will disappear when you open and edit the file | Step 1: Change the file extension on the .CSV file to .TXT | Step 2: Open the .TXT file
$4.99