Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Training Bible

 

 NEW!Excel 2007+Training Level 1 &Excel 2007+Training

Excel Training Bible You will be able to download your software immediantley after purchase $119.95 Secure Payment Options

The Complete Excel Training Bible: Courses101-201-301-401–501 -601 & 701.

Complete training in all aspects of Excel applications with spreadsheet examples.

Learn all the hidden secrets within Excel for more effective working and save hours of work time.

Unlimited version licenses means that the download files can be shared among work colleagues.

Learn how to write Macros to automate repetitive tasks in your Excel
Step by step development of VBA applications and you can copy the VBA codes into your Excel VBA editor.

Information from course 101-104 are:

EXCEL COURSE 101 introduces newcomers to Excel and remind older hands of the power of Excel working with Formulas and Functions. Easy to read in Microsoft Word step by step guide in English covering: > In depth Formula and Function rules, what is meant by Cell References, Absolute and Relative cell references, using the AutoSum function, AutoCalculate rules, Nesting arguments, Syntax rules, Insert rules, Naming cell ranges, Averaging, Counting, CountIf, SumIf, working with Text, using Constants, using the Paste Name dialog, calculation operators and references, adding cell comments, using find and replace, Headers & Footers, Data Sorting, sorting alphanumeric text, single or multiple column sorting, Sorting numbers, Hiding and Unhiding rows and columns, creating Auto Formats, Charting options, formatting charts, charting options, cell protection options, explaining the If function and connecting arguments, correct use of brackets, using Volatile arguments, highlighting common problems with Dates and Times in Excel, interpreting Errors in Excel, suppressing errors, working with Add-Ins. Much more..

EXCEL COURSE 201 – Extracting information for Decisions The do’s and don’ts of data and text tables to make decision presentations clearer and easier. Step by step introduction using a data extraction problem as the example. Explaining the Vlookup and Hlookup functions and all Dfunctions. Applying Data validation, List validation, Text validation. Using Auditing options. Working with external data, external references, external data and external formula. Working with Auto Filters, Advanced Filters, Tables and Lists guidelines, compound filtering, dealing with blanks, Names Ranges. Using little known features in Excel: Placeholders, Sections, Colors, Suppressing values, Comparison Operators, Leading zeros, displaying symbols and currencies. Much more..

EXCEL COURSE 301 – Working with Pivot Tables. Course Outline: Understanding pivot tables – one of Excel’s most useful features. Why Pivot Tables? Pivot table advantages, Pivot charting, Pivot table guidelines, step by step guide to creating pivot tables, working with pivot tables, format pivot table options, data options, drill down, Queries, work with Pivot Table1.xls example, Field options, Grouping Fields, Rules using Pivot Table Names.

EXCEL COURSE 401 – Developing What-If Analysis in Excel. Working with financial scenarios and Goal Seek to analyze complex computations. How to create a default scenario, adding scenarios, using Names in scenarios as short cuts, displaying scenarios, preparing summary reports, merging scenarios from different shared workbooks, using Goal Seek.

Course 501 - How to develop macros for Excel automation. Course 601 - How to develop VBA modules within your Excel. Course 701 - How to Control user inputs to your spreadsheets with VBA UserForms

Excel Training Bible You will be able to download your software immediantley after purchase $119.95 Secure Payment Options

See Also More Excel Training


All Training Comes With Lifetime Free Question Support. Register Here Then Send Your Username & Order Number
Type/Level Cost Instant Download Bundled Savings Option
Excel Training  30 Day Money Back Guarantee
Complete Excel Course Special $59.95 YES N/A
Excel Level 1 Basic Free N/a N/A
Excel Level 2 Intermediate $29.95 YES Yes
Excel Level 3 Advanced $29.95 YES Yes
Excel Tips & Tricks Intermediate-Advanced $19.95 YES No
Excel VBA Training 30 Day Money Back Guarantee
Excel VBA 1 Basic $29.95 YES Yes
Excel VBA 2 (UserForms & ActiveX Controls) $29.95 YES Yes
Working With Excel Sheets In VBA 30 Day Money Back Guarantee      
EXCEL CHARTING (index of courses)  30 Day Money Back Guarantee $9.95 yes yes
EXCEL TRAINING VIDEOS 60 Day Money Back Guarantee
EXCEL VIDEO TRAINING $67.00 YES NO
VBA Coding Enhancement tools-basic to advanced vba experience
Code VBA Coding tools added to your Visual Basic editor (VBE) you create better VBA macros faster. Download Demo $99.00 YES No
Smart VBA VBA Development Tool for VBA Programmers. Download Demo $99.00 YES no
Print VBA Code Customizable printing of VBA source code in color with joining indicators $59.95 YES No
Excel Dashboard Learning Kit
Excel Dashboard Reports/Charts 365 Day Money Back Guarantee $49.95 YES Yes
Excel in the Stock Trading Market 30 Day Money Back Guarantee
Build an Automated Stock Trading System $89.95 YES No
Build an Automated Sector Fund System $89.95 YES No
Build an Automated Spread Trading System $89.95 YES No
Build an Cash Flow Valuation Model With Excel with Yahoo! Finance $49.95 YES No
Technical Indicators Library Open Source $89.95 YES No
Excel Finance & Statistic
Finance and Statistics Models $29.95 YES Yes
Random Numbers Generator and Statistics $29.95 YES Yes
Numerical Searching and Option Pricing Models $29.95 YES Yes
ACCESS/SQL
111+ POWER ACCESS/SQL QUERIES $39.95 YES N/A
 
Mathematics Aids With Demos
Speed Math for Mind: Speed Mind Maths-details/buy
DreamCalc Graphing Calculator-details/buy
DreamCalc Professional Calculator-details/buy
DreamCalc Scientific Calculator-details/buy
FindDec standard-details/buy | FindDec Professional-details/buy | FindDec Unlimited-details/buy
Aquarius Soft Pocket Binary Converter-details/buy
Aquarius Soft Pocket Currency Calculator-details/buy
Aquarius Soft Pocket Unit Converter-details/buy


Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft