Excel, Accelerated 1-Month Pass

All Courses, Excel, Accelerated

Excel, Accelerated: Expandable conditional dropdown lists from nonadjacent ranges

Time: 02:4 | Would you like to learn Expandable conditional dropdown lists from nonadjacent ranges? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Upper and lower fences Technique: Data validation

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Expandable conditional dropdown list content

Course

Time: 02:4 5| Would you like to learn Expandable conditional dropdown list content? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Data validation to create in-cell dropdown lists Technique: Lower

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Pull selected columns from another tab

Course

Time: 3:26 | Would you like to pull selected columns from another tab? To learn how, watch the video and download the template. Acceleration Technique: Helper column Function: FILTER, INDEX, MATCH, TRUE Object: Create a tab, Name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Reference summarized information from a separate form

Course

Time: 3:41 | Would you like to reference summarized info from a separate form? To learn how, watch the video and download the template. Acceleration Techniques: Substitute cell references for text and; Extract target text from a cell w/ more text

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Highlight cells that match the adjacent cell

Course

Time: 1:45 | Would you like to highlight cells that match the adjacent cell? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Conditional formatting Technique: Paste formats

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Look up vendor cost rates

Course

Time: 1:10 | Would you like to learn how to look up vendor cost rates? To learn how, watch the video and download the Excel template. Acceleration techniques: Function: XLOOKUP Technique: Absolute referencing Technique: Double-click the fill handle

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Identify consecutive identical data

Course

Time: 2:07 | Would you like to Identify consecutive identical data? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Double-click to copy down Technique: AutoFilter

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Protect and Sort

Course

Time: 3:46 | Would you like to know how to Sort, Select, and Protect data in a locked table? To learn how, watch the video and download the Excel template. Techniques: Create and name a table, Create arrows for sorting, Lock/unlock cells

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Dynamic dropdown lists

Course

Time: 2:15 | Would you like to know how to create a dynamic data validation lookup? To learn how, watch the video and download the Excel template. Techniques: IF, VLOOKUP, Create and name data ranges, Absolute referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Nested IF

Course

Time: 1:57 | Would you like to know how to determine price by filtered price points? To learn how, watch the video and download the Excel template. Techniques: IFS, IF, Nesting IF statements

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Transpose a list into a 3-column database

Course

Time: 0:47 | Would you like to know how to transpose a list into a 3-column database? To learn how, watch the video and download the Excel template. Techniques: INDEX, Helper columns, Fill down, Absolute referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Automatically change a week of dates based on the first date in the week

Course

Time: 0:26 | Would you like to know how to automatically change a week of dates based on the first date in the week? To learn how, watch the video and download the Excel template. Techniques: Name a cell, Perform math on a date

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Allocate payroll to projects with inconsistent employee names

Course

Time: 2:13 | Would you like to know how to allocate payroll to projects with inconsistent employee names? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, SUMIF, ROUND, Name mapping, Create and name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create a personal budget

Course

Time: 3:03 | Would you like to know how to create a simple personal budget? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, Create a PivotTable, Use a PivotTable Timeline, Create and name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Track project dates

Course

Time: 3:56 | Would you like to know how to track project dates? To learn how, watch the video and download the Excel template. Techniques: Conditional formatting, MAXIFS, TODAY, AND, Create and name a table object

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Export an IRS form to Excel

Course

Time: 0:39 | Would you like to know how to export an IRS form to Excel? To learn how, watch the video and download the Excel template. Techniques: Export to Excel using Adobe Acrobat Pro

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate profit by project

Course

Time: 6:07 | Would you like to know how to calculate profit by project? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, SUMIFS, SUMIF, ROUND, IFERROR, EOMONTH, Create and name a table, Create a line graph

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Retain leading zeroes in ID numbers

Course

Time: 2:41 | Would you like to know how to retain leading zeroes in ID numbers? To learn how, watch the video and download the Excel template. Techniques: TEXT, RIGHT, REPT, LEN, FIND

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Total the bills due this week

Course

Time: 1:44 | Would you like to know how to total bills due this week? To learn how, watch the video and download the Excel template. Techniques: SUMIFS, INDEX, MATCH, EOMONTH, DAY, Name a cell, Use an operator on a date, Color an input cell

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Summarize PayPal transactions

Course

Time: 3:32 | Would you like to know how to summarize PayPal transactions? To learn how, watch the video and download the Excel template. Techniques: SUMIFS, LEFT, DATEVALUE, IFERROR, TEXT, Create and name a table, Name a cell, Remove duplicates

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Use the FILTER function to exclude multiple values

