Excel 2010:

Basic (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:

·   A keyboard and a mouse

·   1 GHz  processor (or faster)

·   1 GB RAM (or higher)

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

·   CD or DVD drive

·   SVGA monitor at 1024 × 768 or higher resolution

Software requirements

You will need the following software:

·   Microsoft Windows 7

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

·   Adobe Reader

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

   Opening Help files at Microsoft Office Online (If online Help is not available, students will not be able to complete Activity C-1 in the unit titled “Getting started.”)

   Downloading the Student Data files from www.axzopress.com

   Downloading the PowerPoint files from www.axzopress.com

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 also use Windows Vista or Windows XP, but the screen shots in this course were taken in Windows 7, so students’ screens will look different.

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   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 and click Continue.

b   At the next screen, click Customize.

c   Click the Installation Options tab.

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   On the last screen of the Office 2010 installer, click Continue Online. Internet Explorer displays the Office Online Web site, and the installer window closes.

h   On the Office Online Web page, click the Downloads tab. Download and install any available updates. 

i    Close Internet Explorer.

4   Install Adobe Reader.

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

b   Click Download.

c   If a notification appears at the top of the browser window, click it and choose Run Add-on.

5   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.

     Note: The Student Data files are available via download only. There is no CD included with this Instructor’s Edition.

6   Start Microsoft Office Excel 2010. Then do the following:

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

b   Select “Don’t make changes” and click Finish.

7   Disable Protected View settings for Excel as follows:

a   On 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 the settings. Close Excel. 

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.