Rounding a number with 2 digits

http://support.microsoft.com/kb/124423/en-us

Advertisements

Circular references introduction

Circular references – results when one of the cells you are referencing in the formula is the cell in which you want the formula to appear.

To make difference from reference relative and absolute reference you willl just look above and jus think if you want the line to be constant you will add $ or variable you will not add the symbol $.

Same if you look at right just think if you want that the column must be constant or variable. For constant you will add $ sign.

A cell is formed by a line and a column is the intersection of those 2.

Good tutorials about circular references in excel:

http://chandoo.org/wp/2010/09/16/excel-circular-references/

http://www.dummies.com/how-to/content/dealing-with-circular-references-in-excel-2010-for.html

Troubleshoot circular references errors above is this tutorial from ofzen:

http://www.ofzenandcomputing.com/zanswers/4743/

http://www.ehow.com/how_2265255_check-circular-references-excel.html

http://www.ehow.com/how_8767009_rid-circular-references-excel.html

http://www.igetit.net/newsletters/Y06_06/circref.aspx

http://www.techrepublic.com/article/get-excel-to-calculate-formulas-with-circular-references/6130292

http://blogs.office.com/b/microsoft-excel/archive/2012/02/17/circular-references-excel-error-message.aspx

Good habit:

http://office.microsoft.com/en-us/excel-help/remove-or-allow-a-circular-reference-HP010342831.aspx

http://excel.tips.net/T002163_Dealing_with_Circular_References.html

http://www.exceltip.com/st/Circular_References_in_Excel_2007/1353.html

Very good tutorials from jkp:

http://www.jkp-ads.com/Articles/circularreferences02.asp

http://www.jkp-ads.com/Articles/circularreferences03.asp

http://www.jkp-ads.com/Articles/circularreferences04.asp

Missing menus and toolbars in word

http://wordprocessing.about.com/od/troubleshootin1/qt/wordregentry.htm

1. From the Windows Start menu, select Run

2. Type regedit in the box and click OK

3. On the left side of the window, click the folders in the following order (the location will vary depending on your version of Word):
HKEY_CURRENT_USER\Software\Microsoft\Office\version number\Word\Data

4. Right-click the Data folder and select Edit

5. Rename the folder

6. Close the registry

When you restart Word, the problem should be resolved. A new data folder will be created automatically.

 

Formula excel neaplicata corect pentru mai multe coloane

Fie formula excel =IF(A5=”R”;0;L5*M5) aceasta formula e calculata intr-o anumita celula.

 

Solutia este din excel-> sa accesam tabul formulas->formulas calculation must be set at automatic not at manual.

 

 

Set language to english in entire powerpoint presentation

Se scrie un modul se da F5 pt.rulare macro si se salveaza ca pptm:

http://www.proz.com/forum/office_applications/34774-set_language_in_entire_ppt_presentation.html

SET LANGUAGE TO ENGLISH:

Sub SetLangUK()
‘set language to UK for all slides and notes:
Dim scount, j, k, fcount
scount = ActivePresentation.Slides.Count
For j = 1 To scount
fcount = ActivePresentation.Slides(j).Shapes.Count
For k = 1 To fcount ‘change all shapes:
If ActivePresentation.Slides(j).Shapes(k).HasTextFrame Then
ActivePresentation.Slides(j).Shapes(k).TextFrame _
.TextRange.LanguageID = msoLanguageIDEnglishUK
End If
Next k
‘change notes:
fcount = ActivePresentation.Slides(j).NotesPage.Shapes.Count
For k = 1 To fcount ‘change all shapes:
If ActivePresentation.Slides(j).NotesPage.Shapes(k).HasTextFrame Then
ActivePresentation.Slides(j).NotesPage.Shapes(k).TextFrame _
.TextRange.LanguageID = msoLanguageIDEnglishUK
End If
Next k
Next j
End Sub

Introducere in macros

http://www.youtube.com/watch?v=wH03Xnr3Pug&feature=related

Stergerea din greseala a Personal.xlsb care va permite sa creati macro-uri

Daca ati sters din greseala fisierul Personal.xlsb din caile:

Windows XP
C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART
In Vista or Windows 7 look here
C:\Users\Username\AppData\Roaming\Microsoft\Excel\XLSTART

Veti primi un mesaj de eroare de genul:

“Personal Macro Workbook in the startup folder must stay open for recording.”

and then “Unable to record.”

SOLUTIA:

Ca sa recuperam fisierul Personal.xlsb sters din greseala:

Pasul1: Deschideti un workbook si salvati-l ca Personal.xls in calea:

C:\Program Files\Microsoft Office\Office 10\XLStart

Pasul2: Inchideti excel si redeschideti-l

Automat veti regasi fisierul Personal.xlsb in calea :

Windows XP
C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART
In Vista or Windows 7 look here
C:\Users\Username\AppData\Roaming\Microsoft\Excel\XLSTART

Previous Older Entries