Course

Time: 1:59 | Would you like to know how to use the FILTER function to exclude multiple values? To learn how, watch the video and download the Excel template. Techniques: FILTER, * operator

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Use VBA to mimic double-clicking the fill handle

Course

Time: 5:10 | Would you like to know how to use VBA to mimic double-clicking the fill handle? To learn how, watch the video and download the Excel template. Techniques: Define a variable, Set the variable's value

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Separate text which has a bullet point

Course

Time: 4:10 | Would you like to know how to separate text which has a bullet point? To learn how, watch the video and download the Excel template. Techniques: Text to columns, TRIM, LEFT, FIND, IFERROR, ISBLANK, IF

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Compare data on 2 tabs

Course

Time: 2:10 | Would you like to know how to compare data on 2 tabs? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, = operator, Use tables

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Total columns based on 1 criterion

Course

Time: 1:12 | Would you like to know how to total columns based on 1 criterion? To learn how, watch the video and download the Excel template. Techniques: SUMIF, Absolutely reference columns, rows, or both

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Add notes next to a PivotTable

Course

Time: 2:23 | Would you like to know how to add commentary next to a PivotTable? To learn how, watch the video and download the Excel template. Techniques: Create and name a table, Create a PivotTable, Remove duplicates, IFERROR, XLOOKUP

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Paste data into a transposed layout

Course

Time: 1:21 | Would you like to know how to paste data into a transposed layout? To learn how, watch the video and download the Excel template. Techniques: transpose while pasting

$4.99

All Courses, Excel Advantage for Accountants

Excel Advantage for Accountants: Create Excel-Based Payroll Allocation Template

Course

Time: 1:21 | Would you like to know how to paste data into a transposed layout? To learn how, watch the video and download the Excel template. Techniques: transpose while pasting

$199

All Courses, Excel, Accelerated

Excel, Accelerated: Call up a record with selected contact information

Course

Time: 2:30 | Would you like to know how to call up a record with selected contact information? To learn how, watch the video and download the Excel template. Techniques: Create a fence under a database, Name a range, Create an in-cell dropdown box

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Tag and expand a list

Course

Time: 0:48 | Would you like to know how to append text to an existing list, duplicating that list for each type of text? To learn how, watch the video and download the Excel template. Techniques: & operator, Sort with two levels

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate benefit eligibility date

Course

Time: 1:24 | Would you like to know how to calculate the date based on criteria? To learn how, watch the video and download the Excel template. Techniques: EOMONTH, XLOOKUP, Create and name a table, Paste Values

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Troubleshoot a circular reference

Course

Time: 1:13 | Would you like to know how to troubleshoot a circular reference? To learn how, watch the video and download the Excel template. Techniques: Locating circular reference

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Move comments into cells

Course

Time: 2:18 | Would you like to know how to move comments into cells? To learn how, watch the video and download the Excel template. Techniques: Add the Developer tab to the ribbon, Insert and name a module for macro programming

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Use conditional formatting to test for identical cell values

Course

Time: 0:42 | Would you like to know how to use conditional formatting to test for identical cell values? To learn how, watch the video and download the Excel template. Techniques: Conditional formatting, Use a formula inside conditional formatting

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create combinatorial table based on two lists

Course

Time: 3:14 | Would you like to know how to create combinatorial table based on two lists? To learn how, watch the video and download the Excel template. Techniques: COUNTA, INDEX, IF, ISTEXT, MOD, IFERROR, & operator, Create and name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Summarize monthly financial transactions in a PivotTable

Course

Time: 5:37 | Would you like to know how to summarize monthly financial transactions in a PivotTable? To learn how, watch the video and download the Excel template. Techniques: Create a PivotTable from detailed transactions

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Count names in multiple columns

Course

Time: 1:42 | Would you like to know how to count names in multiple columns ? To learn how, watch the video and download the Excel template. Techniques: Group and outline, IF, COUNTIF, Table slicer, Create and name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Test for whether row and column headers are in a table record

Course

Time: 1:16 | Would you like to know how to test for whether row and column headers are in a table record ? To learn how, watch the video and download the Excel template. Techniques: Helper column, COUNTIF, The join operator

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Pull relevant information from another tab

Course

Time: 1:16 | Would you like to know how to pull relevant information from another tab? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, INDEX, MATCH, VLOOKUP, COLUMN, Select table headers only

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: AutoComplete from a predefined list

Course

Time: 2:56 | Would you like to know how to perform AutoComplete from a predefined list? To learn how, watch the video and download the Excel template. Techniques: INDEX, Fill down to the bottom of a list, In-cell AutoComplete, In-cell dropdown

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Change date formatting

Course

Time: 1:55 | Would you like to know how to change date formatting? To learn how, watch the video and download the Excel template. Techniques: Add digits to the end of text, Reformat cells from text to number, Reformat cells from number to date, &

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Split out address components into columns

Course

Time: 0:47 | Would you like to know how to split out address components into columns? To learn how, watch the video and download the Excel template. Techniques: Text to Columns in 2 stages

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Split month, date, and time into separate columns

Course

Time: 0:50 | Would you like to know how to split month, date, and time into separate columns? To learn how, watch the video and download the Excel template. Techniques: TEXT

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Extract key terms from a cell

Course

Time: 2:22 | Would you like to know how to extract key terms from a cell? To learn how, watch the video and download the Excel template. Techniques: LEFT, RIGHT, LEN, FIND, Helper columns, Fill down, Increment numbers

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Identify most recent date

Course

Time: 1:55 | Would you like to know how to list each vendor with the most recent date that they were paid? To learn how, watch the video and download the Excel template. Techniques: NUMBERVALUE, MAXIFS, PivotTable, table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Track a two-way loan balance

Course

Time: 3:20 | Would you like to know how to track a balance of a loan whose balance switches between two parties? To learn how, watch the video and download the Excel template. Techniques: Force a table to have different formulas in a column, SUMIF

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Extract key totals from a database

Course

Time: 4:19 | Task: Extract key totals from a database | Acceleration techniques: Table, PivotTable, SUMIFS

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Troubleshoot monthly date groupings in a PivotTable

Course

Time: 1:49 | Task: Troubleshoot monthly date groupings in a PivotTable | Acceleration techniques: NUMBERVALUE, PivotTable, group PivotTable dates by month

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Extract numbers from cells with both numbers and text

Course

Time: 1:54 | Task: Take a cell with both numbers and text, and extract only the numbers | Acceleration techniques: Text to columns, IF, LEFT, FIND, NUMBERVALUE

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Advance data 1 month in a two-dimensional, multi-year table

Course

Time: 2:02 | Task: Advance data 1 month in a two-dimensional, multi-year table | Acceleration techniques: INDEX, MATCH, SUMIFS, Combination absolute/relative referencing in a single cell reference

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: T1S EA video - Create automated amortization schedule

Course

Time: 7:31 | Task: Create an automated amortization schedule which also calculates the final payment for a $0 ending balance | Acceleration techniques: ROUND, PMT, EDATE, name ranges, macros/VBA, Goal Seek, command buttons

$49

All Courses, Excel, Accelerated

Excel, Accelerated: Control date groupings in a PivotTable

Course

Time: 1:13 | Task: Control date groupings in a PivotTable | Acceleration techniques: Group and ungroup dates in the PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create scenarios from columns in different combinations

Course

Time: 2:05 | Task: Add different combinations of cost sets for different scenarios | Acceleration techniques: Create an in-cell drop-down list, Name a range, COUNTIF, SUMPRODUCT, Absolute and relative referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Count survey responses

Course

Time: 2:52 | Task: Tally survey response totals for each question | Acceleration techniques: COUNTIF, Create a database layout, keyboard shortcuts, PivotTable, PivotChart, Slicer

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Test for whether a number falls within a range

Course

Time: 1:55 | Task: Test for whether a number falls within a range | Acceleration techniques: Control cells, RANDBETWEEN, IF, AND, greater than or equal to operator, less than or equal to operator, absolute referencing, named ranges

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create invoice ID from existing information

Course

Time: 1:57 | Task: Create invoice ID from existing information | Acceleration techniques: LEFT, TEXT, FIND, &, LOWER, UPPER, a variety of date formats, IFERROR

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create sheet tabs from cell data

Course

Time: 3:03 | Task: Create sheet tabs from cell data | Acceleration techniques: Record a macro; edit the VBA code; create a For/Next loop; Sheet, Range, and Cell objects

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Total database figures in new columns

Course

Time: 2:46 | Task: Total database figures in a new report with dates in columns | Acceleration techniques: SUMIF, RANDBETWEEN, TEXT, Remove Duplicates, Table, PivotTable, copy a column to a row

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Compare 4 key metrics for 350 companies over 10 years

