Scroll down to see the list of available courses and detailed curriculum
In this introductory course to Excel, participants will explore Excel activities that go beyond the basic. After successful completion of this session, participants can expect to have the skills required to work efficiently in an existing worksheet and to also create new worksheets from a template and from scratch.
In Excel Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use more of Excel's built-in functions to perform complex calculations. You will also create charts, use graphics, and data management skills in an Excel database.
Upon successful completion of this course, students will be able to:
You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. This session includes all of these skills.
Upon successful completion of this course, participants will be able to:
In this course, we do not really do much Excel. We use the Excel software as a basis for examining the creation of custom functions using Visual Basic programming. These skills are then transerable to other applications such as Word or PowerPoint.
As a power user, you may find that the functions available in Excel fall a bit short of your own requirements. By using the Visual Basic module that is included with Microsoft Office products (VBA) you will create new functions that elicit interaction from users, perform automated tasks and sequential activities. Your new functions will be controllable by hotkeys, toolbar icons and command buttons.
This course is not for the faint of heart and is intended for advanced Excel users.