Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?

Course Outline

Are you currently saving every Excel spreadsheet in a separate file? Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?

Attend this course if you want to:

Learn how to keep related spreadsheets in one workbook file.

Name worksheet pages for easy retrieval.

Change the color of worksheet tabs.

Insert, delete, and move worksheets to where you want them.

Change the default number of worksheets in new workbooks.

Copy a worksheet within a workbook or to another workbook (to use as a template for new data).

Group worksheets and simultaneously edit or format the data on all the worksheets.

Create formulas that span multiple worksheets.

Hide worksheets to reduce the number of worksheet tabs and prevent undesired viewing.

Print workbooks or selected sheets within the workbook.

Share workbooks with other users for simultaneous updates.

Assign a password to prevent unauthorized people from reading and/or editing the workbook.

Protect specific cells in a worksheet so they can't be modified until unprotected.

Hide formulas from others using the workbook.

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.

Reviews

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.

The course was perfect (for me) and was more than expected for an online program. Will be queuing up for the next one.
I would recommend to not be in the office while taking the course, as interruptions definitely take away from the presentation.

Reviewed byJeffrey T.2016

This was an online course so the facility, break times or presence/attire were not relevant, there should be a section that identifies this so you don't have to check off these areas.

Reviewed byFrank M.2014

No rating was given for items that didn't apply.
The flow of the course was great. Questions were answered fully. Danielle was knowledgeable, spoke clearly, and at a ideal speed. She left time for questions after every worksheet and made sure everyone was ready before moving on to next topic.

Reviewed byAndrea G.2014

Should be a N/A option for Facility feedback section, this course was done online. I indicated average, but I this is not accurate as I was not in a classroom setting.

Reviewed byNicole M.2014

She speaks INCREDIBLY fast and she moves quite quickly through the course material. I realize that she asked a number of times 'are there any questions?' but.. when she gives directions SLOW DOWN.
I realize taht this is a tips & tricks course, so there is an assumption that people have the knowledge. What I missed was an opportunity to talk about my current problems WITH 2 live projects and trying to track baselines etc.
I guess that is a separate course.

Reviewed bytammy f.2013

Good content !

Reviewed byLiana .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 byHayley 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 byGary 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 byMelissa 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 byLindsey 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 bySarah 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 byKerry B.2012

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

Reviewed byFanny 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 byNina 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 byLinda 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 byPhilip S.2011

Excellent Instructor

Reviewed byMarie-Josee T.2011

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.