Course

Time: 5:48 | Task: Create a dynamic dashboard to compare 4 key metrics for 350 companies over 10 years | Acceleration techniques: ROUND, RANDBETWEEN, TEXT, Remove Duplicates, Name a range, Data validation, Drop-down list, SUMIFS, Line graph

$49.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create a basic startup 3-year P&L forecast

Course

Time: 5:17 | Task: Create a basic 3-year P&L startup forecast| Acceleration techniques: ROUND, dynamic rounding, goal seek to forecast revenue based on owner compensation requirements, Group and Outline, asymmetrical absolute referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create a chart from the most recent form entry

Course

Time: 2:16 | Task: Create a chart from the most recent form entry values | Acceleration techniques: MAX, VLOOKUP, COLUMNS, create and name a table, pie chart

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Forecasted accrual of multiple staggered bills

Course

Time: 2:50 | Task: Forecast and accrue expenses for multiple staggered bills | Acceleration techniques: MAXIFS, SUMIFS, table object, format painter, ROUND, use a control cell, fill down

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Identify overdue items

Course

Time: 4:18 | Task: Identify overdue items | Acceleration techniques: Conditional formatting, AND, TODAY, <=, use a control cell, AutoFilter, table object, slicers

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Delete blank rows

Course

Time: 1:57 | Task: Delete blank rows | Acceleration techniques: Go To, activate the Delete Cells dialog, record a macro, assign a keyboard shortcut to a macro, make a macro available to all locally open Excel files

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Dynamic rolling average

Course

Time: 3:50 | Task: Create a rolling n-month average that ignores annual totals | Acceleration techniques: AVERAGEIFS, EOMONTH, IFERROR, IF, MIN, absolute referencing, concatenate operator, helper row, use a named range in a formula

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Extract text from a cell

Course

Time: 4:01 | Task: Extract text from a cell | Acceleration techniques: CHAR, REPLACE, FIND, Text-to-columns, NUMBERVALUE, RIGHT, LEN

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Bank statement manipulation and categorization

Course

Time: 3:33 | Task: Manipulate and classify a list of transactions | Acceleration techniques: Table, VLOOKUP, split a column into 2 columns of debits and credits, Accumulate all records with specified text, remove duplicates, create a PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: T1S EA video - Amortization schedule with flexible accrued interest

Course

Time: 2:13 | Task: Calculate loan interest when payments are irregular | Acceleration techniques: ROUND, absolute referencing, create a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Reference an expanding database

Course

Time: 4:01 | Task: Summarize figures from multiple tabs | Acceleration techniques: Create and name a table, 3-D formulas, fence technique, SUM, SUMIF, EOMONTH

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Rotating Assignments

Course

Time: 1:40 | Task: Assign employees to line items on a rotating basis | Acceleration techniques: Create and name a table, IF, VLOOKUP, COLUMNS

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Parse addresses

Course

Time: 2:16 | Task: Parse addresses from 1 cell into multiple cells| Acceleration techniques: Increment text cells which end with a number, RIGHT, LEFT, TEXT, Text-to-columns, TRIM

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Change certain grades to other text

Course

Time: 0:51 | Task: Retain certain grades while changing others to specified text | Acceleration techniques: VLOOKUP, name a range

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Format a number in a text string

Course

Time: 1:40 | Task:Format a number in a string which concatenates both text and numbers from cells in a database | Acceleration techniques: CONCAT, TEXT, TEXTJOIN

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create a database layout with multiple dimensions

Course

Time: 5:03 | Task: Create a multidimensional database layout from information laid out in a different format | Acceleration techniques: Transpose, VLOOKUP, INDEX, MATCH, Format Painter, absolute referencing, PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create uniform starting column

Course

Time: 3:08 | Task: Create uniform starting column from comparative Balance Sheet | Acceleration techniques: TRIM, CONCAT, Delete columns, Format Painter, absolute referencing, VLOOKUP, MATCH

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Eliminate in-cell line breaks

Course

Time: 0:29 | Task: Eliminate in-cell line breaks | Context:Data exported from another system | Acceleration techniques: Keyboard shortcuts Find and Replace, Find the line breaks

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate how many times a customer placed an order

Course

Time: 2:06 | Task: Calculate how many times the customer placed an order | Context: Sales ledger | Acceleration techniques: PivotTable, COUNTIF, table, COUNTIFS, "&" operator

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate % change

