Excel Skills Pack Long Description:
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
OPEN DOORS ONLINE MEETING ROOM: When you purchase, do join our Open Doors membership. Either host your own online meetings and invite professional managers to attend using our online Membership Connect software for question and answer conferences, AND receive invitations to just attend member online meetings. A free sign up form is provided in the return order confirmation email.
Your online meeting room awaits! Click this link > http://twitlk.com/t/i102