{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Start","1","2","3","4","5","Learn more"],"not_rendered":{"images":12,"external_links":2,"defined_names":15,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["Welcome\nInstructions for screen readers: Tips & tricks for Excel. Pick up fun Excel tips and tricks in the next 5 worksheets in this tutorial. The instructions for each sheet start in cell A1, and each subsequent step is in cell A2, A3, and so on. \nThe instructions will indicate which cells to navigate to for use of a feature, or further reading."]
["Tips & tricks"]
["Ready to be more productive? Here are five quick tips \nguaranteed to save you time in Excel.\n\n"]
["Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":13,"n_cols":5,"rows_kept":13}
["Tip #1: Recommended Charts. There is a table of data in cells B7 to E13. Navigate to any cell within that range, then press ALT+N > R to launch the Recommended Charts dialog. Press Tab, then use your Up/Down arrow keys to scroll through the options. Press Enter to insert the selected chart on the worksheet."]
["DID YOU KNOW...\nYour version of Excel has many charts to choose from. But in Excel for Office 365, there are newer charts available like funnel charts, waterfall charts, and even filled map charts."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[null,"Product","January","February","March"]
[null,"Apples",500,700,300]
[null,"Oranges",600,{"v":1010,"d":"1,010"},200]
[null,"Bananas",800,500,400]
[null,"Lemons",700,200,560]
[null,"Cherries",{"v":1010,"d":"1,010"},300,734]
[null,"Pears",500,100,234]

{"sheet":"2","index":2,"n_rows":17,"n_cols":3,"rows_kept":17}
["Tip #2: Flash Fill. Type \"Nancy Smith\" in cell C8, then press Enter. Next, press CTRL+E to fill the empty cells following the example in C8. You could also enter \"Smith, Nancy\", or any other combination you like."]
["DID YOU KNOW...\nIf your data is imported and refreshed, Flash Fill won't automatically clean it up again. However, if you upgrade to Excel for Office 365, you can use the new Get Data button. That button lets you import and clean your data. After that, if you need to refresh the data, Excel will clean any new data that comes in. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[null,"Product","First and last name"]
[null,"Nancy.Smith@contoso.com"]
[null,"Andy.North@fabrikam.com"]
[null,"Dave.Ludwig@relecloud.com"]
[null,"Chuck.Degrute@contoso.com"]
[null,"Alfred.Cortland@fabrikam.com"]
[null,"John.Massente@relecloud.com"]
[null,"Geoff.Moore@contoso.com"]
[null,"Jorge.Johnson@fabrikam.com"]
[null,"Dave.Ludwig@relecloud.com"]
[null,"Yvonne.McKay@fabrikam.com "]

{"sheet":"3","index":3,"n_rows":3,"n_cols":1,"rows_kept":3}
["Tip #3: Co-authoring. Upload an Excel file to OneDrive.com, share it, and then everyone can edit the file at the same time using a web browser."]
["DID YOU KNOW...\nIf you and your peers upgrade to Excel for Office 365, you aren't limited to co-authoring in a web browser. You can edit at the same time using the Excel desktop app. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"4","index":4,"n_rows":117,"n_cols":6,"rows_kept":117}
["Tip #4: Tabular PivotTables. In this PivotTable there is a label in cell B8 titled, \"Row Labels\", but it isn't very specific. Click anywhere within the PivotTable (from cells B7 to F15), and then on the Design tab, click Report Layout > Show in Tabular Form. That's much better."]
["DID YOU KNOW...\nIf you upgrade to Excel for Office 365, you can choose your preferred PivotTable layout settings. That way you don't have to change the layout every time you make a new PivotTable. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[null,"Sum of Expense","Column Labels"]
[null,"Row Labels","Food","Utilities","Gas","Supplies"]
[null,"Terry",{"v":20,"d":"$20"},{"v":270,"d":"$270"},null,{"v":125,"d":"$125"}]
[null,"Victor",null,null,{"v":75,"d":"$75"},{"v":100,"d":"$100"}]
[null,"Bill",{"v":250,"d":"$250"},null,{"v":95,"d":"$95"}]
[null,"Martha",{"v":325,"d":"$325"},{"v":55,"d":"$55"},{"v":55,"d":"$55"}]
[null,"Mike",null,{"v":95,"d":"$95"},{"v":95,"d":"$95"}]
[null,"Sally",{"v":325,"d":"$325"},null,{"v":325,"d":"$325"}]
[null,"Craig",{"v":250,"d":"$250"},{"v":250,"d":"$250"},null,{"v":250,"d":"$250"}]
{"$rows_empty":82}
[null,"Date","Family member","Type of purchase","Expense"]
[null,"2017-01-01","Bill","Gas",{"v":95,"d":"$95"}]
[null,"2017-01-15","Martha","Food",{"v":325,"d":"$325"}]
[null,"2017-01-17","Bill","Food",{"v":250,"d":"$250"}]
[null,"2017-01-21","Terry","Supplies",{"v":125,"d":"$125"}]
[null,"2017-01-17","Victor","Supplies",{"v":100,"d":"$100"}]
[null,"2017-01-21","Victor","Gas",{"v":75,"d":"$75"}]
[null,"2017-02-02","Martha","Gas",{"v":55,"d":"$55"}]
[null,"2017-02-20","Terry","Utilities",{"v":20,"d":"$20"}]
[null,"2017-02-25","Terry","Utilities",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mike","Gas",{"v":95,"d":"$95"}]
[null,"2017-02-20","Sally","Food",{"v":325,"d":"$325"}]
[null,"2017-02-25","Craig","Food",{"v":250,"d":"$250"}]
[null,"2017-02-20","Sally","Gas",{"v":325,"d":"$325"}]
[null,"2017-02-25","Craig","Supplies",{"v":250,"d":"$250"}]
[null,"2017-02-20","Terry","Food",{"v":20,"d":"$20"}]
[null,"2017-02-25","Terry","Utilities",{"v":125,"d":"$125"}]
[null,"2017-02-02","Martha","Utilities",{"v":55,"d":"$55"}]
[null,"2017-02-02","Mike","Utilities",{"v":95,"d":"$95"}]
[null,"2017-02-25","Craig","Utilities",{"v":250,"d":"$250"}]

{"sheet":"5","index":5,"n_rows":17,"n_cols":4,"rows_kept":17}
["Tip #5: Use the IF function. Navigate to cell D8 and press F2 to enter Edit mode and view the formula. If spoken aloud, Excel would say: If C8 is greater than or equal to 70, then show 'Yes', if not show 'No.'"]
["DID YOU KNOW...\nIn Excel for Office 365, you can use the new IFS function to specify multiple conditions, not just one."]
["Example: =IFS(C8>=90,\"A\",\nC8>=80,\"B\",\nC8>70,\"C\",\nC8>=60,\"D\",\nTRUE,\"F\")"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[null,"Student","Score","Passing grade?"]
[null,"Nancy Smith",78,{"$f":"IF(C8>=70,\"Yes\",\"No\")","v":"Yes"}]
[null,"Andy North",90,{"$f":"IF(C9>=70,\"Yes\",\"No\")","v":"Yes"}]
[null,"Dave Ludwig",85,"Yes"]
[null,"Chuck Degrute",27,"No"]
[null,"Alfred Cortland",57,"No"]
[null,"John Massente",78,"Yes"]
[null,"Geoff Moore",81,"Yes"]
[null,"Jorge Johnson",44,"No"]
[null,"Dave Ludwig",65,"No"]
[null,"Yvonne McKay",70,"Yes"]

{"sheet":"Learn more","index":6,"n_rows":5,"n_cols":1,"rows_kept":5}
["Good Job"]
["While you're here, check out these other helpful pages."]
["Why upgrade? See what else is possible when you upgrade to Office 365."]
["Typing tips - Check out our handy list of keyboard shortcuts in Excel"]
["Community - Ask questions and connect with other Excel fans."]