Business Applications

File Management
It’s not enough to be organized with files and folders in the filing cabinets. Now it’s just as important to keep good, organized records in a PC. This File Management class will give the students a better understanding of how to do just that by learning how to create, save, edit, delete, and navigate folders to help them find folders quickly and be more efficient on the job. This class will show students how to back up, use cloud storage, work with flash drives, and save attachments.
Class Length: 4 hrs.

MICROSOFT WORD 1 (WORD1)
This class introduces the basics of Word for Windows. We delve deep into the Word interface working hands on with the ribbon, tabs, quick access toolbar, status bar, toolbars, scroll bars, rulers, view modes and more! Students will learn to create, save, open, close, preview and print documents. We undo, redo, move, copy, cut, paste, drag, and drop! Auto correct, spell check is more of what we go over. We briefly touch on page setup, margins, alignment, paper size, page breaks as we discuss these functions more thoroughly in future classes.
Class Length: 4hrs

MICROSOFT WORD 2 (WORD2)
This module teaches students how to enhance the appearance of documents using character formatting. Specific topics include using format painter and the highlight feature, extend or collapse characters, shading and drop caps, control bullets and automatic numbering for paragraphs, and use symbols.
Class Length: 4hrs

MICROSOFT WORD 3 (WORD3)
This workshop is an extension of part A. Formatting Documents consists of not only text, but formatting paragraphs and entire pages. From page layout and margins, to page borders, page breaks and columns, indent paragraphs, change line spacing and alignment options, set custom tabs, change tab alignment, and use leaders, add borders, and control page and section breaks we will show students how to create professional looking documents every time!
Class Length: 4hrs

MICROSOFT WORD 4 (WORD4)
Learn to create templates for repetitive type documents and use the table feature to create list or forms. Each student will learn in a hands-on environment how to create and manage tables by inserting/deleting columns or rows, adjust column width and spacing, change the text direction, control borders, shading, and color, split and manage cells, draw, and erase cell borders, perform table calculations, sort text or numbers, and use Table Auto Format to create complex tables.
Class Length: 4hrs

MICROSOFT WORD 5 (WORD5)
In this course, students will learn how to navigate Microsoft Word to easily create newsletters and work with graphics. When successfully completed, they will be able to create newsletters, certificates and invitations using features such as column breaks, drop cap or page border, insert pictures from ClipArt Gallery, create WordArt, rotate, or align objects, create text boxes, enhance object appearance by changing colors, add a shadow or 3-D effect, group/ungroup objects and control the layering of objects
in a document.
Class Length: 4hrs

MICROSOFT WORD 6 (WORD6)
Students will learn how to customize form letters or maintain a mailing list to create labels and envelopes. Specific topics will include creating a form letter with merge codes, maintain a database of names, addresses, etc., merge labels or envelopes, create a catalog or list, use queries to select data, sort data files alphabetically or numerically, merge a Word document with data from Access or Excel.
Class Length: 4hrs

MICROSOFT WORD 7 (WORD7)
Students will learn how to use pre-set templates that they can edit and customize. Students will learn to create and edit cover pages, invoices, resumes, and more and how to save them to documents.
Class Length: 4hrs

MICROSOFT WORD 8 (WORD8)
When someone is working with a 20+ page document, he or she will want to be able to change and find specific pages or subjects quickly. In this course, students learn how to easily navigate multiple pages and paragraphs quickly, find and replace words, set bookmarks, create headers and footers, tables of contents, and track changes.
Class Length: 4hrs

MICROSOFT WORD 9 (WORD9)
In this final class, we help students navigate Word by showing you great shortcuts such as Autocorrect and Macros. Create AutoText entries to recall repetitive blocks of text and record Macros to play repetitive keystrokes for quicker entries.
Class Length: 4hrs

MICROSOFT WORD 10 (WORD10)
Recap & Review of all Word classes 1-9
Class Length: 4hrs

MICROSOFT EXCEL 1 (EXCEL1)
Create, edit, and format a spreadsheet. This part 1 class gets down to basics by controlling screen layout options, creating, saving, opening, closing, previewing, and printing workbooks. In this class we will show you how to move within a spreadsheet and manipulate the print area. Students will learn to edit data, undo, and redo, move, and copy text and formulas, use the fill handle to copy or create a series, insert, and delete columns and rows, format columns, text and numbers, control cell alignment, write basic formulas.
Class Length: 4hrs

MICROSOFT EXCEL 2 (EXCEL2)
This class is going to teach you advanced formatting to enhance the appearance of spreadsheets such as merging cells, working with multiple sheets in a file and work with multiple sheets by renaming, moving, copying, deleting, grouping, and linking formulas between sheets. Linking formulas between multiple files, viewing multiple sheets/ files and freezing titles will also be covered.
Class Length: 4hrs

