:: Subscribe to our newsletter
 
Articles / Directory
06/17/2013
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



06/17/2013
Latest version of NeuralCode(v1.3) for
Neural Networks Trading.



06/17/2013
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



06/17/2013
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



02/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.



Free Excel Training

Other Excel Add-In, Templates and Training

Excel Training Course Lesson 1
  • Section 1A - Excel Fundamentals
    You will find that by following a few basic fundamental rules when starting a spreadsheet that you will be able to extract, change, modify, report, add and manipulate data in a way you never thought possible.

  • Section 1B - Workbooks
    Every single time you start Excel you are, by default, creating a New Blank Workbook. The name of your Workbook has the default name of Book1, until you save the Workbook as a different name. A Workbook is like the outer shell of the spreadsheet and contained within it are the Worksheet(s) and cells.

  • Section 1C - Toolbars
    The Toolbars in Excel are where all of Excelís features can be accessed. They contain both text and icons (pictures).

  • Section 1D - Worksheets
    All Workbooks must contain at least one Worksheet. All Worksheets contains 256 columns and 65,536 rows.

Excel Training Course Lesson 2
  • Section 2A - Copying or Cutting and Pasting
    Copying, Cutting and pasting is something you will no doubt be doing an awful lot of when working in Excel, especially when you start to use formulas to perform calculations.

  • Section 2B - Inserting Rows, Columns and Cells
    When working in Excel, there are times that you may need to insert an entire new row, an entire new column or only a single cell. Although the term Inserting gives the impression that you are actually adding another row, column or cell, you are in fact NOT.

Excel Training Course Lesson 3
  • Section 3A - Custom Formatting
    In this lesson we will look at how Excel sees Dates and Times and how formatting a cell affects the data within it.

  • Section 3B - The Undo/Redo Feature
    As with most Microsoft Office applications, Excel contains a very handy feature that allows us to Undo or Redo certain steps we have taken.

Excel Training Course Lesson 4
  • Section 4 - The basics for Formulas
    In this lesson we will start to take a look at what Excel does best and that is; work with formulas.

Excel Training Course Lesson 5
Excel Training Course Lesson 6
  • Section 6 - How Excel Calculates
    One of the fundamental things that you must know about Formulas and Functions is the method in which Excel performs calculations. We will not go into any great detail in this, but there are some basics all Excel users need to know.

Excel Training Course Lesson 7
  • Section 7 - Effective Printing
    Printing is an essential part of Excel. Even in these days of a paperless office, we need to be able to efficiently present data that people can understand and use to itís fullest capacity. In Excel, you can access the Page Setup dialog box via the File menu and have access to all the print options. This lesson covers the print options in details.

Excel Training Course Lesson 8
  • Section 8 - Sorting
    Data sorting is an extremely handy and versatile feature within Excel. Excel allows you to sort Worksheet data alphabetically, numerically or chronologically. This lesson discuss sorting in details.

Excel Training Course Lesson 9
  • Section 9 - Creating a Spreadsheet, Charting it and Password Protection
    In this day and age charts are widely used in business to represent data in another way apart from just digits in a Worksheet. Charts can add colour and style to a presentation and allow the reader to easily identify the trends and patterns that you may wish to relay. Charts can be created in a number of ways, but if you have never created a chart before, the Chart Wizard within Excel is probably the best way to start.

Excel Training Course Lesson 10
  • Section 10 - THE IF FUNCTION AND NESTING
    In this lesson we thought we would look at one of Excels most useful Functions, the IF Function and Nesting. The term nesting in Excel means using the result of one Function as the argument of another.


Back to Excel Add-in, Templates and Training Main Page


Special :
Get the Excel VBA Training for free when you purchase our Technical Indicators now!


 

Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners