GS-Calc

1. Introducing GS-Calc

2. Entering data

   1. Editing and filling cells
   2. Entering numbers, text strings, date/time strings and error codes
   3. Using cell references
   4. Merging and splitting cells
   5. Entering formulas
   6. Using formula composer
   7. Using array formulas
   8. Ensuring high performance
   9. Replacing formulas automatically in worksheets
   10. Entering unicode characters
   11. Selecting cells, navigation, scrolling, key shortcuts
   12. Inserting series
   13. Inserting sequences and series using formulas
   14. Drop-down lists
   15. Using the Increment, Decrement and Operations commands
   16. Spell-checking and adding Hunspell dictionaries
   17. Generating and inserting passwords

3. Worksheet views

   1. Splitting worksheet views
   2. Row and column synchronization options

4. Pivot Tables

   1. Using pivot tables
   2. Creating Pivot Table Reports
   3. Pivot Table Functions

5. Monte Carlo Simulations

   1. Using Monte Carlo simulations

6. Lookup functions

   1. vLookUp() function
   2. hLookUp() function
   3. Match() function function
   4. Unique() function function
   5. Sort() function function

7. Regular Expressions

   1. Using regular expressions in formulas
   2. Find & Replace
   3. Syntax

8. Using the FILTER() function

   1. Filtering data tables
   2. Creating the Filtering Expressions

9. Inspecting cells and finding certain cell types

   1. Using the Inspect Cells pane

10. Formatting

    1. Data styles and numeric formats
    2. Using cell style palettes
    3. Using custom cell styles
    4. Conditional formatting
    5. Using hyperlinks
    6. Lists of images in cells
    7. Charts in cells

11. Charts and images

    1. Creating charts and selecting chart data

12. Password protection

    1. Protecting and encrypting workbooks
    2. Protecting workbook structure
    3. Protecting individual cells
    4. Protecting and encrypting workbooks

13. Opening and saving files

    1. Content and statistics
    2. Managing the list of recently used files and folders
    3. GS-Calc *.gsc and ODF *.ods files
    4. Excel (*.xlsx, *.xml, *.xls) files
    5. GS-Base (*.gsb) file
    6. PDF files
    7. Text files
    8. Text *.zip archives
    9. dBase/Clipper/FoxPro files
    10. MySQL files
    11. SQlite (*.db) files

14. Printing workbooks

    1. Printing and print previewing

15. Settings

    1. Modifying program settings
    2. Legacy compatibility

16. Scripting

    1. Methods, properties and sample usage
    2. Samples

17. Custom DLL libraries

    1. Adding functions in DLL libraries

18. COM Programming

    1. Interfaces, methods and properties
    2. C++ samples

19. Support

    1. Contacting technical support

20. Copyrights

    1. Copyrights