Excel Introduction

Who should attend

This class is for anyone who would like a foundational understanding of how to create, edit, and present spreadsheets, data sets and formulas.

Team Pass by Learnit

Excel Introduction

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

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

Course ID
EXCELIFaOc
Available times
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

Course Outline

Module 1: Excel Essentials & Intro to Formulas and Functions

Learning Outcomes:?

1. Be able to Navigate Excel and create spreadsheets

2. Be able to use excels basic functions (sum, max, min, avg)

3. Select cells and sheets using keyboard shortcuts

  • 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

Learning Outcomes:

1. Be able to edit a spreadsheet by adding columns and rows

2. Creating reusable fonts, and formats in workbooks by saving them as templates

3. Adjust settings for workbook so its suitable for printing? using print options in Excel

  • 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

Skills covered

No items found.