Excel 2010:

Intermediate (First Look Edition)

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:

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

�� At least 1 GB of RAM

�� At least 2 GB hard-disk space after operating system install

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

�� A keyboard and a mouse

�� SVGA monitor at 1024 � 768 or higher resolution

�� Printer (useful but not required)

�� DVD drive if you�ll be installing via disc

Software requirements

You will need the following software:

�� Windows 7 Professional or Ultimate

�� Microsoft Office 2010

�� A printer driver (An actual printer is not required, but students will not be able to access Print Preview without a printer driver 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 2010

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

�� Downloading document templates from Microsoft Office Online (If online templates are not available, students will not be able to complete Activity B‑1 in the unit titled �Templates and settings.�)


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.

���� Note: You can use Windows XP or Windows Vista, but the screen shots in this course were taken in Windows 7, so students� screens might look different.

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

3�� Install Microsoft Office 2010 according to the software manufacturer�s instructions, as follows:

a�� When prompted for the CD key, enter the code included with your software.

b�� Select �Customize installation� and click Next.

c�� Click the Installation Options tab.

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

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

f��� Click Install Now.

4�� Configure Windows Explorer to show hidden files and folders.

5�� Start Microsoft Office Excel 2010. Then do the following.

a�� Activate the software, if prompted. After activation, the Welcome to the 2010 Microsoft Office System dialog box appears.

b�� Select �Don�t make changes.�

c�� Click Finish to close the dialog box.

6�� Disable Protected View settings for Excel as follows:

a�� From the File tab, click Options.

b�� Select Trust Center, and click Trust Center Settings.

c�� Select Protected View, and clear Enable Protected View for files originating from the Internet.

d�� Click OK twice to save settings.

e�� Close Excel.

7�� Start Internet Explorer and configure it to use Express Settings. When asked about Suggested Sites, choose No, don�t turn on. Close Explorer.

8�� If you have the data disc that came with this manual, locate the Student Data folder on it and copy it to the desktop of each student computer.

���� If you don�t have the data disc, you can download the Student Data files for the course:

a�� Connect to www.axzopress.com.

b�� Under Downloads, click Instructor-Led Training.

c�� Browse the subject categories to locate your 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) for downloading the Student Data files. You can download the files directly to student machines or to a central location on your own network.

e�� Create a folder named Student Data on the desktop of each student computer.

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

CertBlaster software

CertBlaster pre- and post-assessment software is available for this course. To download and install this free software, students should complete the following steps:

1�� Go to www.axzopress.com.

2�� Under Downloads, click CertBlaster.

3�� Click the link for Excel 2010.

4�� Save the .EXE file to a folder on your hard drive. (Note: If you skip this step, the CertBlaster software will not install correctly.)

5�� Click Start and choose Run.

6�� Click Browse and navigate to the folder that contains the .EXE file.

7�� Select the .EXE file and click Open.

8�� Click OK and follow the on-screen instructions. When prompted for the password, enter c_xl2010.

 

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.