Is your salary on par with others in your field? Learn more in Skillsoft's 2024 IT Skills and Salary Report. Click Here.

MyGK
Support
USA USA - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Contact Sales
Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

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

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.

GK# 7119 Vendor# EXCL1 Level 1
Vendor Credits:
  • Global Knowledge Delivered Course
  • Training Exclusives
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
Access Period:
No available dates
Add To Cart

BUY NOW

Request a quote

Is This The Right Course?

The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.

Who Should Attend?

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.

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
BUY NOW

Labs Outline
  • Formatting Rows and Columns
  • Search and Replace
  • Borders and Colors
  • Align Contents
  • Functions
  • Format Tabs
  • Manage Multiple Workbooks
  • Custom the Excel Environment
BUY NOW

Prerequisites

The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.