Time Dependent Density Functional Theory of core electron excitations: from implementation to applications