Access 2010 Level 2: Accessing the Possibilities |
THIS CLASS WILL COVER BOTH ACCESS 2007 AND 2010.
Learn the fundamentals of Access as you work with tables, queries, reports, forms and macros. Build your own personal contact management system in class, beginning with table creation, look up wizards and data value intelligence, and then to create command buttons and menus. Fieldwork is assigned to ensure you master the material. Learn to build relational databases and avoid potential pitfalls to using Access. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
ACCESS2010-LVL2 (04JUN2013)
Learn More... |
Jun 4, 2013 |
Jun 18, 2013 |
Briarcliff Campus |
$525.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
ACCESS2010-LVL2 (01AUG2013)
Learn More... |
Aug 1, 2013 |
Aug 15, 2013 |
Briarcliff Campus |
$525.00 |
Greg Creech
|
Register |
Excelling @ Excel: Data Analysis using Pivot Tables and Subtotals |
This half day course covers creating and downloading databases and then how to analyze data through Pivot Tables and SubTotals.
Data analysis is a powerful Excel feature and we will look in depth at creating and editing Pivot Tables and Pivot Charts for analysis. We will look at other database features such as Subtotals and using the Name Manager. We will use sorting and filtering to help restrict our data and use Pivot Tables for Sum, Average, and Count functions. Using Office 2007/2010 we will use the new Format as a Table feature and learn the advantages and disadvantages of using Format as a Table. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
DATA ANALYSIS (23AUG2013)
Learn More... |
Aug 23, 2013 |
Aug 23, 2013 |
Alpharetta Campus |
$250.00 |
Greg Creech
|
Register |
Excelling at Excel 2010 Level 2 |
THIS CLASS WILL COVER BOTH EXCEL 2007 AND 2010
Learn the four Fs of Excel — formatting, fills, functions/formulas, and filters...tools that help you create effective and clear spreadsheets. Understand formatting and basic formulas as you begin building budget and expense spreadsheets. We go on to explore filters, fills, complex formulas, macros, charts and conditional formatting. These tools help you to create fully functional monthly and annual budget tracking spreadsheets. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL2 (05JUN2013)
Learn More... |
Jun 5, 2013 |
Jun 12, 2013 |
Briarcliff Campus |
$425.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL2 (05AUG2013)
Learn More... |
Aug 5, 2013 |
Aug 12, 2013 |
Briarcliff Campus |
$425.00 |
Greg Creech
|
Register |
More Excelling at Excel Day 3 |
| Students will customize their workbooks through more functions, such as If . .. Then . . . Else and Data Validation, learn more functions, collaborate with other users, and enhance their spreadsheets using charts. This class will cover both Excel 2007 and 2010. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL3 (19JUN2013)
Learn More... |
Jun 19, 2013 |
Jun 19, 2013 |
Briarcliff Campus |
$375.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
EXCEL2010-LVL3 (29AUG2013)
Learn More... |
Aug 29, 2013 |
Aug 29, 2013 |
Briarcliff Campus |
$375.00 |
Greg Creech
|
Register |
Office 2010: How to Win in Office 2010 |
| Your new Microsoft Office 2010 is ready for you and this course prepares you for this fantastic new version of Office. You’ll learn tips and tricks and productivity tools in using the new User Interface and Features. This course is designed for current Office 2003 and 2007 users only as we will examine the differences and discuss what features and commands have moved and changed. We’ll work with the return of File, how to customize the Ribbon with your tab, use the new Backstage view, the insert and edit screen shots, and examine Outlook’s interface and changes. This course provides an overview of the new features in Word, Excel, Outlook, and PowerPoint. This class will lessen your frustration in using the new Office and increase your productivity with tons of shortcuts and tools. Your new Microsoft Office is ready for you and with this course you will be ready for the new Office. Come learn how to win with Office 2010! |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
OFFICE2010 (19AUG2013)
Learn More... |
Aug 19, 2013 |
Aug 19, 2013 |
Briarcliff Campus |
$355.00 |
Greg Creech
|
Register |
OneNote - Notebooks for the Digital Age |
This half day workship tackles Microsoft’s OneNote application and brings the old-fashion spiral notebook and scrapbook into the information age. We will build a OneNote file with tabs, divisions, and pages. We will add text boxes, videos, sound, and information from other applications, such as Outlook, PDF, and Word. This class teaches you how to use templates for agendas, class notes, projects, to-do lists, and many other ways of using OneNote to capture all of your electronic files and information in one, organized place.
Prerequisite: Comfortable using Microsoft Office. Bring your photos, files, videos, and other digital media to incorporate into your OneNote notebook. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
ONENOTE (10JUL2013)
Learn More... |
Jul 10, 2013 |
Jul 10, 2013 |
Alpharetta Campus |
$250.00 |
Greg Creech
|
Register |
Outlook 2007: Lookout It's Outlook! |
| Is Outlook looking out for you? Need to learn how to send an e-mail with attachments? Manage your contacts, calendar and tasks? Look Out! This course is for you. We concentrate on the full version of Outlook including the calendar and tasks. Learn how to organize all of your contacts, both personal and professional. We also review Outlook Express, which includes email and the address book. Use Outlook’s fantastic calendar system, learn to create and back up folders and have fun looking at all Outlook can do. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
OUTLOOK (17JUL2013)
Learn More... |
Jul 17, 2013 |
Jul 17, 2013 |
Briarcliff Campus |
$355.00 |
Greg Creech
|
Register |
Powerpoint 2010 Level 2: PowerPoint Power |
THIS CLASS WILL COVER BOTH POWERPOINT 2007 AND 2010
You’ll create your own PowerPoint presentation and template to help with your branding and customization of PowerPoint. We’ll learn the new interface including the Ribbon, the Tabs, and other important new elements. As we build our presentation, we’ll learn how to present using PowerPoint’s slide show options and create interactive slides with the web and other applications. Our slides will include: Charts, Diagrams, Photos, Clip Art, Text, Bullets and Numbers, Tables, Sound, and Movies. We’ll discuss the importance of color, animation, and presenting with PowerPoint. You’ll not only learn how to create a dynamic PowerPoint presentation from scratch but also how to present your presentation like a pro. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
POWERPOINT-LVL2 (16JUL2013)
Learn More... |
Jul 16, 2013 |
Jul 23, 2013 |
Briarcliff Campus |
$415.00 |
Greg Creech
|
Register |
Powerpoint Pizzazz |
| This half day workship covers creating and enhancing PowerPoint presentations with Animations, Transitions, Multimedia including Videos and Music, and tips in presenting with PowerPoint.
No more boring presentations! We designed this course for existing PowerPoint users who know the basics of editing and creating a presentation. This offering will take you to a new and entertaining level of developing PowerPoint presentations to include appropriate animations for progressive disclosure, introducing charts and graphs, incorporating music and videos into your presentation. You will learn important tips in branding, using color, and presenting with PowerPoint. You will jazz up those presentations to ensure that your audience’s attention and retention rate increases dramatically and you will enjoy making presentations as PowerPoint does much of the work for you. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
POWERPOINT PIZZAZZ (27AUG2013)
Learn More... |
Aug 27, 2013 |
Aug 27, 2013 |
Alpharetta Campus |
$250.00 |
Greg Creech
|
Register |
Win with Windows 7 |
| In this half day workshop, we will learn about Windows 7, the fantastic operating system by Microsoft. This education workshop will lessen your confusion and help you to become more productive in using Windows 7’s new features and enhanced services quickly. This course will teach you the new navigation techniques in using Windows Explorer, the Taskbar, and the Start Menu. You will learn how to customize Windows 7’s folders, views, layouts, and properties. We will explore new features of Windows including Snap and Snipping Tool. We will look at the new Control Panel and Device screen as well as productive Desktop items, such as the new Notification Area and Show Desktop feature. The course covers the enhanced and improved search features, libraries, and gadgets. Join us for a fun and productive session as we discover the power and ease-of-use in Windows 7. You’ll find out why Windows 7 has received rave reviews. Come experience computer heaven with Windows 7. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
WIN7 (29JUL2013)
Learn More... |
Jul 29, 2013 |
Jul 29, 2013 |
Alpharetta Campus |
$250.00 |
Greg Creech
|
Register |
Access 2010 Level 1: Introduction |
| You have worked with Microsoft Access 2007(or earlier) and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course you will be introduced to the new features available in Microsoft Office Access 2010. Using the new and enhanced features in Access, you will be able to create a highly functional database. Knowing the tools that allow you to accomplish these operations will greatly expand your Access capabilities. The textbook for this class is provided. |
| Inquire |
HR - Excel and Access |
| This course is designed for the Human Resources Generalist, Specialist, or Manager to analyze and track HR data and information using databases including Excel and Access. This unique two day course combines Excel and Access databases for the HR person to manipulate data and to analyze data using Excel’s PivotTables and Access’ Queries and objects. Here are some of the items we will learn:
Know differences between Access and Excel Human Resources databases and information systems,
Analyze Human Resources data using Excel’s PivotTables and Access Queries and Reports,
Customize Excel information after downloading from HR applications, such as PeopleSoft, ADP, and Ceridian,
Manipulate data through Sorting and Filtering in Excel and Access
Create and edit Access queries and set criteria for data
Develop custom Total Compensation workbooks and worksheets using industry constructs |
| Inquire |
MS Excel 2010 Level 1: Introduction |
| Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 2010 by learning to create, edit, and print basic Excel documents with the latest version of this application! In this course, you will learn to speed up data entry, move and copy information, and create formulas to perform calculations. You'll prepare a document for printing by setting margins, page breaks, and more. Finally, you'll learn to manage large Excel documents, making your data more readable and more attractive with formatting techniques. |
| Inquire |
MS Project 2007 Level 1 and Level 2: Creating and Managing Projects |
| Learn to manage projects or participate on project teams. Then take that knowledge and apply it to hands-on exercises using Microsoft Project. This course discusses Gantt charts, tasks, critical paths, and resource management. You will also have the opportunity to work with a project plan once it has entered the project implementation phase. Learn to import and export Project data with Excel and other applications. Learn to update a Project Plan as changes occur during the project and create custom reports for project stakeholders. Finally, create templates to re-use project information in future projects. |
| Inquire |
MS Visio |
| Learn fundamental skills while creating several types of diagrams using Microsoft Visio. Create a directional map, a block diagram, a flowchart, an organization chart, and an office layout. As you create these drawings, you will learn to manipulate Visio master shapes, connect shapes, and format diagrams. Learn shortcuts to enhance your productivity and unique tools for each type of drawing. When you've completed the course, you will have the fundamental skills to create any kind of diagram using Visio. |
| Inquire |
Powerpoint 2010 Level 1: Introduction |
| Know how to impress your audience with a professional quality presentation? After this course, you will! PowerPoint is the world's most popular presentation software. So learn to use it's built-in templates and other features to create slides that effectively deliver your message. Enhance your presentation through formatting, charts, images, flowchart shapes, and more in this exciting course. |
| Inquire |
Word 2007 Level 2: My Word |
THIS CLASS WILL COVER BOTH WORD 2007 AND 2010
Make your documents appealing and customized using the powerful new features of 2007 Microsoft Word. We’ll examine and use the new interface including the Ribbon, tabs, mini-toolbar, and live preview. You’ll learn to create your own custom template and to format your documents through creating your own styles, special paragraph spacing and indents. We’ll add productive features to our documents, including pictures, diagrams, clip art, watermarks, and bullets. We’ll learn how to use Mail Merge for form letters and labels as well as how to create, edit, and use Tables in word to help you sort and sum your lists. You’ll see why Word is much more than a word processor. |
| Inquire |
Word 2010 Level 1: Introduction |
| Learn how to use the newest version of Microsoft Word. Explore the various components of the Microsoft Office Word 2007 environment. The course covers basic concepts such as creating, editing, and formatting of text and paragraphs. You will also add graphic elements to a document and include tables. In addition we will learn how to control page appearance by setting page margins, previewing the completed document, and printing it successfully. |
| Inquire |
