Excel 2007 - Level 1

In this course, you will create & edit basic formulas in worksheets & workbooks as well as learn basic formulas & functions, adding/deleting columns, adjusting heights and widths, learn about absolute references, formatting, templates, and more.

Course Outline

Course Objective
You will create and edit basic formulas in Microsoft® Office Excel® 2007 worksheets and workbooks as well as learn basic formulas and functions, adding/deleting columns, adjusting heights and widths, learn about absolute references, formatting, templates and much more.

Target Student
This course is designed for people who are new to Excel or not familiar with formulas and functions.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• explore the Excel 2007 environment
• create a basic worksheet
• modify a worksheet
• perform calculations
• format a worksheet
• develop a workbook
• print workbook contents
• customize the layout of the Excel application window

Course Content

Lesson 1: The Fundamentals

• Explore the Ribbon
• Obtain Help
• Customize the Quick Access Toolbar

Lesson 2: Worksheet Basics

• Creating and Opening a Workbook
• Navigating in a Worksheet
• Select and Enter Data
• Performing Calculations
• Understanding Absolute and Relative Cell References
• Using Autofill
• Using Undo and Redo
• Saving, Previewing and Printing a Workbook

Lesson 3: Editing a Worksheet

• Editing Cell Data
• Cutting, Copying and Pasting Cell Data
• Using the Paste Special Command
• Spell Check a Worksheet
• Insert and Delete Cells, Columns, and Rows
• Using Find and Replace Commands
• Using Comment
• Track Changes

Lesson 4: Formatting a Worksheet

• Formatting Labels and Values
• Adjusting Row Height and Column Width
• Working with Cell Alignment
• Adding Borders, Background Colours and Patterns
• Using Format Painter
• Using Cell Styles and Document Themes
• Applying Conditional Formatting
• Find and Replace Formatting

Lesson 5: Managing Workbooks

• Viewing a Workbook
• Working with the Workbook Window
• Splitting and Freezing a Workbook Window
• Selecting Worksheets
• Inserting and Deleting Worksheets
• Renaming, Moving and Copying Worksheets
• Working with Multiple Workbooks
• Hiding Rows, Columns, Worksheets and Windows
• Protecting a Workbook, Worksheet and Worksheet Elements
• Sharing a Workbook
• Creating a Template

Lesson 6: Working with Page Layout and Printing

• Creating Headers and Footers
• Set Page Breaks
• Adjusting Margins and Orientation
• Adjusting Size and Scale
• Adding Print Titles, Gridlines and Headings
• Advanced Printing Options

Additional Details

Pre-Requisites

To ensure your success, we recommend that you know how to use a mouse comfortably as well as understand Windows Explorer. If you are not familiar with this, then we suggest that you take an Introduction to Computers.

Certificates offered

Certificate of Completion

Cancellation Policy

You may cancel or reschedule your registration without penalty up to 5 days before your class date. Presidio reserves the right to change or cancel courses up to 2 days prior to the class start date, due to insufficient enrollment or extenuating circumstances. You will be notified at that time in writing of such change or cancellation.

Materials and Certificates Received with Course:
All students receive a course manual and Certificate of Completion. Included with the courses is the use of our kitchen facility which is stocked with snacks, various teas and coffees.

Vendor Information:
Presidio has over 10 years of experience offering training in the adult education environment. We keep the attendance in our courses small so that every person has a chance to participate. Our average size is 5 people and usually not larger than 8. Course start at 8:30 but our doors are open and coffee is on at 8:00am. All training is hands-on and everyone receives a manual to keep. Post support is available at no charge.

We are centrally located in a modern facility in the historic Exchange District. Access is easy by any method of transportation as we are only blocks away from major routes for Winnipeg Transit as well as offer paid parking right outside our door to motorists. Our training rooms are fully networked systems with high-speed internet access and use video projection overhead systems.

Map & Reviews

