{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Keyboard Shortcuts","F9","Notepad","Right-Click","VBA","Table1","Power Query"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Overview","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Convert Formula to Value Without Paste Special"]
[]
[null,"Sales Rep","Product","Sales","Profit"]
[null,"Zuschuss","Mouse",65342,19602.599999999999]
[null,"Joe","Keyboard",60117,18035.099999999999]
[null,"Mark","Graphics Cards",63514,19054.2]
[null,"Janifer","    Mouse",66043,19812.899999999998]
[null,"Carroll","    Hard disks",60334,18100.2]
[null,"Xylona","    Routers",53974,16192.199999999999]
[null,"Preis","Keyboard",61274,18382.2]
[null,"Dalton","Graphics Cards",65845,19753.5]
[null,"Mathis","Memory cards",76930,23079]
[null,"Willium","    Pen drives",64802,19440.599999999999]

{"sheet":"Keyboard Shortcuts","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Keyboard Shortcuts"]
[]
[null,"Sales Rep","Product","Sales","Profit"]
[null,"Zuschuss","Mouse",65342,19602.599999999999]
[null,"Joe","Keyboard",60117,18035.099999999999]
[null,"Mark","Graphics Cards",63514,19054.2]
[null,"Janifer","    Mouse",66043,19812.899999999998]
[null,"Carroll","    Hard disks",60334,18100.2]
[null,"Xylona","    Routers",53974,16192.199999999999]
[null,"Preis","Keyboard",61274,18382.2]
[null,"Dalton","Graphics Cards",65845,19753.5]
[null,"Mathis","Memory cards",76930,23079]
[null,"Willium","    Pen drives",64802,19440.599999999999]

{"sheet":"F9","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Keyboard Shortcuts"]
[]
[null,"Sales Rep","Product","Sales","Profit"]
[null,"Zuschuss","Mouse",65342,19602.599999999999]
[null,"Joe","Keyboard",60117,{"$f":"D6*30%","v":18035.099999999999}]
[null,"Mark","Graphics Cards",63514,19054.2]
[null,"Janifer","    Mouse",66043,19812.899999999998]
[null,"Carroll","    Hard disks",60334,18100.2]
[null,"Xylona","    Routers",53974,16192.199999999999]
[null,"Preis","Keyboard",61274,18382.2]
[null,"Dalton","Graphics Cards",65845,19753.5]
[null,"Mathis","Memory cards",76930,23079]
[null,"Willium","    Pen drives",64802,19440.599999999999]

{"sheet":"Notepad","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Notepad"]
[]
[null,"Sales Rep","Product","Sales","Profit"]
[null,"Zuschuss","Mouse",65342,19602.599999999999]
[null,"Joe","Keyboard",60117,18035.099999999999]
[null,"Mark","Graphics Cards",63514,19054.2]
[null,"Janifer","    Mouse",66043,19812.900000000001]
[null,"Carroll","    Hard disks",60334,18100.2]
[null,"Xylona","    Routers",53974,16192.2]
[null,"Preis","Keyboard",61274,18382.2]
[null,"Dalton","Graphics Cards",65845,19753.5]
[null,"Mathis","Memory cards",76930,23079]
[null,"Willium","    Pen drives",64802,19440.599999999999]

{"sheet":"Right-Click","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Right-Click Drag Down"]
[]
[null,"Sales Rep","Product","Sales","Profit","Value Without Formula"]
[null,"Zuschuss","Mouse",65342,{"$f":"D5*30%","v":19602.599999999999},19602.599999999999]
[null,"Joe","Keyboard",60117,{"$f":"D6*30%","v":18035.099999999999},18035.099999999999]
[null,"Mark","Graphics Cards",63514,{"$f":"D7*30%","v":19054.2},19054.2]
[null,"Janifer","    Mouse",66043,{"$f":"D8*30%","v":19812.899999999998},19812.899999999998]
[null,"Carroll","    Hard disks",60334,{"$f":"D9*30%","v":18100.2},18100.2]
[null,"Xylona","    Routers",53974,{"$f":"D10*30%","v":16192.199999999999},16192.199999999999]
[null,"Preis","Keyboard",61274,{"$f":"D11*30%","v":18382.2},18382.2]
[null,"Dalton","Graphics Cards",65845,{"$f":"D12*30%","v":19753.5},19753.5]
[null,"Mathis","Memory cards",76930,{"$f":"D13*30%","v":23079},23079]
[null,"Willium","    Pen drives",64802,{"$f":"D14*30%","v":19440.599999999999},19440.599999999999]

{"sheet":"VBA","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Run a VBA Code to Convert Formula to Value"]
[]
[null,"Sales Rep","Product","Sales","Profit"]
[null,"Zuschuss","Mouse",65342,19602.599999999999]
[null,"Joe","Keyboard",60117,18035.099999999999]
[null,"Mark","Graphics Cards",63514,19054.2]
[null,"Janifer","    Mouse",66043,19812.900000000001]
[null,"Carroll","    Hard disks",60334,18100.2]
[null,"Xylona","    Routers",53974,16192.2]
[null,"Preis","Keyboard",61274,18382.2]
[null,"Dalton","Graphics Cards",65845,19753.5]
[null,"Mathis","Memory cards",76930,23079]
[null,"Willium","    Pen drives",64802,19440.599999999999]

{"sheet":"Table1","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sales Rep","Product","Sales","Profit"]
["Zuschuss","Mouse",65342,19602.599999999999]
["Joe","Keyboard",60117,18035.099999999999]
["Mark","Graphics Cards",63514,19054.2]
["Janifer","    Mouse",66043,19812.900000000001]
["Carroll","    Hard disks",60334,18100.2]
["Xylona","    Routers",53974,16192.2]
["Preis","Keyboard",61274,18382.2]
["Dalton","Graphics Cards",65845,19753.5]
["Mathis","Memory cards",76930,23079]
["Willium","    Pen drives",64802,19440.599999999999]

{"sheet":"Power Query","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of the Power Query Editor"]
[]
[null,"Sales Rep","Product","Sales","Profit"]
[null,"Zuschuss","Mouse",65342,{"$f":"D5*30%","v":19602.599999999999}]
[null,"Joe","Keyboard",60117,{"$f":"D6*30%","v":18035.099999999999}]
[null,"Mark","Graphics Cards",63514,19054.2]
[null,"Janifer","    Mouse",66043,19812.899999999998]
[null,"Carroll","    Hard disks",60334,18100.2]
[null,"Xylona","    Routers",53974,16192.199999999999]
[null,"Preis","Keyboard",61274,18382.2]
[null,"Dalton","Graphics Cards",65845,19753.5]
[null,"Mathis","Memory cards",76930,23079]
[null,"Willium","    Pen drives",64802,19440.599999999999]