Categories
Applications
Business Finance
Database Management
Email & News Convertor
Inventory Systems
Multimedia & Design
Personal Finance
Personal Info Managers
Presentation Tools
Project Management
Software Development
Spreadsheets
Web Authoring & Development
Word Processing


Related
Multiple Regression Analysis
The Multiple Regression Analysis and Forecasting template provides a solid...
EXCEL to MySQL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....
MSSQL to EXCEL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....
MYSQL to Excel
MSSQL-to-Excel is a program to publish Microsoft SQL databases as Microsoft...
Project Management - Excel Business Tools
The Project Planning and Management excel template is designed as a generic...
Home : Business Finance : SpreadSheet :
Complete Excel Course

Complete Excel Course has 50 lessons written by OzGrid Business Applications. It helps you improve Excel skills and solute Excel problems by offering you EXCEL LEVELS 1,2 AND 3, VBA AND VBA USERFORMS.

Buy Now Download


Main features:

  • Developed on a professional basis and drawn from 'real world' experience.
    Each lesson is between 5 and 10 Word Document pages long, and there are 25 Workbook examples. 
  • TIME SAVING MICROSOFT EXCEL SOLUTIONS help you improve your Excel skills and find hundreds of time saving Excel solutions to Microsoft Excel problems. It is a downloadable book in Windows help file format and freeware. 
  • EXCEL LEVELS 1,2 AND 3 OUTLINE: The Fundamentals of Excel, 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.
  • Excel Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining
  • 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
  • VBA AND VBA USERFORMS OUTLINE: The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects, Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs. Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.
  • UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the ReEdit Control, Finding the Active Control, Creating Controls at Runtime.