Course

Time: 2:44 | Task: Calculate a % change | Context: Comparative numbers that are also a % of the whole | Acceleration techniques: Change the number of visible decimal places, % format, IFERROR, IF

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate totals for columns of different lengths

Course

Time: 2:04 | Task:Calculate totals for columns of different lengths | Context: List of values | Acceleration techniques: VBA: Insert a new module, create a macro, define a variable, select a cell, assign a value to a cell

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Convert a Word list into a columnar Excel database

Course

Time: 2:16 | Task: Convert a Word list into a columnar Excel database | Context: Contact list | Acceleration techniques: ROW, CEILING.MATH, CONCAT, VLOOKUP, COLUMNS, 5 keyboard shortcuts, asymmetric absolute references

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate run rate

Course

Time: 3:47 | Task: Calculate a run rate | Context: Monthly Profit & Loss report | Acceleration techniques: Driver cells, % number format, ROUND, Format Painter, SUBTOTAL

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Multi-criterial lookup for item costs, without XLOOKUP

Course

Time: 1:56 | Task: Look up item costs from a specific invoice number (without XLOOKUP) | Context:Sales line item report | Acceleration techniques: CONCAT, table objects, VLOOKUP, COLUMNS | Bonus! Creating sample data: CHOOSE, RANDBETWEEN

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Consolidate multiple tabs

Course

Time: 2:09 | Task: Consolidate multiple tabs into a single database | Context: Investment account tracking | Acceleration techniques: VLOOKUP, MATCH, Single absolute referencing ($A1, A$1)

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: What XLOOKUP replaces

Course

Time: 2:12 | Task: Look up a value using multiple criteria | Context: Professional impact and areas of specialty | Acceleration techniques: Create and name tables, resize a table, CONCAT, VLOOKUP

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Sorting unusual values

Course

Time: 1:24 | Task: Sort non-alphabetically | Context: Tooling area | Acceleration techniques: Sort, COUNTIF, Absolute referencing ($A$1), Paste Values, Helper column

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Dynamically link Word and Excel

Course

Time: 1:01 | Task: Dynamically link a Word doc to an Excel spreadsheet | Context: Office for Windows | Acceleration techniques: Paste Special

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Eliminate balancing error

Course

Task: Eliminate a balancing error due to too many decimal places Context: SaasAnt accounting entry upload Acceleration techniques: Function: ROUND Technique: Double-click the Fill Handle to copy down Time: 1:11

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Transform grid into dimensional database

Course

Task: Transform a grid into a dimensional database Context: Profit & Loss by property Acceleration techniques: Function: COUNTIF Technique: Absolute referencing ($A$1) Function: INDEX Function: MATCH Time: 2:21

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Day of the week

Course

Task: Translate a date into the day of the week expressed as text Acceleration techniques: Function: RANDBETWEEN Function: DATE Function: WEEKDAY Technique: Fill Handle Object: Create a table Function: VLOOKUP Function: COLUMNS Time: 1:19

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Populate the preferred address

Course

Task: Cause the preferred address to populate in a database Context: Address database Acceleration techniques: Object: Create and name a table Technique: Double-click the Fill Handle Function: IF Function: VLOOKUP Function: COLUMNS Time: 2:41

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: PivotTable and VLOOKUP basics

Course

Task: Summarize detailed information and consult a reference table Context: Random data Acceleration techniques: * Object: PivotTable * Keyboard shortcut: Ctrl+Shift+4 * Function: VLOOKUP * Technique: Absolute referencing ($J$1) Time: 4:53

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Dynamically reference different tabs

Course

Task: Dynamically reference an identical cell in different tabs Context: Property management Acceleration techniques: Function: INDIRECT Operator: & Technique: Single and double apostrophes Technique: Double-click the Fill Handle Time: 2:16

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Eliminate NA Error in VLOOKUP

Course

Task: Substitute 0 for the #N/A error in a VLOOKUP formula Context: Random database Acceleration techniques: Function: VLOOKUP Technique: Absolute referencing Function: IFERROR Time: 1:00

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Reconcile a bank statement

Course

Task: Reconcile a bank statement Context: Accounting ledger is in Excel Acceleration techniques: Object: Create a table Object: Name a table Technique: Name a range Function: SUMIFS Operator: <= (less than or equal to) Operator: & Time: 2:53

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Random sample

Course

