CA flag CA
888-843-8733
888-843-8733

Microsoft Excel Training Course

Course 1361

  • Duration: 3 days
  • Labs: Yes
  • Language: English
  • 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

  • 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 
  • 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 
  • Setting up initial cell formatting 
  • Drawing attention to data with formatting 
  • Working with templates - Protecting cell ranges and worksheets 
  • Analyzing data with conditional formatting 
  • 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 
  • Subtotaling a Filtered list with the subtotal command 
  • Implementing Tables and Table Formulas 
  • Subtotaling a table with the Total Row 
  • Filtering Tables with Slicers 
  • 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 
  • 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,885 GOV $2,539 For Team Prices Call: 888-843-8733

  • 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 $5,150
  • 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 8 - 10 9:00 AM - 4:30 PM EST
    Washington, DC or Virtual
  • Jan 22 - 24 9:00 AM - 4:30 PM EST
    Ottawa or 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 $5,150
  • 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 8 - 10 9:00 AM - 4:30 PM EST
    Washington, DC or Virtual
  • Jan 22 - 24 9:00 AM - 4:30 PM EST
    Ottawa or 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 $5,150
  • 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?
* Required Fields
Customize Your Team Training Experience

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

* Required Fields
Preferred method of contact:

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

Microsoft Excel Training FAQs

No specific experience is required.

Related Courses

  • Microsoft
    Excel Data Analysis Course

    Attend this Excel data analysis course and learn advanced Excel techniques including What-If analyses & PivotTables to better analyze your data.

    Intermediate
    2 days
    Online or In-class
    Starts from $2,340
  • Learning Tree
    Automating Excel with Macros Training

    Unlock the full potential of Excel with our Automating Excel with Macros training. Learn to automate tasks, boost productivity, and save time.

    Intermediate
    1 day
    Online or In-class
    Starts from $1,075
  • Learning Tree
    Creating & Designing Excel Workbooks Training

    Attend this 1-day Excel Workbook course & learn to create new, well-designed workbooks, and to summarize, analyze, organize & present large datasets.

    Foundation
    1 day
    Online or In-class
    Starts from $1,075
  • Learning Tree
    Designing Data Models in Excel for Power BI Reports Training

    Learn to design BI Data Models for Power BI or Excel dashboards in our Designing Data Models in Excel for Power BI Reports Training.

    Intermediate
    3 days
    Online or In-class
    Starts from $2,885
Chat With Us