| |
This course is designed for Excel users who would like develop their quantitative skills for managerial decision making. Students will learn how to use present value, Internal Rate of Return, Standard Deviation and more. It features a mix of case studies, individual exercises and group activities. This course is appropriate for all students who wish to strengthen their quantitative skills. The emphasis is on real-world scenarios that are widely used in diverse industries. Prerequisites: ITS6005 Excel 2010 Basic or equivalent experience.
|
This course is designed to give experienced Excel 2010 users hand-on experience in creating macros that run in response to specific spreadsheet conditions, working with control structures, developing user screens to accept or display data, validating data entry as well as debugging and handling code errors. Prerequisite: Excel 2010 - Advanced or equivalent experience.
|
This course builds on the skills covered in Word 2010 Basic. Here you will work with styles, sections, and columns and will use the Navigation pane to work with outlines. Formatting tables, graphics, labels and envelopes are also covered. You will also use document templates, manage document revisions, and work with Web features. Prerequisite: Word 2010 - Basic
|
This course builds on the material in the Excel 2010 Basic course. In this class, you will use styles, themes, and backgrounds, and integrate these into large workbooks. You will also create outlines and subtotals, apply cell names, and learn how to work with tables. This course also covers advanced charting techniques, sparklines, worksheet auditing, PivotCharts and workbook templates. Prerequisite: Excel 2010 Basic or equivalent knowledge.
|
This course builds on the skills covered in Access 2010 Basic. Here you will learn how to normalize data, manage table relationships, and enforce referential integrity. You will create lookup fields and subdatasheets; create join queries, and generate summary values. Adding objects to forms and creating advanced form types are also covered. Finally, printing reports; creating and modifying charts as well as using PivotTables will be covered. Prerequisite: Access 2010 - Basic
|
Are you new to the world of computing? This course will cover basic document and spreadsheet creation, internet and email access, and fundamental concepts of hardware and software. Strengthen your keyboard and mouse skills while working in popular business programs, such as Microsoft Word, Excel, and Internet Explorer.
|
This course covers the basic features of Word 2010. After an introduction to Word's screen elements, you will learn how to navigate documents, enter and edit text, create and save documents, and learn how to enhance their appearance. You will also create tables, insert headers, footers and graphics, as well as proof and print documents. Prerequisite: Personal Computers An Introduction or equivalent knowledge. Students enrolling in this course must have mouse and keyboard proficiency navigating the Windows environment
|
This course covers the basic features of PowerPoint 2010; creating, and editing presentations. You will format text, use drawing objects, work with graphics, tables and charts. You will use templates, themes, slide masters, and transition effects. Finally, you will proof, run, and print presentations. Prerequisite: Personal Computers An Introduction or equivalent knowledge. Students enrolling in this course must have mouse and keyboard proficiency navigating the Windows environment
|
This course teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet and Excel terminology, you will learn how to navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures and then save those workbooks in various formats. You will learn about absolute and relative references, work with ranges and use Excel's math functions. Basic formatting and printing strategies are covered as well as basic charting. Prerequisite: Personal Computers An Introduction or equivalent knowledge. Students enrolling in this course must have mouse and keyboard proficiency navigating the Windows environment
|
In this class you will perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, indices, bookmarks, and cross-references. You will also create macros, customize the ribbon and Quick Access toolbar, and work with XML documents. Prerequisite: Word 2010 - Intermediate
|
In this class you will work with advanced formulas, lookup functions such as VLOOKUP and INDEX, and learn data validation and database functions. You will import and export data, query external databases and create macros. Finally, you will learn Goal Seek, Solver, SmartArt and conditional formatting. Prerequisite: Excel 2010 Intermediate or equivalent knowledge.
|
This course covers the basic features of Access 2010. After an introduction to database concepts and the Access environment, you will learn how to design and create databases, tables, and fields. You will sort and filter data, set field properties and data entry rules. You will also create queries, forms, and reports. Prerequisite: Personal Computers An Introduction or equivalent knowledge. Students enrolling in this course must have mouse and keyboard proficiency navigating the Windows environment
|
In this class you will learn how to query with SQL; create crosstabs, parameters, and action queries; create macros; import, export, and link database objects. You will interact with XML documents; create hyperlink fields; optimize, split, as well as back up and password-protect databases. Setting Access options and properties are also discussed. Prerequisite: Access 2010 - Intermediate
|