|
Learn to navigate, edit and view while creating and applying basic functions and formulas, and formatting. This fundamental course provides users with a strong foundation for operating the Excel application.
Develop and maintain Excel charts, multiple worksheets and workbooks. Learn to insert graphics, utilize templates and protect information. This course builds on Level 1 skills, enhancing them to new levels of creativity and professional processes.
Apply skills while acquiring knowledge of advanced features for the functionality of organized data. Create tables, pivot charts, financial functions, data auditing, also learn advanced formatting features and analysis tools.
2003
This class is for those already familiar with Windows and who are just starting with Excel. You do not have to spend hundreds of dollars or take days out of the office to get top-quality Excel training. You will learn everything about Excel and its powerful electronic spreadsheets. This class guides you through all common commands to create, revise, format, and print different worksheets.
Enhance your spreadsheet knowledge now. Students will gain a better understanding of how to use complex formulas and functions critical to development of advanced spreadsheets. Learn how to customize screen displays, toolbars, Excel defaults, protecting worksheets, and file maintenance. Experience the power of macros for automating tasks. Create and modify charts.
Master the concept of databases, manipulating data and sorting of data using a variety of criteria. Apply filtering techniques to control data output. Learn to subtotal, contract and expand database displays. Acquire complex calculation and analysis tools. Define array formulas and array constants. Create and edit simple arrays. |