Course Details:
Microsoft Excel – Level 1 / Intro (2010, 2013, 2016, 2019)

<< Back to courses

Course Overview:

Learn to create, format, enhance and print simple Excel spreadsheets.

This course is intended to help users get up to speed with Excel quickly. We will cover different features of the interface, the basics of formatting and editing, the basics of building formulas and functions and show users how to print.

 

What You'll Learn

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will:

  • Modifying a Worksheet
  • Formatting a Worksheet
  • Performing Calculations
  • Basic Charts
  • Printing Workbook Contents
  • Refine the Page Layout and Apply Print Options
  • Customizing the Excel Environment
 

Course Outline

Getting Started with Microsoft Excel

  • Identity the Elements of Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Modifying a Worksheet

  • Manipulate Data
  • Search for the Replace Data
  • Spell Check a Worksheet

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Colors to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apple Styles

Performing Calculations

  • Create Formulas in a worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts

Printing Workbook Contents

  • Refine the Page Layout and Apply Print Options

Refine the Page Layout and Apply Print Options

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks

Customizing the Excel Environment

  • Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Customize the Advanced and Trust Center Options
 

Labs Outline

  • Formatting Rows and Columns
  • Search and Replace
  • Borders and Colors
  • Align Contents
  • Functions
  • Format Tabs
  • Manage Multiple Workbooks
  • Custom the Excel Environment
Course Title
Microsoft Excel – Level 1 / Intro (2010, 2013, 2016, 2019)
Course Number
7119
Duration
1 day
Price
$295.00