University of Arkansas Community College at Batesville

Excel Level 3 covers how to use Excel for a variety of problem-solving tasks. Included are how to use Excel as a database; utilizing conditional formatting, data validation, the Data Table, outlining and subtotaling; Paste Special with calculations; consolidating; programmatic formulas including VLOOKUP, HLOOKUP, ISERROR and nested IF statements with AND and OR; and Pivot Tables and Scenarios.

Cancellations: To cancel a class, five (5) business days' notice prior to the course starting date is required to withdraw and receive a refund.

Testimonial: "The instructor was able to take what would otherwise be a tedious subject and make it interesting. The lecture was hands-on and full of practical application." Billy Stidham, Excel Levels 1, 2 and 3