{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["checklist","redirectlist","About","<<Start Here>>","diag_test_results","Using the Mouse","Intro & Basic Shortcuts","Selecting & Navigating","Copying & Pasting","Nav 1.","Nav 2.","Formatting I","Alt Shortcuts, Menus, Formats","Rows, Columns, Sheets","Exs. Rows,Cols,Sheets","Formatting","Exercise support","Formula Shortcuts","Workbook Nav","Data Tools","Keyboard Layout & Troubleshoot","Results","Results2","Data Submission","Freq Used Shortcuts","All Shortcuts","Record Times"],"not_rendered":{"charts":0,"images":73,"macros":1,"external_links":2,"defined_names":192,"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":"checklist","index":0,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,"paste special - need to update shortcut"]
[]
[null,null,null,null,null,null,null,null,null,"ok"]
["make sure each subsection is numbered to easily jump around the screen",null,null,null,null,null,null,null,null,"x","When you're finished, Use CTRL+ Page Down to jump to the next worksheet"]
["make sure the mouse enables/disables properly based on sheets.",null,null,null,null,null,null,null,null,"x","new beg, int, advanced section labels"]
["rename exercises?","make sure all nav buttons work",null,null,null,null,null,null,null,"x","figure out page headers"]
["remove gridlines","check formatting",null,null,null,null,null,null,null,null,"a/b test the intro/outro button colors?"]
[]
[]
["spellcheck"]
[null,null,null,null,null,null,null,null,"utm links"]
[null,null,null,null,null,null,null,null,"http://www.automateexcel.com/?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=mainpage"]
["reset computer id",null,null,null,null,null,null,null,"http://www.automateexcel.com/excel-practice-test?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=tests"]
["reset test results",null,null,null,null,null,null,null,"http://www.automateexcel.com/advanced-excel-course?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=course"]
[null,null,null,"http://www.automateexcel.com/learnshortcuts",null,null,null,null,"http://www.automateexcel.com/learn-shortcuts?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=keyrocket"]
[null,null,null,"use this link still",null,null,null,null,"http://www.automateexcel.com/shortcuts/shortcut-pdfs?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=shortcutpdf"]
["col az"]
["call to action at the bottom of each page…"]
[null,null,null,"section on creating macro with custom shortcut?"]
[null,null,null,"and maybe a sample of macros to actually use?"]
[]
[]
[null,null,null,null,null,null,null,null,"need to figure out landing page issue..."]
["old diag test macros"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Sub Open_MainSite()"]
[null,null,null,null,"ActiveWorkbook.FollowHyperlink Address:=\"http://www.automateexcel.com/?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=mainpage\", NewWindow:=True 'Open Website\""]
["(so I also need some disclaimer…)",null,null,null,"End Sub"]
[null,null,null,null,"Sub Open_practicetests()"]
[null,null,null,null,"ActiveWorkbook.FollowHyperlink Address:=\"http://www.automateexcel.com/excel-practice-test?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=tests\", NewWindow:=True 'Open Website\"",null,null,null,null,null,"Add a counter on the top right, above \"select entire column\""]
[null,null,null,null,"End Sub"]
[null,null,null,null,"Sub open_course_landingpage()"]
[null,null,null,null,"ActiveWorkbook.FollowHyperlink Address:=\"http://www.automateexcel.com/advanced-excel-course?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=course\", NewWindow:=True 'Open Website\""]
[null,null,null,null,"End Sub"]
[null,null,null,null,"Sub open_keyrocket()"]
[null,null,null,null,"ActiveWorkbook.FollowHyperlink Address:=\"http://www.automateexcel.com/learn-shortcuts?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=keyrocket\", NewWindow:=True 'Open Website\""]
[null,null,null,null,"End Sub"]
[null,null,null,null,"Sub Open_shortcutpdf()"]
[null,null,null,null,"ActiveWorkbook.FollowHyperlink Address:=\"http://www.automateexcel.com/shortcuts/shortcut-pdfs?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=shortcutpdf\", NewWindow:=True 'Open Website\""]
[null,null,null,null,"End Sub"]

{"sheet":"redirectlist","index":1,"n_rows":125,"n_cols":16,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"get this set up so it does the utm tracking… then I can set up macros that link to those pages… "]
["home-header-about","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=About&utm_campaign=shortcuttrainer","home","http://www.automateexcel.com",null,null,"home",null,"header",null,"http://www.automateexcel.com",null,"about","About",null,{"$f":"A2&\",\"&B2","v":"home-header-about,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=About&utm_campaign=shortcuttrainer"}]
["home-header-start-here","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=start-here&utm_campaign=shortcuttrainer","fulltutorial","http://www.automateexcel.com/advanced-excel-training-course",null,"1 page","affiliate",null,null,null,"http://www.automateexcel.com/affiliate",null,"start here","<<Start Here>>",null,{"$f":"A3&\",\"&B3","v":"home-header-start-here,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=start-here&utm_campaign=shortcuttrainer"}]
["home-header-using-the-mouse","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer","keyrocket_download","http://www.automateexcel.com/thank-you-for-downloading-keyrocket",null,null,"fulltutorial",null,"header","individual pages","http://www.automateexcel.com/advanced-excel-training-course",null,"using the mouse","Using the Mouse",null,"home-header-using-the-mouse,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer"]
["home-header-intro-basic-shortcuts","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer","keyrocket_info","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1",null,null,"keyrocketinfo",null,null,"individual pages","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1",null,"intro & basic shortcuts","Intro & Basic Shortcuts",null,"home-header-intro-basic-shortcuts,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer"]
["home-header-selecting-navigating","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer","shortcut_diag_test","http://www.automateexcel.com/excel-practice-test/",null,"1 page","keyrocketdownload",null,null,null,"http://www.automateexcel.com/thank-you-for-downloading-keyrocket",null,"selecting & navigating","Selecting & Navigating",null,"home-header-selecting-navigating,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer"]
["home-header-copying-pasting","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer","shortcut_basics","http://www.automateexcel.com/excel-practice-test/",null,null,"shortcuttest",null,null,"individual pages","http://www.automateexcel.com/excel-practice-test/",null,"copying & pasting","Copying & Pasting",null,"home-header-copying-pasting,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer"]
["home-header-nav1","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav1&utm_campaign=shortcuttrainer","shortcut_selectnav","http://www.automateexcel.com/excel-practice-test/",null,null,"learnshortcuts",null,"header",null,"http://www.automateexcel.com/learn-excel-shortcuts/",null,"nav1","Nav 1.",null,"home-header-nav1,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav1&utm_campaign=shortcuttrainer"]
["home-header-nav2","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav2&utm_campaign=shortcuttrainer","shortcut_copypaste","http://www.automateexcel.com/excel-practice-test/",null,null,null,null,null,null,null,null,"nav2","Nav 2.",null,"home-header-nav2,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav2&utm_campaign=shortcuttrainer"]
["home-header-formatting-i","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting-I&utm_campaign=shortcuttrainer","shortcut_formatting1","http://www.automateexcel.com/excel-practice-test/",null,null,null,null,null,null,null,null,"formatting i","Formatting I",null,"home-header-formatting-i,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting-I&utm_campaign=shortcuttrainer"]
["home-header-altshortcuts","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=altshortcuts&utm_campaign=shortcuttrainer","shortcut_menusformats","http://www.automateexcel.com/excel-practice-test/",null,null,"start page is unique",null,null,null,null,null,"altshortcuts","Alt Shortcuts, Menus, Formats",null,"home-header-altshortcuts,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=altshortcuts&utm_campaign=shortcuttrainer"]
["home-header-rowscolssheets","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=rowscolssheets&utm_campaign=shortcuttrainer","shortcut_rowscolssheets","http://www.automateexcel.com/excel-practice-test/",null,null,"header",null,null,null,null,null,"rowscolssheets","Rows, Columns, Sheets",null,"home-header-rowscolssheets,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=rowscolssheets&utm_campaign=shortcuttrainer"]
["home-header-exs-rowscolssheets","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer","shortcut_formulas","http://www.automateexcel.com/excel-practice-test/",null,null,null,null,null,null,null,null,"exs-rowscolssheets","Exs. Rows,Cols,Sheets",null,"home-header-exs-rowscolssheets,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer"]
["home-header-formatting","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting&utm_campaign=shortcuttrainer","shortcut_workbooknav","http://www.automateexcel.com/excel-practice-test/",null,null,null,null,null,null,null,null,"formatting","Formatting",null,"home-header-formatting,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting&utm_campaign=shortcuttrainer"]
["home-header-exercise-support","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Exercise-support&utm_campaign=shortcuttrainer","shortcut_datatools","http://www.automateexcel.com/excel-practice-test/",null,null,"pay with a tweet for the pdf shortcut download?",null,null,null,null,null,"exercise support","Exercise support",null,"home-header-exercise-support,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Exercise-support&utm_campaign=shortcuttrainer"]
["home-header-formula-shortcuts","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer","shortcut_landingpage","http://www.automateexcel.com/learn-excel-shortcuts/",null,null,null,null,null,null,null,null,"formula shortcuts","Formula Shortcuts",null,"home-header-formula-shortcuts,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer"]
["home-header-workbook-nav","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer","sbc_image","http://www.automateexcel.com/advanced-excel-training-course",null,null,null,null,null,null,null,null,"workbook nav","Workbook Nav",null,"home-header-workbook-nav,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer"]
["home-header-data-tools","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Data-Tools&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,"data tools","Data Tools",null,"home-header-data-tools,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Data-Tools&utm_campaign=shortcuttrainer"]
["home-header-keyboard-layout-troubleshoot","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer","shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/",null,null,null,null,null,null,null,null,"keyboard layout & troubleshoot","Keyboard Layout & Troubleshoot",null,"home-header-keyboard-layout-troubleshoot,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer"]
["home-header-productivity-software","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Productivity-Software&utm_campaign=shortcuttrainer","automateexcel","http://www.automateexcel.com/",null,null,null,null,null,null,null,null,"productivity software","Productivity Software",null,"home-header-productivity-software,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Productivity-Software&utm_campaign=shortcuttrainer"]
["home-header-optimize-your-workspace","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,"optimize your workspace","Optimize Your Workspace",null,"home-header-optimize-your-workspace,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer"]
["home-header-results","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Results&utm_campaign=shortcuttrainer","codevba","http://codevba.com/automateexcel.htm",null,null,null,null,null,null,null,null,"results","Results",null,"home-header-results,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Results&utm_campaign=shortcuttrainer"]
["home-header-freq-used-shortcuts","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,"freq used shortcuts","Freq Used Shortcuts",null,"home-header-freq-used-shortcuts,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer"]
["home-header-all-shortcuts","http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer","#How to work affiliate program with this? I guess I can create",null,null,null,null,null,null,null,null,null,"all shortcuts","All Shortcuts",null,"home-header-all-shortcuts,http://www.automateexcel.com?utm_source=shortcuttrainer&utm_medium=header&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer"]
["fulltutorial-header-about","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=About&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-about,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=About&utm_campaign=shortcuttrainer"]
["fulltutorial-header-start-here","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=start-here&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-start-here,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=start-here&utm_campaign=shortcuttrainer"]
["fulltutorial-header-using-the-mouse","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer","#keyrocket","http://sites.fastspring.com/veodin/product/keyrocketpremium_onetime?source=spreadsheetbootcamp",null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-using-the-mouse,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer"]
["fulltutorial-header-intro-basic-shortcuts","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-intro-basic-shortcuts,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer"]
["fulltutorial-header-selecting-navigating","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer","#https://yoast.com/cloak-affiliate-links/",null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-selecting-navigating,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer"]
["fulltutorial-header-copying-pasting","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-copying-pasting,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer"]
["fulltutorial-header-nav1","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav1&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-nav1,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav1&utm_campaign=shortcuttrainer"]
["fulltutorial-header-nav2","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav2&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-nav2,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav2&utm_campaign=shortcuttrainer"]
["fulltutorial-header-formatting-i","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting-I&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-formatting-i,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting-I&utm_campaign=shortcuttrainer"]
["fulltutorial-header-altshortcuts","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=altshortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-altshortcuts,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=altshortcuts&utm_campaign=shortcuttrainer"]
["fulltutorial-header-rowscolssheets","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-rowscolssheets,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=rowscolssheets&utm_campaign=shortcuttrainer"]
["fulltutorial-header-exs-rowscolssheets","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-exs-rowscolssheets,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer"]
["fulltutorial-header-formatting","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-formatting,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting&utm_campaign=shortcuttrainer"]
["fulltutorial-header-exercise-support","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Exercise-support&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-exercise-support,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Exercise-support&utm_campaign=shortcuttrainer"]
["fulltutorial-header-formula-shortcuts","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-formula-shortcuts,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer"]
["fulltutorial-header-workbook-nav","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-workbook-nav,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer"]
["fulltutorial-header-data-tools","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Data-Tools&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-data-tools,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Data-Tools&utm_campaign=shortcuttrainer"]
["fulltutorial-header-keyboard-layout-troubleshoot","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-keyboard-layout-troubleshoot,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer"]
["fulltutorial-header-productivity-software","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Productivity-Software&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-productivity-software,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Productivity-Software&utm_campaign=shortcuttrainer"]
["fulltutorial-header-optimize-your-workspace","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-optimize-your-workspace,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer"]
["fulltutorial-header-results","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Results&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-results,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Results&utm_campaign=shortcuttrainer"]
["fulltutorial-header-freq-used-shortcuts","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-freq-used-shortcuts,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer"]
["fulltutorial-header-all-shortcuts","http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"fulltutorial-header-all-shortcuts,http://www.automateexcel.com/advanced-excel-training-course?utm_source=shortcuttrainer&utm_medium=header&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-about","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=About&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-about,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=About&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-start-here","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-start-here,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-using-the-mouse","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-using-the-mouse,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-intro-basic-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-intro-basic-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-selecting-navigating","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-selecting-navigating,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-copying-pasting","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-copying-pasting,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-nav1","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav1&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-nav1,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav1&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-nav2","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav2&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-nav2,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav2&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-formatting-i","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting-I&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-formatting-i,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting-I&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-altshortcuts","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=altshortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-altshortcuts,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=altshortcuts&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-rowscolssheets","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-rowscolssheets,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=rowscolssheets&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-exs-rowscolssheets","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-exs-rowscolssheets,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-formatting","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-formatting,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-exercise-support","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Exercise-support&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-exercise-support,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Exercise-support&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-formula-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-formula-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-workbook-nav","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-workbook-nav,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-data-tools","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Data-Tools&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-data-tools,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Data-Tools&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-keyboard-layout-troubleshoot","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-keyboard-layout-troubleshoot,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-productivity-software","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Productivity-Software&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-productivity-software,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Productivity-Software&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-optimize-your-workspace","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A67&\",\"&B67","v":"keyrocketinfo-incontent-optimize-your-workspace,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer"}]
["keyrocketinfo-incontent-results","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Results&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-results,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Results&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-freq-used-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-freq-used-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-all-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketinfo-incontent-all-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-about","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=About&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-about,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=About&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-start-here","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-start-here,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-using-the-mouse","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-using-the-mouse,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-intro-basic-shortcuts","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-intro-basic-shortcuts,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-selecting-navigating","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-selecting-navigating,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-copying-pasting","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-copying-pasting,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-nav1","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav1&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-nav1,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav1&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-nav2","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav2&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-nav2,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=nav2&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-formatting-i","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting-I&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-formatting-i,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting-I&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-altshortcuts","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=altshortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-altshortcuts,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=altshortcuts&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-rowscolssheets","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-rowscolssheets,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=rowscolssheets&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-exs-rowscolssheets","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-exs-rowscolssheets,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-formatting","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-formatting,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formatting&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-exercise-support","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Exercise-support&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-exercise-support,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Exercise-support&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-formula-shortcuts","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-formula-shortcuts,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-workbook-nav","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-workbook-nav,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-data-tools","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Data-Tools&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-data-tools,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Data-Tools&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-keyboard-layout-troubleshoot","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-keyboard-layout-troubleshoot,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-productivity-software","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Productivity-Software&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-productivity-software,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Productivity-Software&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-optimize-your-workspace","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-optimize-your-workspace,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-results","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Results&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-results,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Results&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-freq-used-shortcuts","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-freq-used-shortcuts,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-all-shortcuts","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"shortcuttest-incontent-all-shortcuts,http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-about","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=About&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-about,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=About&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-start-here","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=start-here&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-start-here,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=start-here&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-using-the-mouse","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-using-the-mouse,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Using-the-Mouse&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-intro-basic-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-intro-basic-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Intro-Basic-Shortcuts&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-selecting-navigating","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-selecting-navigating,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Selecting-Navigating&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-copying-pasting","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-copying-pasting,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Copying-Pasting&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-nav1","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav1&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-nav1,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav1&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-nav2","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav2&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-nav2,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=nav2&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-formatting-i","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting-I&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-formatting-i,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting-I&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-altshortcuts","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=altshortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-altshortcuts,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=altshortcuts&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-rowscolssheets","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-rowscolssheets,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=rowscolssheets&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-exs-rowscolssheets","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-exs-rowscolssheets,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=exs-rowscolssheets&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-formatting","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-formatting,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formatting&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-exercise-support","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Exercise-support&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-exercise-support,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Exercise-support&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-formula-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-formula-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Formula-Shortcuts&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-workbook-nav","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-workbook-nav,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Workbook-Nav&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-data-tools","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Data-Tools&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-data-tools,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Data-Tools&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-keyboard-layout-troubleshoot","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-keyboard-layout-troubleshoot,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Keyboard-Layout-Troubleshoot&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-productivity-software","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Productivity-Software&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-productivity-software,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Productivity-Software&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-optimize-your-workspace","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-optimize-your-workspace,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Optimize-Your-Workspace&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-results","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Results&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-results,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Results&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-freq-used-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-freq-used-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=Freq-Used-Shortcuts&utm_campaign=shortcuttrainer"]
["learnshortcuts-header-all-shortcuts","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"learnshortcuts-header-all-shortcuts,http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=header&utm_term=All-Shortcuts&utm_campaign=shortcuttrainer"]
["affiliate-incontent-about","http://www.automateexcel.com/affiliate?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=about&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"affiliate-incontent-about,http://www.automateexcel.com/affiliate?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=about&utm_campaign=shortcuttrainer"]
["keyrocketdownload-incontent-intro-basics-hortcuts","http://www.automateexcel.com/affiliate?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=intro&utm_campaign=shortcuttrainer",null,null,null,null,null,null,null,null,null,null,null,null,null,"keyrocketdownload-incontent-intro-basics-hortcuts,http://www.automateexcel.com/affiliate?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=intro&utm_campaign=shortcuttrainer"]
[]
[]
["home-incontent-start-here","http://www.automateexcel.com/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]
["fulltutorial-incontent-start-here","http://www.automateexcel.com/advanced-excel-training-course/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]
["keyrocketinfo-incontent-start-here","http://www.automateexcel.com/learn-excel-shortcuts/keyrocket-vid1/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]
["shortcuttest-incontent-start-here","http://www.automateexcel.com/excel-practice-test/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]
["learnshortcuts-incontent-start-here","http://www.automateexcel.com/learn-excel-shortcuts/?utm_source=shortcuttrainer&utm_medium=incontent&utm_term=start-here&utm_campaign=shortcuttrainer"]

{"sheet":"About","index":2,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[14,6,14,11],[23,1,23,5],[10,1,10,7]]}
[null,"Share with your friends and colleagues:"]
[]
[]
[]
[]
[]
[null,"About Automate Excel and Spreadsheet Boot Camp"]
[null,"www.automateexcel.com was founded in 2004 and is one of the oldest and most trusted sources of information for Microsoft Excel and VBA."]
[null,"Spreadsheet Boot Camp is the name of our awesome self-paced, hands-on Excel Tutorial."]
[null,"Check out our website for more information:"]
[null,"http://www.automateexcel.com/advanced-excel-training-course"]
[]
[null,"Usage"]
[null,"This spreadsheet is free for your personal use and you may distribute it unedited at your discretion."]
[null,"Although we prefer that you link to our site:",null,null,null,null,"http://www.automateexcel.com/learn-excel-shortcuts"]
[null,"We encourage you to share it with your friends and colleagues through social media or email, or by posting links on a blog/message board."]
[]
[null,"If you are an organization, please distribute this trainer as you see fit.  We simply ask that you let us know."]
[null,"This helps us keep track of who is using our trainer and helps us develop better training solutions for broader use."]
[]
[null,"Affiliate"]
[null,"Our affiliates earn a percentage of any sales that they refer."]
[null,"Share a link to this trainer, if someone visits that link and later purchases our full tutorial, you will receive percentage of the sale."]
[null,"http://www.automateexcel.com/affiliate"]
[]
[]
[]
[]
[]
[null,"Contact"]
[null,"spreadsheetbootcamp@gmail.com"]
[]
[null,"Legal"]
[null,"Microsoft, MS, Office, Excel, PowerPoint, Outlook, Word,  and Windows are either  registered trademarks  or trademarks of Microsoft Corporation in the United States and/or other Countries."]
[null,"Spreadsheet Boot Camp LLC and its software services are independent and are not affiliated with Microsoft Corporation."]
[null,"Copyright © 2012-2016 by Spreadsheet Boot Camp LLC"]
[]
[null,"Privacy"]
[null,"To improve your user experience, this spreadsheet accesses information on your computer. Specifically, it looks for your computer's unique ID and"]
[null,"checks to see if you've downloaded and installed KeyRocket. No information is ever transmitted without your consent and we will never share any"]
[null,"personal data that you choose to share with us."]
[]
[null,"When you're finished, Use CTRL+ Page Down to jump to the next worksheet"]

{"sheet":"<<Start Here>>","index":3,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Helpful Shotcuts"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Index"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diag Test\nResult",null,null,null,null,null,"Diag Test\nResult"]
[null,null,null,null,null,null,null,null,null,"Using the Mouse",null,null,null,null,null,"Rows, Columns, & Sheets"]
[null,null,null,null,null,null,null,null,null,null,"Using the Mouse",null,null,null,null,null,"Inserting & Deleting",null,null,{"$f":"diag_test_results!AH14","v":0},{"$f":"diag_test_results!AF14&\" of \" &diag_test_results!AG14","v":"0 of 1"}]
[null,null,"Copy + Paste Diagnostic Test Results Below:",null,null,null,null,null,null,"Intro & Basic Shortcuts",null,null,null,null,null,null,"Hiding & Grouping"]
[null,null,null,null,null,null,".",null,null,null,"Becoming a Shortcut Guru",null,null,null,null,null,"ALT Shortcuts",null,null,{"$f":"diag_test_results!AH16","v":0},{"$f":"diag_test_results!AF16&\" of \" &diag_test_results!AG16","v":"0 of 1"}]
[null,null,null,null,null,null,null,null,null,null,"Using CTRL Shortcuts",null,null,null,null,"Sheets Exercises"]
[null,null,null,null,null,null,null,null,null,null,"CTRL & \"Must-Use\" Shortcuts",null,null,{"$f":"diag_test_results!AE18","v":0},{"$f":"diag_test_results!AC18&\" of \" &diag_test_results!AD18","v":"0 of 7"},null,"Exercises"]
[null,null,null,null,null,null,null,null,null,"Selecting & Navigating",null,null,null,null,null,"Formatting Exercise"]
[null,null,null,null,null,null,null,null,null,null,"Worksheet Navigation",null,null,{"$f":"diag_test_results!AE20","v":0},{"$f":"diag_test_results!AC20&\" of \" &diag_test_results!AD20","v":"0 of 2"},null,"Formatting Exercise"]
[null,null,null,null,null,null,null,null,null,null,"Selecting Cells",null,null,{"$f":"diag_test_results!AE21","v":0},{"$f":"diag_test_results!AC21&\" of \" &diag_test_results!AD21","v":"0 of 2"},"Formula Shortcuts"]
[null,null,null,null,null,null,null,null,null,"Copying & Pasting",null,null,null,null,null,null,"Formula Creating & Editing",null,null,{"$f":"diag_test_results!AH22","v":0},{"$f":"diag_test_results!AF22&\" of \" &diag_test_results!AG22","v":"0 of 3"}]
[null,null,null,null,null,null,null,null,null,null,"Copying & Pasting Basics",null,null,{"$f":"diag_test_results!AE23","v":0},{"$f":"diag_test_results!AC23&\" of \" &diag_test_results!AD23","v":"0 of 2"},null,"Formula Auditing",null,null,{"$f":"diag_test_results!AH23","v":0},{"$f":"diag_test_results!AF23&\" of \" &diag_test_results!AG23","v":"0 of 1"}]
[null,null,null,null,null,null,null,null,null,null,"Paste Special",null,null,{"$f":"diag_test_results!AE24","v":0},{"$f":"diag_test_results!AC24&\" of \" &diag_test_results!AD24","v":"0 of 1"},null,"Undo",null,null,{"$f":"diag_test_results!AH24","v":0},{"$f":"diag_test_results!AF24&\" of \" &diag_test_results!AG24","v":"0 of 1"}]
[null,null,null,null,null,null,null,null,null,null,"Exercise #1",null,null,null,null,null,"Formula Exercise"]
[null,null,null,null,null,null,null,null,null,"Navigation Exercise",null,null,null,null,null,"Workbook Navigation"]
[null,null,null,null,null,null,null,null,null,null,"Nav Exercise",null,null,null,null,null,"Workbook Nav & Viewing"]
[null,null,null,null,null,null,null,null,null,"Formatting 1",null,null,null,null,null,"Data Tools"]
[null,null,null,null,null,null,null,null,null,null,"Simple Formatting",null,null,{"$f":"diag_test_results!AE29","v":0},{"$f":"diag_test_results!AC29&\" of \" &diag_test_results!AD29","v":"0 of 4"},null,"Find & Go To",null,null,{"$f":"diag_test_results!AH29","v":0},{"$f":"diag_test_results!AF29&\" of \" &diag_test_results!AG29","v":"0 of 1"}]
[null,null,null,null,null,null,null,null,null,"Alt Shortcuts, Menus, & Formatting",null,null,null,null,null,null,"Data Tools",null,null,{"$f":"diag_test_results!AH30","v":0},{"$f":"diag_test_results!AF30&\" of \" &diag_test_results!AG30","v":"0 of 1"}]
[null,null,null,null,null,null,null,null,null,null,"Intro to ALT Shortcuts",null,null,{"$f":"diag_test_results!AE31","v":0},{"$f":"diag_test_results!AC31&\" of \" &diag_test_results!AD31","v":"0 of 1"},"Keyboard Layout & Troubleshooting"]
[null,null,null,null,null,null,null,null,null,null,"The Home Ribbon",null,null,null,null,null,"Keyboard Layout"]
[null,null,null,null,null,null,null,null,null,null,"Menus",null,null,null,null,null,"Keyboard Recommendations"]
[null,null,null,null,null,null,null,null,null,null,"Cell Format Menu - Repeat",null,null,null,null,null,"Troubleshooting"]
[]
[]
[]
[]
[]
[]
[null,"When you're finished, Use CTRL+ Page Down to jump to the next worksheet"]

{"sheet":"diag_test_results","index":4,"n_rows":33,"n_cols":34,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,{"$f":"A12+1","v":2},3,4,5,6,7,null,1,2,3,null,"save","[test-save]",{"$f":"MID(DiagnosticTestResult,FIND(N12,DiagnosticTestResult)+LEN(N12),1)","v":{"$error":"#VALUE!"}},null,1,2,3,4,5,6,7,null,1,2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"copy","[test-copy]",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,"Insert Row or Column",null,null,null,"undo",{"$f":"\"[test-\"&M14&\"]\"","v":"[test-undo]"},{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,{"$f":"VALUE(VLOOKUP(I14,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"COUNTIF(Y14:AA14,0)","v":0},{"$f":"COUNTA(Y14:AA14)","v":1},{"$f":"AF14/AG14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"move to end of data region (right)","[test-right-to-end-of-region]",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,"Activate Ribbon Commands",null,null,null,"move to first cell in the worksheet","[test-move-to-first-cell]",{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,{"$f":"VALUE(VLOOKUP(I16,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"COUNTIF(Y16:AA16,0)","v":0},{"$f":"COUNTA(Y16:AA16)","v":1},{"$f":"AF16/AG16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"select all cells in range","[test-select-all-cells-in-range]",{"$error":"#VALUE!"}]
["Save","Copy","Undo","Paste","Edit Cell","Toggle Absolute / Relative References (In Cell Edit Mode)","Move to end of data region (Right)",null,null,null,null,null,"select entire row","[test-select-entire-row]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A18,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,null,{"$f":"COUNTIF(Q18:W18,0)","v":0},{"$f":"COUNTA(Q18:W18)","v":7},{"$f":"AC18/AD18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"paste","[test-paste]",{"$error":"#VALUE!"}]
["Move to end of data region (Right)","Move to First Cell in the Worksheet",null,null,null,null,null,null,null,null,null,null,"paste special","[test-paste-special2]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A20,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(B20,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q20:W20,0)","v":0},{"$f":"COUNTA(Q20:W20)","v":2},{"$f":"AC20/AD20","v":0}]
["Select all Cells in Range","Select Entire Row",null,null,null,null,null,null,null,null,null,null,"bold","[test-bold]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A21,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(B21,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q21:W21,0)","v":0},{"$f":"COUNTA(Q21:W21)","v":2},{"$f":"AC21/AD21","v":0}]
[null,null,null,null,null,null,null,null,"Edit Cell","Toggle Absolute / Relative References (In Cell Edit Mode)","Copy Formula From Cell Above",null,"apply currency format","[test-currency-format]",{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,{"$f":"VALUE(VLOOKUP(I22,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(J22,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(K22,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"COUNTIF(Y22:AA22,0)","v":0},{"$f":"COUNTA(Y22:AA22)","v":3},{"$f":"AF22/AG22","v":0}]
["Copy","Paste",null,null,null,null,null,null,"Edit Cell",null,null,null,"apply percentage format","[test-percentage-format]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A23,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(B23,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"VALUE(VLOOKUP(I23,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"COUNTIF(Q23:W23,0)","v":0},{"$f":"COUNTA(Q23:W23)","v":2},{"$f":"AC23/AD23","v":0},{"$f":"COUNTIF(Y23:AA23,0)","v":0},{"$f":"COUNTA(Y23:AA23)","v":1},{"$f":"AF23/AG23","v":0}]
["Paste Special",null,null,null,null,null,null,null,"Undo",null,null,null,"add outline border","[test-outline-border]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A24,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,{"$f":"VALUE(VLOOKUP(I24,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"COUNTIF(Q24:W24,0)","v":0},{"$f":"COUNTA(Q24:W24)","v":1},{"$f":"AC24/AD24","v":0},{"$f":"COUNTIF(Y24:AA24,0)","v":0},{"$f":"COUNTA(Y24:AA24)","v":1},{"$f":"AF24/AG24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"activate ribbon commands","[test-ribbon-commands]",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"insert row or column","[test-delete-row]",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"edit cell","[test-edit-cell]",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"toggle absolute / relative references (in cell edit mode)","[test-references]",{"$error":"#VALUE!"}]
["Bold","Apply Currency Format","Apply Percentage Format","Add Outline Border",null,null,null,null,"Find",null,null,null,"copy formula from cell above","[test-copy-formula-down]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A29,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(B29,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(C29,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(VLOOKUP(D29,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"VALUE(VLOOKUP(I29,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"COUNTIF(Q29:W29,0)","v":0},{"$f":"COUNTA(Q29:W29)","v":4},{"$f":"AC29/AD29","v":0},{"$f":"COUNTIF(Y29:AA29,0)","v":0},{"$f":"COUNTA(Y29:AA29)","v":1},{"$f":"AF29/AG29","v":0}]
[null,null,null,null,null,null,null,null,"Activate Filter",null,null,null,"activate filter","[test-filter]",{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,{"$f":"VALUE(VLOOKUP(I30,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"COUNTIF(Y30:AA30,0)","v":0},{"$f":"COUNTA(Y30:AA30)","v":1},{"$f":"AF30/AG30","v":0}]
["Activate Ribbon Commands",null,null,null,null,null,null,null,null,null,null,null,"find","[test-find]",{"$error":"#VALUE!"},null,{"$f":"VALUE(VLOOKUP(A31,$M$12:$O$31,3,FALSE))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q31:W31,0)","v":0},{"$f":"COUNTA(Q31:W31)","v":1},{"$f":"AC31/AD31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","[test-]"]
[null,null,null,null,null,null,null,null,null,null,null,null,"paste-special2","[test-paste-special2]","paste-special1",{"$f":"IFERROR(VALUE(MID(DiagnosticTestResult,FIND(O33,DiagnosticTestResult)+LEN(O33)+1,1)),0)","v":0}]

{"sheet":"Using the Mouse","index":5,"n_rows":56,"n_cols":39,"rows_kept":56,"cut":false,"hidden":false,"merged":[[35,2,38,4],[35,9,38,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[null,"Before we get started with keyboard shortcuts, let's cover a handful of mouse shortcuts."]
[]
["1. Using the Mouse"]
[]
[]
[]
[null,"This section covers using the mouse in Excel. If you've disabled the mouse, it's been temporarily activated again."]
[]
["x","Zoom In/Out"]
[null,"Hold CTRL and Use the Mouse Wheel to Zoom In/Out quickly"]
[]
["x","Drag and Fill"]
[null,"Select each dark highlighted cell, click, hold and drag the little box in the lower right hand corner of each dark highlighted cell to fill the boxes."]
[null,"Notice how Excel is smart enough to fill in the sequential days and months."]
[]
[null,null,null,null,"Monday",null,"Mon",null,"January",null,"Jan",null,1,null,"Jan",1,"<<Highlight both of these cells and drag down.",null,null,null,null,null,null,null,null,"Monday",{"$f":"Z20=E20","v":true},"Mon",{"$f":"AB20=G20","v":true},"January",{"$f":"AD20=I20","v":true},"Jan",{"$f":"AF20=K20","v":true},1,{"$f":"AH20=M20","v":true},"Jan",1,{"$f":"AJ20=O20","v":true},{"$f":"AK20=P20","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Notice how in this situation Excel is smart enough to realize you are working with dates.",null,null,null,null,null,null,null,null,"Tuesday",false,"Tue",false,"February",false,"Feb",false,1,false,"Feb",2,{"$f":"AJ21=O21","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday",false,"Wed",false,"March",false,"Mar",false,1,false,"Mar",3,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday",false,"Thu",false,"April",false,"Apr",false,1,false,"Apr",4,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friday",false,"Fri",false,"May",false,"May",false,1,false,"May",5,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saturday",false,"Sat",false,"June",false,"Jun",false,1,false,"Jun",6,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday",false,"Sun",false,"July",false,"Jul",false,1,false,"Jul",7,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",false,"Aug",false,1,false,"Aug",8,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",false,"Sep",false,1,false,"Sep",9,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",false,"Oct",false,1,false,"Oct",10,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",false,"Nov",false,1,false,"Nov",11,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AA20:AM31,\"=false\")=0,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"December",false,"Dec",false,1,false,"Dec",12,false,false]
[]
["x","Drag"]
[null,"Click, hold and drag on the border of the cell to move "]
[]
[null,null,"Move Me",null,null,null,null,null,null,null,null,null,null,null,null,"                                                                               "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(J36),\"Complete!\",\"\")","v":""}]
[]
["x","Autofill"]
[null,"Double-click the little box in the lower right corner of the top cell to copy the formula down."]
[]
[null,null,2009,10000]
[null,null,2010,{"$f":"D44*1.06","v":10600},null,"Select the cell and double-click near the arrow."]
[null,null,2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11236,{"$f":"Z46=D46","v":false}]
[null,null,2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11910.16,{"$f":"Z47=D47","v":false}]
[null,null,2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12624.7696,{"$f":"Z48=D48","v":false}]
[null,null,2014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13382.255776,{"$f":"Z49=D49","v":false}]
[null,null,2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AA46:AA50,\"=false\")=0,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,14185.191122560002,{"$f":"Z50=D50","v":false}]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
["x"]

{"sheet":"Intro & Basic Shortcuts","index":6,"n_rows":194,"n_cols":13,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Becoming a Shortcut Guru"]
[]
[]
[]
[]
[null,"This workbook will introduce you to numerous powerful time-saving shortcuts."]
[null,"If you're a frequent Excel user, the return on investment from mastering these shortcuts will be massive."]
[null,"You will be able to get more done, in less time, all while impressing your coworkers and bosses."]
[]
[]
[]
[]
[null,"Besides this tutorial, there are several ways to master Excel shortcuts::"]
[null,"1. Practice Shortcuts with our free online"]
[null,"2. Install the"]
[null,"3. Print off our "]
[null,"4.                                       and take away the safety net."]
[]
["x","1. Practice Shortcuts with our free online App"]
[null,"The App works like this: An Excel command will appear (ex. Apply Currency Format)"]
[null,"and you type the appropriate shortcut (ex. CTRL + SHIFT + $). The app will tell you if you are right or wrong, and you move on to the next shortcut."]
[null,"This is a fantastic way to develop \"muscle memory\" and make these shortcuts second-nature. You can spend as little as one minute per day and see a huge improvement."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x","2. Hands down, the easiest way to become a shortcut expert is with this awesome app:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If a shortcut doesn't exist, or is too complicated, you can create your own custom shortcuts:"]
[]
[]
[]
[]
[]
[]
[]
[null,"KeyRocket tracks your usage and identifies which shortcuts would benefit you the most:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KeyRocket is produced by a company called Veodin Software."]
[null,"Its installed in many corporate environments, so it's safe to use on your work computer and should work well with firewalls and proxies."]
[null,"It's free to try, but unfortunately, it's a bit expensive to purchase. However, if you're a student you can get a big discount by emailing Veodin from a .edu email address."]
[]
[null,"If you want to see KeyRocket in action"]
[null,"or"]
[null,"Use this link to "]
[]
[]
[]
[]
[]
["x","3. Print off our Shortcut Lists."]
[null,"Print off our shortcut lists and keep them at your desk."]
[]
[]
[]
[]
["x","4. Disable the Mouse"]
[null,"We estimate you can work 2-4x faster by using keyboard shortcuts instead of the mouse."]
[null,"However, as you work, you probably instinctively reach for the mouse."]
[null,"If you take away the safety net of the mouse, you'll have no choice but to use the keyboard…"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Click the icon above to disable the mouse."]
[null," You can enable the mouse again at any time by using the shortcut: CTRL + Q (See reminder on the top of each worksheet in cell M3)"]
[]
[]
[]
["2. Using CTRL Shortcuts"]
[]
[]
[]
["x","Excel uses two primary keys for shortcuts: ALT and CTRL. We will introduce you to the ALT Shortcuts in later lessons."]
[null,"Now we will focus on the CTRL Shortcuts:"]
[]
[null,"To use the CTRL Shortcuts: Press and Hold CTRL then (while still pressing CTRL) tap another key."]
[null,"Example: Press and Hold CTRL, then tap C to Copy."]
[]
[null,"We will identify CTRL shortcuts as (CTRL + C); the + indicating to press and hold the first key."]
[null,"Having trouble? In the ",null,null,null,null,null,null,"you'll find a visual demonstration of the CTRL Shortcut."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: https://commons.wikimedia.org/wiki/File:ANSI_Keyboard_Layout_Diagram_with_Form_Factor.svg"]
[null,null,null,null,null,null,null,null,null,null,null,"Author: Rumudiez"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. CTRL & The \"Must-Use\" Shortcuts"]
[]
[]
[]
[]
["x","This tutorial is filled with shortcuts. If you feel overwhelmed, focus on these shortcuts first:"]
[]
[null,"The CTRL Shortcuts"]
[null,"CTRL + S",null,"Save Workbook"]
[null,"CTRL + P",null,"Print"]
[null,"CTRL + N",null,"New Workbook"]
[null,"CTRL + O",null,"Open Workbook"]
[null,"CTRL + C",null,"Copy"]
[null,"CTRL + X",null,"Cut"]
[null,"CTRL + V",null,"Paste"]
[null,"CTRL + Z",null,"Undo"]
[]
[null,"Other \"Must-Use\" Shortcuts"]
[null,"We will practice these shortcuts in future lessons."]
[null,"Arrow Keys",null,"Navigate Cells"]
[null,"CTRL + Arrow Keys",null,"\"Jump\" to Next Cell (see below)"]
[null,"SHIFT + Arrow Keys",null,"Select Arrays of Cells"]
[]
[null,"CTRL + TAB",null,"Cycle to Next Workbook"]
[null,"ALT + TAB",null,"Cycle to Next Program (Windows shortcut, not Excel specific)"]
[null,"CTRL + Page Up",null,"Go to Previous Worksheet"]
[null,"CTRL + Page Down",null,"Go to Next Worksheet"]
[]
[null,"F2",null,"Edit Cell"]
[null,"F4",null,"Anchor Cell References"]
[]
[]
[]
[null,"When you're finished, Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Selecting & Navigating","index":7,"n_rows":142,"n_cols":15,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Worksheet Navigation"]
[]
[]
[]
[]
["x","Arrow Keys"]
[null,"Instead of using the mouse, you can use the Arrow Keys to navigate."]
[null,"Follow the path from start to finish by using the Arrow Keys on the keyboard."]
[]
[null,null,"Start","x","x","x","x"]
[null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,"x",null,null,"x","x","x","x","x","Finish"]
[null,null,null,null,null,null,"x",null,null,"x"]
[null,null,null,null,null,null,"x",null,null,"x"]
[null,null,null,null,null,null,"x","x","x","x"]
[]
["x","CTRL"]
[null,"Next, follow the same path again, but this time hold down the CTRL key while following the path.  CTRL allows you to skip to the last populated cell in a series."]
[null,"Use CTRL for lightning fast navigation within Excel."]
[]
[null,"Try navigating the new path below.  CTRL also allows you to skip to the next nonblank cell."]
[]
[null,null,"Start",null,null,null,"x"]
[]
[]
[null,null,null,null,null,null,null,null,null,"x",null,null,null,null,"Finish"]
[]
[]
[null,null,null,null,null,null,"x",null,null,"x"]
[]
["x","Enter/Tab Navigation"]
[null,"Excel makes it easy to enter data or formulas in adjacent cells."]
[null,"When you finish entering data into a cell, you can use TAB to move to the cell to the right or ENTER to move down a cell."]
[null,"Actually, ENTER is a bit more complicated. ENTER moves to the cell directly below the first cell in the range you are editing, which may not necessarily be the currently selected cell."]
[null,"If you enter several values in a row using TAB, once you hit ENTER you will return to cell directly below the original cell where you first hit TAB."]
[]
[null,"Try this below:"]
[null,"Use TAB to go from A to D. Once you reach the end use ENTER to start the next row."]
[]
[null,null,"a","b","c","d"]
[null,null,"e","f","g","h"]
[]
[null,"Now, try moving in the reverse direction (Up or to the Left) by holding SHIFT while using ENTER/TAB."]
[]
["x","Other Navigation"]
[null,"Try each of these shortcuts:"]
[null,"Home",null,"Move to Beginning of Row"]
[null,"Ctrl + Home",null,"Move to First Cell in Worksheet"]
[null,"Ctrl + End",null,"Move to Last Used Cell in Worksheet"]
[null,"Page Up / Down",null,"Scroll Up / Down One Page"]
[]
[]
[]
["2. Selecting Cells"]
[]
[]
[]
[]
["x","CTRL"]
[null,"If you are using the mouse, you can select non-continuous ranges of cells by holding down CTRL and clicking the desired cells."]
[]
[]
[]
[]
[]
[]
[]
["x","SHIFT"]
[null,"You can use the SHIFT key in combination with any of the navigation commands in the previous section to select that range of cells."]
[null,"Try it now: Hold down SHIFT and use the Arrows to select a range of cells."]
[]
[null,null,"Start","x","x","x","x"]
[null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,"x",null,null,"x","x","x","x","x","Finish"]
[null,null,null,null,null,null,"x",null,null,"x"]
[null,null,null,null,null,null,"x",null,null,"x"]
[null,null,null,null,null,null,"x","x","x","x"]
[]
[null,"Notice that you can't select the entire path at once by using the SHIFT key. The SHIFT key will only select rectangular blocks of cells."]
[]
["x","CTRL + SHIFT"]
[null,"Use CTRL with SHIFT and the ARROW Keys to quickly select large arrays of data."]
[null,"Play around with SHIFT and CTRL + SHIFT in the data set below."]
[]
[null,null,"Type","# Sold","Remaining Inventory","Ave Price"]
[null,null,"Sedan",23,67,15000]
[null,null,"Truck",45,55,22000]
[null,null,"SUV",56,44,24500]
[null,null,"Coupe",40,60,13000]
[]
["x","Other Selection Shortcuts"]
[null,"Try each of these in the data set above."]
[null,"CTRL + A",null,"Select All Cells in Range. Use this shortcut twice to select the entire worksheet."]
[null,"CTRL + SHIFT + 8 (*)",null,"Select Data Region Surrounding the Cell."]
[null,"CTRL + Space",null,"Select Entire Column"]
[null,"SHIFT + Space",null,"Select Entire Row"]
[]
[null,"You can also use SHIFT in conjunction with any of the navigation shortcuts in section 1.4 above:"]
[null,"SHIFT + Home",null,"Select to the Beginning of the Row"]
[null,"SHIFT + Ctrl + Home",null,"Select to First Cell in Worksheet"]
[null,"SHIFT + Ctrl + End",null,"Select to Last Used Cell in Worksheet"]
[null,"SHIFT + Page Up / Down",null,null,"Select Up / Down One Page"]
[]
["x","Drop Down Lists and Filters"]
[null,"Drop Down Lists allow you to define a cell value by choosing one from a list."]
[null,"Filters allow you to filter data so only rows matching your criteria are shown."]
[null,"You don't need the mouse to work with Drop Down Lists or Filters."]
[null,"Just select the cell with the Drop Down Arrow and use ALT + Down Arrow to activate the Drop Down."]
[null,"Next, use the arrow keys to select the desired item and hit ENTER to save changes (or ESC to exit without saving)."]
[]
[null,"Try this below:"]
[]
[null,"1. Data Validation ",null,null,"2. Filter"]
[null,"A",null,null,"Name","Age"]
[null,null,null,null,"Steve",33]
[null,null,null,null,"Amy",49]
[null,null,null,null,"Marco",21]
[]
[]
[]
[null,"When you're finished, Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Copying & Pasting","index":8,"n_rows":255,"n_cols":69,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Copy & Pasting Basics"]
[]
[]
[]
[]
["x","Copy, Cut, and Paste"]
[null,"Copying (CTRL+ C) copies the contents of a cell or cells.  The original cell(s) remain unchanged."]
[null,"Cutting (CTRL + X) moves a cell or cells.  After pasting, The original cell(s) are erased."]
[null,"Pasting (CTRL + V) pastes the copied or cut cell(s)."]
[]
[]
[null,"Practice Copying, Cutting, and Pasting Below:"]
[null,null,"Cells to Copy",null,"Copy & Paste <<Here>>",null,"Cells to Cut",null,"Cut & Paste <<Here>>"]
[null,null,1,null,null,null,1]
[null,null,3,null,null,null,3]
[null,null,5,null,null,null,5]
[null,null,7,null,null,null,7]
[null,null,9,null,null,null,9]
[null,null,11,null,null,null,11]
[null,null,13,null,null,null,13]
[null,null,15,null,null,null,15]
[null,null,17,null,null,null,17,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(E18:E26)=81,ISERROR(I18)),\"Complete!\",\"\")","v":""}]
[]
[]
[]
["2. Paste Special"]
[]
[]
[]
[]
["x","Paste Special (CTRL + ALT + V)"]
[]
[null,"When you Copy & Paste in Excel, you copy every aspect of the cell: formulas, formats, etc. "]
[null,"Alternatively, when you use Paste Special (CTRL + ALT + V) you choose which aspects of the cell to paste."]
[null,"You can chose to only paste Values, Formats, Comments and so on."]
[]
[null,"To activate the Paste Special Menu: Copy (CTRL + C) a cell or range of cells, go to the area where you want to Paste, but instead of Pasting as usual by using CTRL + V…"]
[null,"Use CTRL + ALT + V (hold down CTRL and ALT and tap V) to activate the Paste Special Menu."]
[]
[null,"Here is the Paste Special Menu:"]
[null,"We highlighted the most important"]
[null,"menu options:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"        Ignore These"]
[]
[]
[]
[]
[]
[]
[]
[null,"Notice the underlined letters? You can select an option simply by tapping the letter key corresponding to the underlined letter."]
[]
[null,"Hint: Memorize Paste Values and number formats (CTRL + ALT + V > U) as there is a good chance you will use it over and over again."]
[]
["x","Paste Values"]
[null,null,"Paste Values (CTRL + ALT + V > V) allows you to paste the output of a cell, but not the format or any other features."]
[null,null,"Select the black area (using the navigation shortcuts) and use Paste Values to paste the Taj Mahal to the right."]
[null,null,null,null,null,null,null,null,null,null,null,"Paste Here"]
[null,null,"                           !"]
[null,null,"                          /^\\"]
[null,null,"                        /     \\"]
[null,null,"     |               | (       ) |               |"]
[null,null,"    /^\\  |          /^\\ \\     / /^\\          |  /^\\"]
[null,null,"    |O| /^\\        (   )|-----|(   )        /^\\ |O|"]
[null,null,"    |_| |-|    |^-^|---||-----||---|^-^|    |-| |_|"]
[null,null,"    |O| |O|    |/^\\|/^\\||  |  ||/^\\|/^\\|    |O| |O|"]
[null,null,"    |-| |-|    ||_|||_||| /^\\ |||_|||_||    |-| |-|"]
[null,null,"    |O| |O|    |/^\\|/^\\||(   )||/^\\|/^\\|    |O| |O|"]
[null,null,"    |-| |-|    ||_|||_||||   ||||_|||_||    |-| |-|"]
[null,null,"    |O| |_|----|___|___|||___|||___|_|_|    |O| |O|"]
[null,null,"    |_|                                         |_|"]
[null,null,"       /_______________________________________\\"]
[null,null,"    __|_______________________________________|___|"]
[]
[]
[null,null,"Now try a more practical exercise."]
[null,null,"Each month you prepare a spreadsheet that reflects the past month's sales."]
[null,null,"After successfully updating the spreadsheet, you value paste that month's results into a historical results section to maintain a record."]
[]
[null,null,"Use Paste Values (CTRL + ALT + V > V) to paste the result of formulas, but not the actual formula itself."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Historical Results"]
[null,null,null,null,null,"Sales",null,null,null,null,null,"Jan","Feb","Mar","April"]
[null,null,null,null,"Shirts",{"$f":"SUM(AI95:AM95)","v":251344.73402882976},null,null,null,null,null,300178.62046798819,260990.50138678981,267147.53203005233,"Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ95*100000","v":12630.075585466517},{"$f":"AR95*100000","v":80180.057316633829},83177.894064339824,23171.061190695964,52185.64587169361,null,null,null,{"$f":"RAND()","v":0.12630075585466516},{"$f":"RAND()","v":0.80180057316633824},{"$f":"RAND()","v":0.83177894064339819},0.23171061190695963,0.52185645871693609]
[null,null,null,null,"Pants",{"$f":"SUM(AI96:AM96)","v":265841.02062589576},null,null,null,null,null,239268.55400539763,235125.96203341862,250529.70720415004,"Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ96*100000","v":62057.057274713989},86747.049985942082,90733.538824941657,8699.0469648847265,17604.327575413281,null,null,null,{"$f":"RAND()","v":0.62057057274713989},0.86747049985942082,0.90733538824941662,8.6990469648847268E-2,0.17604327575413281]
[null,null,null,null,"Socks",{"$f":"SUM(AI97:AM97)","v":340184.94468524418},null,null,null,null,null,262871.1446152397,110573.93277238004,286897.3087550418,"Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ97*100000","v":76606.450612073357},84054.399906583814,85234.614685939247,74886.436655258542,19403.042825389195,null,null,null,{"$f":"RAND()","v":0.76606450612073362},0.8405439990658381,0.85234614685939247,0.74886436655258548,0.19403042825389194]
[null,null,null,null,"Shoes",{"$f":"SUM(AI98:AM98)","v":180995.12758862477},null,null,null,null,null,320598.39714571426,292124.04891589336,306706.0974159633,"Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ98*100000","v":17787.179067774494},66356.260350168333,38516.378219394974,49943.207274895605,8392.102676391356,null,null,null,{"$f":"RAND()","v":0.17787179067774495},0.66356260350168339,0.38516378219394976,0.49943207274895607,8.3921026763913553E-2]
[null,null,null,null,"Watches",{"$f":"SUM(AI99:AM99)","v":255042.76767267368},null,null,null,null,null,304541.2596188701,270514.46703348972,357542.95712881174,"Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ99*100000","v":82028.035170581075},4733.3988216187727,75653.64559945013,70242.582255205343,22385.10582581834,null,null,null,{"$f":"RAND()","v":0.82028035170581082},4.7333988216187728E-2,0.75653645599450126,0.70242582255205344,0.22385105825818341]
[]
[null,null,"Notice how the Sales values are no longer nicely formatted?  Below we'll learn to use Paste Values and Number Formats (CTRL + ALT + V > U) to paste both the values and number formatting."]
[]
["x","Paste Formats"]
[null,null,"Paste Formats (CTRL + ALT + V > T) to see the hidden message. T because the T in formats is underlined."]
[null,null,null,null,null,null,null,null,null,null,null,"Paste Here"]
[null,null,null,null,null,null,null,null,null,null,null,"Boot","best","Spreadsheet","to","Excel!","to","best"]
[null,null,null,null,null,null,null,null,null,null,null,"Spreadsheet","way","to","way","learn","way","to"]
[null,null,null,null,null,null,null,null,null,null,null,"learn","Boot","Spreadsheet","is","best","learn","way"]
[null,null,null,null,null,null,null,null,null,null,null,"way","learn","Camp","way","to","Boot","best"]
[null,null,null,null,null,null,null,null,null,null,null,"Excel!","best","way","is","Spreadsheet","Camp","Boot"]
[null,null,null,null,null,null,null,null,null,null,null,"Boot","Spreadsheet","Camp","best","the","Spreadsheet","Camp"]
[null,null,null,null,null,null,null,null,null,null,null,"learn","learn","to","Boot","Boot","best","to"]
[null,null,null,null,null,null,null,null,null,null,null,"Camp","Excel!","Spreadsheet","is","learn","Camp","way"]
[null,null,null,null,null,null,null,null,null,null,null,"to","to","Excel!","best","Boot","Excel!","Boot"]
[null,null,null,null,null,null,null,null,null,null,null,"is","learn","Boot","Boot","Spreadsheet","is","Excel!"]
[null,null,null,null,null,null,null,null,null,null,null,"learn","best","Excel!","Camp","way","learn","is"]
[]
[]
[null,null,"Returning to our monthly sales example, use Paste Formats (CTRL + ALT + V > T) to update the cell formatting in the historical results section."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Historical Results"]
[null,null,null,null,null,"Sales",null,null,null,null,null,"Jan","Feb","Mar","April"]
[null,null,null,null,"Shirts",{"$f":"F95","v":251344.73402882976},null,null,null,null,null,300178.62046798819,260990.50138678981,267147.53203005233,269310.36191694182]
[null,null,null,null,"Pants",{"$f":"F96","v":265841.02062589576},null,null,null,null,null,239268.55400539763,235125.96203341862,250529.70720415004,277665.33829046303]
[null,null,null,null,"Socks",{"$f":"F97","v":340184.94468524418},null,null,null,null,null,262871.1446152397,110573.93277238004,286897.3087550418,287930.8931794755]
[null,null,null,null,"Shoes",{"$f":"F98","v":180995.12758862477},null,null,null,null,null,320598.39714571426,292124.04891589336,306706.0974159633,259002.64864155388]
[null,null,null,null,"Watches",{"$f":"F99","v":255042.76767267368},null,null,null,null,null,304541.2596188701,270514.46703348972,357542.95712881174,300641.45988477219]
[]
["x","Paste Values and Number Formats"]
[null,null,"Paste Values and number format (CTRL + ALT + V > U) allows you to paste the output of a cell, as well as the original number formatting."]
[null,null,"Use it in our monthly sales example:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Historical Results"]
[null,null,null,null,null,"Sales",null,null,null,null,null,"Jan","Feb","Mar","April"]
[null,null,null,null,"Shirts",{"$f":"F95","v":251344.73402882976},null,null,null,null,null,300178.62046798819,260990.50138678981,267147.53203005233,"Paste Here"]
[null,null,null,null,"Pants",{"$f":"F96","v":265841.02062589576},null,null,null,null,null,239268.55400539763,235125.96203341862,250529.70720415004,"Paste Here"]
[null,null,null,null,"Socks",{"$f":"F97","v":340184.94468524418},null,null,null,null,null,262871.1446152397,110573.93277238004,286897.3087550418,"Paste Here"]
[null,null,null,null,"Shoes",{"$f":"F98","v":180995.12758862477},null,null,null,null,null,320598.39714571426,292124.04891589336,306706.0974159633,"Paste Here"]
[null,null,null,null,"Watches",{"$f":"F99","v":255042.76767267368},null,null,null,null,null,304541.2596188701,270514.46703348972,357542.95712881174,"Paste Here"]
[]
[]
["x","Paste Widths (CTRL + ALT + V > W) is also useful. Paste Widths allows you to paste column widths."]
[null,null,"Try copying column U and pasting the column width into column V."]
[null,null,"Use CTRL + Z to undo this change."]
[]
[null,"Skip Blanks"]
["x","Skip Blanks will only copy and paste non-blank cells."]
[null,"Try it below"]
[]
[null,null,"Discount Rate",null,"Paste Here While Skipping Blanks"]
[null,null,5.3999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3999999999999999E-2,{"$f":"Z151=E151","v":false}]
[null,null,5.1999999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1999999999999998E-2,{"$f":"Z152=E152","v":false}]
[null,null,null,null,"Do Not Overwrite This"]
[null,null,4.2999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2999999999999997E-2,{"$f":"Z154=E154","v":false}]
[null,null,null,null,"Do Not Overwrite This"]
[null,null,6.8000000000000005E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.8000000000000005E-2,{"$f":"Z156=E156","v":false}]
[null,null,6.2E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AA152:AA157,\"=false\")=0,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,6.2E-2,{"$f":"Z157=E157","v":false}]
[]
[]
["x","Transpose"]
[null,"Transpose allows you to paste a vertical series horizontally or vis-a-versa. In other words, instead of appearing top to bottom the data will appear left to right."]
[]
[null,null,null,null,"Paste Here"]
[null,null,"CTRL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CTRL","+","ALT","+","V","+","E","To","Paste","Me","Sideways"]
[null,null,"+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z164=E164","v":false},{"$f":"AA164=F164","v":false},false,false,false,false,false,false,false,false,false]
[null,null,"ALT"]
[null,null,"+"]
[null,null,"V"]
[null,null,"+"]
[null,null,"E"]
[null,null,"To"]
[null,null,"Paste"]
[null,null,"Me"]
[null,null,"Sideways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Z165:AJ165,\"=false\")=0,\"Complete!\",\"\")","v":""}]
[]
[]
[]
["3. Exercise"]
[]
[]
[]
[]
["x","Combine your knowledge from the previous sections to complete this simple exercise."]
[null,"Jump from cell to cell, following the arrow direction. At each \"jump\", follow the directions."]
[]
[null,"Use the following shortcuts:"]
[null,"CTRL"]
[null,"SHIFT"]
[null,"Arrow Keys"]
[null,"CTRL + C"]
[null,"CTRL + V"]
[]
[null,null,"START",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ255=\"copy this\"","v":false}]
[null,null,{"$f":"IF(COUNTIF(BQ199:BQ206,\"=false\")=0,\"Finished!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,{"$f":"BF200=\"Paste Here\"","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,{"$f":"BF201=\"Paste Here\"","v":true}]
[null,"When you're finished, Use CTRL+ Page Down to jump to the next worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This"]

{"sheet":"Nav 1.","index":9,"n_rows":46,"n_cols":34,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Nav_IsStarted","v":true}]
[]
[]
[]
[]
[null,"Start Here>>>>>","X"]
[null,null,"x"]
[null,null,"x"]
[null,null,"X","x",null,null,"x","X"]
[null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"X","x","x","X"]
[null,null,null,null,null,null,null,null,null,null,"x"]
[]
[null,null,null,null,null,null,null,null,null,null,"x"]
[]
[null,null,null,null,null,null,null,null,null,null,"x"]
[]
[null,null,null,null,null,null,null,null,null,null,"x"]
[]
[null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,"X","x",null,"x","x","x","X"]
[null,null,null,null,"x"]
[null,null,null,null,"x"]
[null,null,null,null,"x"]
[null,null,null,null,"X","x",null,"x","x","X"]
[null,null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M41=\"draw bridge\",\"Go to Next Sheet\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Draw Bridge from Drop Down"]
[null,null,null,null,null,null,null,null,null,"X","x","x","Select Draw Bridge from Drop Down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draw Bridge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storm Gates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Turn Back"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M41=\"draw bridge\",\"Go to Next Sheet\",\"\")","v":""}]

{"sheet":"Nav 2.","index":10,"n_rows":25,"n_cols":44,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Nav_IsStarted","v":true}]
[]
[]
["<<Start Here>>"]
[{"$f":"AJ15","v":"Copy This"},"x","x","x","x","x","x","x","Paste Here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy This",null,null,null,null,null,null,null,"Done"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[]
[]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"x"]
[null,null,null,"Value Paste","x","x","x","x",{"$f":"AR25","v":"Copy This"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value Paste",null,null,null,null,"Paste as Values!",null,null,null,null,"Copy This"]

{"sheet":"Formatting I","index":11,"n_rows":68,"n_cols":10,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,3,44,4],[44,6,44,7]]}
[null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Simple Formatting"]
[]
[]
[]
[]
["x","It's vital to format your spreadsheets to properly communicate your results to your audience."]
[null,"But let's face it… After spending hours preparing data, who wants to spend time formatting? "]
[null,"The next several sections will cover huge time saving formatting shortcuts."]
[]
[null,"Complete the shortcut exercises below. Try to find at least one new shortcut to incorporate in your work."]
[]
[null,"For each item below, apply the appropriate format to the unformatted cells."]
[]
[null,"Format Type","Shortcut","Unformatted","Formatted","Memorization tricks"]
[]
[null,"Bold","CTRL + B","Text","Text","B for Bold"]
[null,"Italic","CTRL + I","Text","Text","I for Italic"]
[null,"Underline","CTRL + U","Text","Text","U for Underline"]
[]
[null,"Apply General Format","CTRL + SHIFT + ~","2036-02-27T07:59:59.712","2036-02-27T07:59:59.712"]
[null,"Apply Number Format","CTRL + SHIFT + !","2036-02-27T07:59:59.712",49732.333330000001]
[null,"Apply Time Format","CTRL + SHIFT + @","2036-02-27T07:59:59.712",49732.333330000001,"@ is the symbol for \"at\", as in \"meet at 3pm\""]
[null,"Apply Date Format","CTRL + SHIFT + #","2036-02-27T07:59:59.712","2036-02-27T07:59:59.712"]
[null,"Apply Currency Format","CTRL + SHIFT + $","2036-02-27T07:59:59.712",49732.333330000001,"$ for Currency Format"]
[null,"Apply Percentage Format","CTRL + SHIFT + %","2036-02-27T07:59:59.712",49732.333330000001,"% for percentage"]
[null,"Apply Scientific Format","CTRL + SHIFT + ^","2036-02-27T07:59:59.712",49732.333330000001,"^ Is the symbol for an exponent. You need an exponent for scientific notation"]
[]
[null,"Add Outline Border","CTRL + SHIFT + &","Text","Text"]
[]
[null,"Remove Borders","CTRL + SHIFT + _","Text","Text"]
[]
[]
["x","Repeat Previous Format"]
[null,"F4 tells Excel to repeat the previously applied format. "]
[null,"You can apply a format, continue working in your spreadsheet, then, when you are ready, you can use F4 to reapply that same formatting."]
[]
[null,"Let's walk through an example:"]
[]
[null,"1. Underline (CTRL + U)"]
[null,"2. Bold (CTRL + B)",null,"3. Type any text",null,null,"4. Reapply formatting (F4)"]
[null,"Bold & Underline This Text",null,null,null,null,"Reapply Format"]
[]
[null,"Notice that in step 4, the F4 shortcut applies the last formatting used: Bold Formatting. It does not apply Underline Formatting even though it was used on the same cell."]
[]
[null,"This shortcut isn't very useful with simple formatting, such as, applying Bold text, but it is very useful when applying multiple formatting changes with the "]
[null,"Cell Formatting Menu (CTRL + 1) that you will be introduced to in the next worksheet."]
[]
[]
[null,"When you're finished, Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Alt Shortcuts, Menus, Formats","index":12,"n_rows":190,"n_cols":13,"rows_kept":190,"cut":false,"hidden":false,"merged":[[54,5,54,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Introduction to ALT Shortcuts"]
[]
[]
[]
[]
["x","ALT Shortcuts are quite a bit different than CTRL shortcuts."]
[null,"They are best introduced with an example:"]
[]
[null,"Use the ARROW Keys to select this cell:"]
[null,"Text"]
[null,"1. Tap (and release) the ALT Key."]
[null,"Notice the letters and numbers that appear on the top of the screen?"]
[null,"These letters and numbers correspond to the Ribbon Menus and Commands."]
[null,"By tapping the ALT key, virtually every single Excel feature is just a couple keystrokes away."]
[null,"2. Tap the 'H' Key."]
[null,"This brings up the Home Ribbon."]
[null,"3. Tap the '6' Key."]
[null,"This indents the text in the selected cell(s)."]
[]
[null,"We abbreviate the shortcut as ALT > H > 6"]
[]
[null,"Now, undo the indent with the Undo Shortcut (Ctrl + Z)"]
[]
[]
[]
["2. Formatting - The Home Ribbon"]
[]
[]
[]
[]
["x","The Home Ribbon contains most of the cell formatting options you need:"]
[]
[]
[]
[]
[]
[]
[null,"From the previous section you know that ALT > H > 6 indents text. Instead of 6, you can use W to Wrap Text, or AC to Align Center, etc."]
[]
[null,"Practice using the Home Ribbon Commands below. If you can't find the command, scroll down for the appropriate keystrokes."]
[]
[]
[]
[null,"Practice:"]
[null,"Apply Bottom Border","Text",null,null,"Text"]
[]
[null,"Allign Center","Text",null,null,"Text"]
[]
[null,"Wrap Text","Long String of Text",null,null,"Long String of Text"]
[]
[null,"Merge and Center","text1","text2",null,"text1"]
[]
[null,"Add Digit After Decimal",33,null,null,33]
[]
[null,"Solutions:"]
[null,"ALT > H > B > O"]
[null,"ALT > H > AC"]
[null,"ALT > H > W"]
[null,"ALT > H > M"]
[null,"ALT > H > 0"]
[]
["x","Custom Shortcuts & Merge Cells"]
[null,"As you may have noticed, while these shortcuts don't require memorization, they take several keystrokes to activate."]
[null,"You can actually program custom shortcuts. There are several ways to do this, but if you have the KeyRocket App it's very easy:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In the image above, we've assigned the shortcut CTRL + M to the Merge and Center Command."]
[]
[]
[]
["3. Menus"]
[]
[]
[]
[]
["x","Many of the Ribbon commands activate pop-up menus:"]
[null,null,null,"Sort Menu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Using the keyboard to navigate these menus can save you quite a bit of time."]
[null,"Luckily that's very easy."]
[]
[]
[]
[]
["x","Navigating Menus"]
[null,"When you activate a menu, a menu cursor appears (see above)."]
[null,"You can move the cursor with the Arrow Keys or by pressing the TAB key (SHIFT + TAB moves in reverse)"]
[]
[null,"In general, The Arrow Keys allow you to navigate within a section, while the TAB key allows you to cycle between sections."]
[null,"That being said, each menu is a little different and you will explore on your own."]
[]
["x","Menu Options"]
[null,"Within Menus, you will find several different menu options:"]
[]
[null,"Check Boxes",null,null,"Entry Boxes",null,"Drop Downs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x","Activating and Saving Menu Options"]
[null,"Check Boxes - When a Check Box is activate, use SPACE to check or uncheck the checkbox. Also,"]
[null,"Whenever you see an underlined letter, you can type the letter (or ALT + the letter if you are in another section of the menu) to check or uncheck that option."]
[]
[null,null,null,null,null,"ALT + K will select the Strikethrough option"]
[]
[]
[]
[null,"Entry Boxes - When the Entry Box is selected, you can type your entry directly into the box. Alternatively, you can use the Up / Down Arrows (when available)."]
[null,"                         Use ENTER or TAB to save your selection"]
[null,"Drop Downs - When the drop down menu is selected, simply use the Up / Down Arrows to activate the drop down and make your selection."]
[null,"                         Use ENTER or TAB to save your selection"]
[]
[null,"ESC exits menu without saving changes"]
[null,"ENTER exits menu and saves changes"]
[]
[null,"We will practice navigating a menu in the next section."]
[]
[]
[]
["4. Cell Format Menu & Repeat Formatting"]
[]
[]
[]
["x","Practice Menu Navigation"]
[null,"Use CTRL + 1 (hold down CTRL and press 1) to bring up the Cell Formatting Menu."]
[null,"Practice using TAB, the Arrow Keys, and the other Keyboard Commands to navigate this Menu."]
[]
[null,"You can see all the formatting options available to you. Most of these options are available directly from the Home Ribbon."]
[null,"With that in mind, you generally only need to use the Cell Formatting Menu for very complex or specific formatting."]
[]
[]
["x","F4 to Repeat"]
[null,"As discussed in the previous worksheet, F4 will repeat the previous format."]
[null,"When you apply changes made to the Cell Formatting Menu, all of the changes made in one session are included in the \"previous format\" with the F4 shortcut."]
[null,"So, you can make a large number of formatting changes within the Cell Formatting Menu and then use F4 to apply all of those changes to other cells."]
[]
[null,"Try it Below:"]
[]
[null,"Use the Cell Formatting Menu to apply several different formats to the cell below:"]
[null,"Text1"]
[]
[null,"Then use F4 to reapply the formatting"]
[null,"Text2"]
[]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Rows, Columns, Sheets","index":13,"n_rows":154,"n_cols":13,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Inserting & Deleting - Rows, Columns, and Cells"]
[]
[]
[]
[]
["x","The Inserting and Deleting Shortcuts are very easy to remember. Use CTRL and + to add or - to delete. "]
[null,"CTRL + +","Inserts Rows, Columns, or Cells"]
[null,"CTRL + -","Deletes Rows, Columns, or Cells"]
[]
[null,"These shortcuts activate the Insert and Delete Dialog Boxes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"When you chose 'Entire' Row or Column, you insert or delete entire rows or columns."]
[null,"When you \"Shift cells\", you insert (or delete) a single cell and \"shift\" the remaining cells in that row or column to make room for the new cell."]
[]
[null,"If you select a single row (or column) before using CTRL + + or CTRL + - you only affect a single row (or column)."]
[null,"However, you can select multiple rows (or columns) to insert or delete the number of rows (or columns) that you've selected."]
[]
[null,"Practice Inserting and Deleting:"]
[]
[null,null,"<<1. Delete Row>>"]
[null,null,null,null,null,null,null,null,null,"<<2. Insert Column>>"]
[]
[null,null,"<Insert 2 Rows>"]
[null,null,"<Insert 2 Rows>"]
[]
[null,null,null,null,"A","B","C","D","E","F"]
[null,null,"<<Shift Cells Right>>","A","B","C","D","E","F"]
[]
["x","Skip the Dialog Box"]
[null,"You can skip the Dialog Box by selecting entire rows or columns before using the Insert / Delete shortcuts."]
[null,"This will insert or delete the number of rows or columns that you have selected."]
[null,null,"CTRL + SPACE","Select Entire Column"]
[null,null,"SHIFT + SPACE","Select Entire Row"]
[]
[null,null,"<<1. Select Entire Row. 2. Delete This Row>>"]
[]
[null,"Select These 3 Rows, and use CTRL + + to add 3 new rows:"]
[null,null,1]
[null,null,2]
[null,null,3]
[]
[]
[]
["2. Hiding & Grouping - Rows and Columns"]
[]
[]
[]
[]
["x","This section will introduce you to the shortcuts for hiding and grouping rows and columns."]
[null,"Hide & Unhide"]
[null,"Hide Columns",null,"CTRL + 0"]
[null,"Hide Rows",null,"CTRL + 9"]
[]
[null,"Unhide Columns",null,"CTRL + SHIFT + 0"]
[null,"Unhide Rows",null,"CTRL + SHIFT + 9"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x","Grouping & Ungrouping"]
[null,"Group Rows or Columns",null,"ALT + SHIFT + →"]
[null,"UnGroup Rows or Columns",null,"ALT + SHIFT + ←"]
[]
[null,"You might find the ALT Shortcuts are easier to remember:"]
[null,"Group Rows or Columns",null,"ALT > A > G > G"]
[null,"UnGroup Rows or Columns",null,"ALT > A > U > U"]
[null,"G for Group, U for UnGroup"]
[]
[]
[null,"<<Hide This Row>>"]
[]
[null,"<<Unhide the Row Below>>"]
[]
[]
[null,"Group"]
[null,"These"]
[null,"Rows"]
[]
[null,"UnGroup"]
[null,"These"]
[null,"Rows"]
[]
[]
[]
[]
["3. Rows, Columns, Sheets - ALT Shortcuts"]
[]
[]
[]
[]
["x","Many of the Rows, Columns, and Sheets Shortcuts are only available as ALT Shortcuts"]
[]
[null,"The Insert, Delete, and Format Ribbon Submenus:"]
[null,null,"ALT > H > I",null,"ALT > H > D",null,null,null,"ALT > H > O"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x","There are a couple of notable commands:"]
[null,"Insert Sheet",null,"ALT > H > I > S"]
[null,"Delete Sheet",null,"ALT > H > D > S"]
[]
[null,"Column Width",null,"ALT > H > O > W"]
[null,"Autofit Column Width",null,"ALT > H > O > I"]
[null,"Rename Sheet",null,"ALT > H > O > R"]
[null,"Tab Color",null,"ALT > H > O > T"]
[]
[]
[]
[]
[]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Exs. Rows,Cols,Sheets","index":14,"n_rows":95,"n_cols":29,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[]
["1. Rows, Columns, & Sheets Exercises"]
[]
[]
[]
["x",null,"Use the shortcuts learned on the previous sheets to complete these exercises."]
[]
[]
[null,null,null,"Delete These 2 Rows (SHIFT + SPACE and CTRL + -)"]
[]
[null,"Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me"]
[null,"Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,"Delete these 2 columns (CTRL + SPACE and CTRL + -)",null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[null,null,null,null,null,null,null,null,"Delete Me","Delete Me"]
[]
[]
[null,"Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here","Add Row Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[null,null,null,"Add Columns and Rows (It's easiest to select a row/column first before using CTRL + +)",null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[null,null,null,"Use AutoFit (ALT > H > O > I) to make the text in the columns to the right appear entirely in one column.  >>>>",null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Column Here"]
[]
[]
[]
[null,null,null,"Hide the following 2 rows (SHIFT + SPACE and ALT > H > O > U > R or CTRL + 9)"]
[]
[null,"Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me"]
[null,"Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me","Hide Me"]
[]
[null,null,null,"Find the hidden rows below and unhide them (SHIFT + SPACE and ALT > H > O > U > O or CTRL + 0)"]
[]
[]
[]
[]
[]
[]
[null,null,"Group the rows so you can hide/unhide them as a group."]
[null,null,"This may be the preferred method to hide rows/columns because you can easily see that rows are hidden"]
[null,null,"Data > Outline > Group (ALT > A > G > G)"]
[]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[null,"Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me","Group Me"]
[]
[]
[null,"Ungroup These Rows. Alt > A > U > U"]
[]
[null,"Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup"]
[null,"Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup"]
[null,"Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup","Ungroup"]
[]
[]
[]
[null,null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Formatting","index":15,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Format the data below to match the picture."]
[null,"If you need help, click the HELP buttons off to the side."]
[null,"1. Apply Currency Formatting for Revenues, COGS, and Profit."]
[null,"2. Change date formatting to Short Date: 3/31/2017."]
[null,"3. Autofit the column width in the cells so everything is visible."]
[null,"4. Add an underline under the Cost of Goods Sold line."]
[null,"5. Bold the column and row headers."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2012-03-31","2012-06-30","2012-09-30","2012-12-31"]
[null,null,"Revenues",50000000,55000000,60000000,58000000]
[null,null,"Cost of Goods Sold",32000000,33000000,36000000,35000000]
[null,null,"Profit",{"$f":"SUM(D37:D38)","v":82000000},{"$f":"SUM(E37:E38)","v":88000000},{"$f":"SUM(F37:F38)","v":96000000},{"$f":"SUM(G37:G38)","v":93000000}]
[]
[]
[]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]

{"sheet":"Exercise support","index":16,"n_rows":183,"n_cols":30,"rows_kept":183,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,1.1000000000000001]
[]
[null,null,"2012-03-31","2012-06-30","2012-09-30","2012-12-31",null,null,"CTRL + 1 to activate Format Menu, Use ALT, Tab, Space, Arrows to navigate.",null,null,null,null,null,null,null,null,"2017-03-31","2017-06-30","2017-09-30","2017-12-31"]
[null,"Revenues",50000000,55000000,60000000,58000000,null,null,"Also you can use CTRL + ALT + V to Paste Formats.",null,null,null,null,null,null,null,"Revenues",50000000,55000000,60000000,58000000]
[null,"Cost of Goods Sold",32000000,33000000,36000000,35000000,null,null,"ALT + H + O + I",null,null,null,null,null,null,null,"Cost of Goods Sold",32000000,33000000,36000000,35000000]
[null,"Profit",{"$f":"SUM(C6:C7)","v":82000000},{"$f":"SUM(D6:D7)","v":88000000},{"$f":"SUM(E6:E7)","v":96000000},{"$f":"SUM(F6:F7)","v":93000000},null,null,"CTRL + U",null,null,null,null,null,null,null,"Profit",{"$f":"SUM(R6:R7)","v":82000000},{"$f":"SUM(S6:S7)","v":88000000},{"$f":"SUM(T6:T7)","v":96000000},{"$f":"SUM(U6:U7)","v":93000000}]
[null,null,null,null,null,null,null,null,"CTRL + B"]
[]
[]
[null,1.2]
[]
[null,"Date","D Rate"]
[null,{"$f":"B16-1","v":-4},4.8300000000000003E-2]
[null,-3,4.8399999999999999E-2]
[null,-2,4.87E-2]
[null,-1,4.8599999999999997E-2]
[null,"00:00:00",4.8899999999999999E-2]
[null,"1900-01-01",4.8899999999999999E-2]
[null,"1900-01-02",4.8800000000000003E-2]
[]
[]
[null,2.1,null,"The macro only needs to check the values, not the formats for exercises 2.1, 2.2 and 2.3"]
[]
[]
[null,"Use Date()"]
[null,"Use Vlookup(). Make sure you have the correct TRUE/FALSE indicator to look up the exact EMP ID"]
[null,"Use Vlookup(). Make sure you have the correct TRUE/FALSE indicator to look up the approximate age range"]
[]
[]
[]
[null,null,"Salary Buckets",null,null,null,null,null,null,null,"Salary Check",null,"Tax by Bracket",null,null,null,null,null,null,null,"Total Tax",null,"Effective Rate",null,"Effective Rate"]
[null,"Salary",8925,36250,87850,183250,398350,400000,"Greater",null,"Check",null,0.1,0.15,0.25,0.28000000000000003,0.33,0.35,0.39600000000000002,null,null,null,null,null,"Check"]
[null,123318.22414999999,8925,27325,51600,35468.224149999995,0,0,0,null,true,null,892.5,4098.75,12900,9931.1027619999986,0,0,0,null,27822.352761999999,null,0.22561428332083228,null,"ok"]
[null,87017.49,8925,27325,50767.490000000005,0,0,0,0,null,true,null,892.5,4098.75,12691.872500000001,0,0,0,0,null,17683.122500000001,null,0.20321342870266657,null,"ok"]
[null,170884.068,8925,27325,51600,83034.067999999999,0,0,0,null,true,null,892.5,4098.75,12900,23249.539040000003,0,0,0,null,41140.789040000003,null,0.24075263142729025,null,"ok"]
[null,450000,8925,27325,51600,95400,215100,1650,50000,null,true,null,892.5,4098.75,12900,26712.000000000004,70983,577.5,19800,null,135963.75,null,0.30214166666666664,null,"ok"]
[null,107939.3175,8925,27325,51600,20089.317500000005,0,0,0,null,true,null,892.5,4098.75,12900,5625.0089000000016,0,0,0,null,23516.258900000001,null,0.21786555116952633,null,"ok"]
[null,20189,8925,11264,0,0,0,0,0,null,true,null,892.5,1689.6,0,0,0,0,0,null,2582.1,null,0.12789637921640498,null,"ok"]
[null,93697.822400000005,8925,27325,51600,5847.8224000000046,0,0,0,null,true,null,892.5,4098.75,12900,1637.3902720000015,0,0,0,null,19528.640272000001,null,0.20842149552453207,null,"ok"]
[null,200612.16,8925,27325,51600,95400,17362.160000000003,0,0,null,true,null,892.5,4098.75,12900,26712.000000000004,5729.5128000000013,0,0,null,50332.762800000004,null,0.25089587191524182,null,"ok"]
[null,75000,8925,27325,38750,0,0,0,0,null,true,null,892.5,4098.75,9687.5,0,0,0,0,null,14678.75,null,0.19571666666666668,null,"ok"]
[null,162835.8621,8925,27325,51600,74985.862099999998,0,0,0,null,true,null,892.5,4098.75,12900,20996.041388000001,0,0,0,null,38887.291387999998,null,0.23881281977135183,null,"ok"]
[]
[null,"These records should allow you to check if the Checks are working"]
[null,162835.8621,8925,27325,51600,74985.862099999998,0,0,0,null,true,null,892.5,4098.75,12900,20996.041388000001,70983,0,0,null,109870.291388,null,0.67473030799890366,null,"check"]
[null,75000,8925,27325,0,0,0,0,0,null,false,null,892.5,4098.75,9687.5,0,0,0,0,null,14678.75,null,0.19571666666666668,null,"ok"]
[]
[]
[null,2.2000000000000002]
[]
[null,null,"Use date(), year(), month(), day()"]
[null,null,"Use IF statements"]
[null,null,"Use IF statements"]
[null,null,"Use IF statements and date()"]
[]
[]
[]
[]
[null,"Emp ID","Birth Date",null,"Hire Date","1/1/2014 Age","1905-07-05","Proj 2014",null,null,null,null,null,null,null,null,null,null,{"$f":"(DATE(2014,1,1)-P61)/365","v":114.08219178082192},{"$f":"VLOOKUP(O61,$M$92:$S$141,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"T61*(1+VLOOKUP(S61,$T$91:$U$97,2,TRUE))","v":{"$error":"#N/A"}}]
[null,1330,"1982-05-07",null,"2027-11-03",31.676712328767124,85622.140240000008,92471.911459200011,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1939,"1963-12-24",null,"1992-11-23",50.057534246575344,69427.895688000004,72205.011515520004,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1877,"1957-02-26",null,"2010-09-21",56.884931506849313,84416.832048000011,87793.505329920008,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1751,"1976-03-08",null,"2014-11-17",37.843835616438355,108263.35440000001,114759.15566400002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1261,"1980-06-03",null,"2032-10-15",33.602739726027394,94024.758119999999,99666.243607199998,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1252,"1958-10-22",null,"2011-10-24",55.232876712328768,127851.99455200002,132966.07433408001,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1669,"1958-12-12",null,"1982-01-18",55.093150684931508,125151.96128000002,130158.03973120003,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1418,"1984-09-14",null,"2023-04-15",29.317808219178083,117110.22124800003,126479.03894784005,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1273,"1965-02-03",null,"2004-02-29",48.942465753424656,142050.09628800003,149152.60110240005,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1579,"1976-03-08",null,"2013-08-31",37.843835616438355,121293.06944000002,128570.65360640002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1889,"1971-01-04",null,"2013-05-15",43.021917808219179,121773.04888800002,127861.70133240003,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1581,"1971-07-12",null,"2010-09-18",42.504109589041093,71802.781592000014,75392.920671600019,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1364,"1959-01-17",null,"1985-05-07",54.994520547945207,80844.975064000027,84078.774066560029,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1816,"1982-05-07",null,"2014-05-24",31.676712328767124,96528.273752000008,104250.53565216002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1948,"1957-12-16",null,"2001-09-17",56.082191780821915,132319.49556800001,137612.27539072002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1295,"1955-05-06",null,"2003-07-21",58.698630136986303,68257.126960000009,70987.412038400013,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1946,"1960-03-14",null,"1998-04-06",53.838356164383562,76500.148696000004,79560.154643840011,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1212,"1957-12-16",null,"1989-09-16",56.082191780821915,123154.62744800001,128080.81254592002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1739,"1971-01-04",null,"2016-02-20",43.021917808219179,107058.046208,112410.94851840001,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1112,"1957-06-02",null,"1990-03-05",56.62191780821918,77019.431672000021,80100.208938880023,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1677,"1956-05-30",null,"1987-02-08",57.630136986301373,122326.87132800002,127219.94618112003,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1791,"1974-04-03",null,"2000-02-17",39.775342465753425,124242.02505600001,131696.54655936002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1641,"1957-06-02",null,"1999-08-27",56.62191780821918,139938.42492000002,145535.96191680004,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1500,"1985-01-24",null,"2007-03-05",28.956164383561642,69302.83900800001,77619.179688960023,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1328,"1957-07-27",null,"1980-08-06",56.471232876712328,103514.77360800002,107655.36455232002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1502,"1976-07-03",null,"2027-11-29",37.523287671232879,89023.681936000008,94365.102852160009,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1495,"1960-05-31",null,"2004-03-11",53.624657534246573,138304.35096800001,143836.52500672001,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1419,"1976-07-03",null,"2012-07-20",37.523287671232879,111265.90573600003,117941.86008016004,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1080,"1968-01-25",null,"2017-02-02",45.967123287671235,133283.02751200003,139947.17888760005,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1008,"1981-01-03",null,"2032-11-14",33.016438356164386,106682.876168,113083.84873808001,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1861,"1979-03-08",null,"2006-12-08",34.843835616438355,117245.99707200001,124280.75689632002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1792,"1981-09-24",null,"2015-12-07",32.293150684931504,119891.243608,129482.54309664002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1487,"1970-04-12",null,"2008-02-02",43.753424657534246,126235.78584000003,132547.57513200003,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1305,"1978-08-02",null,"2023-08-16",35.441095890410956,64643.584416000012,68522.199480960015,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1198,"1970-10-08",null,"2015-05-28",43.263013698630139,95090.717440000022,99845.25331200003,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1131,"1961-07-30",null,"2002-05-06",52.460273972602742,125608.12040800002,130632.44522432002,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1749,"1973-12-08",null,"1998-05-16",40.093150684931508,78451.032904000007,82373.584549200008,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2000,"1966-10-04",null,"1999-09-30",47.276712328767125,80379.287808000008,84398.252198400005,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1157,"1981-10-07",null,"2035-08-18",32.257534246575339,107491.57603200003,116090.90211456004,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1067,"1967-12-22",null,"1995-08-22",46.060273972602737,106589.97692000003,111919.47576600003,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1239,"1970-07-10",null,"2017-01-13",43.509589041095893,80312.590912,84328.220457600008,null,null,null,null,null,null,null,null,null,null,114.08219178082192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1700,"1981-10-07",null,"2023-07-16",32.257534246575339,95052.60492800003,102656.81332224004]
[]
[]
[]
[null,2.2999999999999998]
[]
[]
[null,null,"Use date(), year(), month(), day()"]
[]
[null,null,"Use IF statements"]
[null,null,"Use IF statements"]
[null,null,"Use IF statements and date()"]
[]
[]
[]
[null,"Number Retired by 1/1/2024",null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number Retired by 1/1/2024",null,null,{"$f":"COUNTIF(AD122:AD163,\"=yes\")","v":30}]
[null,"Number Active on 1/1/2024",null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number Active on 1/1/2024",null,null,{"$f":"COUNTBLANK(AD122:AD163)","v":12}]
[null,"Percentage Active",null,null,0.2857142857142857,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage Active",null,null,{"$f":"V119/(V119+V118)","v":0.2857142857142857}]
[null,"Employee ID","Birth Date",null,"Hire Date",null,null,null,null,null,"Age 60 Service","Expected Retirement Date","Retired by 1/1/2024?",null,null,null,null,null,"Employee ID","Birth Date",null,"Hire Date","Age 65 Date",null,"Age 60 Date",null,null,"Age 60 Service","Expected Retirement Date","Retired by 1/1/2024?"]
[null,1330,"1982-05-07",null,"2011-01-01","2047-05-07",null,"2042-05-07",null,null,31.367123287671234,"2042-05-07","Yes",null,null,null,null,null,1330,"1982-05-07",null,"2011-01-01",{"$f":"DATE(YEAR(T122)+65,MONTH(T122),DAY(T122))","v":"2047-05-07"},null,{"$f":"DATE(YEAR(T122)+60,MONTH(T122),DAY(T122))","v":"2042-05-07"},null,null,{"$f":"(Y122-V122)/365","v":31.367123287671234},{"$f":"IF(AB122>20,Y122,W122)","v":"2042-05-07"},{"$f":"IF(AC122>DATE(2024,1,1),\"Yes\",\"\")","v":"Yes"}]
[null,1939,"1963-12-24",null,"1996-11-09","2028-12-24",null,"2023-12-24",null,null,27.139726027397259,"2023-12-24","",null,null,null,null,null,1939,"1963-12-24",null,"1996-11-09","2028-12-24",null,"2023-12-24",null,null,27.139726027397259,"2023-12-24",""]
[null,1877,"1957-02-26",null,"1983-07-11","2022-02-26",null,"2017-02-26",null,null,33.654794520547945,"2017-02-26","",null,null,null,null,null,1877,"1957-02-26",null,"1983-07-11","2022-02-26",null,"2017-02-26",null,null,33.654794520547945,"2017-02-26",""]
[null,1751,"1976-03-08",null,"2011-01-01","2041-03-08",null,"2036-03-08",null,null,25.2,"2036-03-08","Yes",null,null,null,null,null,1751,"1976-03-08",null,"2011-01-01","2041-03-08",null,"2036-03-08",null,null,25.2,"2036-03-08","Yes"]
[null,1261,"1980-06-03",null,"2011-01-01","2045-06-03",null,"2040-06-03",null,null,29.44109589041096,"2040-06-03","Yes",null,null,null,null,null,1261,"1980-06-03",null,"2011-01-01","2045-06-03",null,"2040-06-03",null,null,29.44109589041096,"2040-06-03","Yes"]
[null,1252,"1958-10-22",null,"1993-03-05","2023-10-22",null,"2018-10-22",null,null,25.649315068493152,"2018-10-22","",null,null,null,null,null,1252,"1958-10-22",null,"1993-03-05","2023-10-22",null,"2018-10-22",null,null,25.649315068493152,"2018-10-22",""]
[null,1669,"1958-12-12",null,"1985-10-03","2023-12-12",null,"2018-12-12",null,null,33.213698630136989,"2018-12-12","",null,null,null,null,null,1669,"1958-12-12",null,"1985-10-03","2023-12-12",null,"2018-12-12",null,null,33.213698630136989,"2018-12-12",""]
[null,1418,"1984-09-14",null,"2011-01-01","2049-09-14",null,"2044-09-14",null,null,33.726027397260275,"2044-09-14","Yes",null,null,null,null,null,1418,"1984-09-14",null,"2011-01-01","2049-09-14",null,"2044-09-14",null,null,33.726027397260275,"2044-09-14","Yes"]
[null,1273,"1965-02-03",null,"2011-01-01","2030-02-03",null,"2025-02-03",null,null,14.101369863013698,"2030-02-03","Yes",null,null,null,null,null,1273,"1965-02-03",null,"2011-01-01","2030-02-03",null,"2025-02-03",null,null,14.101369863013698,"2030-02-03","Yes"]
[null,1579,"1976-03-08",null,"2009-12-24","2041-03-08",null,"2036-03-08",null,null,26.221917808219178,"2036-03-08","Yes",null,null,null,null,null,1579,"1976-03-08",null,"2009-12-24","2041-03-08",null,"2036-03-08",null,null,26.221917808219178,"2036-03-08","Yes"]
[null,1889,"1971-01-04",null,"2011-01-01","2036-01-04",null,"2031-01-04",null,null,20.021917808219179,"2031-01-04","Yes",null,null,null,null,null,1889,"1971-01-04",null,"2011-01-01","2036-01-04",null,"2031-01-04",null,null,20.021917808219179,"2031-01-04","Yes"]
[null,1581,"1971-07-12",null,"2011-01-01","2036-07-12",null,"2031-07-12",null,null,20.539726027397261,"2031-07-12","Yes",null,null,null,null,null,1581,"1971-07-12",null,"2011-01-01","2036-07-12",null,"2031-07-12",null,null,20.539726027397261,"2031-07-12","Yes"]
[null,1364,"1959-01-17",null,"1984-03-30","2024-01-17",null,"2019-01-17",null,null,34.824657534246576,"2019-01-17","",null,null,null,null,null,1364,"1959-01-17",null,"1984-03-30","2024-01-17",null,"2019-01-17",null,null,34.824657534246576,"2019-01-17",""]
[null,1816,"1982-05-07",null,"2011-01-01","2047-05-07",null,"2042-05-07",null,null,31.367123287671234,"2042-05-07","Yes",null,null,null,null,null,1816,"1982-05-07",null,"2011-01-01","2047-05-07",null,"2042-05-07",null,null,31.367123287671234,"2042-05-07","Yes"]
[null,1948,"1957-12-16",null,"2006-11-06","2022-12-16",null,"2017-12-16",null,null,11.117808219178082,"2022-12-16","",null,null,null,null,null,1948,"1957-12-16",null,"2006-11-06","2022-12-16",null,"2017-12-16",null,null,11.117808219178082,"2022-12-16",""]
[null,1295,"1955-05-06",null,"2005-04-23","2020-05-06",null,"2015-05-06",null,null,10.04109589041096,"2020-05-06","",null,null,null,null,null,1295,"1955-05-06",null,"2005-04-23","2020-05-06",null,"2015-05-06",null,null,10.04109589041096,"2020-05-06",""]
[null,1946,"1960-03-14",null,"2011-01-01","2025-03-14",null,"2020-03-14",null,null,9.205479452054794,"2025-03-14","Yes",null,null,null,null,null,1946,"1960-03-14",null,"2011-01-01","2025-03-14",null,"2020-03-14",null,null,9.205479452054794,"2025-03-14","Yes"]
[null,1212,"1957-12-16",null,"2003-06-25","2022-12-16",null,"2017-12-16",null,null,14.487671232876712,"2022-12-16","",null,null,null,null,null,1212,"1957-12-16",null,"2003-06-25","2022-12-16",null,"2017-12-16",null,null,14.487671232876712,"2022-12-16",""]
[null,1739,"1971-01-04",null,"2011-01-01","2036-01-04",null,"2031-01-04",null,null,20.021917808219179,"2031-01-04","Yes",null,null,null,null,null,1739,"1971-01-04",null,"2011-01-01","2036-01-04",null,"2031-01-04",null,null,20.021917808219179,"2031-01-04","Yes"]
[null,1112,"1957-06-02",null,"1997-05-09","2022-06-02",null,"2017-06-02",null,null,20.079452054794519,"2017-06-02","",null,null,null,null,null,1112,"1957-06-02",null,"1997-05-09","2022-06-02",null,"2017-06-02",null,null,20.079452054794519,"2017-06-02",""]
[null,1677,"1956-05-30",null,"1980-04-26","2021-05-30",null,"2016-05-30",null,null,36.11780821917808,"2016-05-30","",null,null,null,null,null,1677,"1956-05-30",null,"1980-04-26","2021-05-30",null,"2016-05-30",null,null,36.11780821917808,"2016-05-30",""]
[null,1791,"1974-04-03",null,"2003-12-21","2039-04-03",null,"2034-04-03",null,null,30.304109589041097,"2034-04-03","Yes",null,null,null,null,null,1791,"1974-04-03",null,"2003-12-21","2039-04-03",null,"2034-04-03",null,null,30.304109589041097,"2034-04-03","Yes"]
[null,1641,"1957-06-02",null,"1999-03-31","2022-06-02",null,"2017-06-02",null,null,18.186301369863013,"2022-06-02","",null,null,null,null,null,1641,"1957-06-02",null,"1999-03-31","2022-06-02",null,"2017-06-02",null,null,18.186301369863013,"2022-06-02",""]
[null,1500,"1985-01-24",null,"2011-01-01","2050-01-24",null,"2045-01-24",null,null,34.087671232876716,"2045-01-24","Yes",null,null,null,null,null,1500,"1985-01-24",null,"2011-01-01","2050-01-24",null,"2045-01-24",null,null,34.087671232876716,"2045-01-24","Yes"]
[null,1328,"1957-07-27",null,"2006-06-10","2022-07-27",null,"2017-07-27",null,null,11.136986301369863,"2022-07-27","",null,null,null,null,null,1328,"1957-07-27",null,"2006-06-10","2022-07-27",null,"2017-07-27",null,null,11.136986301369863,"2022-07-27",""]
[null,1502,"1976-07-03",null,"2011-01-01","2041-07-03",null,"2036-07-03",null,null,25.520547945205479,"2036-07-03","Yes",null,null,null,null,null,1502,"1976-07-03",null,"2011-01-01","2041-07-03",null,"2036-07-03",null,null,25.520547945205479,"2036-07-03","Yes"]
[null,1495,"1960-05-31",null,"2007-10-19","2025-05-31",null,"2020-05-31",null,null,12.624657534246575,"2025-05-31","Yes",null,null,null,null,null,1495,"1960-05-31",null,"2007-10-19","2025-05-31",null,"2020-05-31",null,null,12.624657534246575,"2025-05-31","Yes"]
[null,1419,"1976-07-03",null,"2011-01-01","2041-07-03",null,"2036-07-03",null,null,25.520547945205479,"2036-07-03","Yes",null,null,null,null,null,1419,"1976-07-03",null,"2011-01-01","2041-07-03",null,"2036-07-03",null,null,25.520547945205479,"2036-07-03","Yes"]
[null,1080,"1968-01-25",null,"2009-11-29","2033-01-25",null,"2028-01-25",null,null,18.167123287671235,"2033-01-25","Yes",null,null,null,null,null,1080,"1968-01-25",null,"2009-11-29","2033-01-25",null,"2028-01-25",null,null,18.167123287671235,"2033-01-25","Yes"]
[null,1008,"1981-01-03",null,"2010-08-10","2046-01-03",null,"2041-01-03",null,null,30.421917808219177,"2041-01-03","Yes",null,null,null,null,null,1008,"1981-01-03",null,"2010-08-10","2046-01-03",null,"2041-01-03",null,null,30.421917808219177,"2041-01-03","Yes"]
[null,1861,"1979-03-08",null,"2011-01-01","2044-03-08",null,"2039-03-08",null,null,28.2,"2039-03-08","Yes",null,null,null,null,null,1861,"1979-03-08",null,"2011-01-01","2044-03-08",null,"2039-03-08",null,null,28.2,"2039-03-08","Yes"]
[null,1792,"1981-09-24",null,"2011-01-01","2046-09-24",null,"2041-09-24",null,null,30.75068493150685,"2041-09-24","Yes",null,null,null,null,null,1792,"1981-09-24",null,"2011-01-01","2046-09-24",null,"2041-09-24",null,null,30.75068493150685,"2041-09-24","Yes"]
[null,1487,"1970-04-12",null,"2011-01-01","2035-04-12",null,"2030-04-12",null,null,19.290410958904111,"2035-04-12","Yes",null,null,null,null,null,1487,"1970-04-12",null,"2011-01-01","2035-04-12",null,"2030-04-12",null,null,19.290410958904111,"2035-04-12","Yes"]
[null,1305,"1978-08-02",null,"2002-09-22","2043-08-02",null,"2038-08-02",null,null,35.884931506849313,"2038-08-02","Yes",null,null,null,null,null,1305,"1978-08-02",null,"2002-09-22","2043-08-02",null,"2038-08-02",null,null,35.884931506849313,"2038-08-02","Yes"]
[null,1198,"1970-10-08",null,"2008-02-10","2035-10-08",null,"2030-10-08",null,null,22.673972602739727,"2030-10-08","Yes",null,null,null,null,null,1198,"1970-10-08",null,"2008-02-10","2035-10-08",null,"2030-10-08",null,null,22.673972602739727,"2030-10-08","Yes"]
[null,1131,"1961-07-30",null,"2003-01-15","2026-07-30",null,"2021-07-30",null,null,18.550684931506851,"2026-07-30","Yes",null,null,null,null,null,1131,"1961-07-30",null,"2003-01-15","2026-07-30",null,"2021-07-30",null,null,18.550684931506851,"2026-07-30","Yes"]
[null,1749,"1973-12-08",null,"2000-10-21","2038-12-08",null,"2033-12-08",null,null,33.153424657534245,"2033-12-08","Yes",null,null,null,null,null,1749,"1973-12-08",null,"2000-10-21","2038-12-08",null,"2033-12-08",null,null,33.153424657534245,"2033-12-08","Yes"]
[null,2000,"1966-10-04",null,"2004-09-09","2031-10-04",null,"2026-10-04",null,null,22.082191780821919,"2026-10-04","Yes",null,null,null,null,null,2000,"1966-10-04",null,"2004-09-09","2031-10-04",null,"2026-10-04",null,null,22.082191780821919,"2026-10-04","Yes"]
[null,1157,"1981-10-07",null,"2011-01-01","2046-10-07",null,"2041-10-07",null,null,30.786301369863015,"2041-10-07","Yes",null,null,null,null,null,1157,"1981-10-07",null,"2011-01-01","2046-10-07",null,"2041-10-07",null,null,30.786301369863015,"2041-10-07","Yes"]
[null,1067,"1967-12-22",null,"2011-01-01","2032-12-22",null,"2027-12-22",null,null,16.983561643835618,"2032-12-22","Yes",null,null,null,null,null,1067,"1967-12-22",null,"2011-01-01","2032-12-22",null,"2027-12-22",null,null,16.983561643835618,"2032-12-22","Yes"]
[null,1239,"1970-07-10",null,"1998-01-13","2035-07-10",null,"2030-07-10",null,null,32.509589041095893,"2030-07-10","Yes",null,null,null,null,null,1239,"1970-07-10",null,"1998-01-13","2035-07-10",null,"2030-07-10",null,null,32.509589041095893,"2030-07-10","Yes"]
[null,1700,"1981-10-07",null,"2011-01-01","2046-10-07",null,"2041-10-07",null,null,30.786301369863015,"2041-10-07","Yes",null,null,null,null,null,1700,"1981-10-07",null,"2011-01-01","2046-10-07",null,"2041-10-07",null,null,30.786301369863015,"2041-10-07","Yes"]
[]
[]
[]
[]
[]
[null,null,"Navigation Exercise Support"]
[]
[null,null,"Select Draw Bridge from Drop Down",null,null,"[Nav_PenaltyCount]",null,61]
[null,null,"Draw Bridge",null,null,"[Nav_StartTime]"]
[null,null,"Swim",null,null,"[Nav_EndTime]"]
[null,null,"Storm Gates",null,null,"[Nav_Step2]",null,false]
[null,null,"Turn Back",null,null,"[Nav_Step3]",null,false]
[null,null,null,null,null,"[Nav_Step4]",null,false]
[null,null,null,null,null,"[Nav_Step5]",null,false]
[null,null,null,null,null,"[Nav_Step6]",null,false]
[null,null,null,null,null,"[Nav_Step7]",null,false]
[null,null,null,null,null,"[Nav_Step8]",null,false]
[null,null,null,null,null,"[Nav_Step9]",null,false]
[null,null,null,null,null,"[Nav_Step10]",null,false]
[null,null,null,null,null,"[Nav_IsStarted]",null,true]

{"sheet":"Formula Shortcuts","index":17,"n_rows":286,"n_cols":37,"rows_kept":286,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Formula Creating & Editing"]
[]
[]
[]
["x","F2 to Edit Existing Cell Contents in Cell Edit Mode"]
[null,"You probably know that you can simply select a cell and start typing to add content to that cell."]
[null,"If the cell is blank, that's exactly what you want, but what if the cell has existing content and you want to edit (not replace) the existing content?"]
[null,"Use the F2 key to enter Cell Edit Mode. From Cell Edit Mode you can edit the existing cell contents."]
[]
[null,"Use F2 to edit the Formula in F16 to multiply 3*5 instead of adding 3+5."]
[]
[null,null,null,null,{"$f":"G16+I16","v":8},null,3,null,5]
[]
["x","Cursor Appears Within Cell, Not Formula Bar"]
[null,"Notice that the text cursor appears within the cell instead of above in the formula bar."]
[]
[]
[]
["x","Navigate Within Cell Edit Mode"]
[null,"When in Cell Edit Mode you can use Arrows, CTRL, and SHIFT to move to and/or select portions of the cell content, similar to navigating and selecting cells."]
[null,"Think of each character within a cell as a mini-cell itself. You use the Arrows to navigate between characters, CTRL to jump quickly, SHIFT to select multiple characters, etc.."]
[null,"Remember HOME and END? HOME will bring you to the beginning character in a line and END will bring you to the last character."]
[]
["x","Tap F2 Again to Enter Cell Enter Mode"]
[null,"When in Cell Edit Mode, tapping F2 again will switch you to Cell Enter Mode (you can toggle back and forth)."]
[]
["x","In Cell Enter Mode Arrow Keys No Longer Navigate Within the Cell Content, but Instead Add Cell References"]
[null,"In Cell Enter Mode, using the Arrow Keys will add a cell reference just like when you first enter a formula."]
[null,"If your cursor is within an existing cell reference, then the Arrow Keys will change that cell reference."]
[null,"If your cursor is not in an existing cell reference, then the Arrow Keys will add a new cell reference."]
[]
[]
[null,"In the bottom left of the screen you can see if you're in \"enter\" or \"edit\" mode. "]
[]
[]
[]
[]
["x","Use F2 to Quickly Visualize Cell References"]
[null,"F2 also allows you to quickly \"audit\" your formula. When you press F2, colored borders will appear around the cells referenced by the current cell."]
[]
[]
[]
["x","Quick Sum"]
[null,"To sum an array of numbers you use the Sum function: =sum(a1:a5)"]
[]
[null,"Instead of typing out the Sum function =sum(...) you can use ALT + =  (don't type the +)."]
[null,"ALT + = will automatically fill in the sum function with its best guess of the area you want to sum."]
[null,"Try it below:"]
[null,null,5,null,1,3,5]
[null,null,19,null,7,9,11]
[null,null,12,null,13,15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C56=36,G56=81),\"Complete!\",\"\")","v":""}]
[]
[null,"Remember: if the sum array is not correct, simply use the Arrows, CTRL, and SHIFT to adjust the array."]
[]
["x","Lock Cell References"]
[null,"As we mentioned in the earlier lesson on Copying and Pasting, when you Copy & Paste formulas the cell references move proportionally."]
[null,"This means that if you Copy a formula and Paste it two cells to the right, the column references will move two to the right (i.e. C to E)."]
[]
[null,null,2,null,5]
[null,null,99,null,3]
[null,null,77,null,55]
[null,null,32,null,11]
[null,null,{"$f":"SUM(C64:C67)","v":210},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E68=SUM(E64:E67),\"Complete!\",\"\")","v":""}]
[null,null,"^Copy (CTRL + C) and Paste (CTRL + V) this formula to see the references move"]
[]
[null,"Many times this is exactly what you want, but sometimes you want the cell reference to remain unchanged.  "]
[null,"You can freeze (also called \"anchor\") cell references by adding $ signs to the references."]
[null,null,"=D47","Cell reference is not frozen"]
[null,null,"=$D47","Column reference is frozen, but row reference is not"]
[null,null,"=D$47","Row reference is frozen, but column is not"]
[null,null,"=$D$47","Both row and column references are frozen."]
[]
[null,"Actually typing in the $ signs can be a real pain. Instead, with your cursor within the cell reference you want to change, press F4."]
[null,"F4 will cycle through absolute / relative references."]
[]
[null,"Practice: Use F4 to lock the cell references in the cell below, so when you copy and paste the formula the cell references don't move."]
[null,null,3]
[null,null,8]
[]
[null,null,null,{"$f":"C82*C83","v":24}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA87=TRUE,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,24,{"$f":"F87=Z87","v":false}]
[]
[]
[null,"Using F4, create a single formula in cell C94 that, when copied, will create a multiplication table:"]
[]
[null,null,null,null,null,null,"Multiplication Table"]
[null,null,1,{"$f":"C93+1","v":2},3,4,5,6,7,8,9]
[null,1]
[null,{"$f":"B94+1","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z102=SUM(C94:K102),\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,2025]
[]
[]
["x","Copy Cell Above"]
[null,"CTRL + ' will copy the contents of the cell above into the selected cell:"]
[null,"Try it by selecting C109 and using CTRL + ':"]
[null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z109=SUM(C109),\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,13]
[]
[null,"Now try selecting C113:D114 and use CTRL + '"]
[null,null,13,14]
[]
[]
[]
[null,"Notice that above only the first selected cell is updated with the formula above. D113 and row 114 remain unchanged."]
[null,"CTRL + ' is fairly limited. Instead try using CTRL + D and CTRL + R ..."]
[]
["x","Fill"]
[null,"The Fill Down (CTRL + D) and Fill Right (CTRL + R) shortcuts allow you to enter a formula in one cell and \"Fill\" the formula in other cells. "]
[null,"These are easy to remember: D for Down and R for Right and easy to use:"]
[null,"Simply select the cell containing the formula you wish to copy, along with all the cells you wish to copy the formula into."]
[]
[null,"Try it by selecting cells D127:E137 and pressing CTRL + D:"]
[]
[null,null,"ID","Product","Price",null,null,null,null,null,null,"ID","Product","Price"]
[null,null,1,{"$f":"VLOOKUP($C127,$L$127:$N$137,2,FALSE)","v":"Hats"},{"$f":"VLOOKUP($C127,$L$127:$N$137,3,FALSE)","v":15},null,null,null,null,null,null,5,"Socks",8]
[null,null,2,null,null,null,null,null,null,null,null,2,"Shoes",20,null,null,null,null,null,null,null,null,null,null,null,null,"Shoes",20,{"$f":"D128=AA128","v":false},{"$f":"E128=AB128","v":false}]
[null,null,3,null,null,null,null,null,null,null,null,8,"Shorts",8,null,null,null,null,null,null,null,null,null,null,null,null,"Pants",10,{"$f":"D129=AA129","v":false},false]
[null,null,4,null,null,null,null,null,null,null,null,3,"Pants",10,null,null,null,null,null,null,null,null,null,null,null,null,"Parkas",350,false,false]
[null,null,5,null,null,null,null,null,null,null,null,7,"Shirts",7,null,null,null,null,null,null,null,null,null,null,null,null,"Socks",8,false,false]
[null,null,6,null,null,null,null,null,null,null,null,1,"Hats",15,null,null,null,null,null,null,null,null,null,null,null,null,"Raincoats",100,false,false]
[null,null,7,null,null,null,null,null,null,null,null,11,"Gloves",4,null,null,null,null,null,null,null,null,null,null,null,null,"Shirts",7,false,false]
[null,null,8,null,null,null,null,null,null,null,null,6,"Raincoats",100,null,null,null,null,null,null,null,null,null,null,null,null,"Shorts",8,false,false]
[null,null,9,null,null,null,null,null,null,null,null,10,"Ski Jackets",300,null,null,null,null,null,null,null,null,null,null,null,null,"Sunglasses",11,false,false]
[null,null,10,null,null,null,null,null,null,null,null,4,"Parkas",350,null,null,null,null,null,null,null,null,null,null,null,null,"Ski Jackets",300,false,false]
[null,null,11,null,null,null,null,null,null,null,null,9,"Sunglasses",11,null,{"$f":"IF(COUNTIF(AC128:AD137,FALSE)=0,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Gloves",4,false,false]
[]
[null,"Now try Filling Right CTRL + R"]
[]
[null,"Jan","Feb","Mar","April","May","June","July","Aug","Sep","Oct","Nov","Dec"]
[null,{"$f":"1+A142","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B142:M142)=AA142,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,78]
[]
[]
[]
["2. Formula Auditing"]
[]
[]
[]
[]
["x","Nested Formula Result"]
[null,"When you are working with complex nested formulas you may wish to check the result of parts of the Excel formula."]
[null,"You can select individual pieces of a formula and press the F9 key to calculate the result of those pieces."]
[null,"The selected part of the formula is replaced by the result of that piece."]
[null,"Try this in the example below:"]
[]
[null,"Use F2 to edit the Vlookup formula in cell D160. Highlight C163+D163 and press F9."]
[null,"Hint: Use F2 to Edit the cell and the arrows + SHIFT to make your selection before pressing F9."]
[]
[null,null,{"$f":"VLOOKUP(C163+D163,N161:O162,2,FALSE)","v":"Steve Scott"},null,null,null,null,null,null,null,null,null,null,"Emp ID","Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Jack Jones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Steve Scott"]
[null,null,4,3,1]
[]
[null,"Be careful using F9! If you use F9 and save/exit the cell (by pressing ENTER) your changes will be saved."]
[null,"You probably don't want this. If you want use CTRL + Z to undo this."]
[null,"Alternatively, while still editing the cell, press F9 again to cycle back to display cell references. Or you can use the ESC key to leave the cell without saving."]
[]
["x","Formula Precedents and Dependents."]
[null,"Formula Precedents are all the cells that \"go into\" the current cell."]
[null,"Formula Dependents refers to all the cells that \"rely on\" the current cell."]
[]
[null,null,"Cell 1",null,null,null,{"$f":"SUBSTITUTE(C173,\"1\",\"2\")","v":"Cell 2"},"=SUBSTITUTE(C173,\"1\",\"2\")"]
[null,null,"^ Cell 1 is a precedent to Cell 2",null,null,null,"^ Cell 2 is a dependent to Cell 1"]
[]
[]
["x","\"Go To\" Precedents and Trace Dependents (CTRL + [ or ])"]
[null,"\"Go To\" Precedents/Dependents selects all the cells that go into/rely on the selected cell. "]
[null,"If there is only one cell input, then Excel will jump to that cell."]
[]
[]
[]
[]
[]
["x","Trace Precedents/Dependents (ALT > M > P or D)"]
[null,"Trace behaves similar to Go To except \"tracing\" doesn't select the cells, it generates arrows to them."]
[null,"If you are reviewing a cell and you're not sure what the cell's purpose is, the best thing to do is Trace Dependents and you can"]
[null,"see where the cell is referenced."]
[]
[]
[]
[]
[]
["x","Try Selecting (CTRL + [ or ]) & Tracing (ALT > M > P or D) Precedents / Dependents in the cells below"]
[null,"Remove the Trace Arrows using ALT > M > A"]
[]
[null,null,"Year",2012,null,null,null,"Year","Sales"]
[null,null,"Sales",{"$f":"VLOOKUP(D197,H198:I203,2,FALSE)","v":144617},null,null,null,2007,100326]
[null,null,null,null,null,null,null,2008,154419]
[null,null,null,null,null,null,null,2009,152094]
[null,null,null,null,null,null,null,2010,117870]
[null,null,null,null,null,null,null,2011,147971]
[null,null,null,null,null,null,null,2012,144617]
[]
["x","Formula View"]
[null,"Use CTRL + ~ (~ is the key to the left of the 1 key in upper left of keyboard) or ALT > M > H to switch to Formula View."]
[null,"Formula View displays each cell's actual formula instead of the result of the formula."]
[null,"When you select a cell with a formula in Formula View mode, the formula inputs are highlighted:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Try using Formula View Mode now. Click on the Sales in cell D198 and press CTRL + ~."]
[]
[null,"Some people use this view to audit their formulas. They may even print the formula view out on paper to review the logic."]
[]
[]
[]
["3. Undo"]
[]
[]
[]
[]
["x","Undo"]
[null,"Use CTRL + Z reverses your last action."]
[null,"Make a mistake? Simply hit CTRL + Z."]
[]
[null,"CTRL + Y will undo your undo."]
[]
[]
[]
["4. Formula Exercise"]
[]
[]
[]
[]
["x","The formula below produces an error. One of the inputs is bad."]
[null,"1. Using the F2 and F9 technique, find the bad input reference and remove it."]
[null,"2. Then \"lock\" the discount rate cell reference so you can copy the formula down."]
[null,"3. Copy the formula down using the techniques discussed above."]
[]
[null,null,null,"5-Year Adj."]
[null,null,"Employee ID","Ave. Salary",null,null,null,"Discount Rate"]
[null,null,816,{"$f":"(AG250++AH250+AI250+AJ250+AK250)/COUNT(AG250:AK250)*(1+H249)^COUNT(AG250:AK250)","v":{"$error":"#N/A"}},null,null,null,0.03,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84153.103842000026,{"$error":"#N/A"},96346.888588705842,103091.17078991525,110307.55274520932]
[null,null,780,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59573.384761482521,{"$error":"#N/A"},68205.568213421342,72979.957988360838,78088.555047546106]
[null,null,325,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137005.46070996815,{"$error":"#N/A"},156857.55196684255,167837.58060452156,179586.21124683807]
[null,null,349,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98196.854321499108,{"$error":"#N/A"},112425.57851268434,120295.36900857225,128716.04483917232]
[null,null,742,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97415.633007499229,{"$error":"#N/A"},111531.15823028587,119338.33930640589,127692.02305785431]
[null,null,226,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126706.52335143802,{"$error":"#N/A"},145066.29858506142,155220.93948601573,166086.40525003686]
[null,null,715,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110564.55548281173,{"$error":"#N/A"},126585.35957227116,135446.33474233016,144927.57817429327]
[null,null,281,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64729.164923535711,{"$error":"#N/A"},74108.420920956036,79296.010385422967,84846.731112402573]
[null,null,732,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136738.97588113515,{"$error":"#N/A"},156552.45348631166,167511.12523035347,179236.90399647821]
[null,null,129,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116291.17419925983,{"$error":"#N/A"},133141.76534073259,142461.68891458388,152434.00713860476]
[null,null,337,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101808.42502805164,{"$error":"#N/A"},116560.46581461634,124719.69842163949,133450.07731115425]
[null,null,440,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101421.32075037844,{"$error":"#N/A"},116117.27012710828,124245.47903600587,132942.66256852628]
[null,null,211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99286.637016253022,{"$error":"#N/A"},113673.27071990811,121630.39967030167,130144.5276472228]
[null,null,845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91829.269464121113,{"$error":"#N/A"},105135.33060947228,112494.80375213534,120369.44001478482]
[null,null,697,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62454.226016340326,{"$error":"#N/A"},71503.843366108049,76509.11240173562,81864.750269857119]
[null,null,843,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112634.72183732495,{"$error":"#N/A"},128955.49303155334,137982.37754376209,147641.14397182546]
[null,null,531,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72089.756406249304,{"$error":"#N/A"},82535.562109514838,88313.051457180889,94494.965059183553]
[null,null,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D267=AA267,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,104875.53312590234,null,null,null,null,null,59682.783796477102,{"$error":"#N/A"},68330.819168586648,73113.976510387714,78231.954866114858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89623.055591730023,{"$error":"#N/A"},102609.43634697171,109792.09689125973,117477.54367364792]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Workbook Nav","index":18,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Workbook Navigation & Viewing"]
[]
[]
[]
[]
[null,"These shortcuts are useful for navigating within and between workbooks."]
[null,"The first set of shortcuts are the most useful and you definitely should incorporate these."]
[null,"Try each of the other shortcuts at least once so you understand what they do."]
[]
["x","Navigation"]
[null,"Move to next/previous worksheet",null,null,null,"CTRL + Page Down/Up"]
[null,"Next Workbook",null,null,null,"CTRL + TAB (SHIFT for reverse)"]
[null,"Next Application",null,null,null,"ALT + TAB (SHIFT for reverse)"]
[]
[null,"Activate Control Box",null,null,null,"ALT + SPACE"]
[null,"New Worksheet",null,null,null,"ALT + SHIFT + F1"]
[]
[]
[null,"Viewing"]
[null,"Command",null,null,null,"CTRL + …"]
[null,"Close Window",null,null,null,"F4"]
[null,"Restore Window Size",null,null,null,"F5"]
[null,"Next Window",null,null,null,"F6"]
[null,"Move Window",null,null,null,"F7"]
[null,"Resize Window",null,null,null,"F8"]
[null,"Minimize Workbook",null,null,null,"F9"]
[null,"Maximize/Restore Window",null,null,null,"F10"]
[]
[null,"Command",null,null,null,"… + F6"]
[null,"Next Pane",null,null,null,"Alone"]
[null,"Previous Pane",null,null,null,"SHIFT"]
[null,"Next Window",null,null,null,"CTRL"]
[null,"Previous Window",null,null,null,"CTRL + SHIFT"]
[]
[null,"Other Viewing"]
[null,"Formula View Mode",null,null,null,"CTRL + ~"]
[null,"Hide Ribbon",null,null,null,"CTRL + F1"]
[null,"Expand or Collapse Formula Bar",null,null,null,"CTRL + SHIFT + U"]
[]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Data Tools","index":19,"n_rows":145,"n_cols":27,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
["1. Find & Go To"]
[]
[]
[]
[]
["x","Find and Replace (CTRL + F) is a massively powerful search tool. "]
[]
[null,"This often overlooked tool that allows you to search a workbook, worksheet, or selection of a worksheet for specific text or numbers."]
[null,"The Replace feature behaves similarly, but actually replaces the searched value with another value."]
[]
[null,"You can activate the Find and Replace Dialog Box by typing CTRL + F or CTRL + H."]
[null,"CTRL + F will open up the Find section and CTRL + H will open up the Replace section."]
[null,"CTRL + F is much more intuitive (F for Find) so you may want to use that shortcut exclusively and then simply navigate to the Replace section."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x","Exercise 1"]
[null,"Open the Find Dialog Box (CTRL + F)"]
[null,"Type \"overlooked\" and hit ENTER."]
[]
[null,"Remember the Menu Navigation Shortcuts?"]
[null,"You can select a Menu Option by holding ALT and tapping it's corresponding underlined letter."]
[]
[null,"Use CTRL + F to activate the Find Dialog Box and use ALT + T to show the detailed Options."]
[null,"From here you can select the following options:"]
[null,null,"Toggle between searching entire workbook or worksheet"]
[null,null,"Look in formula inputs (whatever is typed into a cell) or look at formula results"]
[null,null,"Case-sensitive"]
[null,null,"Match entire cell contents"]
[]
["x","Exercise 2"]
[null,"Now try an example with Find and Replace"]
[null,"The best time to use Replace (CTRL + H) is to replace a specific piece of text that is scattered throughout the workbook."]
[]
[null,"Use Replace to change the reference in the formulas below from Salaryv1 to Salaryv2.  You can see how much time this would save if there were numerous references throughout the workbook."]
[]
[null,null,"Emp ID","Salary",null,null,null,null,null,"Emp ID","Salary1",null,"Emp ID","Salary2"]
[null,null,567,{"$f":"VLOOKUP(C56,Salaryv1,2,FALSE)","v":67508},null,null,null,null,null,567,67508,null,567,67349,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N56=D56","v":false}]
[null,null,453,{"$f":"VLOOKUP(C57,Salaryv1,2,FALSE)","v":58412},null,null,null,null,null,453,58412,null,453,69028,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N57=D57","v":false}]
[null,null,940,{"$f":"VLOOKUP(C58,Salaryv1,2,FALSE)","v":74494},null,null,null,null,null,940,74494,null,940,63923,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N58=D58","v":false}]
[null,null,320,{"$f":"VLOOKUP(C59,Salaryv1,2,FALSE)","v":72761},null,null,null,null,null,320,72761,null,320,62322,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N59=D59","v":false}]
[null,null,1100,{"$f":"VLOOKUP(C60,Salaryv1,2,FALSE)","v":56518},null,null,null,null,null,1100,56518,null,1100,73443,null,null,null,{"$f":"IF(COUNTIF(AA56:AA60,\"=false\")=0,\"Complete!\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"N60=D60","v":false}]
[]
[]
["x","The Go To Dialog Box (CTRL + G) is another useful search tool."]
[]
[null,"From here you can jump to \"named ranges\" in the workbook."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Use ALT + S to open the Go To Special Dialog Box"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"From here you can select all cells with certain characteristics (errors, blanks, text, etc.)"]
[]
[]
[]
["2. Data Tools"]
[]
[]
["x"]
[]
[null,"This is the last section where you will be introduced to new shortcuts."]
[null,"The first shortcuts have to do with manipulating and presenting data. We won't discuss what these features actually do, but our                       dives into these in great detail."]
[]
[null,"The second shortcuts are miscellaneous shortcuts that don't fit in any other section."]
[]
["x","Data Tools"]
[null,"Practice these shortcuts on the data set to the right."]
[]
[null,"Filter",null,null,null,"CTRL + SHIFT + L",null,"Emp ID","Age","Service"]
[null,"Table",null,null,null,"CTRL + T",null,89490,35,12]
[null,"Insert Chart",null,null,null,"ALT + F1",null,101127,43,7]
[null,"Create Pivot Chart",null,null,null,"F11",null,83995,43,3]
[null,null,null,null,null,null,null,83493,53,17]
[null,null,null,null,null,null,null,108003,65,14]
["x","Misc. Tools",null,null,null,null,null,103383,75,1]
[null,"Open Visual Basic (VBA) Editor",null,null,null,"ALT + F11",null,84545,54,0]
[null,"Open Macro Dialog Box",null,null,null,"ALT + F8",null,94262,43,4]
[null,"Open Name Manager Dialog Box",null,null,null,"CTRL + F3",null,81168,63,6]
[]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Keyboard Layout & Troubleshoot","index":20,"n_rows":90,"n_cols":28,"rows_kept":90,"cut":false,"hidden":false,"merged":[[41,5,41,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[]
[]
["x"]
[]
[null,"Keys","Shortcut Examples"]
[null,"CTRL (Control)","CTRL Shortcut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3]
[null,"ALT","ALT Shortcut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5]
[null,"SHIFT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7]
[null,"TAB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Enter / Return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,"Space",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,"~",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,"!, @, #, $, %, ^, *, (, )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,"_",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,"+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,21]
[null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,22]
[null,"Delete",null,null,null,null,null,null,null,null,null,"Source: https://commons.wikimedia.org/wiki/File:ANSI_Keyboard_Layout_Diagram_with_Form_Factor.svg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"End",null,null,null,null,null,null,null,null,null,"Author: Rumudiez",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,"Page Up / Down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,"Home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,"F2, F4, and all other F Keys",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[]
[]
[]
["x","Your keyboard layout may appear quite a bit different. This is especially the case on laptop keyboards where space is at a premium."]
[null,"Poor keyboard layout can really cut into your ability to use keyboard shortcuts and work efficiently."]
[]
[null,"Here are a few things to look out for:"]
[null,"1. A fn key directly to the left of the CTRL key on the bottom-left of the keyboard."]
[]
[]
[]
[]
[]
[null,"2. Small or unusually shaped arrow keys."]
[null,"3. Out of place Page Up / Page Down, End, or Home keys."]
[]
[null,"If your keyboard has any of these layout flaws (especially #1) you should consider buying a new keyboard."]
[null,"We've included a keyboard buying guide on our website:",null,null,null,"http://www.automateexcel.com/external-keyboard-for-laptop/?utm_source=shortcuttrainer&utm_medium=link&utm_term=shortcut&utm_content=shortcut&utm_campaign=keyboardguide"]
[]
[]
["2. Troubleshooting"]
[]
[]
[]
[]
[null,"fn Mode"]
[null,"Many keyboards have functions associated with the F1-F12 keys:"]
[null,"Examples:"]
[null,"Adjust Brightness"]
[null,"Adjust Volume"]
[null,"Turn Wireless On / Off"]
[]
[null,"Typically, to activate these functions you hold down the fn key, while pressing the appropriate function key."]
[null,"If the fn key is not pressed then the keys activate the F1-F12 commands instead."]
[]
[null,"As an aspriring shortcut guru, that's exactly what you want. Unfortunately, sometimes the configuration is reversed."]
[null,"You will need to hold down the fn key to access the F1-F12 commands."]
[]
[null,"Fortunately, there is an easy fix:"]
[]
[null,"1. Restart your computer."]
[null,"2. Press the F10 key to open the Bios setup window (you must do this before the Windows screen appears)."]
[null,"3. Navigate to \"System Configuration\""]
[null,"4. Find a option labeled \"Action Keys Mode\" or something similar."]
[null,"5. Select the desired mode."]
[null,"6. Press F10 to save your change and finish restarting your computer."]
[]
[null,"Note: Each laptop is unique and this method may not work for all laptops. If it doesn't work, we recommend googling \"<laptop make & model> toggle fn key\"."]
[]
[]
[]
[null,"Use CTRL+ Page Down to jump to the next worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["x"]

{"sheet":"Results","index":21,"n_rows":36,"n_cols":32,"rows_kept":36,"cut":false,"hidden":true,"merged":[[8,2,10,2],[8,4,10,4]]}
[null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE DOWN = Move to Next Worksheet"]
[null,null,null,null,null,null,null,null,null,null,"CTRL + PAGE UP = Move to Previous Worksheet"]
[null,null,null,null,null,null,null,null,null,null,"CTRL + Q to Enable Mouse"]
[null,"Results"]
[]
[]
[]
[]
[null,null,"Navigation Exercise",null,"Formatting Exercise",null,null,null,null,"Help us Collect Data"]
[]
["Your Results",null,null,null,null,null,null,null,"We are collecting data on completion times."]
[null,"Last Attempt",null,null,null,null,null,null,"Once we have enough data, we will make it available through our website",null,null,null,{"$f":"HYPERLINK(\"http://www.automateexcel.com/in/eff-results\",\"Visit Site\")","v":"Visit Site"}]
[null,"Time",{"$f":"Nav_Last_Seconds","v":""},null,{"$f":"Form_Last_Seconds","v":""},null,null,null,"If you wish to help us collect data, please submit your results using the button below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C13*24*60*60","v":{"$error":"#VALUE!"}},null,{"$f":"E13*24*60*60","v":{"$error":"#VALUE!"}}]
[null,"Penalties",{"$f":"Nav_PenaltyCount","v":4},null,null,null,null,null,"If, after you submit, you take the tests again, we request that you resubmit so we receive the latest data."]
[null,"Total Time",{"$f":"Nav_Latest_SecondwPen","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,"Fields",null,"All Responses Are Optional"]
[null,"Best",null,null,null,null,null,null,"School"]
[null,"Time",{"$f":"Nav_Best_Seconds","v":1.7361110803904012E-4},null,{"$f":"Form_Best_Seconds","v":6.2500000058207661E-4},null,null,null,"Company"]
[null,"Penalties",{"$f":"Nav_Best_PenaltyCount","v":0},null,null,null,null,null,"Work Experience"]
[null,"Total Time",{"$f":"Nav_Best_SecondwPen","v":1.7361111111111112E-4},null,null,null,null,null,"Profession (Actual or Expected)"]
[null,null,null,null,null,null,null,null,"Email"]
[null,"First"]
[null,"Time",{"$f":"Nav_First_Seconds","v":1.7361111531499773E-4},null,{"$f":"Form_First_Seconds","v":6.2500000058207661E-4}]
[null,"Penalties",{"$f":"Nav_First_PenaltyCount","v":0}]
[null,"Total Time",{"$f":"Nav_First_SecondwPen","v":1.7361111111111112E-4}]
[]
[]
[]
["Benchmarks"]
[null,"Expert",2.4305555555555552E-4,null,4.7453703703703704E-4]
[null,"Advanced",2.8935185185185189E-4,null,5.5555555555555556E-4]
[null,"Intermediate",3.3564814814814812E-4,null,6.3657407407407402E-4]
[null,"Beginner",4.6296296296296293E-4,null,9.4907407407407408E-4]
[]
[null,"Efficiency Increase",{"$f":"IF(ROUNDUP((C25-C20)/C20,1)=0,\"Minimal\",ROUNDUP((C25-C20)/C20,1))","v":"Minimal"},null,{"$f":"IF(ROUNDUP((E23-E18)/E18,1)=0,\"Minimal\",ROUNDUP((E23-E18)/E18,1))","v":"Minimal"}]
[null,"Potential Efficiency Increase",{"$f":"IF(MAX(ROUNDUP((C25-C20)/C20,1),ROUNDUP((C25-C30)/C30,1))=0,\"Minimal\",MAX(ROUNDUP((C25-C20)/C20,1),ROUNDUP((C25-C30)/C30,1)))","v":"Minimal"},null,{"$f":"IF(MAX(ROUNDUP((E23-E18)/E18,1),ROUNDUP((E23-E30)/E30,1))=0,\"Minimal\",MAX(ROUNDUP((E23-E18)/E18,1),ROUNDUP((E23-E30)/E30,1)))","v":0.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MAX(ROUNDUP((C15-C20)/C20,1),ROUNDUP((C15-C30)/C30,1))=0,\"Minimal\",MAX(ROUNDUP((C15-C20)/C20,1),ROUNDUP((C15-C30)/C30,1)))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(MAX(ROUNDUP((E13-E18)/E18,1),ROUNDUP((E13-E30)/E30,1))=0,\"Minimal\",MAX(ROUNDUP((E13-E18)/E18,1),ROUNDUP((E13-E30)/E30,1)))","v":{"$error":"#VALUE!"}}]

{"sheet":"Results2","index":22,"n_rows":16,"n_cols":98,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87]
[]
[null,null,null,null,null,"Navigation Exericse"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"10",null,null,null,null,null,null,null,null,null,"20",null,null,null,null,null,null,null,null,null,"30",null,null,null,null,null,null,null,null,null,"40",null,null,null,null,null,null,null,null,null,"50",null,null,null,null,null,null,null,null,null,"60",null,null,null,null,null,null,null,null,null,"70"]
[null,null,null,null,null,"Best Time",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76]
[null,null,null,null,null,null,null,null,null,null,null,"=REPT(\" \",'Record Times'!$BR$4*3.5)&'Record Times'!$BR$4&\" secs\""]
[]
[null,null,null,null,null,"First Time",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"need to add in the actual times someplace"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"need to adjust the nav exercise so expet is more advanced?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I think the best/first times should be in adjascent rows…"]

{"sheet":"Data Submission","index":23,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["ninja_forms_field_4","Email",{"$f":"Results!K21","v":"00:00:00"},null,"diag test results",null,null,null,null,null,4,null,null,"mouse enabled?"]
["ninja_forms_field_5","School",{"$f":"Results!K17","v":0},null,null,null,null,null,null,null,5,null,null,1,null,"1=yes"]
["ninja_forms_field_6","Company",{"$f":"Results!K18","v":0},"URL",null,null,null,null,null,null,6]
["ninja_forms_field_7","experience",{"$f":"Results!K19","v":0},"http://www.automateexcel.com/in/eff-feedback",null,null,null,null,null,null,7,null,null,null,null,"Yes"]
["ninja_forms_field_9","Profession",{"$f":"Results!K20","v":0},null,null,null,null,null,null,null,9,null,null,null,null,"No"]
["ninja_forms_field_10","Form_Attempts",{"$f":"'Record Times'!E6","v":3},null,null,null,null,null,null,null,10]
["ninja_forms_field_11","Form_Time_Best",{"$f":"Results!E18","v":6.2500000058207661E-4},null,null,null,"<<post penalties I assume?",null,null,null,11,null,null,"None"]
["ninja_forms_field_12","Form_Time_First",{"$f":"Results!E23","v":6.2500000058207661E-4},null,null,null,null,null,null,null,12,null,null,"Internship(s) Only"]
["ninja_forms_field_13","Nav_Attempts",{"$f":"'Record Times'!BI6","v":11},null,null,null,null,null,null,null,13,null,null,"<1 year"]
["ninja_forms_field_14","Nav_Time_Best",{"$f":"Results!C20","v":1.7361111111111112E-4},null,null,null,null,null,null,null,14,null,null,"1 year"]
["ninja_forms_field_15","Nav_Time_First",{"$f":"Results!C25","v":1.7361111111111112E-4},"orig_computerID",null,null,null,null,null,null,15,null,null,"2 years"]
["ninja_forms_field_16","ComputerID",1746527678,1746527678,null,null,null,null,null,null,16,null,null,"3 years"]
["ninja_forms_field_17","submit",null,null,null,null,null,null,null,null,17,null,null,"4 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5 years"]
["ninja_forms_field_17",null,null,null,null,null,null,null,null,null,null,null,null,"6 years"]
["ninja_forms_field_5",null,null,null,null,null,null,null,null,null,null,null,null,"7 years"]
["ninja_forms_field_6",null,null,null,null,null,null,null,null,null,null,null,null,"8 years"]
["ninja_forms_field_17",null,null,null,null,null,null,null,null,null,null,null,null,"9 years"]
["ninja_forms_field_9",null,null,null,null,null,null,null,null,null,null,null,null,"10 years"]
["ninja_forms_field_10",null,null,null,null,null,null,null,null,null,null,null,null,"11 years"]
["ninja_forms_field_11",null,null,null,null,null,null,null,null,null,null,null,null,"12 years"]
["ninja_forms_field_12",null,null,null,null,null,null,null,null,null,null,null,null,"13 years"]
["ninja_forms_field_13",null,null,null,null,null,null,null,null,null,null,null,null,"14 years"]
["ninja_forms_field_14",null,null,null,null,null,null,null,null,null,null,null,null,"15 years"]
["ninja_forms_field_15",null,null,null,null,null,null,null,null,null,null,null,null,"16 years"]
["ninja_forms_field_16",null,null,null,null,null,null,null,null,null,null,null,null,"17 years"]
["ninja_forms_field_17",null,null,null,null,null,null,null,null,null,null,null,null,"18 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"19 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"20+ years"]

{"sheet":"Freq Used Shortcuts","index":24,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Navigation",null,null,null,"Editing",null,null,null,"ALT Shortcuts"]
[null,"Cell Navigation and Selection",null,null,null,"Cells",null,null,null,"Cell Size"]
[null,"Move one cell in any direction",null,"Arrow Keys",null,"Edit Cell",null,"F2",null,"Row Height",null,"ALT + H + O + H"]
[null,"Go to end of contiguous range",null,"CTRL + Arrow Keys",null,"Cancel cell entry",null,"ESC",null,"AutoFit Row Height",null,"ALT + H + O + A"]
[null,"Select range",null,"SHIFT + Arrow Keys",null,"Anchor cells",null,"F4",null,"Column Width",null,"ALT + H + O + W"]
[null,"Select contiguous range",null,"CTRL + SHIFT + Arrow Keys",null,"Highlight within cells",null,"SHIFT + Arrow Keys",null,"AutoFit Column Width",null,"ALT + H + O + I"]
[null,"Move one page up (down)",null,"Page Up (Down)",null,null,null,null,null,"Default Column Width",null,"ALT + H + O + D"]
[null,"Move to beginning of row",null,"Home",null,"Fill Down",null,"CTRL + D"]
[null,"Move to cell \"A1\"",null,"CTRL + Home",null,"Fill Right",null,"CTRL + R",null,"Visibility"]
[null,"Move to cell to the right (left)",null,"TAB (SHIFT + TAB)",null,null,null,null,null,"Hide/Unhide Columns, Rows & Sheets",null,"ALT + H + O + U"]
[null,"Move to cell below (above)",null,"Enter (SHIFT + Enter)",null,"Copy",null,"CTRL + C"]
[null,"Select All",null,"CTRL + A",null,"Paste",null,"CTRL + V",null,"Organize Sheets"]
[null,null,null,null,null,"Paste Special",null,"CTRL + ALT + V",null,"Rename Sheet",null,"ALT + H + O + R"]
[null,"Worksheet Navigation",null,null,null,"Cut",null,"CTRL + X",null,"Move or Copy Sheet",null,"ALT + H + O + M"]
[null,"Move to next/previous worksheet",null,"CTRL + Page Up/Down",null,"Undo",null,"CTRL + Z",null,"Tab Color",null,"ALT + H + O + T"]
[null,"New Worksheet",null,"SHIFT + F11",null,"Repeat",null,"CTRL + Y"]
[]
[null,"Workbook Navigation",null,null,null,"Row/Columns",null,null,null,"Viewing"]
[null,"Switch workbooks",null,"CTRL + TAB",null,"Select Column",null,"CTRL + SPACE",null,"Freeze Panes",null,"ALT + W + F + F"]
[null,"Switch workbooks in reverse",null,"CTRL + SHIFT + TAB",null,"Select Row",null,"SHIFT + SPACE",null,"Split Screen",null,"ALT + W + S"]
[null,"New Workbook",null,"CTRL + N",null,"Delete Row or Column",null,"CTRL + \"-\""]
[null,null,null,null,null,"Insert Row or Column",null,"CTRL + \"+\""]
[null,"Basics",null,null,null,"Group/Ungroup rows or columns",null,"ALT + SHIFT + Left/Right Arrow Keys"]
[null,"Save",null,"CTRL + S"]
[null,"Print",null,"CTRL + P",null,"Tools/Other Features",null,null,null,"Tools"]
[null,"New Workbook",null,"CTRL + N",null,"Display Name Menu",null,"CTRL + F3",null,"Sort",null,"ALT + A + SS"]
[null,"Close Program",null,"ALT + F4",null,"Go To",null,"F5 or CTRL + G",null,"Filter",null,"ALT + A + T"]
[null,"Open Workbook",null,"CTRL + O",null,"Find",null,"CTRL + F",null,"Text to Columns",null,"ALT + A + E"]
[null,"Close Window",null,"CTRL + W (CTRL + F4)",null,"Replace",null,"CTRL + H",null,"Data Validation",null,"ALT + A + V"]
[]
[null,"Recalculate Workbook",null,"F9",null,"Auditing",null,null,null,"Auditing"]
[null,null,null,null,null,"Show Formulas",null,"CTRL + ~",null,"Trace Precedents",null,"ALT + M + P"]
[null,"Formatting",null,null,null,"Go To",null,"F5 or CTRL + G",null,"Trace Dependents",null,"ALT + M + D"]
[null,"Cell Formatting",null,null,null,null,null,null,null,"Remove Trace Arrows",null,"ALT + M + A + A"]
[null,"Format Menu",null,"CTRL + 1",null,null,null,null,null,"Track Changes",null,"ALT + R + G"]
[null,"Bold",null,"CTRL + B"]
[null,"Italic",null,"CTRL + I"]
[null,"Underline",null,"CTRL + U"]
[null,"Insert a comment",null,"SHIFT + F2"]
[]
[null,"Want to master Excel? Visit www.spreadsheetbootcamp.com",null,null,null,null,"Excel is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries."]

{"sheet":"All Shortcuts","index":25,"n_rows":89,"n_cols":10,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Key","Alone","Shift","Ctrl","Alt","Ctrl + Shift","Alt + Shift","Ctrl + Alt","Ctrl + Alt + Shift"]
[null,"Esc","Esc"]
[null,"Backspace","Backspace","Collapse Selection","Goto Active Cell"]
[null,"Tab","Move Right","Move Left","next window","next application","Previous Window"]
[null,"Enter","Enter","Move Up","Fill Selection with Active Cell","New Line in Cell"]
[null,"Insert","Insert Mode",null,"Copy"]
[null,"Delete","Clear",null,"Delete To End Of Line"]
[null,"Home","Start of Row",null,"Start of Worksheet",null,"Select to Start of Sheet"]
[null,"End","End of Row",null,"End of Worksheet",null,"Select to End of Sheet"]
[null,"Page Up","Page Up",null,"Previous Worksheet","Left 1 screen","Select Current, Next Sheet"]
[null,"Page Down","Page Down",null,"Next Worksheet","Right 1 screen","Select Current, Prev Sheet"]
[null,"Left Arrow","Move Left","Select Left","Move Left Area","Back"]
[null,"Right Arrow","Move Right","Select Right","Move Right Area","Forward"]
[null,"Up Arrow","Move Up","Select Up","Move Up Area"]
[null,"Down Arrow","Move Down","Select Down","Move Down Area","Drop down list"]
[null,"Space Bar","Space","Select Row","Select Column","Control Box","Select All"]
[]
[null,"F1","Help","What's This Help","Show/Hide Ribbon","Insert Chart",null,"New Worksheet"]
[null,"F2","Edit Mode","Add/Edit Comment","Print Preview","Save As"]
[null,"F3","Paste Name","Insert Function","Define Name",null,"Names From Labels"]
[null,"F4","Repeat Action","Find Again","Close Window","Quit Excel","Find Previous"]
[null,"F5","Goto","Find","Restore Window Size"]
[null,"F6","Next Pane","Prev Pane","Next Window","Previous Window","Prev Workbook"]
[null,"F7","Spell Check",null,"Move Window"]
[null,"F8","Extend Selection","Add To Selection","Resize Window","Macro List"]
[null,"F9","Calculate All","Calculate Worksheet","Minimize Workbook",null,null,null,"Calculate all","Recheck dependents"]
[null,"F10","Activate Menu","Context Menu","Maximize/Restore Window",null,null,"Smart Tag menu"]
[null,"F11","New Chart","New Worksheet","New Macro Sheet","VB Editor",null,"Script Editor"]
[null,"F12","Save As","Save","Open",null,"Print"]
[]
[null,"`   ~","`","~","Toggle Formula View",null,"General Format"]
[null,"1   !","1900-01-01","!","Format Cells",null,"Number Format"]
[null,"2   @","1900-01-02","@","Bold",null,"Time Format"]
[null,"3   #","1900-01-03","#","Italics",null,"Date Format"]
[null,"4   $","1900-01-04","$","Underline",null,"Currency Format"]
[null,"5   %","1900-01-05","%","Strike thru",null,"Percent Format"]
[null,"6   ^","1900-01-06","^","Hide/Display Objects",null,"Exponent Format"]
[null,"7   &","1900-01-07","&","Show/Hide Standard Toolbar",null,"Outside Border"]
[null,"8   *","1900-01-08","*","Display/Hide Outline Symbols",null,"Select Region"]
[null,"9   (","1900-01-09","(","Hide Rows",null,"Unhide Rows"]
[null,"0   )","00:00:00",")","Hide Columns",null,"Unhide Columns"]
[null,"-   _","-","_","Delete Cells","control menu","No Border"]
[null,"=   +","=","+","Calculate All","auto sum","Insert Cells"]
[null,"[   {","[","{","Show Precedents",null,"All Precedents"]
[null,"]   }","]","}","Show Dependents",null,"All Dependents"]
[null,"\\   |",null,null,"Select Differences",null,"Select Unequal Cells"]
[null,";   :",";",":","Insert Date","Select Visible Cells","Insert Time"]
[null,"'   \"","'","\"","Copy Formula From Above","Style","Copy Value Above"]
[null,",   <",",","<"]
[null,".   >",".",">","Next corner of range"]
[null,"/   ?","/","?","Select Array",null,"Select Array"]
[]
[null,"A","a","A","Select All ",null,"Insert Formula Arguments"]
[null,"B","b","B","Bold"]
[null,"C","c","C","Copy"]
[null,"D","d","D","Fill Down"]
[null,"E","e","E"]
[null,"F","f","F","Find",null,"Open Font Menu"]
[null,"G","g","G","Go To"]
[null,"H","h","H","Replace"]
[null,"I","i","I","Italics"]
[null,"J","j","J"]
[null,"K","k","K","Insert/Edit Hyperlink"]
[null,"L","l","L","Create Table"]
[null,"M","m","M"]
[null,"N","n","N","New Workbook"]
[null,"O","o","O","Open Workbook",null,"Select All Cells w/Comments"]
[null,"P","p","P","Print",null,"Open Font Menu"]
[null,"Q","q","Q"]
[null,"R","r","R","Fill Right"]
[null,"S","s","S","Save"]
[null,"T","t","T","Create Table"]
[null,"U","u","U","Underline"]
[null,"V","v","V","Paste",null,null,null,"Paste Special"]
[null,"W","w","W","Close Window"]
[null,"X","x","X","Cut"]
[null,"Y","y","Y","Repeat"]
[null,"Z","z","Z","Undo"]
[null,null,null,null,null,null,"                   Excel is either a registered trademark or trademark of"]
[null,"Want to master Excel? Visit www.spreadsheetbootcamp.com to learn Excel entirely inside an Excel spreadsheet.",null,null,null,null,"                   Microsoft Corporation in the United States and/or other countries."]

{"sheet":"Record Times","index":26,"n_rows":19,"n_cols":73,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,null,"DO NOT MOVE ANY OF THESE CELLS! That will bomb the macros!"]
[null,"Formatting Exercise",null,null,null,null,null,null,null,null,null,null,null,null,null,"Exercise 2.1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Exercise 2.2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Exercise 2.3",null,null,null,null,null,null,null,null,null,null,null,null,null,"Navigation Exercise"]
[null,null,null,"Completion Time",null,null,null,null,null,null,null,null,"Min","Sec","Seconds","Sec w/Pen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completion Time",null,null,null,null,null,null,null,"Min","Sec","Penalties","Seconds","Sec w/Pen"]
[null,"Best",null,"Best Time",{"$f":"MIN(E9:E1048576)","v":"00:00:54"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(E4,E9:N1048576,9,FALSE)","v":0},{"$f":"VLOOKUP(E4,E9:N1048576,10,FALSE)","v":54},{"$f":"E4","v":6.2500000058207661E-4},null,null,"Best Time",{"$f":"MIN(S9:S1048576)","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(S4,S9:AB1048576,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(S4,S9:AB1048576,10,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Best Time",{"$f":"MIN(AG9:AG1048576)","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(AG4,AG9:AP1048576,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AG4,AG9:AP1048576,10,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Best Time",{"$f":"MIN(AU9:AU1048576)","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(AU4,AU9:BD1048576,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AU4,AU9:BD1048576,10,FALSE)","v":{"$error":"#N/A"}},null,"Best",null,null,{"$f":"MIN(BI9:BI1048576)","v":"00:00:15"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(BI4,BI9:BR1048576,9,FALSE)","v":0},10,{"$f":"VLOOKUP(BI4,BI9:BS1048576,11,FALSE)","v":0},{"$f":"BI4","v":1.7361110803904012E-4},{"$f":"TIME(HOUR(Nav_Best_Seconds),MINUTE(Nav_Best_Seconds),SECOND(Nav_Best_Seconds)+Nav_Best_PenaltyCount*3)","v":1.7361111111111112E-4}]
[null,null,null,"# Attempts",13,null,null,null,null,null,null,null,"Display",null,null,null,null,null,null,null,null,null,null,null,null,null,"Display",null,null,null,null,null,null,null,null,null,null,null,null,null,"Display",null,null,null,null,null,null,null,null,null,null,null,null,null,"Display",null,null,null,null,"# Attempts",0,null,null,null,null,null,null,null,"Display","=VLOOKUP(BI4,BI9:BR1048576,10,FALSE)"]
[null,null,null,"# Completions",{"$f":"COUNT(E9:E1048576)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Completions",{"$f":"COUNT(BI9:BI1048576)","v":11}]
[null,"Latest","2016-04-30T16:45:05",null,{"$f":"IF(D7=\"\",\"\",D7-C7)","v":""},{"$f":"IF(D7=\"\",\"\",DAY(E7))","v":""},{"$f":"IF(D7=\"\",\"\",HOUR(E7))","v":""},{"$f":"IF(D7=\"\",\"\",MINUTE(E7))","v":""},{"$f":"IF(D7=\"\",\"\",SECOND(E7))","v":""},null,null,null,{"$f":"IF(D7=\"\",\"\",MINUTE(E7)+G7*60)","v":""},{"$f":"IF(D7=\"\",\"\",SECOND(E7))","v":""},{"$f":"E7","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Latest",null,null,{"$f":"IF(BH7=\"\",\"\",BH7-BG7)","v":""},{"$f":"IF(BH7=\"\",\"\",DAY(BI7))","v":""},{"$f":"IF(BH7=\"\",\"\",HOUR(BI7))","v":""},{"$f":"IF(BH7=\"\",\"\",MINUTE(BI7))","v":""},{"$f":"IF(BH7=\"\",\"\",SECOND(BI7))","v":""},null,null,null,{"$f":"IF(BH7=\"\",\"\",MINUTE(BI7)+BK7*60)","v":""},{"$f":"IF(BH7=\"\",\"\",SECOND(BI7))","v":""},4,{"$f":"BI7","v":""},{"$f":"TIME(HOUR(BT7),MINUTE(BT7),SECOND(BT7)+BS7*3)","v":{"$error":"#VALUE!"}}]
[null,null,"Beg Time Stamp","End Time Stamp","Completion Time","Day","Hour","Min","Sec",null,null,null,"Min","Sec",null,null,"Beg Time Stamp","End Time Stamp","Completion Time",null,null,null,null,null,"Hour","Min","Min","Sec",null,null,"Beg Time Stamp","End Time Stamp","Completion Time",null,null,null,null,null,"Hour","Min","Min","Sec",null,null,"Beg Time Stamp","End Time Stamp","Completion Time",null,null,null,null,null,"Hour","Min","Min","Sec",null,null,"Beg Time Stamp","End Time Stamp","Completion Time","Day","Hour","Min","Sec",null,null,null,"Min","Sec","Penalties"]
[null,"First","2016-04-11T19:29:18","2016-04-11T19:30:12",6.2500000058207661E-4,0,0,0,54,null,null,null,0,54,{"$f":"E9","v":6.2500000058207661E-4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First","2015-07-08T11:52:19","2015-07-08T11:52:34",1.7361111531499773E-4,0,0,0,15,null,null,null,0,15,null,{"$f":"BI9","v":1.7361111531499773E-4},{"$f":"TIME(HOUR(BT9),MINUTE(BT9),SECOND(BT9)+BS9*3)","v":1.7361111111111112E-4}]
[null,null,"2016-04-11T19:29:18","2016-04-11T19:30:42",9.7222221666015685E-4,0,0,1,24,null,null,null,1,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-16T10:59:05","2015-07-16T10:59:20",1.7361111531499773E-4,0,0,0,15,null,null,null,0,15]
[null,null,"2016-04-15T11:23:42","2016-04-15T11:25:04",9.4907407037680969E-4,0,0,1,22,null,null,null,1,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-16T10:59:05","2016-01-17T23:28:43",1.7361111531499773E-4,0,0,0,15,null,null,null,0,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-16T10:59:05","2016-01-17T23:28:46",1.7361111531499773E-4,0,0,0,15,null,null,null,0,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42201.457696759258,42386.978703703702,1.7361111531499773E-4,0,0,0,15,null,null,null,0,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42201.457696759258,42388.026770833334,185.5210069444438,3,12,30,15,null,null,null,750,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42388.40896990741,42388.409143518518,1.7361110803904012E-4,0,0,0,15,null,null,null,0,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42388.416284722225,42388.416493055556,2.0833333110203966E-4,0,0,0,18,null,null,null,0,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42475.473912037036,42475.474166666667,2.546296309446916E-4,0,0,0,22,null,null,null,0,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42475.474351851852,42475.474560185183,2.0833333110203966E-4,0,0,0,18,null,null,null,0,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42475.525706018518,42475.525914351849,2.0833333110203966E-4,0,0,0,18,null,null,null,0,18]