GS-Calc 21.3

1. Introducing GS-Calc
2. Notational conventions (numbers, formulas, dates)

3. Performance and compatibility

   1. Ensuring high performance
   2. Formula compatibility between GS-Calc and other spreadsheets

4. Entering data

   1. Editing and filling cells
   2. Copying cells vs duplicating copied cells
   3. Using AutoScroll Range to automatically move between cells
   4. Entering numbers, text strings, date/time strings and error codes
   5. Using cell references
   6. Merging and splitting cells
   7. Entering formulas
   8. Using formula composer
   9. Using array formulas
   10. Update options
   11. Ensuring high performance
   12. Replacing formulas automatically in worksheets
   13. Entering Unicode characters
   14. Selecting cells, navigation, scrolling, key shortcuts
   15. Performing multiple selections to combine their values
   16. Inserting series
   17. Inserting sequences and series using formulas
   18. Drop-down lists
   19. Using the Increment, Decrement and Operations commands
   20. Spell-checking and adding Hunspell dictionaries
   21. Generating and inserting passwords

5. Worksheet views

   1. Splitting worksheet views
   2. Row and column synchronization options
   3. Selecting functions to display within the table toolbar and related options
   4. Hiding view elements / maximizing the table view display areas
   5. Cross-highlighting columns/rows for better readability
   6. Using the Dark Mode

6. Pivot Tables

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

7. Monte Carlo Simulations

   1. Using Monte Carlo simulations

8. Lookup functions

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

9. Output functions

   1. imageIf(), messageIf(), playSoundIf(), setFormatIf()

10. Solver functions

    1. Solver functions

11. Regular Expressions

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

12. Using the FILTER() function

    1. Filtering data tables
    2. Creating the Filtering Expressions

13. Using Python in GS-Calc()

    1. Using Python functions as UDF()
    2. Installing Python and GS-Calc integration

14. Inspecting cells and finding certain cell types

    1. Using the Inspect Cells pane

15. Comparing workbooks, worksheets and cell ranges

    1. Comparing workbooks, worksheets and cell ranges

16. 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

17. Charts and images

    1. Creating charts and selecting chart data
    2. Creating mini-charts in cells
    3. Inserting images, files in worksheets
    4. Images and lists of images in cells

18. Password protection

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

19. 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

20. Printing workbooks

    1. Printing and print previewing

21. Settings

    1. Modifying program settings
    2. Legacy compatibility

22. Scripting

    1. Methods, properties and sample usage
    2. Samples

23. Custom DLL libraries

    1. Adding functions in DLL libraries

24. COM Programming

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

25. Support

    1. Contacting technical support

26. Copyrights

    1. Copyrights