|
 |
 |
 |
| |
| |
| Title: | Complete Excel Course | | Price: | |
| Screenshot: | No Screenshot |
| Downloads: | 0 |
| |
| Date added: | Apr 18, 2006 |
Click here to buy
|
|
|
|
|
|
| CURRENT SPECIAL Was $145.00 Now $59.95 These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from `real world` experience and not made up class room scenarios. There are 50 lessons, each between 5 and 10 Word Document pages long, and 25 Workbook examples. There is also an online Microsoft Pivot Table tutorial as well as Time Saving Microsoft Excel Solutions. TIME SAVING MICROSOFT EXCEL SOLUTIONS: It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions. No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches! 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 Utilised 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, CommandBars, 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 WorksheetFunctions 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 RefEdit Control, Finding the Active Control, Creating Controls at Runtime. |
|
|
|
NEWS
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » Advanced Excel Select
|
| If you ever tried to find cells containing conditional formats, formulas, comments, and such, you would appreciate Advanced Excel Select at its true value. Just two clicks to have the job done!It also introduces a feature useful in fast table formatting: ...
|
|
| 1 - 5 Licenses | 25.76 EUR | | 6 - 10 Licenses | 23.18 EUR | | 11+ Licenses | 20.60 EUR |
| Downloads: 0 |
| Date added: Apr 18, 2006 |
» Click here to buy
» Details |
|
|
| » Agency Scheduler for 200 Nurses and 20 Hospitals
|
| The Nurse Dispatcher is used by staffing agencies providing nurses to work up to 3 daily shifts at several different hospitals. It can also be used for other applications where you need to send people to work different shifts at different locations. You s ...
|
|
| |
|
| » Call and Task Scheduler for 20 Doctors
|
| The calls and tasks spreadsheet allows you to schedule 4 daily calls and 50 daily tasks to 20 doctors. Doctors are assigned to calls via drop-down menus. In a like manner, one or two daily tasks can be assigned to each doctor. A table is provided for you ...
|
|
| |
|
| » Employee Shift Scheduler for Excel
|
| Shift Scheduler for Excel is an affordable spreadsheet that runs in Microsoft Excel (sold separately). With Shift Scheduler, you can easily create professional looking shift schedules. Shift Scheduler was designed for use in small businesses with fewer th ...
|
|
| |
|
| » Call Scheduler for 30 Doctors
|
| The Doctors Call Scheduler Excel spreadsheet schedules doctor`s daily calls for a full year. It was developed with the assistance of a doctor responsible for scheduling 30 doctors to 5 calls per day for an anesthesiology clinic. You simply specify the doc ...
|
|
| |
|
| » Employee Scheduler for Excel and OpenOffice
|
| An Excel-based scheduler for hourly and salaried employees, developed for use in a restaurant although it should fit most situations where you have hourly employees, or a salaried manager overseeing hourly employees. Allows you to schedule employee hours ...
|
|
| |
|
| » Complex-200 Shift Scheduler
|
| The Complex-200 Excel spreadsheet creates schedules where each employee can be assigned to a category (manager, cook, waiter, etc.), a location (Store A, Store B, etc.) and a time (10:30 AM - 4:30 PM) each day for up to 4 weeks. The spreadsheet can enforc ...
|
|
| |
|
| » Complex-100 Shift Scheduler
|
| The Complex-100 Excel spreadsheet creates schedules where each employee can be assigned to a category (manager, cook, waiter, etc.), a location (Store A, Store B, etc.) and a time (10:30 AM - 4:30 PM) each day for up to 4 weeks. The spreadsheet can enforc ...
|
|
| |
|
| » Calendar 100 People to Tasks With Excel
|
| Assign people in 25 groups to 75 tasks on a simple Excel calendar scheduler. Up to 40 tasks can be scheduled each day and you can assign up to 10 tasks per person each day from drop-down menus of available people. Up to 10 vacation periods can be assigned ...
|
|
| |
|
| » ABC Amber QuattroPro Converter
|
| ABC Amber QuattroPro Converter is an advanced tool to convert your QuattroPro spreadsheets into any format you wish (PDF, DBF, CSV, XML, XLS, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly. ...
|
|
| |
|
| » Calendar 200 People to Tasks With Excel
|
| Assign people in 25 groups to 75 tasks on a simple Excel calendar scheduler. Up to 40 tasks can be scheduled each day and you can assign up to 10 tasks per person each day from drop-down menus of available people. Up to 10 vacation periods can be assigned ...
|
|
| |
|
| » XLS Converter - Professional Edition
|
| XLS Converter can easily convert the excel file to txt, html, csv, mdb, dbf,etc. The processing is as quickly as possible. MS Excel is doesn`t required! The interface is very neat and very powerful, you don`t need to open windows explore first, you can se ...
|
|
| |
|
| » ABC Amber Excel Converter
|
| ABC Amber Excel Converter is an advanced tool to convert your Excel spreadsheets (xls) into any format you wish (PDF, DBF, CSV, XML, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly. ...
|
|
| |
|
| » Crew Maker for 100 Employees and 5 Jobs
|
| The CM-5-100 crew maker spreadsheet allows you to assign 100 employees to 5 daily jobs and is ideal for businesses that need to create job-specific work crews that may vary in composition from day-to-day. Up to 6 different employee categories and 8 differ ...
|
|
| |
|
| » Complex-25 Shift Scheduler
|
| The Complex-25 Excel spreadsheet creates schedules where each employee can be assigned to a category (manager, cook, waiter, etc.), a location (Store A, Store B, etc.) and a time (10:30 AM - 4:30 PM) each day for up to 4 weeks. The spreadsheet can enforce ...
|
|
| |
|
| » Asset Register PRO For Excel
|
| Asset Register PRO 5.2 - Excel add-0n. Our new version 5.2 released July 1, 2005 is separated into two separate zip files. Version 5.2/S/L provides customers with an easy to use Asset Register which can be used within any country with S/L depreciation rul ...
|
|
| |
|
| » Advanced Data Grid Control - Standard License
|
| This java Data Grid Control applet enables the display of data in rows and columns in java & web applications. Powerful features include Fast Sorting, Data Acquisition, URL Hyperlinks, Embedded Images, Column Totalling and much more. Enables Dynamic inter ...
|
|
| |
|
| » Automatic Calls for 100 Doctors with Excel
|
| Automatically schedule up to 100 doctors to 10 daily calls each day for up to a year with Excel. Call preferences and qualifications are combined with doctor availability and call history each day to randomly select who is assigned to each call. Holiday a ...
|
|
| |
|
| » Automatic Calls for 50 Doctors with Excel
|
| Automatically schedule up to 50 doctors to 10 daily calls each day for up to a year with Excel. Call preferences and qualifications are combined with doctor availability and call history each day to randomly select who is assigned to each call. Holiday an ...
|
|
| |
|
| » COMxL RS232C
|
| COMxL RS232C @ TCPIP is an ease-to-use and very-helpful Add-Ons/Add-Ins for MS Excel 97/2000 `s user. It lets you link your instrument to your any Excel worksheet directly via RS232 port. The readings from instrument can go/fill-in anywhere you want to th ...
|
|
| |
|
| |
|
|
 |
 |
 |
 |
|
|
