Powered by KU Information Technology
  • Home
  • Excel – Basics

Excel – Basics

What you should already know: 

Attendees should have a basic computing skills:

  • 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 creating and organizing worksheets and workbooks as well as creating formulas and functions that are commonly used in day-to-day activities. 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:

  • Manage and create workbooks and worksheets.
  • Navigate through the Excel environment to find specific data
  • Format worksheets and workbooks using themes and page setup
  • Understand how to use Auto-fill and Flash-Fill.
  • Format cells and ranges.
  • Understand the differences between formulas and functions
  • Create formulas and functions.
Instructor-led Course Time: 
90 minutes
Course outline: 
  1. Intro
    1. What is Excel?
    2. Navigating & Selecting
    3. Tour & Terminology
  2. Create new workbook
    1. Templates
    2. Cell Basics
    3. Row & Column Basics
    4. Page Layout
    5. Themes
    6. Entering Content
    7. Formatting Content
  3. More ways to enter data
    1. Autofill & Flashfill
  4. Functions & Formulas
    1. What are formulas?
    2. What are functions?
    3. Relative, absolute & mixed references
  5. Review
  6. Wrap-up

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.