Advanced Excel for Data Analysis Course Questions 1) I am working off a version of Windows Excel 2016. Do you know what the home key shortcut is? "Fn" does not and work neither does "alt +h."
2) For Excel 2016 In the Pivot Tables Section, when I get to step 3 out of 3 to set up the table, excel doesn't give me the option of clicking layout (it'...1) I am working off a version of Windows Excel 2016. Do you know what the home key shortcut is? "Fn" does not and work neither does "alt +h."
2) For Excel 2016 In the Pivot Tables Section, when I get to step 3 out of 3 to set up the table, excel doesn't give me the option of clicking layout (it's greyed out). It only gives me the option to his cancel, back or finish. I'm forced to click "finish" but when I try to follow Hamilton's instructions on how to make the correct layout, the table ends up looking funky. It does not format properly and the correct results do not show. Do you have any recommendations on how to remedy this?
3) I am getting the hang of anchoring but haven't gotten it down pat yet. And we use it a lot. Is there an anchoring cheat sheet you can provide for how many times to hit the "home" key for locking in columns, rows, or both columns and rows? And definitions for the different locking types?Read More
1) I am working off a version of Windows Excel 2016. Do you know what the home key shortcut is? "Fn" does not and work neither does "alt +h." 2) For Excel 2016 In the Pivot Tables Section, when I get to step 3 out of 3 to set up the table, excel doesn't give me the option of clicking layout (it'... 1) I am working off a version of Windows Excel 2016. Do you know what the home key shortcut is? "Fn" does not and work neither does "alt +h."
2) For Excel 2016 In the Pivot Tables Section, when I get to step 3 out of 3 to set up the table, excel doesn't give me the option of clicking layout (it's greyed out). It only gives me the option to his cancel, back or finish. I'm forced to click "finish" but when I try to follow Hamilton's instructions on how to make the correct layout, the table ends up looking funky. It does not format properly and the correct results do not show. Do you have any recommendations on how to remedy this?
3) I am getting the hang of anchoring but haven't gotten it down pat yet. And we use it a lot. Is there an anchoring cheat sheet you can provide for how many times to hit the "home" key for locking in columns, rows, or both columns and rows? And definitions for the different locking types? Read More