 |
    Microsoft Excel 2003
Overview: This course is designed to teach users the main features of Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets. Create a worksheet, understand Excel features such as the standard toolbars, a name box, and the worksheet window, how to create a workbook, and editing techniques. Formulas and functions are used for simple and common functions. Changing a worksheet appearance including cell characteristics, borders, auto format, and fill colors are introduced. The spell and print capabilities are also presented. Course Duration: 1 day ( 9:00 am - 5:00 pm ) Prerequisites: A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance of a Computing Fundamentals course.
Excel Intermediate Overview: The Excel 2003 intermediate class focuses on how to efficiently manage data. This is accomplished by examining how to use multiple worksheets, using data consolidation, and create advanced charts. This course explores one of the most powerful of excels features in pivot tables. This course also gives the student the ability to use advanced formatting techniques such as conditional formats, styles, comments, and auto formats. Prerequisites: Students should have experience creating, formatting and printing worksheets with Excel, gained from the workplace or prior attendance of an Excel Introduction course. Knowledge of basic functions such as SUM, AVERAGE, MAX and MIN is required.
Excel Advanced Overview: Students attending this class improve their ability to use range names to identify groups of cells. This class teaches how to use functions and array formulas to analyze data. Students are exposed to advanced techniques in summarizing, filtering, and forecasting information. You also learn how to verify that your data is error free. This class also examines the art of creating forms and connecting to databases. This class in intended for the advanced excel user by focusing on useful and time saving techniques. Prerequisites: Excel Intermediate. Students should have a good working knowledge of Excel and must be able to create, format and print workbooks that incorporate basic mathematical, financial and logical functions, multiple worksheets, charts and data lists. < PC Skills | Schedule | Sign Up >
Executive Training Resources
www.etrdirect.com Certified Instructors Professional, Local, & Affordable |
