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