Microsoft Excel 2016: (A) Fundamentals - EOD

Back to List

Course: 2112851 - Microsoft Excel 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the fundamentals of Microsoft Excel and the basic functions of spreadsheets. Create and save workbooks; apply text and number formatting; select, move, copy, and delete data. Apply borders, cell styles and other formatting to rows, columns, cells, and tables. Learn how to write formulas and use common functions. Explore page layout and printing options for worksheets. Check spelling, search for and replace data, and save worksheets in alternate file formats.

Prerequisites

Course Outline

  • Identifying the Elements of the Excel Interface
  • Creating a Basic Worksheet
  • Creating Formulas in Worksheets
  • Inserting Functions in Worksheets
  • Reusing Formulas
  • Creating Relative, Absolute, and References
  • Manipulating Data, Cells, Columns and Rows
  • Searching For and Replace Data
  • Checking Spelling
  • Modifying Fonts
  • Adding Borders, Colors, and Sheet Backgrounds
  • Applying Number Formats
  • Aligning Cell Contents
  • Using Indent, Wrap Text, Orientation, and Merge & Center Options
  • Applying Cell Styles
  • Defining the Basic Page Layout and Print Options for a Workbook
  • Creating Headers and Footers
  • Adjusting Page Margins and Page Orientation
  • Refining the Page Layout
  • Applying Print Options
Course Type: In Classroom
CEU: 0.60
Sections:
Section#: 4575
Section Meeting Dates and Times:
10/2/2017: 1:30 PM - 4:30 PM
10/3/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description:


Section#: 4614
Section Meeting Dates and Times:
11/15/2017: 1:30 PM - 4:30 PM
11/16/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2203
General Services Complex (GSC)
750 Agronomy Rd.
Description:

Category: Technology Training - Spreadsheets

Register and View Schedule

Add to Course Waitlist