Excel 2010: Basic (First Look Edition)

Excel 2010:

Basic (First Look Edition)

Frequently asked questions and instructor notes

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.