High-temperature superconductivity was discovered in the pressurized nickelate La3Ni2O7 which has a unique bilayer structure and mixed valence state of nickel. The properties at ambient pressure contain crucial information of the fundamental interactions and bosons mediating superconducting pairing. Here, using X-ray absorption spectroscopy and resonant inelastic X-ray scattering, we identified that Ni 3dx2−y2\\documentclass[12pt]{minimal} \\usepackage{amsmath} \\usepackage{wasysym} \\usepackage{amsfonts} \\usepackage{amssymb} \\usepackage{amsbsy} \\usepackage{mathrsfs} \\usepackage{upgreek} \\setlength{\\oddsidemargin}{-69pt} \\begin{document}$${d}_{{x}^{2}-{y}^{2}}$$\\end{document}, Ni 3dz2\\documentclass[12pt]{minimal} \\usepackage{amsmath} \\usepackage{wasysym} \\usepackage{amsfonts} \\usepackage{amssymb} \\usepackage{amsbsy} \\usepackage{mathrsfs} \\usepackage{upgreek} \\setlength{\\oddsidemargin}{-69pt} \\begin{document}$${d}_{{z}^{2}}$$\\end{document}, and ligand oxygen 2p orbitals dominate the low-energy physics with a small charge-transfer energy. Well-defined optical-like magnetic excitations soften into quasi-static spin-density-wave ordering, evidencing the strong electronic correlation and rich magnetic properties. Based on an effective Heisenberg spin model, we extract a much stronger inter-layer effective magnetic superexchange than the intra-layer ones and propose two viable magnetic structures. Our findings emphasize that the Ni 3dz2\\documentclass[12pt]{minimal} \\usepackage{amsmath} \\usepackage{wasysym} \\usepackage{amsfonts} \\usepackage{amssymb} \\usepackage{amsbsy} \\usepackage{mathrsfs} \\usepackage{upgreek} \\setlength{\\oddsidemargin}{-69pt} \\begin{document}$${d}_{{z}^{2}}$$\\end{document} orbital bonding within the bilayer induces novel electronic and magnetic excitations, setting the stage for further exploration of La3Ni2O7 superconductor.