MICROSOFT EXCEL 3 (EXCEL3)
This class is loaded with fun! Students will learn to create different types of charts including column, stacked, line and pie charts. We will show you how to embed charts and chart sheets, understand chart components, use chart AutoFormats, move, or resize an embedded chart, add new information to a chart, change the chart type and format, customize the chart axes, legend, titles, data markers, gridlines, plot area and add notes or arrows to a chart. We will also touch on inserting objects such as text boxes and shapes.
Class Length: 4hrs

MICROSOFT EXCEL 4 (EXCEL4)
This class will give students extensive hands-on practice in writing and copying formulas, working with absolute referencing, and understanding formula arguments, creating, and using range names in formulas and use of Trace Precedents/Trace Dependents to see how multiple formulas in a spreadsheet are linked.
Class Length: 4hrs

MICROSOFT EXCEL 5 (EXCEL5)
Once students have mastered the basics, you can now realize the power of Excel. Students will learn in a hands-on environment how to use Excel database features including sorting information, using a list as a database, creating database function formulas, working with the data form, using criteria to find records, filtering data to show specific records, calculating automatic database subtotals and totals and defining a criterion range. In addition, conditional IF statements, vertical and horizontal lookups, and pivot tables will be covered.
Class Length: 4hrs

MICROSOFT EXCEL 6 (EXCEL6)
In most business environments, it’s important to know if a project is over or under budget and to be able to pick out important data from large lists. This class is for those looking to make important data stand out. Conditional formatting helps raw data come to life by controlling the conditions you are looking for such as cells greater than or equal to a certain number.
Class Length: 4hrs

MICROSOFT EXCEL 7 (EXCEL 7)
We show students how to utilize the many templates Excel has to offer. Calendars, budgets, invoices, and statements are among the many you can choose to customize and show students how to customize these templates and save as an Excel file. We will work with a few of the more common templates and show you how to customize these templates to your needs and save as an Excel file.
Class Length: 4hrs

MICROSOFT EXCEL 8 (EXCEL8)
In this class, students learn to create, edit, and manipulate data using Pivot Tables and Pivot Charts.
Class Length: 4hrs

MICROSOFT EXCEL 9 (EXCEL9)
Shortcuts, tips & timesavers

MICROSOFT EXCEL 10 (EXCEL10)
Recap & Review of all that we’ve learned in Excel 1-9
Class Length: 4hrs

MICROSOFT POWERPOINT 1 (PPT1)
In part 1, students will learn to create presentations, add new slides, and know the difference between slide layouts and how to change the layout. We will show students how to navigate through each slide with ease as well as save, close and open files and select, edit redo, and undo slide and objects and create a photo album.
Class Length: 4 hrs.

MICROSOFT POWERPOINT 2 (PPT2)
Students will learn to create slide show effects such as transitions between slides and animations within a slide. Students work with themes, color schemes, and control the color of the slide show as well as work with the slide master, add text into shapes and insert and navigate 3D models. Print various types of handouts and notes pages as well.
Class Length: 4 hrs.

MICROSOFT POWERPOINT 3 (PPT3)
Students will learn the art of animations on a slide. They will also learn to control timings with transitions as well as animations.
Class Length: 4 hrs.

MICROSOFT POWERPOINT 4 (PPT4)
After showing students print options, we put the final touches on our presentation and hit play so we can sit back and watch the show!

MICROSOFT OUTLOOK 1 (OUTL1)
This workshop will include an overview of the different desktop tools including using Email, tracking appointments in the Calendar, keeping a Task List for “to do” items, using the Contacts module to maintain addresses and phone numbers and creating sticky notes to record important information.
Class Length: 4hrs

MICROSOFT OUTLOOK 2 (OUTL2)
Taking basic email function Specific topics include creating distribution lists, using voting buttons, working with signature files and out of office assistant, creating and using rules, integrate Outlook contacts with Word to create envelopes and letters, use field chooser and customize views in Outlook and set up and use the Journal feature to track activities you want recorded on a timeline.
Class Length: 4hrs

MICROSOFT OUTLOOK 3 (OUTL3)
In this class, we go beyond the essential email and calendar functions. Students will learn more about the options menu and how to customize signatures and themes for email as well as out of office assistant, creating and using rules, customizing views, and setting up the journal, tasks, and notes features.
Class Length: 4hrs

MICROSOFT OUTLOOK 4 (OUTL4)
Taking Outlook to a new level with changing views, creating, and managing rules, out of office assistant, voting buttons and creating email templates.
Class Length: 4hrs

• Emotional Intelligence workshop
• Time Management exercises
• Goal Achieving
• Job strategizing- One on one with our career coach
• Skills checklist
• Personality assessment
• Transferability of skills
• Employment opportunities in a remote world
• Your personal online brand
• What is Ideal, Realistic and Acceptable to you?
• Resume review and edits
• Linkedin Profile assessment and completion
• Interview coaching – creating your perfect pitch