In this course, you will use Microsoft Excel along with the Data Analysis Toolpak Add-in.
If you don’t have Excel on your computer, you can download the Microsoft Office 365 products from ERNIE. You must have Excel on your computer before you install the add-ins.
Once you’ve downloaded Microsoft Office 365, use these resources to download the tool.
How to Install Data Analysis addin in Excel (Windows) (YouTube 0:39) (Links to an external site.)
Microsoft Software Information (ERNIE) (Links to an external site.)
Add-ins Installation for Windows OS (PDF)Preview the document
Add-ins Installation for Mac OS (PDF)Preview the document
After installing the add-ins, use Chapter 1 in your textbook as a guide, and practice using the tools. At the end of your practice, you should be able to:
Create a worksheet
Get help while using Excel
Undo an operation
Save a file
Perform calculations
Sort data
Use Excel for statistical functions
If you master these skills now, you will save time in future assignments.
Submit Proof
Submit a screenshot of your work showing that you installed the Data Analysis Toolpak.
Save your assignment using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.
Use this same naming convention for all files submitted in this course.
This is a non-graded, required activity.
https://youtu.be/SqpSwxJ9t2k
https://ernie.erau.edu/Departments/information-technology/Pages/microsoft.aspx
https://ernie.erau.edu/Departments/information-technology/Pages/microsoft.aspx
https://ernie.erau.edu/Departments/information-technology/Pages/microsoft.aspx
