Microsoft Office Classes
Our computer lab features 14 computers with Microsoft Office. We offer hands on training taught by knowledgeable instructors on the following topics:
Fundamentals of Excel
This class provides a firm grounding in worksheet concepts. You will have opportunities to build worksheets, enter formulas, calculate totals, apply formats and control printing layouts. Worksheet design and simple arithmetic calculations are the primary emphasis of the day. We'll also have an introduction to charts and data management.
This class is a logical extension of the fundamentals class, particularly regarding the types of calculations you perform. We'll calculate between worksheets and workbooks. We'll create and manipulate named ranges, use Paste Special, calculate with dates and build formulas that require absolute references. Statistical functions (AVERAGE, MIN, MAX, COUNT) and the IF function are used in calculations. We'll create and modify a pie chart, learn about comments, protect worksheets and workbooks. Custom filtering of lists is also included.
This class explores topics that increase your sophistication with Excel. We'll learn a variety of functions, including VLOOKUP, HLOOKUP, SUMIF, and ROUND. We'll create formulas that use more than one function. Text functions include those which parse, concatenate, and validate data, including insertion of drop-down lists. There are exercises to manage data including subtotals, advanced filtering and pivot tables/charts. We'll also modify charts for secondary axis and trendlines, create custom lists and record simple macros.
Fundamentals of Access
If you have never used Access or have questions about establishing relationships in a database, this is where you should begin. The first class of the series lets you create and manipulate a database to give you an overview of database structure with heavy emphasis on relationships. As you create tables you will learn about importing and linking data, setting properties such as input masks, and inserting lookups. You will learn to create select queries with criteria and filtering and have a brief introduction to forms and reports.
This class is devoted to understanding forms in Access - a key to making a database into a user-friendly application. Participants insert a variety of controls, including combo boxes, list boxes, command buttons and sub-forms to simplify data input. Form properties that control appearance and data entry are explored. The course looks at the relationship between forms, queries and tables; and provides opportunity for attendees to use calculations, expressions such as concatenation, and auto-lookup queries. NOTE: It is recommended that you take this class if you are planning to take the Advanced class, as there is a high level of similarity between form and report design.
The third class in the Access series is the companion to the intermediate class and expands form design to report design. Specific report features include page breaks, grouping, sorting and summaries. In addition to reporting features, participants will automate database procedures with prompting queries, action queries and macros, and create a startup that launches the database. NOTE: The similarities between form and report creation is such that it is recommended you attend the Forms class before the Reports class.
Learn all the PowerPoint elements necessary for you to create an effective presentation, including clip art, animation and sound, backgrounds, the slide master, and design templates. You'll modify templates, insert hyperlinks, use the drawing tools, and produce a kiosk presentation that uses hyperlinks and action buttons, much like a tutorial or webpage.
Discover the wide variety of publications that are template-driven in Publisher. You will create several publications using templates, with focus on manipulating the text and graphic elements that are present in the templates. You will learn to insert additional objects, as well as customize Publisher with business information, logos, and individualize format.
Outlook: More Than Email
Examine the overall structure of Outlook with regard to the integration, consistency and flexibility of its various components. Specific instruction allows attendees to use the Contacts, Calendar, Tasks, Notes, Journal, and Outlook Today components of Outlook, including hands-on activities. You will also learn to create folders and customize settings.
This course explores issues concerning respectful boundaries in today’s work world. You’ll learn to recognize appropriate and inappropriate behavior and discuss issues of physical contact and personal relationships in the workplace. This class will enable you to enhance work relationships and avoid offending others.