Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Microsoft Office Training









Preferred method of contact?

Microsoft Excel Introduction

COURSE TYPE

Foundation

Course Number

1361

Duration

3 Days

Enroll

About This Course: In today's workplace, Microsoft Excel is the de facto tool for working with data on the desktop. Knowing how to leverage Excel enables you to simplify complex tasks, essential to daily work responsibilities. In this introductory course, you gain the skills needed to create Excel worksheets, develop formulas and apply sophisticated formatting to capture and present your data.

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

Course Outline

  • Introduction to Microsoft Excel

The spreadsheet model

  • Worksheets and their contents
  • Differentiating workbooks and worksheets

Navigating the interface

  • The Ribbon
  • Customizing the interface
  • Managing large spreadsheets by zooming
  • Identifying worksheet tabs by color
  • Changing worksheet views

Basic data editing

  • Modifying cell contents and formats
  • Inserting data with AutoFill
  • Knowing when to use Paste Special
  • Acquiring and Conforming Data

Importing data from outside sources

  • Integrating data from other Excel sheets
  • Utilizing data from servers
  • Managing external links
  • Finding and removing duplicates

Excel tables and lists

  • How Excel tables work
  • Converting text to columns
  • Sorting and grouping table data
  • Adding data in a table or list
  • Worksheet Formatting and Presentation

Initial formatting

  • Configuring cell numeric formats
  • Aligning data within cells
  • Fitting cells to data size
  • Naming cells and cell ranges

Worksheet presentation

  • Freezing worksheet areas
  • Hiding content in worksheets
  • Editing, modifying and saving templates

Innovative formatting

  • Styling cells and sheets with prebuilt styles
  • Conditionally formatting cells and data
  • Rotating and wrapping text
  • Leveraging Formulas and Functions

Formula basics

  • Performing simple calculations
  • Specifying relative and absolute cell references
  • Examining formulas with the auditing tools
  • Concatenating text with the & operator
  • Introducing functions with the Wizard and Formula tabs
  • Working with statistical functions: SUM, MAX, MIN,COUNT and COUNTA

Cleaning up data and manipulating data further

  • Utilizing TRIM, UPPER, LOWER LEFT and RIGHT MID functions
  • Manipulating dates with YEAR, MONTH, DAY andTEXT functions
  • Nesting formulas to perform multiple functions
  • Defining and utilizing names in formulas
  • Working with data in advanced formulas
  • Creating a Visual Presentation of Data

Charting your data

  • Determining when charts are required
  • Creating and modifying charts with wizards
  • Adjusting chart layouts, title and labels

Printing workbooks

  • Setting options on the Page Layout tab
  • Viewing and adjusting page breaks
  • Developing appropriate headers and footers
  • Introducing Advanced Excel Features

PivotTable basics

  • Creating a PivotTable with wizards
  • Pivoting existing PivotTable data

Final workbook touches

  • Reviewing and adding comments on worksheets
  • Protecting and sharing worksheets
  • Tracking shared worksheet changes

Creating and managing macros

  • Macro basics and when to use a macro
  • Recording effective macros
  • Launching macros from buttons
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Oct 26 - 28 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 23 - 25 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 18 - 20 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 25 - 27 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 6 - 8 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 6 - 8 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 15 - 17 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 3 - 5 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

May 24 - 26 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 21 - 23 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 10 - 12 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 31 - Aug 2 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Aug 9 - 11 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Sep 6 - 8 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Sep 18 - 20 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2650

Government

$2355

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.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

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


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 17 Credits from NASBA

This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“Coming into the Excel course at Learning Tree, I had zero knowledge of the program, so using teamwork to complete the hands-on exercises worked great. I now have all the basics—plus lots of tips, tricks, and shortcuts. I’m excited to apply what I learned when I get back to work, and I plan to move on to the next level course!”

- D. Galmore, Civilian Training Specialist
US Air Force

Prev
Next