Posted on 27-Jan-2015 18:08
Views 506
Learn how to use lists to extract, manipulate and analyze data. This training will explore Excels 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
Address 6452 rue perodeau Montreal QC
