Microsoft Excel Introduction

Level: Foundation
RATING: 4.7/5 4.71/5 Based on 309 Reviews

Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually, and present summary information in a consumable and professional format.

Key Features of this Microsoft Excel Introduction Training:

  • Choose from on-demand and instructor-led blended learning options
  • Exclusive LinkedIn group membership for peer and SME community support

You Will Learn How To:

  • Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
  • Optimize your worksheets using templates, graphs, and formulas
  • Design simple to complex formulas by nesting Excel functions
  • Import, fine-tune, and share Excel data
  • Create, manage, and launch macros

Certifications/Credits:

CPE 17 Credits

Choose the Excel Training Solution That Best Fits Your Needs

BLENDED LEARNING

On-Demand & Live Review Session

Unlimited annual access to:

  • Library of on-demand courses
  • 1-day instructor-led review sessions
View Bundle Details & Schedule

Standard $1090/Year

Government $1090/Year

ADD TO CART

PRODUCT #70B0

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 3-day instructor-led training course
  • One-on-one after-course instructor coaching
  • After-course computing sandbox included
  • Learning Tree end-of-course exam included
  • Earn 17 NASBA credits (live, in-class training only)
  • Pay later by invoice -OR- at the time of checkout by credit card
View Course Details & Schedule

Standard $1950

Government $1950

RESERVE SEAT

PRODUCT #1361

UNLIMITED ACCESS BUNDLE

Unlimited Access Blended Training — Best Value!

  • Library of on-demand courses
  • 3-day instructor-led training course
  • 1-day instructor-led review sessions
  • After-course instructor coaching benefit
  • After-course computing sandbox included
  • Learning Tree end-of-course exam included
View Bundle Details & Schedule

Standard $2450/Year

Government $2450/Year

ADD TO CART

PRODUCT #70B1

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organization
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience

CONTACT US

Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

On-Demand & Live Review Session

Microsoft Excel Introduction Blended Training Information

  • Microsoft Excel Introduction Blended Learning Description

    This product offers access to a library of Microsoft Office on-demand courses including Excel, Word, PowerPoint, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating and Designing Excel Workbooks (4610).

On-Demand Training Outline

  • On-Demand Course List

    • Access 2016 Essentials
    • Excel 2016 Essentials
    • Excel 2016 Essentials for Mac
    • Excel 2016 Advanced
    • Excel Charts and Pivot Tables
    • Excel Functions
    • Relational Database Design
    • PowerPoint 2016
    • Advanced PowerPoint 2016
    • PowerPoint for Mac
    • Advanced PowerPoint for Mac
    • Outlook 2016
    • Outlook on the Web
    • Word 2016 Essentials
    • Word 2016 Advanced
    • Word 2016 Expert
    • Word 2016 Mail Merge
    • Word 2016 Essentials for Mac
    • Word 2016 Advanced for Mac
    • Word 2016 Expert for Mac
    • Word 2016 Mail Merge for Mac
    • End User Security Awareness
    • Skype for Business

Microsoft Excel Training FAQs

  • What background do I need?

    No specific experience is required.

  • Is the on-demand content the same as the 3-day instructor class?

    No. While many of the same points are covered, taking the instructor-led Introduction to Microsoft Excel course provides the deepest dive into that area. This offering is indented for those who wish to gain a broad knowledge of the topics described in the course outline above - including Excel.

  • How can I sign up for a review session?

    Once you are enrolled in the program, specific details and dates will be sent to you.

  • What on-demand content will I receive?

    An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrollment period.

  • How will I access my course materials if I choose this method?

    Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.

One Day Instructor-Led Review

You'll be able to register for a Training Review Session at any time after you've placed your order.

  • Nov 27 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Dec 17 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Jan 14 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Feb 4 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Mar 4 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Apr 3 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • May 7 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Jun 3 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Jul 9 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Aug 6 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Sep 10 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)

In Class & Live, Online Training

  • Oct 24 - 26 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Dec 5 - 7 ( 3 Days)
    9:00 AM - 4:30 PM EST
    Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

  • Jan 14 - 16 ( 3 Days)
    9:00 AM - 4:30 PM EST
    Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Jan 30 - Feb 1 ( 3 Days)
    9:00 AM - 4:30 PM EST
    New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Feb 20 - 22 ( 3 Days)
    9:00 AM - 4:30 PM EST
    Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

  • Apr 24 - 26 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • May 22 - 24 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Jul 15 - 17 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Aug 19 - 21 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Microsoft Excel Introduction Instructor-Led Course Information

  • Microsoft Excel Introduction Training Course Description

    In this introductory course, you learn how to summarize data with Excel by incorporating formulas, formatting, and charts and graphs. You also gain the skills to efficiently navigate and manipulate multiple spreadsheets in a workbook, optimize your worksheets using templates, graphs and formulas, and design simple-to-complex formulas by nesting Excel functions.

  • Requirements

    • Familiarity working in Microsoft Windows
  • Software

    • This course is applicable to all versions of Excel, from Excel 97 to Excel 2016

