{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Keyboard Shortcut","TODAY Function","NOW Function","Autofill","Fill Series","VBA","IF & NOW ","Auto Populate date"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Entering Date Automatically in Excel"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3"]
[null,"Eraser","AR12"]
[null,"Pen-Stand","AK21"]
[null,"Pen","EC9"]
[null,"Marker","BV5"]
[null,"Highlighter","FG67"]
[null,"Total"]

{"sheet":"Keyboard Shortcut","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of Keyboard Shortcut"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3",44884.640972222223]
[null,"Eraser","AR12"]
[null,"Pen-Stand","AK21"]
[null,"Pen","EC9"]
[null,"Marker","BV5"]
[null,"Highlighter","FG67"]
[null,"Total"]

{"sheet":"TODAY Function","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adopting TODAY Function"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3",{"$f":"TODAY()","v":"2022-11-20"}]
[null,"Eraser","AR12"]
[null,"Pen-Stand","AK21"]
[null,"Pen","EC9"]
[null,"Marker","BV5"]
[null,"Highlighter","FG67"]
[null,"Total"]

{"sheet":"NOW Function","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Implementing NOW Function"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3",{"$f":"NOW()","v":"2022-11-20T17:14:36.920"}]
[null,"Eraser","AR12"]
[null,"Pen-Stand","AK21"]
[null,"Pen","EC9"]
[null,"Marker","BV5"]
[null,"Highlighter","FG67"]
[null,"Total"]

{"sheet":"Autofill","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilization of Autofill Option"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3","2022-11-19"]
[null,"Eraser","AR12","2022-11-20"]
[null,"Pen-Stand","AK21","2022-11-21"]
[null,"Pen","EC9","2022-11-22"]
[null,"Marker","BV5","2022-11-23"]
[null,"Highlighter","FG67","2022-11-24"]
[null,"Total"]

{"sheet":"Fill Series","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Fill Series Command"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3","2022-11-19"]
[null,"Eraser","AR12","2025-11-19"]
[null,"Pen-Stand","AK21","2028-11-19"]
[null,"Pen","EC9","2031-11-19"]
[null,"Marker","BV5","2034-11-19"]
[null,"Highlighter","FG67","2037-11-19"]
[null,"Total"]

{"sheet":"VBA","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Executing VBA Code"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3",{"$f":"MFDate(C5)","v":"20-11-22 17:06:40"}]
[null,"Eraser","AR12",{"$f":"MFDate(C6)","v":"20-11-22 17:06:40"}]
[null,"Pen-Stand","AK21"]
[null,"Pen","EC9"]
[null,"Marker","BV5"]
[null,"Highlighter","FG67"]
[null,"Total"]

{"sheet":"IF & NOW ","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using IF and NOW Functions Together"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3","2022-11-20T15:48:00"]
[null,"Eraser","AR12",{"$f":"IF(C6<>\"\",IF(D6=\"\",NOW(),D6),\"\")","v":"2022-11-20T15:52:33.880"}]
[null,"Pen-Stand",null,""]
[null,"Pen",null,""]
[null,"Marker",null,""]
[null,"Highlighter",null,""]
[null,"Total"]

{"sheet":"Auto Populate date","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Auto populated Date in Excel"]
[]
[null,"Product","ID","Manufacturing Date"]
[null,"Pencil","PR3","2022-11-20T16:56:30"]
[null,"Eraser"]
[null,"Pen-Stand","AK21","2022-11-20T17:09:10"]
[null,"Pen"]
[null,"Marker"]
[null,"Highlighter"]
[null,"Total"]