Preferred method of contact:

Microsoft Excel Introduction

COURSE TYPE

Foundation

Course Number

1361

Duration

3 Days

PDF Add to WishList

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.

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

Important Course Information

Requirements:

  • Familiarity working in Microsoft Windows

Software:

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

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
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $2745   Government: $2415

Jun 6 - 8 (3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

Jun 27 - 29 (3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

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

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

Sep 26 - 28 (3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

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

Show all dates
Show fewer dates

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.

Private Team Training

Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click here »

This event has been added to your cart.

Tuition

Standard

Government

In Classroom or
Online

Standard

$2745

Government

$2415

Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.

Prev
Next

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

“This Excel course gave me the knowledge to show my staff new and better ways of working with Excel, and to answer their questions.”

- J. Dutrow, Record Supervisor
B&C Trust Funds

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français