Excel Introduction

Who should attend

This Excel Introduction class is for anyone who would like to learn how to build and format spreadsheets with functions and formulas between cells.
Team Pass by Learnit

Excel Introduction

From $0
Two, 2-hour Modules (9am - 11:30am PT)

Excel basics class with hands-on training in how to build and format spreadsheets that use functions and formulas between cells.

Course ID
EXCELIFaOc
Upcoming LIVE ONLINE public classes
No Upcoming public classes
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Interested in a private
workshop for your company?

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Course Outline

Module 1: Excel Essentials & Formulas and Functions

Topics:

  • Introduction to the Excel Interface
  • Search & Help
  • Smart Lookup
  • Zooming
  • Navigating and Selecting Cells
  • Keyboard Shortcuts
  • Deleting/Replacing Cell Data
  • Performing Simple Calculations
  • Saving the Workbook File
  • Overview of The Formulas Ribbon
  • Building Basic Formulas
  • Using Simple Functions
  • Formulas/Functions with the Autofill Command
  • Relative and Absolute Cell References

Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

Topics:

  • Inserting Rows & Columns
  • Moving, Copying and Pasting Data
  • Using Autofill to Complete A Series of Values
  • Formatting Worksheet Data/Using Cell Styles
  • Introduction to Worksheet Themes
  • Creating Custom Templates
  • Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy
  • Grouping Worksheets
  • Freezing or Splitting Panes
  • Grouping and Hiding Rows/Columns
  • Creating Custom Views
  • Spell Checking Your Worksheets
  • Setting Print Options
  • Using the Page Layout View
  • Printing Your Worksheet

What We'll Explore:

  • Be able to Navigate Excel and create spreadsheets
  • Be able to use excel's basic functions (sum, max, min, avg)
  • Select cells and sheets using keyboard shortcuts
  • Be able to edit a spreadsheet by adding columns and rows
  • Creating reusable fonts, and formats in workbooks by saving them as templates
  • Adjust settings for workbook so its suitable for printing? using print options in Excel

Skills covered

No items found.

Excel Introduction

Reviews

"Facing fear in using the program, I now have some knowledge in using and manipulating the program, and I can do my job quicker."

Mai B.
Mai B.

"Mo is a great instructor and showed great examples to help us learn the material. It made the class fun. Thank you!"

Jeanette D.
Jeanette D.

"Thank you, Dave. Best webinar training I've attended in a long time! Also appreciated being able to participate with hands-on spreadsheets."

Fanchon S.
Fanchon S.

"This was Excellent. Thank you very much! You are a fantastic teacher!"

Janay Y.
Janay Y.

"I learned so much, can't list it all. I was taking the long road home using Excel. ☺"

Phyllis L.
Phyllis L.