Task: Generate a random sample Context: Accounts receivable database during financial statement audit Acceleration techniques: Function: RAND Function: ROUND Function: RANDBETWEEN Technique: F9 Technique: Remove Duplicates Time: 2:43

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Get vendor name from bank export

Course

Task: Get vendor name from bank export Context: Exported transactions from a bank account Acceleration techniques: Function: RIGHT Function: LEN Technique: Text to Columns Technique: Sort Time: 3:18

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Total Amounts from Pick List

Course

Task: Total values by category Context: A budget vs. actual summary by category Acceleration techniques: Function: SUMIF Technique: Absolute referencing Object: Create a table Object: Name a table Technique: In-cell drop-down list Time: 3:47

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Troubleshoot a Clearing Account

Course

Acceleration techniques include: Sort, Subtotal, Group and Outline

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Separate single-cell multi-line addresses into columns

Course

Acceleration techniques include: CHAR, FIND, REPLACE, Text-to-Columns

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Combine contact lists

Course

Acceleration techniques include: Tables, VLOOKUP, FIND, IFERROR, IF, ISERROR, LEFT, Remove Duplicates

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Spreadsheet update from other spreadsheet

Course

Acceleration techniques include: Programming a macro with open & close workbook, disable screen updating, create a formula, create a variable, autofill, paste formulas

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Cost of living increases in a 60-month forecast

Course

Acceleration techniques include: Name a range, ROUND, POWER, YEAR, targeted absolute referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Deliverables capacity planning for a portfolio of client service levels

Course

Acceleration techniques include: Using a table, controlling a key variable, IF, COUNTIF, VLOOKUP, COLUMNS, and using a helper column

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Rearrange first name and last name

Course

Acceleration techniques include: Text to Columns, LEFT, RIGHT, LEN, FIND, &, and ", "

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Protect Cells With Formulas

Course

Acceleration techniques include: Unlock cell, Protect sheet, TODAY, data validation, create a table object

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Make Excel Recognize Numbers as Numbers

Course

Acceleration techniques include: LEFT, RIGHT, LEN, ISNUMBER, NUMBERVALUE, TRIM, CLEAN, TEXT

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Carryforward Balances

Course

Acceleration techniques include: MIN, create a table object, name a cell, MONTH

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Summarize daily data by month

Course

Acceleration techniques include: Custom date formatting, create and name a table, SUMIFS, <=, &, Split the screen

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Cap Table Summary by Investor Group

Course

Acceleration techniques include: Create and name a table, VLOOKUP, COLUMNS, COUNTIF, create and sort a PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Replace Values With References

Course

Acceleration techniques include: ROW, VLOOKUP, use VBA to create a subroutine, add a formula to a worksheet cell, create a For/Next loop

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Multi-Entity Use of Credit Card

Course

Acceleration techniques include: AutoFilter, LEFT, TEXT, DATEVALUE, Create a reference table, VLOOKUP, COLUMNS

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Consolidated Payroll Files

Course

Acceleration techniques include: Use a table, standardize data layout, PivotChart

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: INDEX MATCH with Shares Sold

Course

Acceleration techniques include: Create and name a table, create in-cell drop-down lists, INDEX, MATCH

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Data Model With Product Sales

Course

Acceleration techniques include: Create and name a table, create a PivotTable, use the Data Model

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: CHOOSE demo with 3 scenarios

Course

Acceleration techniques include: CHOOSE, name cell ranges, create an in-cell drop-down list, MATCH

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Timesheet Error Prevention

Course

Acceleration techniques include: Create and name a table, deploy a fence, name cell ranges, create an in-cell drop-down list, CHOOSE, MATCH

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Timesheet VLOOKUP

Course

Acceleration techniques include: Name a table object, Remove Duplicates, VLOOKUP, COLUMNS, create a PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Clear a table and preserve the formatting

Course

Acceleration techniques include: Name a table object, record a macro, use VBA to select a table header, delete rows, change number format

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Timesheet Summary

Course

Acceleration techniques include: Table object, converting time to decimals, PivotTable, Slicers, Timeline

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Tax Liability With Net Loss

Course

Acceleration techniques include: MAX, IF, controlling text headers

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Conditional Concatenation

Course

Acceleration techniques include: & as a 'join' operator, "" as blank, ISBLANK, IF

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Transform Report into Database

Course

Acceleration techniques include: LEFT, Go To > Special > Blanks, DATEVALUE, CONCAT, EOMONTH, PivotTable, Slicers

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Conditional Dropdown Lists

Course

