Microsoft Excel – Advanced
18 seats available
This class focuses on some of Excel’s advanced features. The class will begin with an overview of spreadsheet design. You will review range names and the Name Manager, which are useful for working with data. You'll practice using subtotals on spreadsheets, and you'll learn how to protect a worksheet against accidental changes to data and formulas. You’ll learn to use some of Excel's advanced functions, including VHOOKUP, HLOOKUP, INDEX and MATCH for working with data, as well as functions that make it easier to work with text, such as the CONCATENATE function and Text to Columns. Excel’s built-in functions for working with dates will also be covered.
This workshop will focus on creating pivot tables in Excel. Pivot Tables are perhaps the most powerful tool for data analysis. Also called a Cross-Tab, a Pivot Table lets users easily apply various functions to data and to separate the data by various criteria in rows and columns. For example, student data can be summarized by state, major, SAT scores, etc. by simply dragging fields in different portions of the Pivot Table.
This class will also include an introduction to Excel macros. You’ll learn how to record macros and then practice a series of techniques for modifying them, including using the Relative References option and storing macros in the Personal Macro Workbook. The session introduces the VBA (Visual Basic for Applications) programming language and the VBA Editor to modify your recorded macros.
A certificate of completion will be awarded by GCC following completion of the training and demonstration of employee’s ability to use Excel's advanced data analysis features.