Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. Press Ctrl+; > Space > Ctrl+Shift+; to insert the current date and time together in the same cell.
Whether you're an experienced Excel pro or you've just switched from another spreadsheet software, many of the default settings make the program frustrating to use. But you don't have to settle for ...