Acceleration techniques include: Named ranges, data validation, nested IF statements, paste validation

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Location-Based Budget

Course

Acceleration techniques include: Table object, SUMIFS, checkbox, macro recorder, VBA to show/hide columns and to change the page orientation

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Rent tracker

Course

Time: 4:00 | Task: Create a rent tracker with automation | Acceleration techniques: Table, PivotTable, EDATE, using a TRUE/FALSE column as a filter

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Subtotal columns which have header groupings

Course

Time: 1:27 | Task: Subtotal columns which have header groupings | Acceleration techniques: LEFT, FIND, SUMIF, absolute referencing for columns, rows, and both, Format Painter, Group and Outline

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Extract key words from text

Course

Time: 2:45 | Task: Extract key words from text | Acceleration techniques: Table, Remove Duplicates, VLOOKUP, COLUMNS, XLOOKUP, RIGHT, LEN

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Effect a currency conversion

Course

Time: 2:19 | Task: Effect a currency conversion | Acceleration techniques: Name a cell, ROUND, Paste Special > Formulas, GBP format, Group and Outline, Center Across Selection

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Tiered sales commissions

Course

Time: 3:54 | Task: Automatically display a commission rate contingent on a value in another cell | Acceleration techniques: IF, IFS, VLOOKUP, XLOOKUP, AND, create and name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Parse an address with a line break

Course

Time: 1:23 | Task: Parse a cell with a line break | Acceleration techniques: LEFT, RIGHT, LEN, FIND, CHAR, format painter

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Invert first and last names, with some middle initials

Course

Time: 1:34 | Task: Invert first and last names, with some middle initials | Acceleration techniques: Text to Columns, IF, ISBLANK, TEXTJOIN

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Allocate budgeted salaries to programs

Course

Time: 2:36 | Task: Allocate budgeted salaries to programs | Acceleration techniques: CEILING.MATH, RAND, XLOOKUP, table, PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: AutoComplete with a predetermined set of options

Course

Time: 3:14 | Task: AutoComplete with a predetermined set of options | Acceleration techniques: AutoComplete, name a range, Combo Box, Format Painter, Create and name a table, XLOOKUP, INDEX

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Split a column into 2 columns

Course

Time: 1:29 | Task: Split a column into 2 columns | Acceleration techniques: Text to columns, table, LEFT, FIND, RIGHT, LEN

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create a dynamic report date

Course

Time: 2:43 | Task: Create a dynamic report date | Acceleration techniques: &, TEXT, EOMONTH, TODAY, date format mmmm yyyy, RANDBETWEEN, create and name a table, MAX

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Split database into different tabs, by month

Course

Time: 0:22 | Do you need help splitting a database into different tabs by month? Use the AutoFilter technique to complete the task easily. Watch the video and download the Excel template to learn how.

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Extract a ZIP code

Course

Time: 2:09 | Do you have a hard time extracting zip codes from an address list? Watch the video and download the Excel template to learn how. Techniques: Create and name a table, RIGHT, TEXT, ISNUMBER, REPLACE, NUMBERVALUE, IF

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: The SUBTOTAL function

Course

Time: 2:26 | Would you like to subtotal the sections of the Balance Sheet more efficiently? Watch the video and download the Excel template to learn how. Techniques: SUBTOTAL

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Adjust inventory prices to a higher minimum

Course

Time: 0:58 | Would you like to make your inventory pricing more efficient? Watch the video and download the Excel template to learn how to adjust a set of numbers to a higher minimum. Techniques: Name a cell, MAX

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Graph a checking account balance

Course

Time: 2:01 | Do you need help graphing a checking account balance? Watch the video and download the Excel template to learn how. Techniques: Create a line graph, Create and name a table, Create a line graph from a table object

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Add total daily hours

Course

Time: 6:20 | Do you need to calculate total daily hours more efficiently? Watch the video and download the Excel template to learn how. Techniques: Name a range, In-cell dropdown, Table, PivotTable, PivotCharts (pie, line), Slicers

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Update a PivotTable

Course

Time: 1:50 | Do you need to update a PivotTable with recently added information? Watch the video and download the Excel template to learn how. Techniques: Create and name a table, Create a PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Standardize database descriptions

Course

Time: 1:27 | Would you like to standardize your database descriptions? Watch the video and download the Excel template to learn how. Techniques: Table, XLOOKUP, PivotTable

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Subtotal numbers being recognized as text

Course

