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, check formulas for errors, 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 1 or equivalent experience. Required text: Same as Level I.