Microsoft Office Training and Website Design Metro Atlanta - (678) 565-1974 Saturday, August 28, 2010 - Chris Menard will present on Excel 2010/2007 to the Executive MBAs at the University of Georiga's Terry College of Business located in Buckhead GA. Menard's presentation will cover four different sessions in Microsoft Excel 2010/2007. Short Bio on Chris Menard: Download Chris Menard's transcript of Certifications (small PDF) Menard is a frequent speaker for the Georgia Society of CPAs. He will be presenting at the Accounting and Auditing Confernce in Duluth in October 2010. Microsoft Office Master Instructor for Office 2007 and 2003. Created an Excel 2007 training video for The Cola-Cola Company in Atlanta. The video was released to over 150 countries. Trainer for Gwinnett Medical Center with locations in Duluth and Lawrenceville. Here are several free short Excel videos Menard created. Click here to email Chris Menard about corporate training for your company. Terry College of Business - Executive MBA Program - Excel Training on Aug 28, 2010 in Buckhead Georgia Sessions 9am to 10:30am - Excel Essentials 10:45am to 12:15pm - Excel Intermediate 1 1pm to 2:30pm - Excel Intermediate 2 2:45pm to 4pm - Excel Advanced Files need for Excel training- Please download the one zip file. After downloading, put the one Excel file inside the zip file in "Documents" or "My Documents" Files for Sat, Aug 28, 2010 (zip file) Free Handouts for 8-28-2010 Executive MBA program- 2 page handout Quick Reference sheet on Word and Excel 2007 - 1.3MB Word Keyboard shortcuts - small 1 page PDF Excel Keyboard shortcuts - small 1 page PDF University Of Georiga - Continuing Education Open to the Public Chris Menard will be teaching classes for the Univerity of Georgia in Gwinnett. To sign up for the Microsoft Office 2007 classes use the "Online Registration Form" on the UGA's Professional Development site. If you live in any of the following cities, Duluth, Suwanee, Dacula, Grayson, Snellville, or Norcross, this is your opportunity to learn MS Office from a Microsoft Office Master Instructor. Microsoft Office 2007 Excel Essentials Training - UGA's Continuing Education Center - Gwinnett Campus September 22, 2010 - Excel 2007 Essentials Training. Just some of the topics include: Using Charts in Excel Use Functions in Excel. Covered will be Counta, Countif, Average, Max, Min, Large, Small Inserting and Deleting Worksheets Using Dates in Excel Working with the Excel Ribbon and Quick Access Toolbar Register online with the University of Georgia Microsoft Office 2007 Excel Intermediate Training - UGA's Continuing Education Center - Gwinnett Campus September 29, 2010 - Excel 2007 Intermediate Training. Just some of the topics include: Advanced Charts Creating a 3D Reference Linking Files Working with Filters and Advanced Filters Sorting by dates, text, and color Subtotals Register online with the University of Georgia Microsoft Office 2007 PowerPoint Essentials Training - UGA's Continuing Education Center - Gwinnett Campus October 7, 2010 - PowerPoint 2007 Essentials Training. Just some of the topics include: Changing layouts Creating new slides Working with Slide Show commands Working with Charts in PowerPoint Using Themes and Animation in PowerPoint Register online with the University of Georgia Upcoming Corporate Training in metro Atlanta Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Microsoft Excel 2007 Level 2 (Intermediate) - 8:30am start time August 25, 2010 - Microsoft Excel 2007 Intermediate training from 8:30am to 1pm. Just some of the topics include: Using Functions - SumIf, If, And, AverageIf, CountIfs Using Headers and Footers and Page Layout features Subtotals Page Breaks 3D Reference Using a Watch Windows Sorting Advanced Filters 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 Gwinnett Medical Center Lawrenceville and Duluth Georgia locations Microsoft PowerPoint 2007 Advanced - 8:30am start time September 23, 2010 - Microsoft PowerPoint 2007 training. Just some of the topics include: Working with video files in PowerPoint Creating a photo gallery Creating custom background images Working with the slide master and creating multiple slide masters Using sound files in many slides 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 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.