Chris Menard to speak for the Georgia Society of CPAs on tips and tricks in Microsoft Excel Chris Menard, a Microsoft Certified Application Specialist Instructor for Microsoft Office 2007, will be speaking in June 2008 at the first annual Technology Conference hosted by the Georgia Society of CPAs. His 75 minute presentation will cover tips and tricks in Microsoft Excel. Download Chris Menard's transcript of Certifications (small PDF) The Georgia Society of Certified Public Accountants (GSCPA) is the premier professional organization for CPAs in the state of Georgia. Menard has been presenting to the Georgia Society of CPAs since 2003. Several of the past conferences he presented at were: Southeast Accounting Show Spring Decision Makers Savannah Tax Forum Accounting Institute 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 newest version, MS Office 2007. Our headquarters is located in metro Atlanta, but we can do on-site computer training at any location. Our computer lab is located in Stockbridge, GA. Upcoming Corporate Training in metro Atlanta ELESYS in Suwanee, GA May 8, 2008 - Microsoft Office 2007 training from 8:00am to 5pm. ELESYS provides a full range of safety systems to the automotive industry, including passive safety systems, such as advanced airbag sensors, passenger sensing, detection and occupant classification systems, and active safety systems, such as vehicle stability control, intelligent braking, and adaptive cruise control. Word 2007 Headers & Footers-Total number of Pages in the header or footer example: Page X of Y Word Keyboard shortcuts - small 1 page Word Document Excel keyboard shortcuts - small 1 page Word Document PowerPoint 2007 Presentation USB Flash Drive not recognized Gwinnett Medical Center in Lawrenceville, GA May 12, 2008 - Microsoft Word Level 1 from 8:30am to 1pm. Just some of the topics from Word include: Selecting Text Using Tab Stops Microsoft Words Format Painter Numbering List Bulleted List Headers and Footers Clayton State University's Continuing Education division in Roswell, GA Friday, May 30, 2008 - Microsoft Excel Intermediate for CPAs from 8:30am to 4:30pm. This class counts for Accounting and Auditing Credit - A&A. Hours can also be used for CPE credit. Chris Menard is a featured speaker for the Georgia Society of CPAs. Chris is teaching this class for the Continuing Education division at Clayton State Univsersity. To register, please call (678) 466-5090. Just some of the topics from MS Excel include: Consolidating Data Auditing toolbar Excel charts Data Analysis Financial Functions Linking and 3D references with MS Excel Gwinnett Medical Center in Lawrenceville, GA May 23, 2008 - Microsoft Outlook 8:30am to 1pm. Just some of the topics from MS Outlook include: Delayed Delivery Creating a Distribution List Voting Buttons Creating Task Recurring tasks Assigning tasks Working with the Outlook calendar Recent Corporate Training Thomas, Kayden, Horstemeyer & Risley On April 17, 2008, Triality trained the staff of Thomas, Kayden, Horstemeyer & Risley in Atlanta on Microsoft Word 2003. Thomas|Kayden practice exclusively in intellectual property law, including the law of patents, trademarks, copyrights, unfair competition, and related litigation. Just some of the topics covered include: Creating Master Documents Word 2007 new features Creating forms Working with Word styles Using Word Equation editor Mail Merge and writing switches The Coca-Company Company in Atlanta GA - Microsoft Access 2007 Training In March 2008, Triality trained Coca-Cola Company in Access 2007. Just some of the topics covered included: Queries Filtering Microsoft Access Tables Reports Going from Microsoft Excel to Access Advanced Queries in Access Download Microsoft Access files for Coca-Cola training zip file - 519KB Southeast United Dairy Industry Association - Windows Training On March 26, 2008, Triality trained the staff of Southeast United Dairy Industry Association - SUDIA in Atlanta on Windows XP SUDIA is the "3-A-Day of Dairy" people in the Southeast, representing dairy farm families across the region. They represent dairy farmers in the media and promote the government-recommended three servings of dairy a day. Just some of the topics covered include: Creating Shortcuts Creating Files Moving Copying Emailing large photos all at once Windows Keyboard Shortcuts and Run Menu Shortcuts - PDF file (19 KB) UCB - makers of Keppra, Zyrtec, and Metadate-CD - Excel Training Triality will be training the pharmaceuticals reps of UCB in Smyrna, Georgia in Microsoft Excel Intermediate and Advanced on March 31, 2008. The reps handle Metadate CD, Xyzal, and Tussionex Just some of the topics covered include: Filters Advanced Filter Excel Functions for RX analysis Subtotals Excel Charts Gwinnett Medical Center in Lawrenceville, GA - Word Training April 2, 2008 - Microsoft Word level 2 from 1pm to 5pm. Just some of the topics from Word level 2 include: Table of Contents Microsoft Word different headers and footers Creating an index Using Microsoft Word's Document Map Using styles Document Map Gwinnett Medical Center in Lawrenceville, GA - Access Training April 4, 2008 - Microsoft Access level 1 from 8am to 4pm. Just some of the topics from Access level 1 include: Creating Microsoft Access Tables in Design view Working with MS Access's 10 datatypes Creating queries Importing from Microsoft Excel into Access In February 2008, we trained the Business Intelligence Group of Coca-Cola in Atlanta. Training was in Microsoft Excel 2007. Just some of the topics covered included: Subtotals Pivot Tables Scenarios Data Tables Excel Functions - there are over 400 in Excel 2007 Excel Charts New City Site Developed by Triality - February 2008 The City of Stockbridge - located in Henry County Georgia Triality has developed a new web site for the City of Stockbridge. The site is among the few that allow you to sign up and pay for park pavilions online. Breadcrumbs appear horizontally near the top of each page that allows links back to previous pages. Photo gallery of the parks and available activities Flash slideshow on the home page. Managed by a flexible Content Management System including site-wide search, infinite nodes, dynamic menu. See more dynamic websites created by Triality. 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.