Excel 2013

MOS Certification Comprehensive

Frequently asked questions and instructor notes

Topic A0:   Classroom setup

All our courses assume that each student has a personal computer to use during the class. Our hands-on approach to learning requires that they do. This topic gives information on how to set up the classroom to teach this course.

Hardware requirements

Each student’s personal computer should have:

·   A keyboard and a mouse

·   1 GHz or faster 32- or 64-bit processor

·   At least 1 GB of RAM

·   At least 2 GB of available hard disk space after operating system install

·   Video adapter card compatible with DirectX 9 or newer, with at least 64 MB video memory

·   A monitor at 1024 × 768 or higher resolution

·   DVD drive if you’ll be installing via disc

·   Printer (useful but not required)

Software requirements

You will need the following software:

·   Microsoft Windows 7 (You can also use Windows XP, Windows Vista, or Windows 8, but the screenshots in this course were taken in Windows 7, so students’ screens will look different.)

·   Microsoft Office 2013 (minimally, you can install only Excel 2013)

·   Adobe Reader

·   A printer driver (An actual printer is not required, but students will not be able to get an exact preview in Print Preview or complete Activity A-3 in the “Printing” unit unless a printer driver is installed.)

Network requirements

The following network components and connectivity are also required for this course:

·   Internet access, for the following purposes:

–   Updating the Windows operating system and Microsoft Office 2013

–   Downloading the Student Data files from www.axzopress.com (if necessary)

Classroom setup instructions

Before you teach this course, you will need to perform the following steps to set up each student computer.

1   Install Windows 7 on an NTFS partition according to the software publisher’s instructions. After installation is complete, if the student machines have Internet access, use Windows Update to install any critical updates and Service Packs.

2   With flat-panel displays, we recommend using the panel’s native resolution for best results. Color depth/quality should be set to High (24 bit) or higher.

3   Configure Windows Explorer to display file extensions, and to show hidden files and folders.

4   Install Microsoft Office 2013 according to the software manufacturer’s instructions, as follows:

a   When prompted, accept the License Agreement. Then, click Continue.

b   On the next screen, click Customize.

c   Click the Installation Options tab, if necessary.

d   For Microsoft Office Excel, Office Shared Features, and Office Tools, click the down-arrow and choose “Run all from My Computer.”

e   Set all except the following to Not Available: Microsoft Office Excel, Office Shared Features, and Office Tools.

f    Click Install Now.

g   When the installation is complete, click Close.

5   Start Microsoft Office Excel 2013. Then do the following:

a   On the Activate Office screen, click Enter a product key instead.

b   Enter your product key, and click Install.

c   On the First things first screen, select “Ask me later” and click Accept.

d   Close the Welcome screen.

6   Install Adobe Reader.

a   In your browser, go to http://get.adobe.com/reader/.

b   If necessary, uncheck the box to decline any additional installations.

c   Click the button to start the download, and follow the instructions provided to complete the installation.

d   After the installation is complete, start Adobe Reader and accept the license agreement, and then close the Reader.

7   Download the Student Data files provided for this course. These files are necessary for students to be able to perform the hands-on activities.

a   Connect to www.axzopress.com.

b   Under Downloads, click Instructor-Led Training.

c   Browse the subject categories to locate this course. Then click the course title to display a list of available downloads. (You can also access these downloads through our Catalog listings.)

d   Click the link(s) to download the Student Data files.

e   Create a folder named Student Data.

f    Double-click the downloaded zip file(s) and drag the contents into the Student Data folder.

g   Place a copy of the Student Data folder on the desktop of each student computer.

8   Disable Protected View settings for Excel as follows:

a   Open a new blank workbook.

b   On the File tab, click Options.

c   Select Trust Center and click Trust Center Settings.

d   Select Protected View and clear “Enable Protected View for files originating from the Internet.”

e   Click OK twice to save the settings. Close Excel.

 

Topic B:   Frequently asked questions

There are no frequently asked questions for this course at this time.

 

Topic C:   Course notes

There are no notes for this course at this time.

 

Topic D:   Additional information

There is no additional information for this course at this time.