home / infca / office (navigation links) Antes que intentar vivir mejor, intenta mejorar
Word | Excel 2013 | Power Point
Alternatives : LibreOffice 		Links | End

Coses de Office

go 2 top
Word
Protected mode

To open all your documents in full editing mode in Word 2013 or Word 2010, just follow these simple steps.

  1. Click the File tab in the upper left corner
  2. Select Options
  3. Select Trust Center in the left pane
  4. Click "Trust Center Settings" button
  5. Select Protected View
  6. Uncheck all three options under "Protected View" and click "Ok¨:
    • Enable Protected View for files originating from the Internet
    • Enable Protected View for files located in potentially unsafe locations
    • Enable Protected View for Outlook attachments
Preguntes
Keyboard Shortcuts

To print a list of all the shortcuts in Word, follow these steps:

  1. Select Tools|Macro|Macros from the menu bar.
  2. From the Macros In drop-down menu, select Word Commands.
  3. Select ListCommands from the macro listing.
  4. Click the Run button.
  5. Choose Current Menu and Keyboard Settings from the popup window and click OK.
  6. Word will automatically open a new document containing a table of keystrokes. Print the document.

fgcu

Date Field
{ DATE \@ "M/d/yyyy" }
TOC Field
{ ? }
Amunt! Top Amunt!
Trucs de Excel

How to copy data by reference, not by value

... so future changes in origin are reflected in destination too.

The "Point and Click" method - if you don't want to type the formula manually:

  1. click on destination cell
  2. type "="
  3. click the origin tab at the bottom of your screen.
  4. click origin cell
  5. press Enter

To link data across sheets in Google Sheets, you use the sheet name followed by an exclamation mark before the cell coordinate.

S2.C4 ='S1'!B4

Create a graph

  1. Highlight the cells: click and drag to select the range, as B4:B20
  2. Insert Chart: go to the top menu and select Insert > Chart.
  3. Configure: a chart will appear, and the Chart Editor panel will open on the right.
    • Chart type: select Column chart (this creates vertical bars).
    • Customize: use the "Customize" tab in the editor to change colors, add a title, or label your axes.
Power Point

Office 2013 install

Tenim

[KG128GB]\office_ISO\2013-i-Visio 1.553.651.712 Microsoft Office Install DVD 64bit.iso 37.803.008 Microsoft Toolkit.exe 15.149 Office 2013 logo.png 3.173 WDoubleYouW.nfo

  1. read NFO file

I també

[KG128GB]\office_ISO\2013 1.076.271.104 Office_Profesional_Plus_2013_64Bit_English.iso

Muntem el ISO amb Daemon Tools "Lite" per W7, i obtenim "15.0.4420.1017"

Engeguem SETUP.EXE, instalem sense xarxa i fem proves - sembla que no cal clau d'activació, tot i que hi ha un directori "Crack", que sembla per W7 i 8.

Remove "Office upload center"

C:\Program Files\Microsoft Office\Office15\MSOSYNC.EX

Project 2000
Office alternatives

8 best microsoft office alternatives :

WORD replacement :

SAG @ Ubuntu : LibreOffice

LibreOffice (Ubuntu)

Calc - add up all column

  1. *** import as English-UK *** - Endesa uses "." as decimal separator
  2. clik on the cell where you want the result
  3. clik on the "Sigma" sign (Σ)
  4. select cells to add
  5. command shall be like "=SUM(E757:E780)"
  6. if the origin is another Sheet, it becomes =SUM($'sols produccio'.C2:C27)

Another way is to write "=SUM(" and then select the range with the cursor ...

Calc - insert graph

  1. select 2 columns of data to plot
    if they are not consecutive, select first one as usual, then hold "Control" and select second range of data
  2. select "Insert" menu from top bar, then "Chart" - chart wizard comes up
  3. choose "Chart Type" - I like "Area" or "Line"
  4. click "Next"
  5. define "Data Range" :
    • (+) data series : in columns
    • (-) first row as label (no label in our data)
    • (+) first column as label (1st column on X axis)
  6. click "Next"
  7. define "Data Series" :
    • click "Add"
    • data range.name : name of the range, as "produccio"
    • data range.Y-Values : cells to use, as "$dades.$D5:$D16"
  8. repeat "Data Series" and "Add", if required

uTube : graphs (ch 29), curso completo LibreOffice Calc

Resulting ranges are as :

... Data Series ... Name "2022" Y-Values $Taula.$C$6:$C$1

Parts del grafic :

Per accedir a qualsevol part :

  1. piquem damunt el grafic i escollim "Edit"
  2. amb el boto dret, piquem al exterior (chart area) o al interior de la grafica (chart wall)
Calc + graph - delete graph

Using "Del" you can receive the message "This function cannot be completed with the selected objects"

Just once click on chart - area of chart without border but with green markers - and then press Delete.
Or choose View - Navigator (or press F5), unfold group OLE objects, doubleclick on name of your chart (e.g. Object 1). After this anyway press Delete.

ask libreoffice

Calc + graph - rename legend

In the Data Ranges dialog box, click on the “Data Series” tab, then enter the appropriate name in double-quotes in the “Range for Name” box for each of your data series.

ask libreoffice

Calc - graph of a table

  1. creaate a one-column series of data using "=TOCOL(C4:N34; 1; TRUE)"
  2. on top menu, select "Insert", then "Graph"
  3. provide data location : "P4:P400"
  4. personalize colors anr titles

llista d funcions, detall TOCOL

Calc - split view

  1. click on the small icon at the right-top section of Calc
  2. the mouse pointer changes with a vertical two-way arrow
  3. click and hold, then drag it down
  4. then you have the same sheet with two views

libreofficehelp.com

Calc - veure tipus

Per saber si el contingut d'una cel·la és un text, un número, una data o una fórmula ... mètode visual (Ressaltat de valors)

SpreadSheet Calc - open any sheet

you need to append a specific GID (Grid ID) to the end of the URL.

  1. Find the Sheet ID (GID)

    • open your Google Spreadsheet in your web browser.
    • click on the tab at the bottom labeled "dades".
    • look at the address bar (URL) of your browser. At the very end of the URL, you will see gid= followed by a string of numbers.

      Example: .../edit#gid=123456789
  2. Update your Public URL - it should look like this:

    https://docs.google.com/spreadsheets/d/YOUR_SPREADSHEET_ID/edit#gid=123456789
Writer - insert hyperlink

  1. copy the destination URL from somewhere else
  2. select the text to act as hyperlink
  3. click CTRL+"K"
  4. paste the URL into the popup
<
Links

Ep ! Valid HTML 4.01!   Valid CSS! Escriu-me !
Updated 20190918  
Uf !