Microsoft Excel Introduction Instructor-Led Course Outline

  • Introduction to Microsoft Excel

    • Examining the Excel interface
    • Working with cell ranges—navigating and selecting cells with the mouse and keyboard
    • Entering and editing data, and employing AutoFill to enter data
    • Inserting and deleting rows and columns, and adjusting column width and row height
    • Manipulating data with cut, copy, paste, and the clipboard
    • Dragging and dropping data with the mouse without using the clipboard
    • Leveraging multiple worksheets
  • Formulas and Functions

    • Writing simple formulas
    • Exploring audit tools to examine and evaluate formulas
    • Referencing cells in formulas using relative and absolute references
    • Configuring cells for the number format and alignment
    • Constructing common functions with the aid of the function wizard and the Formula tab
    • Implementing names in formulas and functions
  • Worksheet Formatting and Presentation

    • Setting up initial cell formatting
    • Drawing attention to data with formatting
    • Working with templates
    • Protecting cell ranges and worksheets
    • Analyzing data with conditional formatting
  • Getting Data In and Out

    • Importing data into Excel from various sources: text, web, Microsoft Access, SQL Server
    • Fixing data with global replace and data tools
    • TEXT and DATE functions
    • 2013 Flash Fill assistant
    • Sorting, filtering, and summarizing data with auto filter and tables
  • Creating Visual Presentation of Data

    • Leveraging charts to create a visual presentation
    • Creating charts using wizards
    • Adjusting chart settings, including titles, labels, and chart types
    • Setting up your workbook for printing
  • Introducing Advanced Features

    • Implementing dates
    • Summarizing data from other worksheets with 3-D formulas
    • Designing IF functions and conditional formatting
    • Analyzing summary data with Pivot tables and slicers

Microsoft Excel Training FAQs

  • What background do I need?

    No specific experience is required.

Unlimited Access Blended Training — Best Value!

  • Oct 24 - 26 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare)

  • Dec 5 - 7 ( 3 Days)
    9:00 AM - 4:30 PM EST
    Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare)

  • Jan 14 - 16 ( 3 Days)
    9:00 AM - 4:30 PM EST
    Ottawa / Online (AnyWare) Ottawa / Online (AnyWare)

  • Jan 30 - Feb 1 ( 3 Days)
    9:00 AM - 4:30 PM EST
    New York / Online (AnyWare) New York / Online (AnyWare)

  • Feb 20 - 22 ( 3 Days)
    9:00 AM - 4:30 PM EST
    Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare)

  • Apr 24 - 26 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare)

  • May 22 - 24 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    New York / Online (AnyWare) New York / Online (AnyWare)

  • Jul 15 - 17 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Ottawa / Online (AnyWare) Ottawa / Online (AnyWare)

  • Aug 19 - 21 ( 3 Days)
    9:00 AM - 4:30 PM EDT
    Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare)

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Microsoft Excel Unlimited Access Blended Training Information

  • Microsoft Excel Introduction Premium Blended Description

    This product offers access to a library of Microsoft Office on-demand courses including Excel, Word, PowerPoint, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating and Designing Excel Workbooks (4610). Enrolling in this bundle also grants you access to any of our multi-day Introduction to Microsoft Excel (1361) course events.

On-Demand Training Outline

  • On-Demand Course List

    • Access 2016 Essentials
    • Excel 2016 Essentials
    • Excel 2016 Essentials for Mac
    • Excel 2016 Advanced
    • Excel Charts and Pivot Tables
    • Excel Functions
    • Relational Database Design
    • PowerPoint 2016
    • Advanced PowerPoint 2016
    • PowerPoint for Mac
    • Advanced PowerPoint for Mac
    • Outlook 2016
    • Outlook on the Web
    • Word 2016 Essentials
    • Word 2016 Advanced
    • Word 2016 Expert
    • Word 2016 Mail Merge
    • Word 2016 Essentials for Mac
    • Word 2016 Advanced for Mac
    • Word 2016 Expert for Mac
    • Word 2016 Mail Merge for Mac
    • End User Security Awareness
    • Skype for Business

Microsoft Excel Training FAQs

  • What background do I need?

    No specific experience is required.

  • Is the on-demand content the same as the 3-day instructor class?

    No. While many of the same points are covered, taking the instructor-led Introduction to Microsoft Excel course provides the deepest dive into that area. This offering is indented for those who wish to gain a broad knowledge of the topics described in the course outline above - including Excel.

  • How can I sign up for a review session or in Instructor-led version of the course?

    Once you are enrolled in the program, specific details and dates will be sent to you.

  • What on-demand content will I receive?

    An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrollment period.

  • How will I access my course materials if I choose this method?

    Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.

One Day Instructor-Led Review

You'll be able to register for a Training Review Session at any time after you've placed your order.

  • Nov 27 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Dec 17 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Jan 14 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Feb 4 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Mar 4 (1 Day)
    9:00 AM - 4:30 PM EST
    Online (AnyWare) Online (AnyWare)
  • Apr 3 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • May 7 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Jun 3 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Jul 9 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Aug 6 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)
  • Sep 10 (1 Day)
    9:00 AM - 4:30 PM EDT
    Online (AnyWare) Online (AnyWare)

Team Training

Questions about which training is right for you?

call 888-843-8733
chat Live Chat




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition!
  • No advance payment required for most products.
  • Tuition can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

Herndon, VA / Online (AnyWare)
Rockville, MD / Online (AnyWare)
Ottawa / Online (AnyWare)
New York / Online (AnyWare)
Alexandria, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Alexandria, VA / Online (AnyWare)
Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français