Curs OpenOffice - Calc

 

 

CALC is the spreadsheet program you've always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions. 

Advanced DataPilot technology makes it easy to pull in raw data from corporate databases; cross-tabulate, summarise, and convert it into meaningful information.

Natural language formulas let you create formulas using words (e.g. "sales - costs").

The Intelligent Sum Button inserts a sum function or a subtotal automatically, depending on context.

Wizards guides you through choosing and using a comprehensive range of advanced spreadsheet functions.

Styles and Formatting makes it easy to apply flexible cell formatting options, including freely rotating contents, templates, backgrounds, borders, and many more. You can be your own spreadsheet expert thanks to templates with built-in functions, allowing you to concentrate on your real work.

Scenario Manager allows "what if ..." analysis at the touch of a button - e.g. compare profitability for high / medium / low sales forecasts.

Hide or reveal Design Themes with a single click - use CALC's defaults or add your own.

Save your spreadsheets in OpenDocument format, the new international standard for office documents. This XML based format means you're not tied in to CALC. You can access your spreadsheets from any OpenDocument compliant software.

Of course, you are free to use your old Microsoft Excel spreadsheets, or save your work in Excel format for sending to people who are still locked into Microsoft products. If all they want to see is your results, then use Portable Document Format (.pdf) - no need to buy any extra software.

Tutorial Objectives
Entering data
Selecting items
Adding or deleting rows and columns
Saving your work
Creating a new color
Changing the cell background color
Formatting text
Cell alignment
Rotating text
Optimizing row or column size
Freezing column or row headings
Hiding/showing rows and columns  

Using worksheets
Using the find features
Using the replace function
Sorting spreadsheet data
Filtering data - autofilter
Filtering data - standard filters
Filtering data - removing filters
Creating charts
Editing charts
Changing the chart data range
Using ranges
Creating calculations
Relative vs. absolute addresses

Opening/importing files
Creating subtotals
Using outline functionality
Multiple Operations
Using the data pilot
Editing a data pilot table
Filtering a data pilot table
Refreshing a data pilot table
Editing a data pilot table 2
Scenarios
Creating scenarios
Modifying and deleting scenarios

Inscrieri:

Doresti sa participi?

Trimite-ne un email la This e-mail address is being protected from spambots. You need JavaScript enabled to view it sau suna la 0733 957 675 / 0726 728 342