The Learn Microsoft Excel for Data Analysis course has interactive exercise spreadsheets!
There are a couple common issues working with these:
When I open the file I’m told it is read-only!
This is likely due to your own Excel settings or anti-virus software settings. Check out Microsoft’s help page for a couple potential fixes or get in touch with your IT department!
The hints and solutions don’t update when I change my answer!
You probably have Excel set to manual calculations. There are a couple ways to handle this:
- You can manually tell Excel to recalculate by pressing the
F9
key or by selecting theCalculate Now
button on theFormulas
tab (see screenshot below.) - You can switch Excel to automatic calculations by using the
Calculation Options
button on theFormulas
tab