Spectral features, chemical shifts, and absolute thresholds of electron energy loss near-edge structure (ELNES) and x-ray absorption near-edge structure (XANES) for selected compounds, i.e. TiO(2) (rutile), TiO(2) (anatase), SrTiO(3), Ti(2)O(3), Al(2)O(3), AlN and β-Ga(2)O(3), were calculated by a plane wave pseudopotential method. Experimental ELNES/XANES of those compounds were well reproduced when an excited pseudopotential, which includes a core hole, was used. In addition to the spectral features, it was found that chemical shifts among different compounds were also reproduced by correcting the contribution of the excited pseudopotentials to the energy of the core orbital.