Computers Etc Software Training Center, Inc
9225 Dowdy Drive #103
San Diego, CA 92126
(858) 578-9476
Info@PC-Classes.com
You are here: Home > Excel 2003 > Package Deal
Sort By:
Page of 1  
E0342031 - Excel 2003 Package (Beg-Int-Adv) March 9/16/23/30, 2012 (1PM-4:15PM)
Our Price: $259.99

Learn how to create simple formulas and charts. Apply formatting, add headers/footers, page numbers, insert/delete rows/sheets/columns, etc. Lots of shortcuts and practical advice. Create advanced formulas that include Absolute Cell References, the Order of Operations, and 3D Formulas. Link and Consolidate data from different sheets/files. Use Formula Auditing to troubleshoot errors. Use advanced sorting, filtering, grouping, and outlining. Create Pivot Tables and Templates. Import/Export/Link/Embed data. Add Validation to spreadsheet. Learn the most important and useful functions: SUM, AVERAGE, MAX, MIN, IF, IF AND, IF OR, COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF, SUMPRODUCT, VLOOKUP, HLOOKUP, PMT, DATE, CONCATENATE, TRIM, etc. Create Macros, use "What-If" Tools such as Goal Seek, Solver, Scenarios, and What-if Tables. Password Protect data.
Z1018281 Certificate of Completion
Our Price: $5.00

Certificate of Completion (suitable for framing).