A slicer and pivot chart walk into a bar ...

Buna,

Astazi vreau sa va inveselesc cu cateva glume despre excel si nu numai.

•  A slicer and pivot chart walk in to a bar. The bartender says, “look at those bast*rds, walking around with out a pivot!"

•  Once Excel, Access and Windows were bragging to each other. Excel says, “I once crashed so hard, it took 5 minutes to recover”. Access says, “Oh thats nothing. I once crashed and took down an entire database. It took them 30 minutes to recover”. Windows doesn’t say anything. Excel pokes him in the arm asks “what about you?”, Windows jolts & replies, “Sorry, what did you say? I just crashed again.”

• If Excel Were a Car...
  It would crash two or three times per day for no apparent reason. The driver is often hurt, but the car itself receives no permanent damage. You'd just accept this fact, restart the car, and begin your trip again.
  Occasionally, your car would fail to restart after a crash, and you'd have to reinstall the engine. For some strange reason, you'd just accept this too.
  You would be forced to buy a new model every 18 months, and your old model would have no resale value. Each new model would be bigger that the previous one, require more gas, and would operate differently. Furthermore, parts from the old car would not be interchangeable with the new car.
  You could call a special phone number when you had a problem. The phone would be staffed by people who know less about your car than you do.
  There would be a special Macintosh model, powered by the sun. However, it would only run on 5 percent of the roads and require different driving skills.
  You would have to spend additional money to buy the operating manuals.
  The oil, engine, gas and alternator warning lights would be replaced by a single warning light: "This car has performed an illegal operation."
  Before engaging, the airbag system would display a message, "Are you sure?"
  Every time you looked under the hood, an obnoxious cartoon character would appear and ask if you need help. No matter how many time you refused help, it would keep appearing.
  A special feature would let you automatically record the route for a particular trip, so you could repeat the trip automatically later on. However, after repeating the trip you always end up at a different location.
  

• An analyst says to a bartender: “I like my woman like I like my probabilities – normally distributed.”

• Ongoing fight in a plane:
  Excel : We are so simple and “excel”lent at the same timel.
  PPT : Huh, We have “Power” and are always to the “Point”
  Word : Lol, No one is going to believe your “Word”, unless i say so….

Si cel mai tare:

- What is your job about?- I am transferring information from one cell to another.- Wow, you’re a genetic engineer?!- Not really, just working with Excel.

Cum sa trimiti automat un mail printr-o apasare de buton?

Buna,

La inceputul lunii am lucrat la un raport care trebuia trimis catre mai multe persoane, si am cautat o sintaxa VBA prin care sa trimit cate un mail la fiecare persoana folosind Thunderbird. Oricat as vrea sa va spun ca am gasit, nu se poate.

Ca sa foloseste totusi optiunea de trimitere mail prin VBA am apelat la Outlook si pentru ca multe persoane m-au intrebat cum se face, astazi va voi prezenta sintaxa pentru trimiterea mailurilor folosind Outlook.

Configurarea fisierului

Pentru exemplul de azi, nu a fost nevoie de o configurare foarte complicata. Am formatat o celula pentru adaugarea adresei de mail catre care se trimite mailul si am adaugat un buton pentru trimiterea mailului. Procedura VBA pentru trimiterea mailului am alocat-o butonului Trimite mail din fisier.

Cum extragem date dintr-un tabel in functie de o conditie?

Buna,

Astazi vreau sa va impartasesc o formula pe care o folosesc ca sa extrag date dintr-un tabel in functie de o conditie. Tin sa va spun ca este o formula mai grea pentru ca se folosesc multe functii: If, Match, Index, Countif, Row, insa va invit sa urmariti logica din spatele ei pentru a vedea cum va poate ajuta.

Configurarea tabelului

Pentru a putea exemplifica cum se pot extrage date dintr-un tabel in functie de o conditie, vom folosi un tabel in care sunt centralizate vanzarile dintr-un an in functie de client si produs.

Pentru ca aceasta formula sa functioneze corect, tabelul trebuie sortat alfabetic in functie de coloana pe care se pune conditia, in cazul nostru coloana Produs.


In alt sheet, in zona B3:C3 am creat o lista derulanta pentru a putea selecta produsul in functie de care vom extrage clientul din tabelul initial.

6 pasi pentru formatarea mai buna a graficelor

Buna,

Asa cum v-am promis, am revenit cat de repede am putut cu un articol practic legat de Data visualization. Cum spune si titlul vom trece prin 6 pasi care tin de formatare, pentru a ajunge la grafice mai bune.

"Mai bune" suna subiectiv si pentru mine aceasta expresie inseamna mai bune din punct de vedere vizual, adica mai frumoase. Am ales acest subiect pentru ca eu aplic de ceva vreme acesti pasi si persoanele care primesc rapoartele mele sunt foarte multumite.

Inainte de a trece la treaba as vrea sa clarific urmatorul aspect: desi Data visualization duce foarte mult cu gandul la vizual, de fapt acesta reprezinta doar o parte dintr-un intreg.

Generarea graficului

Pentru exemplul de azi am folosit un tabel in care avem vanzarile din fiecare luna pentru anul
2011. Folosind acest tabel am generat un grafic de tip coloane care sa arate evoluatia vanzarilor in cursul anului. Pentru grafic am folosit formatarea standard pe care o pune la dispozitie Excel-ul. In plus, ca sa pot demonstra utilitatea pasilor am folosit Excel 2003 care sta mult mai prost la capitolul formatare ca Excel 2007 si 2010.

1. Stergerea fundalului

Apasati click stanga pe fundalul graficului si apasati tasta delete. De ce e mai bine fara fundal? Pentru ca astfel graficul ramane cu un background alb, iar nonculoarea alb ofera cel mai bun contrast si ajuta foarte mult la transmiterea mesajului dorit.