Excel Intermediate with Tables, Worksheets, Protection and Charting

Return to Search page:
Name: Excel Intermediate with Tables, Worksheets, Protection and Charting
Overall Rating: 4.5 out of 5 (4 ratings)
Category: All Learners
Duration: 4.00 hour(s)

Excel Intermediate with Tables, Worksheets, Protection and Charting continues where you left off with Excel Fundamentals with Formulas, Formatting and Printing. This workshop will expand your Excel knowledge to create tables, rules, tables and much more. 


This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Contact: Eric Pfligler
847-543-2990
CorporateTraining@clcillinois.edu
https://calendly.com/tadmeeting/tad-employer-demo
Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.
  • Insert, delete, rename, color, move and copy worksheets
  • Use conditional formatting
  • Sort columns
  • filter and format tables
  • Create rules
  • Protect workbooks and worksheets
  • Convert Text data to column data
  • Create subtotals
  • Freezing rows and columns 
  • Work with charts
Topics
  • Working with Worksheets
    • Inserting
    • Deleting
    • Renaming
    • Coloring Tabs
    • Moving and Copying
  • Applying Conditional Formatting
  • Clearing Conditional Formatting
  • Sort an Individual Column
  • Sort Multiple Columns
  • Filter a Table
  • Format as a Table
  • Formatting Tables
  • Excel Data Validation
    • Create a Rule for a Text String in Data Validation
    • Create a Rule for a Number in Data Validation
    • Create a Rule for a Date in Data Validation
    • Create a Rule for a Short Drop Down List in Data Validation
    • Create a Rule for a Long Drop Down List in Data Validation
  • Protect Workbook Structure
  • Protect the Worksheet
  • Converting Text Data to Column Data
  • Create Subtotals in a Table Structure
  • Add an Additional Calculation in a Subtotal
  • Remove Subtotals
  • Freezing a Row or Column
  • Splitting Panes
  • Creating Cell Comments
  • Editing Cell Comments
  • Deleting Cell Comments
  • Creating charts
  • Moving Charts
  • Changing Chart Types
  • Chart Quick Layouts
  • Adding/Formatting Individual Chart Elements

SkillPrerequisiteExpected Outcome
Excel Intermediate1 - BeginnerNot specified

Audrey Minkalis

Class Costs
Class ValueNo Charge
Individual Fee$0.00
Private Class Fee$0.00
4.5 out of 5 (4 ratings)
Excel Intermediate Tue, Mar 22, 2022
I learned a lot of new things. Extremely helpful and very appreciative this is free of charge! Thank you!
Excel Workshop Tue, Mar 22, 2022
The workshop was very informative and a great refresher.
Excel Training Tue, Mar 22, 2022
The Excel class was excellent. Audrey is very patient and informative.
[See all User Reviews…]

Return to Search page:
Copyright ©1998-2024, Business Talent Solutions, LLC. All Rights Reserved.