Wednesday, October 6, 2010

Excel Skills Pack - COMPLETE MICROSOFT EXCEL CORE KNOWLEDGE PACK


Core fundamentals 1. Keyboard functions, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function.

Core fundamentals 2. Improved working with Formulas, Worksheet Formulas, Extracting Data for Decision Making, Data Validation, Importing external data. Core fundamentals of Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining.

Core fundamentals 3. Learn Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files, Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.

Plus Core Knowledge chapters 4, 5, 6 and 7 VBA and Macro developments.

Special Bonus: Excel Add-Ins improve your spreadsheets presentations and reduce your spreadsheet working hours.
  • Duplication Manager
  • Formula Manager
  • Number Manager
  • Text Manager
  • Excel Plus
  • Named Range Manager
  • Formula Reference Changer
  • Sheet Index Creator
  • File Size Reducer Download or CD shipping.