Excel Hangout All-Access Pass

All Courses, Excel Hangout

Hangout: How to compare data and summarize with PivotTable

Technique: How to compare data and summarize with PivotTable | Why: Create a sales by state summary | Step 1: Create and name your tables | Step 2: Use XLOOKUP to combine data from the 2 tables | Step 3: Summarize with a PivotTable

$4.99

All Courses, Excel Hangout

Hangout: How to Use Formulas in Excel to Get Your Data Just Right

Course

Technique: How to Use Formulas in Excel to Get Your Data Just Right | Why: Easily modify exported data so that it is useful | Step 1: Create a table with formula columns | Step 2: Paste raw data into your formatted table

$4.99

All Courses, Excel Hangout

Hangout: How to Avoid the Divide by Zero Error in Your Presentation

Course

Technique: How to Avoid the Divide by Zero Error in Your Presentation | Why: Eliminate displaying unsightly errors in your presentation | Step 1: Create your formulas | Step 2: Add the IFERROR function

$4.99

All Courses, Excel Hangout

Hangout: How to Dynamically Update Start and End Dates for a List of Transactions in Excel

Course

Technique: Dynamically Update Start and End Dates for a List of Transactions in Excel | Why: Create a visual that quickly shows the start and end dates of a list | Step 1: Import your data into a named table | Step 2: Create the MIN and MAX formulas

$4.99

All Courses, Excel Hangout

Hangout: How to Rename List Items with a Cross Reference Table in Excel

Course

Technique: How to Rename List Items with a Cross Reference Table in Excel | Why: Rename items so they can be imported into the accounting system | Step 1: Create and name a cross reference table | Step 2: Use VLOOKUP to change the names

$4.99

All Courses, Excel Hangout

Hangout: How to Use the HLOOKUP Function in Excel

Course

Technique: How to Use the HLOOKUP Function in Excel | Why: Look up a value in a row based on the column heading | Step 1: Create your formula with the HLOOKUP function

$4.99

All Courses, Excel Hangout

Hangout: How to Create a Pivot Chart in Excel

Course

Technique: How to Create a Pivot Chart in Excel | Why: Create a graphical view that can be easily updated | Step 1: Ensure that your data is in table format | Step 2: Create the pivot table and pivot chart

$4.99

All Courses, Excel Hangout

Hangout: How to Open a .CSV File with Leading Zeros in Excel

Course

Technique: 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

All Courses, Excel Hangout

Hangout: How to Find Unused List Items in Your Accounting File

Course

Technique: 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

All Courses, Excel Hangout

Hangout: How to Use Named Ranges to Make Your Excel Spreadsheet Flexible

Course

Technique: 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

All Courses, Excel Hangout

Hangout: How to Use a Pivot Table to Troubleshoot Xero GL Accounts

Course

Technique: 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

All Courses, Excel Hangout

Hangout: Another Application of the IFERROR Function

Course

Technique: 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

All Courses, Excel Hangout

Hangout: How to Use AND and OR in an IF Statement in Excel

Course

Technique: 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

All Courses, Excel Hangout

Hangout: How to Add a Calculation to a Pivot Table in Excel

Course

Technique: How to Add a Calculation to a Pivot Table in Excel | Why: Create a pivot table that will update automatically | Step 1: Create the pivot table | Step 2: Add a calculated field

$4.99

All Courses, Excel Hangout

Hangout: How to Use the LOOKUP Function in Excel

Course

Technique: How to Use the LOOKUP Function in Excel | Why: Look up a value in a range and return a corresponding value | Step 1: Create your formula with the LOOKUP function

$4.99

All Courses, Excel Hangout

Hangout: How to Use a Pivot Table to Reconcile Data in Excel

Course

Technique: How to Use a Pivot Table to Reconcile Data in Excel | Why: Provides a quick way to visualize data | Step 1: Ensure that your data is in table format | Step 2: Create the pivot table

$4.99

All Courses, Excel Hangout

Hangout: How to Use a Radio or Option Button in Excel

Course

Technique: How to Use a Radio or Option Button in Excel | Why: Allows the user to see results based on the option selected | Step 1: Insert the Option from the Developer Tab | Step 2: Copy the Option Button for each choice | Step 3: Create a formula

$4.99

All Courses, Excel Hangout

Hangout: How to Add a Menu Tab to Your Presentation in Excel

Course

Technique: How to Add a Menu Tab to Your Presentation in Excel | Why: Create simple navigation of the worksheet for users | Step 1: Insert shapes on the Menu Tab for each worksheet | Step 2: Link the shapes to the appropriate tab

$4.99

All Courses, Excel Hangout

Hangout: How to Create a Database in Excel from a Messy QB Export

Course

Technique: How to Create a Database in Excel from a Messy QB Export | Why: Create a usable data table | Step 1: Use the F5 "Go To" Key | Step 2: Delete rows with blanks and subtotals

$4.99

All Courses, Excel Hangout

Hangout: How to Use Formulas in Conditional Formatting in Excel

Course

Technique: How to Use Formulas in Conditional Formatting in Excel | Why: Creates a simple and visual way to see errors | Step 1: Determine where conditional formatting is needed | Step 2: Create conditional formatting with a formula

$4.99

All Courses, Excel Hangout

Hangout: How to Use a Checkbox in Excel

Course

Technique: How to Use a Checkbox in Excel | Why: Creates a way to show or hide values in a table | Step 1: Create your formula | Step 2: Insert the Checkbox from the Developer Tab

$4.99

All Courses, Excel Hangout

