Now that you’ve got the basics, learn to make this spreadsheet program your most powerful tool. Format data using Text functions, sum a data range based on conditions, consolidate data using a formula (3-D references or links to data), check formulas for errors, construct formulas using named cells/ranges, build a logical formula, and calculate payments. Filter a table, create a custom filter, Advanced Filter, extract data and much more. Bring a USB drive to save your work. Must have taken Excel—Level I or equivalent experience. Required text: Same as Level I.