Orange County NC Website
Advanced Excel 5.0 • Windows <br />This course will explore lookup and data tables, array functions and <br />conditional functions to give your spreadsheet added "intelligence ". <br />You will learn how to create advanced macros and about the <br />Scenario Manager. The following topics are included: Using IF <br />Logic; Advanced.Data Management; User - defined Functions; and <br />Customizing Excel <br />Beginning Excel 97 for Windows 95* <br />This one day class covers Excel 97 basics, formulas and formats, <br />preview and print, and charts and maps. <br />Intermediate Excel 97 for Windows 95* <br />This class covers working with database basics, database <br />management, linking and protecting and Visual Basic. <br />Advanced Excel 97 for Windows 95* <br />This class covers using IF logic, advanced data management, user <br />defined functions and customizing Excel. <br />Beginning Access 97 for Wind ®vlrs 95 <br />(Two -Day class) <br />This ' two -day class introduces the Access relational database <br />concepts, providing a foundation for, database management. <br />Students learn how to design tables and forms, how to search and <br />sort data, how to import and export data, and how to create reports. <br />Class Date: <br />Friday, April 2 <br />Class Dates (Choose One): <br />Tuesday, January '19 <br />Thursday, January 28 <br />Friday, February S <br />Tuesday, February 9 <br />Thursday, February 18 <br />Thursday, March 4 <br />Tuesday, March 16 <br />Wednesday, March 31 <br />Thursday, April l <br />Wednesday, April 7 <br />Wednesday, April 21 <br />.Thursday, April 29 <br />Class Dates (Choose One): <br />Friday, January 22 <br />Monday, February 1 <br />Friday, February 26 <br />Tuesday, March 9 <br />Wednesday, March 24 <br />Tuesday, April 13 <br />Thursday, April 22 <br />Class Date: <br />Monday; January 25 <br />Thursday, February 11 <br />Friday, March 12 <br />Friday, April 23 <br />Class Dates (Select One): <br />Fridays, January 22 & 29 <br />Tuesdays, February 2 & 9 <br />Wednesdays, February 10 & 17 <br />Fridays, February 19 & 26 <br />Mondays, March 1 & S <br />Thursdays, March 11 & 18 <br />Tuesdays, March 23 & 30 <br />Fridays, April 2 & 9 <br />Wednesdays, April 14 & 21 <br />