Date formats in excel

Just for my memory, Just in USA the date format is mm/dd/yyyy, the rest of the world uses dd/mm/yyyy. Anyway… I have excels where I have both formats inherited from links, so I cannot change the source data. The solution: =IF(ISNUMBER(Q202);Q202;DATE(RIGHT(Q202;4);LEFT(Q202;FIND(“/”;Q202)-1);MID(Q202;FIND( “/”;Q202 )+1;2)))

Program and Portfolio Management evolution

In the portfolio of solutions and services we provide program and project management team plays an important role in the organization. Basically the project managers and the PMO team is providing governance to the whole execution of projects through the execution of processes and the projects itself. We started an improvement plan to evolve about … Read more

Act as a change agent

If you want to survive in this organization and this industry, make sure you are acting as a change agent.   Keep track on changes that are happening from business perspective and on technology, adopt changes as a natural process of evolution.

Finance and portfolio management

I’m working on a set of accounts and solutions for my company, handling a portfolio at country level. My team is composed by account managers where that handle the day to day relationship with customers, write offers, deliver services with the support of service managers, handle projects directly or with a PM…They do a lot … Read more

La chica de los siete nombres

Una historia de superación personal fuera de lo normal, contado de una manera muy conmovedora. No se puede decir nada de este libro, sin que se te escapen miles de cosas que decir de él, lo mejor es leerlo.  

10 Good Manufacturing Practice rules

Ten suitable GMP ‘rules’, to be used for staff training: Confirm you are trained and have correct written instructions before starting any job. Follow instructions exactly. Report errors and bad practices immediately. Ensure you have the right materials before you start a job. Use the correct equipment for the job, confirm its status and cleanliness. … Read more

Dogs of Dow 2016

Other year trying to understand the values with more return into dividends. AT&T is out due to the fact that is not in Dow Jones anymore, but continuous being the #1.  

New portfolio, new challenges

I took a new portfolio of accounts and services within a team of 8 account managers. The nature of the services/projects and the fact we are covering 4 industries and more than 70 customers makes the environment very diverse. My main challenges for the first 3 months are: Evaluate the financial situation of each account. … Read more

SalesForce Trailhead Admin Beginner

In November 2015 I completed SalesForce Trailhead Developer Beginner. Now, during Christmas time I was able to complete the main challenges of the Admin beginner. And finally, during January I completed it. To me this course was easier than the one related to development: so much configuration activities and the challenges are easier. The big … Read more

Sobre la calidad del agua

Hoy vino a casa un comercial de una empresa que vende aparatos de osmosis, con una demostración de electrólisis que trató de persuadirme de lo mala que era mi agua. 152 de TDS es lo que marcaba el aparato que usó para la calidad del agua, versus el agua osmotizada que marcaba 0.04. Encontré una … Read more