Saturday, May 6, 2017
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, valuable functions, different calculations, comments, Drawing toolbar, Edit Replace, 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.