Hangout: How to Automatically Update a Date Value in a Table in Excel

Course

Technique: How to Automatically Update a Date Value in a Table in Excel | Why: Not all dates export in the right format | Step 1: Set up your table and formula | Step 2: Import data into the table

$4.99

All Courses, Excel Hangout

Hangout: How to Use Dynamic Rounding for a Professional Presentation

Course

Technique: How to Use Dynamic Rounding for a Professional Presentation | Why: Universally change rounding on the fly for your entire presentation | Step 1: Create and name a rounding cell | Step 2: Reference the rounding cell in all formulas

$4.99

All Courses, Excel Hangout

Hangout: How to Use Absolute Referencing to Create a Dynamic Financial Statement

Course

Technique: How to Use Absolute Referencing to Create a Dynamic Financial Statement | Why: Easily create and update financial statements from a raw trial balance | Step 1: Import trial balance | Step 2: Create and design the financial statement

$4.99

All Courses, Excel Hangout

Hangout: How to Use a Scroll Bar in Excel

Course

Technique: How to Use a Scroll Bar in Excel | Why: Creates a user friendly way to update values in a formula | Step 1: Create your formula | Step 2: Insert the Scroll Bar from the Developer Tab

$4.99

All Courses, Excel Hangout

Hangout: How to Use a Spin Button in Excel

Course

Technique: How to Use a Spin Button in Excel | Why: Creates a user friendly way to update values in a formula | Step 1: Create your formula | Step 2: Insert the Spin Button from the Developer Tab

$4.99

All Courses, Excel Hangout

Hangout: How to Protect Your Excel Worksheet with Data Validation

Course

Technique: How to Protect Your Excel Worksheet with Data Validation | Why: Protect cells from being overwritten | Step 1: Highlight cells you want to protect | Step 2: Set data validation rules

$4.99

All Courses, Excel Hangout

Hangout: How to Add % of Grand Total to a Pivot Table

Course

Technique: How to Add % of Grand Total to a Pivot Table | Why: Create a % formula that will update automatically | Step 1: Insert a Pivot Table | Step 2: Insert the total twice in the Values box in the Pivot Table fields list

$4.99

All Courses, Excel Hangout

Hangout: How to Add Formulas to a Pivot Table

Course

Technique: How to Add Formulas to a Pivot Table | Why: Create formulas that will update automatically | Step 1: Insert a Pivot Table | Step 2: Insert a Calculated Field

$4.99

All Courses, Excel Hangout

Hangout: How to Create and Use a Dropdown Box

Course

Technique: How to Create and Use a Dropdown Box | Why: Data consistency | Step 1: Create a list of items | Step 2: Create the box

$4.99

All Courses, Excel Hangout

Hangout: How to Automate a Bank Reconciliation in Excel

Course

$4.99

All Courses, Excel Hangout

Hangout: How to Use the COUNTIFS Function

Course

Technique: How to Use the COUNTIFS Function | Why: Determine if matching items are in a list using multiple criteria | Step 1: Import 2 item lists | Step 2: Use COUNTIFS to determine if line items match in both lists

$4.99

All Courses, Excel Hangout

Hangout: How to Change List Names Using VLOOKUP

Course

Technique: How to Change List Names Using VLOOKUP | Why: Data format and consistency | Step 1: Create a cross reference table | Step 2: Create the VLOOKUP formula

$4.99

All Courses, Excel Hangout

Hangout: How to Create and Use a Timeline

Course

Technique: How to Create and Use a Timeline | Why: Jazz up your presentation and make it more user friendly | Step 1: Insert a Pivot Table | Step 2: Insert a Timeline

$4.99

All Courses, Excel Hangout

Hangout: How to Record and Use a Macro

Course

$4.99

All Courses, Excel Hangout

Hangout: How to use a simple IFERROR Function

Course

Technique: How to use a simple IFERROR Function | Why: Cleans up your presentation | Step 1: Create your formula | Step 2: Add the IFERROR function

$4.99

All Courses, Excel Hangout

Hangout: How to Use a Simple COUNTIF Formula

Course

Technique: How to Use a Simple COUNTIF Function | Why: Count the number of items in a list | Step 1: Create or import a list of items | Step 2: Use the COUNTIF to determine the number of items in the list

$4.99

All Courses, Excel Hangout

Excel Hangout: How to Create and Use a Slicer for Dynamic Presentation

Course

Technique: How to Create and Use a Slicer for Dynamic Presentation | Why: Creates a visual way to filter data on the fly | Step 1: Create a data table | Step 2: Add a totals row | Step 3: Insert a slicer

$4.99

All Courses, Excel Hangout

Excel Hangout: How to use a simple SUMIF function

Course

Technique: How to use a simple SUMIF function | Why: Add values from a table that match your criteria | Step 1: Create or import a list of items | Step 2: Use the SUMIF formula to add values using a matching criteria

$4.99

All Courses, Excel Hangout

Excel Hangout: How to use a simple VLOOKUP function

Course

Technique: How to Use a Simple VLOOKUP Function | Why: Match criteria and select a value | Step 1: Create or import a list of items | Step 2: Use the VLOOKUP formula to add values using a matching criteria

$4.99

All Courses, Excel Hangout

Excel Hangout: How to Eliminate that Rounding Problem on Your Financial Statements

Course

Technique: How to Eliminate that Rounding Problem on Your Financial Statements | Why: Don't give clients a statement that is out of balance | Step 1: Import trial balance | Step 2: Create the financial statement | Step 3: Setup rounding placeholder

$4.99