Name: Excel Intermediate
Best Seller
Overall Rating: 4.9 out of 5 (17 ratings)
Category: All Learners
Duration: 4.00 hour(s)
Individual Fee: $75.00

Excel intermediate will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of data presentation skills though printing and creating charts as well as becoming more efficient and organized.

This course will be taught using Microsoft Excel Desktop but is applicable to older versions which may not have some of the newer features.

This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.

  • Print worksheets
  • Use templates
  • Work with multiple worksheets
  • Apply conditional formatting
  • Create charts

Topics

Printing Worksheets

  • Exploring page setup options
  • Adjust Margins
  • Set the page orientation
  • Scaling
  • Working with page breaks
  • Page break views
  • Creating headers and footers
  • Setting print options
  • Setting the print area
  • Printing the worksheet

Using Templates

  • Using on-line templates
  • Creating custom templates
  • Use a template to create a new workbook
  • Edit a template
  • Sharing Templates

Working with Multiple Worksheets

  • Changing the default number of worksheets
  • Inserting and deleting worksheets
  • Formatting worksheet tabs
  • Move or copy worksheets
  • Selecting worksheets
  • Freeze panes

Applying Conditional Formatting

  • Basic conditional formatting
  • Advanced conditional formatting

Creating Charts

  • Creating a chart
  • Parts of a chart
  • Changing the chart type
  • Switching data
  • Changing the chart style
  • Moving a chart to a chart sheet

SkillPrerequisiteExpected Outcome
Excel1 - BeginnerNot specified
Excel Intermediate1 - BeginnerNot specified
Class Costs
Class Value$125.00
Individual Fee$75.00
Private Class Fee$0.00
4.9 out of 5 (17 ratings)

Great Class! Thu, Jun 22, 2023
Another great class with good instructions and lots of tips for ways to use your time wisely.
Intermediate Excel Training Thu, Jun 1, 2023
The presenter of the class was very detailed and explained clearly.
Great class, highly recommended Wed, May 31, 2023
I am a basic Excel person but this class just took me to another level of what I can do in Excel. The presenter was extremely patient, thorough and took her time to explain and allow us to all understand. it was a perfect class for a refresher or for someone like me who only had basic knowledge. Highly recommended.
[See all User Reviews…]