Excel 2007 Intermediate

Enhance your Excel skills with advanced techniques like using multiple sheets, creating charts, and more. Perfect for users looking to deepen their proficiency.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course takes your Excel skills up a notch! You’ll learn to work with multiple sheets, create formulas, and master charts while having a blast. Think of it as leveling up your spreadsheet game!

Key Points

  • Use multiple worksheets in a workbook
  • Create formulas across multiple sheets
  • Utilize range names for better organization
  • Master charts and drawing tools for annotation
  • Understand Paste Special options

Learning Outcomes

  • Efficiently manage and navigate multiple worksheets
  • Apply advanced formulas across sheets to enhance data analysis
  • Create visual charts and annotations for clearer presentation
  • Use templates and outlines for organized data handling
  • Gain knowledge for 2.25 recertification points

About This Course

Expand your Excel abilities with charts, outlines, workbooks and much more

This course is designed to expand on the skills learned in the Introduction to Excel 2007 training. Specifically this class will focus on using multiple sheets in a workbook, the advantages of working with range names, creating and applying spreadsheet templates, using the outline features and creating subtotals, and understanding all the options found in Paste Special. A significant amount of the course will be spent covering creating and manipulating charts and using drawing tools to annotate charts and spreadsheets.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.


This course aligns with the CAP Body of Knowledge and should be approved for 2.25 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.


  • Use multiple worksheets in a workbook

  • Create formulas across multiple sheets

  • Use the watch window

Course Curriculum

1 Lectures

1 Lectures

Instructor

Profile photo of Intellezy Trainers
Intellezy Trainers

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individualsOur library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need...

More Courses By Intellezy Trainers
Review
4.9 course rating
4K ratings
ui-avatar of Priyongsu Borthakur
Priyongsu B.
4.5
5 years ago

Yes

  • Helpful
  • Not helpful
ui-avatar of Manu Kapoor
Manu K.
4.0
5 years ago

Yes indeed. I learnt about several nuances of MS Excel which I was not aware of previously. However, one of my questions have not been answered yet.

  • Helpful
  • Not helpful
ui-avatar of Fred Vanderburgh
Fred V.
5.0
5 years ago

I've used Excel for over 25 years and never used any of the features in this class. I wish I knew about them for all those years. The instruction was clear and enjoyable to follow.

  • Helpful
  • Not helpful
ui-avatar of Anonymized User
Anonymized U.
3.5
8 years ago

Could've been better if there was a downloadable excel file where we can play around while following through the discussion. That way, we can go straight to application.

  • Helpful
  • Not helpful
ui-avatar of Kwang Seat Lan
Kwang S. L.
5.0
9 years ago

This is a great course! All the information provided was very useful, accessible, and actionable. I'm so glad I stuck it out with this course.

  • Helpful
  • Not helpful
ui-avatar of Beth Grimm
Beth G.
4.0
9 years ago

Content was very concise and the instructor was engaging, presenting the information in a clear way. I look forward to the advanced course!

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses