can you show me how to set this up on excel? also what is the question asking me solve?

Q3. Dennis Haydell (F382, Fa'09) is a 27-year old, highly-motivated individual who wants to have saved more than a million dollars by his retirement at age 67. Fortunately, after completing his Ph.D. in Finance from Louisiana State University Dennis secured a high-paying job with the New Orleans Branch of the Federal Reserve Bank of Atlanta. Dennis is confident his low-risk investment portfolio will consistently earn an annual rate of 5.50%. p.a. If Dennis makes weekly, beginning-of-the-week, deposits of $150.00 for the next 40 years what will his account be worth at his expected retirement? Answer: $1,137,807.79