Intermediate Microsoft Excel
Microsoft Windows
Training
Provided by INT Information Systems, Inc.
Intermediate Excel emphasizes the data organization tools and formulas available to Excel users. At the end of class, students will be able to better understand their data by using tools like sorting and filtering, and use more advanced formulas to perform more advanced analytical tasks. The class is taught as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant recieves a booklet and class CD, detailing the topics and methods presented during the class, for their review after class.
|
|
||||||||||||||||
Intermediate Microsoft Excel
Having learned the basics of data storage in Excel, students in the intermediate class are exposed to various methods of analyzing that data. Topics include sorting data alphabetically or numerically, and building basic charts. Additional coverage of formulas, such as VLOOKUP statements and IF functions, are designed to demonstrate practical examples as well as provide insight into the power and flexibility of formulas in general. Other topics include tools to help users review data on-screen more easily and protecting files from tampering. The class objectives include:
- Work with list-based data sets: sorting and filtering, viewing tools and moving and copy sheets to other books.
- Learn more advanced formulas: 3D formulas, data joining with &, RANK, VLOOKUP and IF.
- Begin to move toward advanced formulas by examining examples of nested formulas.
- Build charts: tools to create and modify basic graphs.
- Discuss advanced formatting: format painter, conditional formatting, hiding sheets, cell and workbook protection.
Visit the class' web page to review the class table of contents and sample slides from the presentation.
About The Training Provider: INT Information Systems, Inc.
INT Information Systems, Inc. - For over 20 years, INT Information Systems has helped people become more comfortable with the personal computer's features and programs. Our focus is on the Microsoft Office suite, with classes covering Access, Excel, PowerPoint and Word, as well as Lotus Notes. Our small, long-term staff creates all of our materials in-house and we offer several unique classes such as "Mastering: Excel...
