Blog

Home > Blog (Page 5)

25 feb.

Posted at 06:50h in Blog
3 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] Percentage Formatarea Percentage Cum obtinem valori procentuale in Excel?Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, :). Vrei un curs personalizat Excel, click aici."Learn today for tomorrow!" [/vc_column_text][/vc_column][vc_column width="3/4"][qode_advanced_tabs title_tag="h3"][qode_advanced_tab tab_title="General"][vc_column_text] Crestere...

24 feb.

Posted at 15:18h in Blog
0 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] Percentage Formatarea Percentage Cum obtinem valori procentuale in Excel? [/vc_column_text][vc_separator type="transparent" up="10"][vc_single_image image="1962" img_size="full" alignment="center" onclick="link_image" qode_css_animation=""][vc_column_text] Daca ti-a placut articolul nostru like si share pe Facebook. Ne gasesti si pe Instagram, scaneaza ecusonul de mai sus."Learn today...

18 feb.

Posted at 15:23h in Blog
0 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text]TimeFunctii: IF, MOD, ABS, TEXT4 functii cu ajutorul carora putem calcula diferente de timp in Excel.Structura functiilor=IF (End>Start, End-Start, 1-Start+End)=MOD (End-Start,1)=ABS (End-Start)=TEXT (End-Start, "h:mm") [/vc_column_text][vc_separator type="transparent" up="10"][vc_column_text]Daca ti-a placut articolul nostru like si share...

15 ian.

Posted at 16:31h in Blog
0 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] FLASH FILL Windows shortcut: CTRL+E Flash Fill este o caracteristica noua adaugata in Excel 2013 (dar indisponibila, din pacate pentru MAC OS, chiar si in versiunea Excel 2016)De unde activam optiunea? [/vc_column_text][vc_separator type="transparent" up="10"][vc_single_image image="1860" img_size="full" alignment="center"...

15 ian.

Posted at 12:40h in Blog
0 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] FLASH FILL Windows shortcut: CTRL+E Flash Fill este o caracteristica noua adaugata in Excel 2013 (dar indisponibila, din pacate pentru MAC OS, chiar si in versiunea Excel 2016)De unde activam optiunea? [/vc_column_text][vc_separator type="transparent" up="10"][vc_single_image image="1860" img_size="full" alignment="center"...

04 ian.

Posted at 07:17h in Blog
0 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] NETWORKDAYS,WEEKDAY & CHOOSE Windows shortcut: n/a Networkdays (start_date, end_date, [Holidays]) functie care returneaza numarul de zile lucratoare Weekday (data,return_type) - returneaza numarul de zile din saptamana. Choose (index_num, Value1, Value2,...

09 dec.

Posted at 10:36h in Blog
0 Likes

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid" angled_section="no" text_align="left" background_image_as_pattern="without_pattern" z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] COUNTIF Windows shortcut: n/a COUNTIF este o functie cu ajutorul careia numaram celulele in functie de o conditie indeplinita.Structura functiei COUNTIF (range,criteria) Range: Selectia de celule dorite pentru evaluare Criteria: Conditia evaluata [/vc_column_text][vc_separator type="transparent" up="10"][vc_single_image image="1615" img_size="full" alignment="center" onclick="link_image" qode_css_animation=""][vc_column_text] Observatie:...

09 dec.

Posted at 10:35h in Blog
0 Likes

NETWORKDAYS,WEEKDAY & CHOOSE [vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="grid"angled_section="no" text_align="left" background_image_as_pattern="without_pattern"z_index="" padding_top="44" padding_bottom="44"][vc_column width="1/4"][vc_column_text] Windows shortcut: n/a Networkdays (start_date, end_date, [Holidays]) functie care returneaza numarul de zile lucratoare Weekday (data,return_type) - returneaza numarul de ziledin saptamana. Choose (index_num, Value1, Value2,...

25 nov.

Posted at 14:49h in Blog
0 Likes

Flash Fill  Windows shortcut: CTRL+E Flash Fill Flash Fill este o caracteristica noua adaugata in Excel 2013 (dar din pacate indisponibilapentru MAC OS, chiar si in Excel 2016) Exemplu practic Cum extragem dintr-o adresa de email de forma (nume1.nume2@companie.com), fiecarecomponenta in parte? Sigur, vom utiliza FlashFill! Avem urmatoarea baza de date...