Presidio Learning Center
[ View Provider's Profile ]

Presidio Learning Center
8-90 Market Avenue
Winnipeg, Manitoba
Canada    R3B 0P3

Reviews

 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

   

It would have been nice for the instructor to tailor make the course for this class. Most if not all of the people attending the course were more interested in the "making forms" aspect of the course and not the "printing" part. He seemed to be having an off day, and for that I felt bad for him. However, he could have picked up on the fact we were all interested in learning more about forms and offer to spend more time there instead. His knowledge of the Adobe Forms was average and I was hoping for someone more experienced to teach the course. I still got quite a bit out of the course and was happy I went....even though I may not attend another course there.

Reviewed by Cathy F. 2012

   

Since I signed up for an "Acrobat" class, I thought that the time spent on developing a form in "Live Cycle" was not appropriate. Most of us in the class did not have this software at our home/office. Plus, too much time was spent on colour separations and pre-press and nobody was there to learn this. The malfunctions or misplacement of the instructor's computer/folders was not worked out before the class which, if they had been, could have improved the class experience. On the positive side, the class did open my eyes to what you could do with forms.

Reviewed by Joyce R. 2012

   

Presidio is fantastic no-frills software training. I would gladly recommend them.

Reviewed by Jordan D. 2012

   

Instructor needs more hands on Excel Level 2 type situations in order to answer questions presented by students with more confidence. The instructor seemed to be learning as we went along. Overall still a beneficial experience.

Reviewed by Jason C. 2012

   

The training provider was good but sometimes I felt he moved too quickly through the course. I understand that there was alot to cover, so I feel that maybe it should have been a longer course. Most of the people on this course had already taken some type of this course before, but this was my first time working with any type of spreadsheets at all. It was sometimes overwhelming. I just might take the course again soon.

Reviewed by Jenny J. 2012

   

I wasn't greeted at the door on arrival and had to find someone to ask what room I was supposed to be in. There was another instructor who arrived the same time as I did, but she was more concerned about looking after another client who was in the office. She didn't even bother asking what class I was scheduled to take. I view this as poor customer service. After waiting around for 15 minutes or more, I went to the back of the office to find someone to assist me. Once we got into the session, I discovered that the Excel 2010 did not cover anything to do with InfoPath - which was my main reason for attending. While I learned a few things about Excel 2010, I did not get answers to many questions I had regarding InfoPath. Following the session, I called the office and requested the class examples that were used be sent to me - I also noted this on the evaluation sheet. As well, I asked for step-by-step instructions for inserting additional icons on the Tool Bar when doing Excel documents. The person who answered the phone said she would pass my request on to Christina Bower, who was not available when I called. To date, I have not received anything from Presidio.

Reviewed by Bernice P. 2011

   

An exercise at the end that tied everything together would have been a nice addition to the course.

Reviewed by Travis R. 2011

   

This seminar was for people with experience using quickbooks, defintiely not for beginners. I don't believe the seminar description properly described this. By 10:30 am, I was completely lost.

Reviewed by Rhonda P. 2011

   

If you have used Excel more than once DO NOT take Level one! I wish someone would have told me that. All you are taught is how to navigate excel.

Reviewed by Melanie M. 2011

   

Course info was very helpful - instructor provided real work examples and work arounds.

Reviewed by Linda H. 2011

   

Instructor was very knowledgeable and patient. Atmosphere was friendly and welcoming.

Reviewed by Nishadi G. 2011

   

I received a photocopy of the manual which wasn't as clear as the original manuals--I was a last minute registrant who got a discount price and this was pointed out--even that I didn't have the same options as the other two did because I booked through Last Minute. The other two who booked, booked through presidio and if they felt they didn't absorb enought during the course that day they could come back for a refresher for free. This was mentioned a few times. The Instructor knew the content inside and out and was very knowlegeable on the software. The 15 minute breaks could have been shortened and the content that was covered could have been presented in a slower manner. I was able to keep up, but the material was rushed through at times.

Reviewed by Colette F. 2011

   

the book says I download the course material and I can't find it. It also says I was to receive a CD didnt receive a CD

Reviewed by Linda R. 2011

   

The course itself was good. The instructor seemed more intent on discussing topics not related to the course material i.e. riots in BC, SQL and how hackers got in etc. The computer programs did not work the majority of the time. The instructor did very little to resolve the issues.

Reviewed by Ruth K. 2011

   

The course was well run, very informative and very hands on whick is really nice. The only comment I could make is the room was small and the overhead screen a little hard on the eyes due to lighting. I would definitely consider taking another course.

Reviewed by Laura H. 2011

   

Exercises are really good and relavent to the material being taught. The instructor really cares about your experience and understanding of the material.

Reviewed by Marcy A. 2011

   

This was an excellent program! The instructor was very knowledgeable. She had extra tips on hand outs and made sure that all in the class understood. I am thirsty for more training now.

Reviewed by Kelly C. 2011

   

I realize this is a 1 day course to make you familiar with the program. But not enough time to cover the information without rushing. The instructor knew this and was very helpful and showed genuwine interest in our understanding/progress even in a rush.

Reviewed by Marcy A. 2011

   

I totally enjoyed this training. The class size was small which made it very easy to understand each new point. The presenter has a great personality and was extremely helpful. I would recommend this training any day!

Reviewed by Sharon . 2011

   

I enjoyed this session more than level 2. The only problem was that the chairs were so uncomfortable. My back still hurts today.

Reviewed by Pam L. 2011

   

I felt the class was not completely professional. There was a lot of joking between the teacher & students & I did not completely enjoy the atmosphere.

Reviewed by Pam L. 2011

   

It was alot of information to take in one day, it's too bad that you can't provide this training over a longer period of time such as in the evenings for a number of weeks or in short time frame such as a 2-3 day period.

Reviewed by Marina W. 2011

   

I found the course to be very helpful. Learned alot in a 1 day course.

Reviewed by Shelley G. 2011