Learn how to use lists to extract, manipulate and analyze data. This training will explore Excel’s table-related features in this workshop, as well as creating custom lists, validating data entry, sorting and filtering data, creating and removing subtotals, pivot Tables and recording a macro. Topics: basics sort and filter data specify data validation criteria separate and concatenate text strings protect a worksheet work with custom lists convert data to a table create and remove subtotals create a pivot table link data between worksheets work with multiple worksheets compare workbooks record and use a macro and much more .... Include course materials, e-learning, tips, tricks and more. More than 20 years' experience as a computer instructor. Microsoft Certified Trainer. English or/and French Training. Individual and Group Training. Training in Montreal, Quebec, Ottawa and surrounding areas. Microsoft Excel for accountants and financial specialist I would like to offer my services as a trainer in Excel 2003-2007-2010-2013 basic/ advanced, Include course materials and people-oriented instruction experience. I can travel within Montreal to teach at your place (Office / Home) www.ithelp4u.ca www.ithelp4u.ca/fr support 24/7 support 24/7 support 24/7 support 24/7 support 24/7 support 24/7