Microsoft Office Training and Website Design Metro Atlanta - (678) 565-1974 February 2, 2010 - Chris Menard will teach Microsoft Excel to the Clayton State's Continuing Education Division Capstone Accounting class at the main campus in Morrow Georgia. Menard, who graduated from Clayton State with a BBA in Accounting, is also a frequent speaker for the Georgia Society of CPAs. Download Chris Menard's transcript of Certifications (small PDF) The Excel portion of the Capstone Accounting will cover topics such as conditional formatting, charts, data tables, functions, goal seek, and data analysis. The Capstone Accounting program is a 35 session program offered at Clayton State. Menard was recognized as Alumni of the year for the School of Business in 2007. Only 50 of 15,000 graduates from Clayton State have received this award. Chris Menard is also the first Microsoft Office Master Instructor world-wide. Several of Chris Menard's 2009 presentation highlights include: Featured speaker at the Georgia Society of CPAs Accounting & Auditing (A&A) conference in Duluth GA. This was the first time the GSCPA tried a hand-on Excel session with this many participants and it was a huge success. Chris Menard trained the Internal Revenue Service (IRS) in Atlanta in MS Office Word, Access, PowerPoint, and Excel. Presented to the Georgia Association for Primary Health Care, Inc. at Lake Oconee. Menard presented to the GSCPA's Southeastern Accounting Show (over 1,500 participants) in August 2009. Menard was featured in two sessions and anchored the closing session with "Microsoft Excel's Greatest Hits". Here are several free short Excel videos Menard created. Microsoft Office Training Specializing in Microsoft Office training, we offer courses in Microsoft Excel, Access, Word, Outlook and PowerPoint. Our training is for any Microsoft Office Suite. Example, we can cover MS Office XP, 2003, or the latest version, MS Office 2007. Our headquarters is located in Atlanta, but we can do on-site computer training at any location. We have clients in Roswell, Duluth, Lawrenceville, Smyrna, Macon, Gainesville, Orlando FL, Atlanta, and many other cities. Our computer lab is located in Stockbridge, GA. Click here to email Microsoft Office Master Instructor Chris Menard about corporate training. Upcoming Corporate Training in metro Atlanta Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Word 2007 Essentials - 8:30am start time February 4, 2010 - Microsoft Word 2007 Essentials from 8:30am to 1pm. Just some of the topics include: Working with the Quick Access Toolbar Using the Mini Toolbar Using Subscript and Superscript Changing the default line spacing in Word 2007 Paragraph alignment and formatting Working with the Format Painter Using Find and Replace Clayton State University Morrow, GA Excel Tips and Tricks for Accounting Students - 7pm February 9, 2010 - Microsoft Excel 2007 for Accountants. Chris Menard, Clayton State alumus, will present to the School of Business Accounting students on February 9th. Menard, who also worked for Clayton State from 1997 to 2002, has a BBA in Accounting and frequently speaks to the Georgia Society of CPAs. Menard has been presenting to the School of Business since 2003. Using the auditing toolbar Excel functions: Average, Sumif, Countif, Max, Large, Small, and Median Working with duplicate information Using Conditional Formatting Using Data Validation Excel Keyboard shortcuts - small 1 page PDF Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Outlook 2007 Essentials - 8:30am start time February 24, 2010 - Microsoft Outlook 2007 Advanced from 8:30am to 1pm. Just some of the topics include: Mail Merge with Outlook Mail Merge with Contacts in Outlook Using the Calendar Printing Assistant Wizard in Outlook Voting Buttons Assigning Task Scheduling Meetings Importing Contacts from MS Excel Creating Rules in Outlook 2007 Publishing a calendar to the web Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Microsoft PowerPoint 2007 Advanced - 8:30am start time March 24, 2010 - Microsoft PowerPoint Advanced training from 8:30am to 1pm. Just some of the topics include: Inserting video clips Inserting Sound clips Making sounds clips play through multiple slides Working with large images and pictures in PowerPoint Going from Landscape to Portrait slides in PowerPoint Animating charts Inserting charts from MS Excel Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Word 2007 Advanced - 8:30am start time March 29, 2010 - Microsoft Word 2007 Advanced training from 8:30am to 1pm. Just some of the topics include: Working with Master Document and Sub Documents Creating an Index Creating a Table of Contents Working with Bookmarks Using StyleRef in heading Working with the Document Map Free Videos on Excel 2007 and Outlook Calendar Printing Assistant Excel 2003 or 2007 - Copy different text down a column quickly This video came from the GSCPA webinar on May 4, 2009. A client sends you data in Excel and you can't filter, sort, subtotal, or data validation due to the way it is set up. You can you a keyboard shortcut to quickly get the data corrected. Excel 2007 - Primary and Secondary axis combination chart Video Trying to chart percentages and numbers? If the variance is too large, it is hard to get a chart. See Chris Menard create a combination chart with 2 axes in Excel 2007. Excel - Use the Index and Match Function Excel's max function will find the highest value, but what if you want to know who was it that was the largest? You can use Excel's index and match function together, as a nested function to figure it out. Use Excel's workday function You can use Excel's workday function to calculate a future date that excludes weekends and holidays. Example: you mail out a letter and the recipient has 10 business days to reply. If December 24 and 25 are during the week, the weekday function will exclude them. Data Validation on a separate worksheet. VLookup Function is also shown. Excel's data validation list allows restricts the data or values that users enter into a cell. Chris Menard shows you in this video how to put your data validation list on another worksheet. Naming a range and Vlookup are also used in this video. Excel - Advanced Data Validation - Indirect Function. In this advanced video, Chris Menard uses Excel's indirect Function to make one data validation list dependent on another. This was a great question that came up during training in Atlanta from a client that does business in the contiguous U.S. When they pick a region, example southeast, they only want to see the southeast states not all 48 states. If you don't know how to name ranges, please see this data validation video first. Excel - Charts - Make Static You want to update your data, but keep your chart static. By default, charts are linked to data. In this video, Chris Menard will show you how to take an existing Excel chart and keep it from getting updated. Excel - Create a custom sort for text and values You want to sort a list in Ascending order but have values and text. Excel will sort by the values first. In this video, Chris Menard shows you how to sort by the text first, then the values using Conditional Formatting. Excel - sum multiple regions quickly using the CTRL key If you know how AutoSum and Autofill work, this will save you time when you need to sum multiple regions. Excel - remove duplicates and use Countif Excel 2007 has a new feature for removing duplicate data. You can use the Countif function to count only specific criteria. Calendar Printing Assistant Video for Outlook 2007. The Calendar Printing Assistant for Office Outlook 2007 is an application for people who need an easy way to print and customize their Outlook 2007 calendar information. It is for Outlook 2007 only, it will not work with previous Outlook versions. Other reasons to use the Calendar Printing Assistant for Outlook 2007: Print dynamic calendars in day, week, month, and year views. You can also print your Tasks (To-Do List) with the calendar. Print multiple shared calendars at once. Fixes the issues with the monthly calendar in Outlook not printing all the appointments. Supports a wide variety of layout templates. The Calendar Printing Assistant is a separate program from Outlook. Visit this Microsoft website to download the Calendar Printing Assistant for Outlook 2007. Video on using Total Commander to sync files Sync File with Total Commander Need to sync the files on your flash drive and work computer, or between two folders? Use Total Commander to sync files. Recent Corporate Training The Georgia Association for Primary Health Care Annual Conference Lake Oconee - Greensboro, Georgia. Location is the Ritz Carlton Lodge, Reynolds Plantation Monday, October 19, 2009 2:00pm to 3:15pm - Microsoft Office Word, Outlook, and PowerPoint 2007 3:30pm to 4:45pm - Microsoft Excel In this session, Chris Menard, will show tips and tricks in three Microsoft Office popular applications: Word, Outlook, and PowerPoint 2007 Available Downloads: GAPHC 2 page handout on Word and Excel 2007 File size for printing: (8 MB) Word Keyboard shortcuts - small 1 page PDF Excel Keyboard shortcuts - small 1 page PDF PowerPoint SlideShow Shortcuts - small 1 page PDF Polk School District in Cedartown, GA Microsoft Excel 2007 Level 1 and Level 2 training Tuesday, June 16, 2009 - Microsoft Excel training from 9am to 4pm. Just some of the topics from MS Excel 2007 include: Using the Ribbons Using the Office button Use Conditional Formatting - Data bars, icon sets, and top/bottom rules Formatting text and numbers Working with dates Using Autosum, Average, Max, Min, Count, Countif, Sumif, and Payment Cut, copy and paste Creating Charts and customizing chart designs Working with Subtotals and Data Validation Trintity Accounting Group- Certified Public Accountants Athens, Georgia Excel 2007 for CPAs - Accounting & Auditing Credit (A&A) Wednesday, October 21st, 2009, 8:30am to 4pm Using the Auditing toolbar Working with Financial functions Data Analysis with Filters - and, or, and Advanced filters Creating charts - columns, bar, pie, and custom charts Using Subtotals in Excel 2007 Outlining a worksheet Excel keyboard shortcuts - small 1 page PDF Trinity Accounting Group 2 page handout on Word and Excel 2007 File size for printing: (8 MB) Georgia Society of CPAs - SEAS College Park, Georgia. Location is the Georgia International Convention Center Microsoft Excel's Greatest Hits Thursday, August 27, 2009 - Microsoft Excel's Greatest hits. Just some of the topics include: Creating static charts Creating running charts - example: running 12 months. Using a data validation based on another data validation Updating multiple worksheets at the same time Writing Macros Working with comments Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Access 2007 Essentials Friday, October 23, 2009 - Microsoft Access 2007 training from 8:30am to 5pm. Just some of the topics include: Working with Tables - creating from scratch and using the table wizard Queries - simple, And, and Or Creating reports with the report wizard Using Access forms to input data Sorting and Filtering in Access 2007 Rubber Network LLC in Atlanta Georgia Microsoft Office 2007 Training Tuesday, April 28, 2009 - Microsoft Office 2007 Training. What's new in Excel, Word, Outlook, and PowerPoint 2007. Just some of the topics include Using the Ribbon and Tabs New features in Excel 2007 - Functions, Charts, AutoFilter Working with Word 2007 Cover Pages, SmartArt, and Contextual Spelling PowerPoint 2007 - using Themes, new layouts for slides, custom layouts LMS Intellibound - Norcross, Georgia Microsoft PowerPoint 2003 Basic and Advanced Training April 21, 2009 - Microsoft PowerPoint training: Using Design Templates Correct use of images and pictures in PowerPoint Compressing Photos Use slide layout Customizing the background Working with the Slide Master Using Tables and Chart Changing the background Rehearse timing Slide transitions and customizing animation Agenda for PowerPoint 2003 with Chris Menard PowerPoint published to the web Word Document into PowerPoint Video on Saving PowerPoint as a Web Page Saving an SWF file in PowerPoint Coal Marketing Company, LTD. Atlanta, GA Microsoft Office 2007 Overview Tuesday, February 17, 2009 - Microsoft Excel, Word, PowerPoint, and Outlook 2007 training from 10:00am to 2pm. Just some of the topics from Office 2007 include: Using the Ribbon Working with Tabs on the ribbon Excel - Data Analysis with Subtotals, new Sorting features, new Filters features Word 2007 - new features: convert to PDF, SmartArt, Tables, Pictures, Contextual Spelling PowerPoint 2007 - working with themes, new layouts, and slide show options Word 2007 Handout Excel 2007 Handout ZF Manufacturing in Gainesville, Georgia develops and produces transmissions, steering systems, axles, and chassis components as well as complete systems for passenger cars, commercial vehicles, and off-road machinery. ZF is also an important transmission specialist for special and rail vehicles, marine craft, and helicopters. October 14 and 15, 2008 - Microsoft Excel 2003 Training. Just some of the topics from Excel 2003 include: Using Text to Columns Column vs Bar Charts Conditional Formatting Data Analysis features of Excel Filters and Advanced Filters Working with Subtotals Excel keyboard shortcuts - small 1 page PDF ZF Substitution function Southeast United Dairy Industry Association in Atlanta, Georgia Tuesday, November 18, 2008, Triality will train the staff of SUDIA in Excel, Word, and PowerPoint 2007. Southeast United Dairy Industry Association - SUDIA serves nine states in the southeast. Their mission is to provide the latest information about nutrition and dairy farming to help consumers make the most informed choices about their families' diets. Rubber Network LLC in Atlanta Georgia Microsoft Excel 2003 Training Wednesday, October 22, 2008 - Microsoft Excel 2007 Training. Just some of the topics from Excel 2003 include: Filter and Advanced Filter in Excel Subtotals Conditional Formatting Data Form Consolidating data 3D Referencing and Linking Advanced Functions Files for Excel training Georgia Association on Young Children in Duluth, GA Microsoft Word, PowerPoint, and Excel Training Thursday, October 9, 2008 - Microsoft Office Training from 1:30pm to 3:30pm. Just some of the topics from Windows include: Working with Tab Stops Using Tables Creating a presentation Managing files Section Breaks Word 2007 Handout in PDF format PowerPoint SlideShow Shortcuts small 1 page PDF Berman Fink Van Horn (BFV) in Atlanta, GA Microsoft Word 2007 - New Features and Advanced Word Wednesday, October 8, 2008 - Microsoft Word 2007 New Features and Advanced training for Attorneys. Topics include: Removing Metadata in Word 2007 New features of Word 2007 Section Breaks vs Page Breaks Working with Table of Contents Using Styles in Word 2007 Georgia-Pacific Corp in Atlanta, GA Microsoft Office 2007 Overview training Tuesday, July 1, 2008 - Microsoft Office 2007 - Word, Excel, PowerPoint, and Outlook training from 8:30am to 4pm. Georgia-Pacific executives will be trained by Chris Menard on the new features of Office 2007. Georgia-Pacific wants to utilize the new features in Office 2007 and called on Chris Menard to teach these features. Georgia-Pacific is one of the world's leading manufacturers of tissue, pulp, paper, packaging, building products and related chemicals. Georgia-Pacific makes building products, bath tissue, Dixie Cups, Napkins, and Paper Towels among many other products. Kids II in Alpharetta, GA As one of the world's fastest growing toy companies, Kids II is dedicated to meeting the evolving needs of parents everywhere. Over the last 35 years, Kids II have developed more than 70 award-winning products that have revolutionized the industry time and time again. Microsoft Excel Intermediate Training Wednesday, July 9, 2008 - Microsoft Excel 2007 intermediate training from 8:00am to 4pm. Just some of the topics from Excel include: Conditional Formatting Consolidating 3D referencing Auditing toolbar Sorting with Excel Filtering with MS Excel Listed below are the Excel and Word and PowerPoint shortcuts - 1 page each in PDF format Word Keyboard shortcuts - small 1 page PDF Excel keyboard shortcuts - small 1 page PDF PowerPoint SlideShow Shortcuts small 1 page PDF Kabobs, Owned by Heinz - Appetizers and hors d'�uvre company in Lake City, GA Microsoft Excel 2003 Training Thursday, September 25, 2008 - Microsoft Excel 2003 Training from 8:30am to 3:30pm. Just some of the topics from Excel 2003 include: Using Text to Columns Column vs Bar Charts Using Borders and Shading in cells Setting up worksheets correctly Working with Subtotals UCB Pharma in Smyrna, GA Microsoft Excel 2003 Advanced Training Wednesday, October 1, 2008 - Microsoft Excel 2003 Advanced training from 3pm to 5pm. Just some of the topics from Microsoft Excel 2007 include: New features in Excel 2007 Advanced Filters Working with Charts Chris Menard's favorite keyboard shortcuts Analyzing Data with Functions Pivot Tables Top 10 Working with Excel's Pivot Charts New Certification Achieved - February 2008 Chris Menard, the owner and President of Triality, recently achieved Microsoft Certified Application Specialist (MCAS) Instructor. Google News picked up Menard's MCAS Instructor achievement. Because Microsoft Certified Application Specialist Instructors have certified in 2007 Microsoft Office, they are the best choice for companies and corporate clients seeking Office 2007 training. To confirm they have the hands-on ability to use the 2007 Microsoft Office programs, Microsoft Certified Application Specialist Instructors are required to earn the latest certifications in: Microsoft Word Microsoft Excel® Microsoft PowerPoint® Microsoft Outlook® Windows Vista® Microsoft Access Instructional Experience Requirement Training Videos - Microsoft Excel 2007 Chris Menard, owner of Triality, is the 1st Microsoft Office Master Instructor for Office 2003, XP, Office 2000, and Office 97. Menard is featured on Microsoft's training web site. See all the Microsoft Office certifications (pdf file)Menard has received. Menard is a training provider and frequent speaker for the Georgia Society of CPAs. Chris will be speaking on August 29, 2007 at the Southeastern Accounting Show on Excel's Advanced features. The 100 minutes presentation counts for 2 hours of Accounting and Auditing (A&A) credit for CPAs. Office 2007, is completely different from previous versions of Office. The menu bar and toolbars are gone. Office now uses Ribbons. Click here to see a short video on how different Excel 2007 is from previous versions. Click here to see a short video on how filters have greatly improved in Excel 2007. Here is a short video on using the "ceiling" function and how to change the default workbook when Excel 2007 starts.