LibreOffice Calc Guide 読書ノート

LibreOffice Calc Guide 7.6 版に基づく。

Table of Contents

• Calc Guide Chapter 1, Introduction ノート
  • What is Calc?
  • Spreadsheets, sheets, and cells
  • Calc main window
  • Creating, opening, and saving spreadsheets
  • Password protection
  • Navigating within spreadsheets
  • Selecting items in a spreadsheet
  • Working with columns and rows
  • Working with sheets
  • Viewing a spreadsheet
  • Using the Navigator
  • Using document properties
• Calc Guide Chapter 2, Entering and Editing Data ノート
  • Introduction
  • Entering data
  • Speeding up data entry
  • Merging and splitting cells
  • Sharing content between sheets
  • Validating cell contents
  • Editing data
  • Group and outline
  • Filtering
  • Sorting records
  • Find and replace
  • Searching and filtering with regular expressions
• Calc Guide Chapter 3, Creating Charts and Graphs ノート
  • Introduction
  • Chart Wizard
  • Using the Sidebar to change chart settings
  • Modifying charts
  • Selecting and moving chart elements
  • Changing chart type
  • Titles, subtitles, and axis names
  • Legends
  • Formatting chart backgrounds
  • Data range and series
  • Axes
  • Data labels
  • Chart Data Tables
  • Grids
  • 3D charts
  • Trend and mean value lines
  • Error bars
  • Adding drawing objects to charts
  • Resizing, moving, and positioning charts
  • Selecting multiple charts
  • Copying, exporting, and deleting charts
  • Gallery of chart types
  • Create box plots with whiskers in Calc
  • Sparklines
• Calc Guide Chapter 4, Formatting Data ノート
  • Introduction
  • Formatting data
  • AutoFormat of cells and sheets
  • Value highlighting
  • Using conditional formatting
  • Hiding and showing data
• Calc Guide Chapter 5, Using Styles and Templates ノート
  • What are styles? Why use them?
  • Calc style types
  • Applying cell styles
  • Applying page styles
  • Creating new styles
  • Using themes
  • Managing styles
  • What is a template? Why use one?
  • Using a template to create a spreadsheet
  • Creating a template
  • Editing a template
  • Changing the template assigned to a document
  • Adding templates obtained from other sources
  • Setting the default template
  • Organizing templates
• Calc Guide Chapter 6, Using Images and Graphics ノート
  • Introduction
  • Adding graphics (images) to a spreadsheet
  • Modifying images
  • Positioning, resizing, and arranging images
  • Using LibreOffice’s drawing tools
  • Additional tools
  • Using Fontwork
  • Generating a QR or Barcode
• Calc Guide Chapter 7, Printing, Exporting, Emailing, and Signing ノート
  • Printing
  • Using print ranges
  • Page breaks
  • Printing options for page styles
  • Headers and footers
  • Exporting to PDF
  • Exporting to other formats
  • Emailing spreadsheets
  • Digital signing of documents
  • Removing personal data
• Calc Guide Chapter 8, Using Formulas and Functions ノート
  • Introduction
  • Setting up a spreadsheet
  • Creating formulas
  • Understanding functions
  • Strategies for creating formulas and functions
  • Finding and fixing errors
  • Examples of functions
  • Volatile / non-volatile functions
  • Using wildcards and regular expressions in functions
  • Advanced functions
• Calc Guide Chapter 9, Using Pivot Tables ノート
  • Introduction
  • The Pivot Table Layout dialog
  • Working with the results of the pivot table
  • Using pivot table results elsewhere
  • Using pivot charts
• Calc Guide Chapter 10, Data Analysis ノート
  • Introduction
  • Consolidating data
  • Creating subtotals
  • Using scenarios
  • Using the Multiple Operations tool
  • Using Goal Seek
  • Using the Solver
  • Using Statistics tools
• Calc Guide Chapter 11, Linking Data ノート
  • Using multiple sheets
  • Referencing other documents
  • Using hyperlinks and URLs
  • Linking to external data
  • Linking to registered data sources
  • Embedding spreadsheets
  • XML Source
• Calc Guide Chapter 12, Sharing and Reviewing Spreadsheets ノート
  • Introduction
  • Sharing spreadsheets
  • Reviewing documents
  • Merging documents
  • Comparing documents
  • Saving versions
• LibreOffice Calc Chapter 13, Macros ノート
  • Introduction
  • On Visual Basic for Applications (VBA) compatibility
  • Using the macro recorder
  • Write your own functions
  • Accessing cells directly
  • Sorting
  • Overview of BeanShell, JavaScript, and Python macros
  • ScriptForge library
  • Built-in object inspector
  • Working with VBA macros
  • Conclusion
• Chapter 14, Calc as a Database ノート
  • Introduction
  • Associating a range with a name
  • Sorting
  • Filtering
  • Useful database-like functions
• Calc Guide Chapter 15, Setting up and Customizing ノート
  • Introduction
  • LibreOffice options
  • Options for loading and saving documents
  • Calc-specific options
  • Default colors for charts
  • Customizing the user interface
  • Assigning macros to events
  • Adding functionality with extensions
  • Adding custom colors
  • Setting up document themes
• Calc Guide Chapter 16, User Interface Variants ノート
  • Introduction
  • Selecting the user interface
  • Standard interfaces
  • Contextual Single
  • Tabbed interface
  • Tabbed Compact interface
  • Groupedbar Compact interface