Home
Courses
Microsoft Excel Training Course

Microsoft Excel Training Course

Course 1361

Duration: 3 days
Labs: Yes
Language: English
17 NASBA CPE Credits (live, in-class training only)
Level: Foundation

Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, and pivot tables.

Microsoft Excel Training Delivery Methods

In-Person
Online

Microsoft Excel Training Information

In this Microsoft Excel training, you will learn to:

Efficiently navigate and manipulate worksheets and workbooks.
Implement an income and expense statement with formulas, functions, and names.
Design a reusable data entry template that protects formulas.
Implement conditional formatting to analyze sales information.
Connect, prepare, and validate data employing editing tools, formulas, and Flash Fill.
Identify, sort, and select detailed data with tables and slicers.
Present and analyze data with conditional formatting, charting, sparklines, and printing parameters.
Construct IF functions that make decisions - present results visually.
Combine data with 3-D formulas.
Analyze summary data with PivotTables and implement a quick dashboard.
Leverage continued support with after-course one-on-one instructor coaching and computing sandbox.

Prerequisites

None.

Microsoft Excel Training Exam Information

Learning Tree end-of-course exam included

Microsoft Excel Training Course Outline

Module 1: Introduction to Microsoft Excel

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, columns, or cells.
Adjusting column width and row height
Manipulating data with cut, copy, paste, with the clipboard, or dragging the mouse
Leveraging multiple worksheets

Module 2: 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

Module 3: 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

Module 4: Getting Data In and Out

Importing data into Excel from various sources: text, web, Microsoft Access, SQL (Structured Query Language) Server
Transforming data with global replace and data tools
TEXT and DATE functions
2013 Flash Fill assistant
Setting WISE (Written, Integrated, Synergistic, and Expansive) goals

Module 5: Sorting, Selecting and Subtotaling data

Subtotaling a Filtered list with the subtotal command
Implementing Tables and Table Formulas
Subtotaling a table with the Total Row
Filtering Tables with Slicers

Module 6: Present Data Visually

Leveraging charts to create a visual presentation
Creating charts using wizards
Adjusting chart settings, including titles, labels, and chart types
Working with Views of the spreadsheet
Setting up your workbook for printing

Module 7: 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

Get This Course $2,785 GOV $1,950

3-day instructor-led training course
Learning Tree end-of-course exam included
After-course computing sandbox included
One-on-one after-course instructor coaching

Get the Advantage $3,895

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#1361

Jan 22 - 24 9:00 AM - 4:30 PM EST

Virtual
Feb 5 - 7 11:00 AM - 6:30 PM EST

Aurora, CO or Virtual
Feb 12 - 14 9:00 AM - 4:30 PM EST

New York or Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
Feb 26 - 28 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Mar 5 - 7 12:00 PM - 7:30 PM EST

San Francisco or Virtual
Mar 26 - 28 10:00 AM - 5:30 PM EDT

Austin or Virtual
Apr 23 - 25 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Apr 30 - May 2 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual
May 21 - 23 9:00 AM - 4:30 PM EDT

Washington, DC or Virtual
Jun 4 - 6 12:00 PM - 7:30 PM EDT

Bellevue, WA or Virtual
Jul 9 - 11 9:00 AM - 4:30 PM EDT

New York or Virtual
Jul 23 - 25 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Aug 20 - 22 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual
Aug 27 - 29 10:00 AM - 5:30 PM EDT

Austin or Virtual
Sep 3 - 5 12:00 PM - 7:30 PM EDT

San Francisco or Virtual

Scroll to view additional course dates

3-day instructor-led training course
Learning Tree end-of-course exam included
After-course computing sandbox included
One-on-one after-course instructor coaching

Get the Advantage $3,895

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#1361

Jan 22 - 24 9:00 AM - 4:30 PM EST

Virtual
Feb 5 - 7 11:00 AM - 6:30 PM EST

Aurora, CO or Virtual
Feb 12 - 14 9:00 AM - 4:30 PM EST

New York or Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
Feb 26 - 28 9:00 AM - 4:30 PM EST

Herndon, VA or Virtual
Mar 5 - 7 12:00 PM - 7:30 PM EST

San Francisco or Virtual
Mar 26 - 28 10:00 AM - 5:30 PM EDT

Austin or Virtual
Apr 23 - 25 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Apr 30 - May 2 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual
May 21 - 23 9:00 AM - 4:30 PM EDT

Washington, DC or Virtual
Jun 4 - 6 12:00 PM - 7:30 PM EDT

Bellevue, WA or Virtual
Jul 9 - 11 9:00 AM - 4:30 PM EDT

New York or Virtual
Jul 23 - 25 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Aug 20 - 22 11:00 AM - 6:30 PM EDT

Aurora, CO or Virtual
Aug 27 - 29 10:00 AM - 5:30 PM EDT

Austin or Virtual
Sep 3 - 5 12:00 PM - 7:30 PM EDT

San Francisco or Virtual

Scroll to view additional course dates

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

Get the Advantage $3,895

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#1361

Questions about this course?

Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Microsoft Excel Training FAQs

No specific experience is required.

Microsoft Excel Training Course

Microsoft Excel Training Delivery Methods

Microsoft Excel Training Information

Microsoft Excel Training Course Outline

Module 1: Introduction to Microsoft Excel

Module 2: Formulas and Functions

Module 3: Worksheet Formatting and Presentation

Module 4: Getting Data In and Out

Module 5: Sorting, Selecting and Subtotaling data

Module 6: Present Data Visually

Module 7: Introducing Advanced Features

Upgrade your course experience with: Subscriptions

Get the Advantage $3,895

Thank you for choosing subscriptions!

Upgrade your course experience with: Subscriptions

Get the Advantage $3,895

Thank you for choosing subscriptions!

Upgrade your course experience with: Subscriptions

Get the Advantage $3,895

Thank you for choosing subscriptions!

Microsoft Excel Training FAQs

What background do I need?

Related Courses