Excel 2007 Tables

Do you spend a lot of time searching for data in large spreadsheets? Would you like to perform database functions such as filtering, subtotaling, and sorting directly in your Excel spreadsheet?

Course Outline

Do you spend a lot of time searching for data in large spreadsheets? Would you like to perform database functions such as filtering, subtotaling, and sorting directly in your Excel spreadsheet?

Learn table design techniques, as well as procedures to sort, filter, and validate data. You will also learn to use formulas in tables and remove duplicate records.

Attend this course if you want to:

• Learn the "rules" of designing an Excel table.

• Define a range of cells into a table.

• Freeze row or column titles so they don't disappear as you scroll.

• Use table styles to change the look of your table quickly and easily.

• Use formulas in tables.

• Remove duplicate records from a table.

• Sort data alphabetically or numerically.

• Filter data to display a subset of the data.

• Set up data validation criteria to prevent data entry errors.

• Convert a table back to a normal cell range.

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

Additional Details

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.

   

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