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