Computers Etc Software Training Center, Inc
8888 Clairemont Mesa Blvd, Suite B
San Diego, CA 92123
(858) 578-9476

  Home > Excel >

Excel Package - Dec 1/8/15/22, 2017 (9AM-12:30PM)

Our Price: $299.00

Quantity in Stock:11
Product Code: E0742052

Learn Excel basics including how to create formulas and charts. Apply formatting, add headers/footers, page numbers, insert/delete rows/sheets/columns, etc. Lots of shortcuts and practical advice. Create more 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 and analyze formulas. Use advanced sorting, filtering, grouping, and outlining. Create Pivot Tables and Pivot Charts. Import/Export/Link/Embed data. Add Validation to spreadsheet. Learn the most important and useful functions: SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MAX, MIN, IF, IF AND, IF OR, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, SUMPRODUCT, VLOOKUP, HLOOKUP, PMT, FV, DATE, CONCATENATE, TRIM, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, ROUND, ISERROR, etc. Create Macros, use Goal Seek, Solver, Scenarios, and What-if Tables. Password Protect data.

Browse for more products in the same category as this item:

Excel > Package Deal