Microsoft Office Training and Website Design Metro Atlanta - (678) 565-1974 Recent accomplishments: Download Chris Menard's transcript of Certifications (small PDF) August 2011 - Trained the Executive MBAs at the University of Georgia's Terry College of Business in Excel 2010. August 2011 - Trained the IRS in Atlanta in Excel 2003. August 2011 - Trained the faculty and staff of Georgia Highlands College located in Cartersville GA in Advanced PowerPoint 2010. Trained Delta Air Lines in Atlanta - June 2011 Training Mizuno USA in Norcross GA - April and May 2011 June 2011 - Created the website of Smith, Welch, Webb & White attorney at law located in Henry County GA. They have four offices. Two of their largest offices are located in Stockbridge and McDonough GA. Their website features their own DUI and Personal Injury Blog post which post automatically show on their home page. Articles written by attorneys automatically get posted to the attorney's bio page and the practice area page. See Andrew Gebhardt's bio for an example. July 2011 - Updated the park pavilion online reservation program for the City of Stockbridge located in Henry County. The City of Stockbridge is one of the only cities or counties in Georgia to feature an online pavilion rental program. The original program was written in 2008, but the updated program features a pavilion search feature, users can book multiple pavilions at one time. Since the update on July 17, 2011, customers from over 16 different surrounding cities have booked pavilions! Video spotlight Creating a data validation in Excel. 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. More free Excel videos several free short Excel videos Menard created. Click here to email Chris Menard about corporate training for your company. Upcoming corporate training in metro Atlanta Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Microsoft Outlook Advanced 2007 - 8:30am start time January 17, 2012 - Microsoft Outlook Essentials from 8:30am to 1pm. Just some of the topics include: Sending and Receiving emails Working with task and recurring task Setting appointment and events on the calendar Creating folders Using Categories Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Microsoft Excel Essentials 2007 - 8:30am start time January 18, 2012 from 8:30am to 1pm. Just some of the topics include: Excel functions - AutoSum, Max, Min, Average Using the Format Painter Inserting and Deleting rows and columns AutoFix, Autocomplete, and Autofill Formatting numbers - Currency, Accounting, Comma Styles, and Percentages Using the Quick Access toolbar Printing and Print Preview Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Microsoft Office Excel 2007- Intermediate - 8:30am start time February 22, 2012 from 8:30am to 1pm. Just some of the topics include: Advancing Filtering Creating 3D formulas Outlining and Consolidating Data Creating Subtotals Changing Chart Axis. Working with charts with 2 axix. Auditing features Protection of cells on a worksheet 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. Community Center online rental Community Center Online rental program for cities, counties, banks, and municipalities. Basically, if you have any facility to rent this is the program for you. We have been in the e-commerce business since 2002. If you have a facility to rent, it can be a park pavilion, conference room, community center, our e-commerce online rental program is just what you need. Advantages of online rental of your facility: Increase in revenue! 24/7 booking. Decrease in phone tag. How much time to you spend playing phone tag and in the end the date they want isn't even available? Contract is filled out online. Client knows immediately if the date they want is available. No risk of double booking. Immediate collection on payments No bad checks! Flexibility to have multiple bookings in one day Security deposit refunds can be handled online or by check. E-Commerce References Kabobs specializes in appetizers and hors d' oeuvre. All their appetizers can be ordered online. Kabobs recently came out with their 2011 new product release of appetizers which features Roasted Vegetable Lasagna, BBQ Pulled Pork Biscuit, Potato Tangled Shrimp, and many other new appetizers. Their website features online ordering of over 100 items. Kabobs has been featured on the Food Network, and operates out of a 60,000 square foot, USDA approved facility. The City of Stockbridge website allows online rental of pavilions and their community center. In 2010, they had rentals from people in over 24 other cities - Conyers, Morrow, Hampton, Atlanta, Henry County, and East Point just to name a few. The reason their pavilions and community center are so popular is it is one of the few websites in Atlanta that features online reservations. Just simply pick a date, pick and time, and pay online. Sunset Farm Foods website has online ordering of sausage, ham, and smoked meats. One of the cool features of their website is the recipe submission and nutritional facts for their products are shown. Clayton State College needed an online graduate program application. We created this in 2007 for them. Potential students can start filling out the application and save their work. This allows the applicant to log back in and not have to restart the application. At the end of the application they pay online. 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 Kids II Alpharetta Georgia Excel 2007 Intermediate - 8:00am to Noon February 23, 2010 - Microsoft Excel 2007 Intermediate from 8:00am to noon. Just some of the topics include: Using a 3D Reference Linking Excel files Advanced formatting and custom formatting Creating an Outline with Excel 2007 PivotTables PivotCharts Scenarios and Data Tables Kids II Alpharetta Georgia Excel 2007 Advanced - 1:00pm to 5pm February 23, 2010 - Microsoft Excel 2007 Advanced from 1pm to 5pm. Just some of the topics include: Advanced Functions - Countif, Sumif, AverageIf, If, And, and Or Lookups and data tables Using Match and Index in Excel Data Validation PivotTables - Creating, Formatting, and Rearranging Importing and Exporting Data Scenarios and Data Tables Goal Seek 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 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.