Course Content
Excel for Finance
Excel for Finance
Connecting to the Google Sheets
We need a special table that contains dates in various formats so that we can standardize them into a single format that’s convenient for data analysis across all tables.
Cope this link:
But if you encounter any issues, you can download an Excel Workbook that contains the same information as the Google Sheets, following the instructions from the previous chapter.
This table includes dates in five different formats, such as a numeric format, the common dd.mm.yyyy format, which is familiar to us and convenient for data analysis, the month represented as both a number and text, and the year.
formats. 📅
If you want to revisit the information covered in the video, here's an 👉e-book with step-by-step explanations for you.
Thanks for your feedback!