Home > Excel Business Solutions > Excel Productivity > Training and Tutorials > Knowledge Base Share

Knowledge Base

Excel knowledge base for training and tutorials

Excel Knowledge Base

Rate this solution:
(3/5 from 3 votes)
Knowledge Base screenshot
The Knowledge Base for Excel consists of examples and training resources to learn and master the core fundamentals of Microsoft Excel and VBA macro programming.

The Excel Knowledge Base is categorized into four main areas:

  • Core Excel 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, Auto Formats, Protection, Basic Charts, Basic Formatting, IF Function.
  • Core Excel fundamentals 2 - Improved working with Formulas, Worksheet Formulas, Extracting Data for Decision Making, Data Validation, Importing external data. Core fundamentals of Advanced Filters, Auto Filters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining.
  • Core Excel fundamentals3 - 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.
  • Core Knowledge chapters and advanced VBA and Macro developments.

The Excel Knowledge Base also includes Excel Add-Ins to improve spreadsheet presentations and increase productivity:

  • Duplication Manager
  • Formula Manager  
  • Number Manager  
  • Text Manager
  • Excel Plus  
  • Named Range Manager
  • Formula Reference Changer
  • Sheet Index Creator
  • File Size Reducer

The Excel Knowledge Base also includes an Open Doors membership to either host online meetings and invite professional managers to attend using an online Membership Connect software for question and answer conferences, and receive invitations to just attend member online meetings.

Get It

(Pricing is available on the next page)
(Updated on 2018-10-01)

Related Excel Solutions for Knowledge Base

Training CoursesTraining and Tutorials  Workbook and VBA ExamplesTraining and Tutorials  Functions and FormulasTraining and Tutorials  2010 Training CoursesTraining and Tutorials  Productivity Add-insTime Saving

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.