Time: 1:37 | Are your subtotal numbers sometimes recognized as text? If you would like to learn how to fix this, watch the video and download the Excel template. Techniques: ISNUMBER, NUMBERVALUE, Subtotal tool

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Calculate overtime automatically

Course

Time: 5:30 | Are you calculating overtime manually? If you would like to learn how to automate this, watch the video and download the Excel template. Techniques: WEEKNUM, SUMIFS, XLOOKUP, Convert time values to decimal values

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Add the year to a date

Course

Time: 1:06 | Do you have source data with only the month and day? If you would like to learn how to append the year, watch the video and download the Excel template. Techniques: DATEVALUE, "join" operator, name a range

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Round money to the nearest penny

Course

Time: 0:48 | Are you having trouble rounding payroll taxes to the nearest penny? If you would like to learn how, watch the video and download the Excel template. Techniques: ROUND, use the additive inverse in a formula

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Compare two databases

Course

Time: 3:26 | Do you need to list the differences between two databases? If you would like to learn how, watch the video and download the Excel template. Techniques: XLOOKUP, IF, TEXT, table objects, the "join" operator

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Count cells containing a certain letter

Course

Time: 1:38 | Do you need to count cells containing a certain letter? If you would like to learn how, watch the video and download the Excel template. Techniques: COUNTIF, Wildcard *, Join operator "&"; Absolute referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Convert text digits to numbers

Course

Time: 1:20 | Do you need help converting text digits to numbers? If you would like to learn how, watch the video and download the Excel template. Techniques: ISNUMBER, NUMBERVALUE, Double-click the fill handle to copy down

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Parse negative and positive numbers into 2 columns

Course

Time: 1:45 | Do you need help parsing negative and positive numbers into 2 columns? If you would like to learn how, watch the video and download the Excel template. Techniques: IF, Format Painter

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Remove text from a cell with dollar amounts

Course

Time: 1:37 | Do you need help removing text from a cell with dollar amounts? If you would like to learn how, watch the video and download the Excel template. Techniques: LEFT, LEN, Autofill down, ISNUMBER, NUMBERVALUE

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Allocate salaries

Course

Time: 4:07 | Do you need help job costing for professional services? If you would like to learn how, watch the video and download the Excel template. Techniques: XLOOKUP, ROUND, Create a PivotTable, Create and name a table, Format Painter

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Clear a cell when a related column is marked complete

Course

Time: 1:18 | Do you need to manage a project status dashboard? If you would like to clear a cell when a different cell is marked complete, watch the video and download the Excel template. Techniques: DATE, IF, checkmark symbol

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Create a checklist with conditional logic

Course

Time: 4:54 | Do you need help creating an in-cell dropdown list? If you would like to learn how, watch the video and download the Excel template. Techniques: Name a range, Name a module, Create a subroutine, If, Evaluate a cell value

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Add a target trendline to a graph

Course

Time: 1:56 | Do you wonder how to a target trendline to a graph? If you would like to learn how, watch the video and download the Excel template. Techniques: COUNT, ROW(), ROW(reference), Create a line graph, Customize the graph title

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Summarize sales by state

Course

Time: 1:22 | Would you like to be able to summarize sales by state? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, Create and name a table

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Name a cell according to the tab name

Course

Time: 1:29 | Would you like to name a cell according to the tab name? To learn how, watch the video and download the Excel template. Techniques: CELL, RIGHT, LEN, FIND, Group sheets, Ungroup sheets

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Combine row headers and subheaders

Course

Time: 1:15 | Would you like help naming row headers and subheaders? To learn how, watch the video and download the Excel template. Techniques: LEN, TRIM, CHOOSE, TEXTJOIN, Absolute referencing

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Concatenate dollar amounts into a single cell

Course

Time: 1:07 | Would you like to link dollar amounts into a single cell? To learn how, watch the video and download the Excel template. Techniques: CONCAT, TEXT

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Roll forward a tax code line item mapping

Course

Time: 1:22 | Would you like to know how to roll forward a tax code line item mapping? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, Unmerge cells, AutoFilter

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Restrict access to a tab

Course

Time: 3:41 | Task: Restrict access to a tab | Acceleration techniques: VBA, hide the tab upon opening the workbook, create a password prompt for the user

$4.99

All Courses, Excel, Accelerated

Excel, Accelerated: Count cells by color

Course

Time: 1:09 | Would you like to know how to count cells by color? To learn how, watch the video and download the Excel template. Techniques: SUBTOTAL, AutoFilter

$4.99