Excel 2007 Tips and Shortcuts

Are you using the fastest methods to accomplish tasks in Excel 2007? Could you use some of Excel's advanced features to automate certain tasks? Learn various tips & shortcuts that will make you more efficient when working with Excel

Course Outline

Are you using the fastest methods to accomplish tasks in Excel 2007? Could you use some of Excel's advanced features to automate certain tasks? Would you like your spreadsheets to look more professional?

Learn various tips and shortcuts that will make you more efficient when working with Excel

Attend this course if you want to:

• Freeze the headings on your worksheet so that they remain visible as you scroll.

• Split the screen to display non-adjacent areas of your worksheet simultaneously.

• Add a comment to a cell to make a note to yourself or other users.

• View a worksheet in Full Screen mode.

• View calculated values in the status bar.

• Customize the information that displays in the status bar.

• Highlight all cells that contain formulas or all cells that contain values.

• View the formulas in a worksheet, rather than formula results.

• Audit a worksheet.

• Choose whether to recalculate formulas manually or automatically.

• Name a cell or range of cells that you use often.

• Quickly enter a series of data (e.g., days of the week, years, numbers).

• Find and replace specific data in a worksheet.

• Learn how to enter fractions in a cell, enter the same data in more than one cell, and enter the current date or time.

• Use hyperlinks to jump to another cell, file, or Web page.

• Add pictures, clip art, and SmartArt diagrams to a worksheet.

• Choose how often Excel automatically backs up your data (for recovery in case of a crash).

• Save multiple workbooks in a workspace.

• Download templates from Microsoft's Web site.

This course can ALSO be taught one-on-one or as a private, dedicated virtual classroom - call 877-313-8881 for more information.

Prerequisites & Certificates

Pre-Requisites

Comfortable with general Excel capabilities. Comfortable with basic functions, formulas, and formatting in Excel.

Certificates offered

Certificate of completion

Cancellation Policy

If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.

Map & Reviews

Elert & Associates Technology Training
[ View Provider's Profile ]

On Line Instructor Led
Your Home or Office
Your City, Your Province
Your Country   --- ---

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

Good content !

Reviewed by Liana . 2013

   

My only complaint was the time, I live in the Pacific time zone and 6am is an early start time, an afternoon east coast option would be nice.

Reviewed by Hayley C. 2013

   

The course was excellent, as was the instructor (Danielle). The only issue I have is the timing. Being located in Ottawa, Canada I started the course at 4:00 pm and finished at 5:30, which required me to make special daycare arrangements. These 1.5 hour courses should start at 2:30 pm Eastern Time at the latest.

Reviewed by Gary P. 2012

   

Felt like a lot of info for a 1.5 hour course. 2 hours might have been better and would have allowed more time for questions. I did an online course so many of the questions asked above do not apply. There is no "N/A" option. Anything I gave half a star is for this reason.

Reviewed by Melissa S. 2012

   

Some ratings were not applicable ie. Faciltiy since this was a virtual course. Excellent Instructor - very knowledgeable. Course only focused on two form types - the form type I was interested in was not covered. A suggestion would be to offer a course that covers all forms types or offer an additional course that covers form types not included in this course.

Reviewed by Lindsey W. 2012

   

The trainer explained everything in a simple way and gave us the right amount of time to try everything ourselves as well. She had a friendly attitude and also paused from time to time to ask us if we had any questions. All in all a good experience.

Reviewed by Sarah S. 2012

   

I did the online course and found it awesome! The instructor was very knowledgeable and extremely helpful I finished the course feeling I got my money's worth and then some. Thank you Survey is stupid as it does not take into consideration I was an online course - has mandatory fields not applicable to me.

Reviewed by Kerry B. 2012

   

There is not enough time to cover all the materials needed in the private course

Reviewed by Fanny L. 2011

   

Please note that I attended this course via Webinar so the facility rating is not applicable. Also not applicable is the Break Times rating since the course was only an hour and a half. I suggest you add an N/A column to your rating sheet.

Reviewed by Nina P. 2011

   

I liked the virtual training. So much easier to fit into my schedule. Did miss the interaction though. There were very little questions asked in both this one and the Powerpoint one. In the Excel presentation, I really liked that the trainer muted everyone. This wasn't the case with the power point one. There were baby noises in the background. Very disruptive and inconsiderate.

Reviewed by Linda H. 2011

   

My course was online so any ratings about the facility or instructor attire are not accurate but I can't turn this in without filling them out.

Reviewed by Philip S. 2011

   

Excellent Instructor

Reviewed by Marie-Josee T. 2011