Blackboard   |   BannerWeb   |   Student Email   |   Student Help Desk Staff / Faculty Email   |   Intranet   |   Sharepoint
Continuing Education, How to Register How to RegisterLanier Technical CollegeContinuing Education Home
    Skip Navigation LinksHome Page > Continuing Education > Microsoft Office Suite Training Outlines
 
Microsoft Office Suite Training Outlines
Computer Workshops Course Descriptions
Excel Introduction
  • Create, edit, and format worksheets
  • Navigate worksheets and customize the ribbon
  • Create and copy formulas and functions
  • Create and modify charts
  • Apply trendlines
  • Work with Borders and Shading
  • Understand relative, absolute, and mixed references
  • Use alignment, indent, and text control options
Excel Intermediate
  • Create headers and footers
  • Adjust page setup, print area, and print titles
  • Logical, financial and date functions
  • Freeze and unfreeze rows and columns
  • Sort worksheet data
  • Link cells and insert 3-D references
  • Use Conditional Formatting and Name Cells/Ranges
  • Perform data analysis
  • Use and customize templates
Excel Advanced
  • Data filters for sorting
  • Analyze data using VLookup, PivotTables and PivotCharts
  • Protect and audit workbooks
  • Merge and link workbooks
  • Consolidate worksheets and data validation
  • Insert Comments
  • Import and export data
  • Track Changes and Merge Workbooks
  • Use Excel Tables with Word Mail Merge
Outlook Introduction
  • Create and customize a message
  • Use mail management tools
  • Work with contacts/calendars/tasks/notes
PowerPoint Introduction
  • Create a presentation
  • Add visuals to slides: clipart, shapes, and tables
  • Use slides and color schemes
  • Create a slideshow to finalize presentation
PowerPoint Intermediate
  • Use Masters and Templates
  • Work with WordArt
  • Work with Graphics
  • Apply animation features
  • Create notes, handouts, and speaker notes
  • Design presentations for the web
PowerPoint Advanced
  • Connect multiple presentations
  • Broadcast a presentation over the Internet
  • Combine presentations
  • Package a presentation
  • Burn a presentation to a CD
  • Save and open presentations in nonnative file formats
  • Integrate the use of PowerPoint with Excel, Word, and Outlook
Word Introduction
  • Create, edit, save and print documents
  • Apply character effects and numbers
  • Use Microsoft’s wizards and templates
  • Change the layout of a document
  • Create graphics
  • Use Word’s editing tools
Word Intermediate
  • Work with tabs and automatic page numbers
  • Work with columns, sections, and bullets
  • Enhance text appearance with WordArt and graphics
  • Prepare a document for the Web
  • Working with tables
  • Work with headers, footers, and page setup
  • Prepare labels and envelopes
Word Advanced
  • Create a table of contents and index
  • Use Master documents
  • Use footnotes, endnotes, and cross-references
  • Perform mail merge
  • Apply formatting to paragraphs, headers, footers, and columns
  • Create a macro
  • Use charts, tables, and forms
Access Introduction
  • Create a database
  • Data entry and modification
  • Design a form/report
  • Query a database
  • Learn database theory
  • Filter data
  • Create relationships
Access Intermediate
  • Customize forms/queries/reports
  • Create/modify tables in design view
  • Use the Lookup and Input mask wizard
  • Database maintenance
  • Create web documents
Access Advanced
  • Create action and parameter queries
  • Create macros
  • Import, export, and protect data
  • Switchboards
  • Hyperlinks and linking
  • Table Analyzer wizard
  • Define relationships
  • Create/group/sort data Access pages
  • Modify input masks
  • Modify forms/queries/reports
For more information
please contact Penny Grindle at 770-533-6992 or
penny@laniertech.edu
Campuses / Contact Us / Directions

© 2014 Lanier Technical College
2990 Landrum Education Drive, Oakwood, Georgia 30566
Phone: 770-533-7000 | Fax: 770-531-6328
A Unit of the Technical College System of Georgia

An Equal Opportunity Institution | Disability Services | National Human Trafficking Resource Center