Laramie County Community College - Laramie Campus

Excel - Level 3 will build upon the skills learned in Levels 1 and 2, and we’ll cover some of Excel’s most powerful and advanced tools for data analysis and presentation. Logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping, and the much beloved and useful date, time, text and other functions will be explored. Importing from other non-Excel data sources using Power Pivot, exporting data, exploration of What-If Analysis and finally, automating repetitive tasks with Macros are also covered in this class. These are all skills that elevate a student into an Excel Power User. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 1 and Excel 2, map to the objectives of both exams. Excel 1 and 2 are strongly recommended prior to taking this class, but they are not required.