Powered by KU Information Technology
  • Home
  • Excel - Intermediate

Excel - Intermediate

What you should already know: 

You should have basic computing skills (i.e. using a mouse and keyboard, formatting text, and saving and organizing files). Attendees should have a basic understanding of Excel including:

  • Deleting and renaming worksheets
  • Selecting content from an entire worksheet as well as content specific to a row or column
  • How to complete data entry using various keys (tab, arrows, enter)
  • Basic computing skills (i.e. using a mouse and keyboard, formatting text, and saving and organizing files)
What you will learn: 

By the end of class, attendees will understand how to work within the Excel environment to better leverage its functionality. This course will cover working with cell ranges and tables, creating data validation drop-down lists for data entry, conditional formatting, removing duplicate records, an introduction to more advanced functions, and creating and modifying charts and other visual elements. Attendees will be given the opportunity to work within Excel with instructor assistance so that real-world applications can be understood and practiced.

What you will need: 

For this course, attendees will need an active KU Online ID. No additional hardware, software, or account permissions are needed.

Course objectives: 

By the end of this course, attendees will be able to:

  • Sort and filter data in a cell range
  • Find and replace data in an Excel workbook
  • Create and manage tables
  • Use conditional logic to format cells.
  • Remove duplicate records using best practices
  • Create and format Charts.
Instructor-led Course Time: 
90 minutes
Course outline: 
  1. Microsoft Excel
    1. Intro
      1. Tour & Terminology
      2. Navigating & Selecting
    2. Cell ranges
      1. Sort & Filter data
      2. Find data
      3. Replace data
      4. Use split screens to access different parts of a worksheet.
    3. Data Validation
      1. Create a named range
      2. Use data validation for consistent data entry
      3. Introduction to Logical statements
      4. Conditional formatting
    4. Tables
      1. Create a table
      2. Sort & filter table data
      3. Use table references in formulas and functions
    5. Duplicate records
      1. Identify duplicate records
      2. Remove duplicates
    6. Charts
      1. Group rows and columns
      2. Create charts
      3. Create Sparklines
      4. Create SmartArt
  2. Review
  3. Wrap-up

 

Software tag: 
Audience tag: 

Link to KU IT's YouTube  Powered by KU IT 

Training Workshops

KU faculty, staff and students can sign up for courses at no cost at workshops.ku.edu.

Share your feedback

Would you like to see added or updated content on this site? Let us know by completing this quick form.