Mastering LibreOffice Calc
Your comprehensive guide to creating professional spreadsheets with LibreOffice Calc. From basic calculations and number crushing to advanced decision making (What if...) and pivot tables, this guide covers everything you need to know.
Chapters
Preface
Introduction to the Calc Guide, its purpose, and how to use this manual effectively.
Read MoreChapter 1: Introduction
Get started with LibreOffice Calc. Learn about its interface, features, and basic operations.
Read MoreChapter 2: Entering, Editing, and Formatting Data
Master the fundamentals of cell and range editing, including typing, selecting, and basic formatting.
Read MoreChapter 3: Formatting Data
Calc formatting resources use an extensive set of attributes to enhance the visual display of relevant information of your spreadsheet.
Read MoreChapter 4: Using Styles and Templates
Using styles simplifies the formatting process, saves time, and ensures consistency, as well as reduces errors and makes global formatting changes easier.
Read MoreChapter 5: Using Images and Graphics
Incorporating graphics can transform a standard spreadsheet into a more engaging and memorable document. Calc supports importing a wide range of vector (line drawing) and raster (bitmap or photo) file formats.
Read MoreChapter 6: Creating Charts and Graphs
Calc offers a variety of ways to present data in the form of customizable charts and graphs.
Read MoreChapter 7: Gallery of Chart Types
This chapter present examples of the chart types that Calc provides, with some notes on the uses of each one.
Read MoreChapter 8: Printing, Exporting, Emailing, and Signing
Prepare your spreadsheet document for printing or digital publishing with these essential tips.
Read MoreChapter 9: Using Formulas and Functions
Formulas are equations that combine numbers and variables to calculate a result. Calc also offer functions, which are predefined calculations designed to help analyze or manipulate data efficiently.
Read MoreChapter 10: Using Pivot Tables
Create, use, and manage pivot tables, a summarized table that compiles groups of individual values from a larger table.
Read MoreChapter 11: Data Analysis
Calc offers various tools for data processing. These tools include features for copying and reusing data, creating subtotals, conducting what-if analysis, and performing statistical analysis.
Read MoreChapter 12: Linking Data
Multiple sheets help keep information organized; once you link those sheets together, you unleash the full power of Calc.
Read MoreChapter 13: Sharing and Reviewing Spreadsheets
Methods for collaboration through sharing and reviewing spreadsheets: simultaneous editing, recording changes, adding comments, reviewing changes, merging and comparing documents, saving, and using document versions.
Read MoreChapter 14: Macros
Use macros to automate both simple and complex tasks, and they enable you to introduce new features that are not built into Calc.
Read MoreChapter 15: Calc as a Database
Calc spreadsheets can be used to aggregate sets of data and to perform analyses on them.
Read MoreChapter 16: Setting up and Customizing
Configure user data, application appearance, display settings, computation modes, and customize menus, toolbars, and keyboard shortcuts.
Read MoreChapter 17: User Interface Variants
Explore different UI options and customize the Calc interface to your liking.
Read MoreAppendix B: Error Codes
Feedback for errors of miscalculation, incorrect use of functions, invalid cell references and values, and other user initiated mistakes.
Read More