*Original Text:*12 a. On the External Data tab, in the Import & Link group, click the Text File button.
*Updated Text:*12a. (Alternate image) On the External Data tab, in the Import & Link group, click the New Data Source button, point to From File and select Text File.
Excel 2016 In Practice – Ch 2 Guided Project 2-3 – The instruction text for step 6a is corrected.
Original text: Click cell B13. The beginning balance is the total cost of the loan.
Corrected text: Click cell B13. The beginning balance is the loan amount.
Excel 2016 In Practice – Ch 4 Guided Project 4-3 – Alternate instructions have been added to the instructions for using the Advanced Filter option.
[ Alt Icon ] In some versions of Office, the above instructions to create an Advanced Filter may not work. If you experience this issue, complete instructions 6. a-e as listed below, then continue with instruction 6.f-l above.
Create an Advanced Filter.
Click the Criteria sheet tab.
Type >Dec 2016 in cell A3 to find records after 2016.
Type mri in cell B3.
Type >Dec 2014 in cell A4 to find records after 2014.
Type ct scan in cell B4. This criteria will find records dated 2017 or later for MRIs and records for CT scans after 2014.
Excel 2016 In Practice – Ch 6 Independent Project 6-5 – An alternate answer string for the Comma style with zero decimals is added to the grading.
PowerPoint 2016 Capstone – Level 3 Creating a Company’s Presentation – Due to a recent update for the Mac version, the Retrospect theme is no longer available with variants. The project has been updated to use the Badge theme.