-
-
Cart
There are no items in your cart. Continue shopping on our Course Directory page.
SUBTOTALPay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
-
Introduction to Microsoft Excel
Level: Foundation
Rating:
4.87/5 Based on 136 Reviews
Introduction to Microsoft Excel training, empowers participants with key skills to: create and edit worksheets, implement formulas and functions, sort and filter detail data with tables and slicers. Visualise the numbers in a consumable and professional format analysing data with charting, conditional formatting, sparklines, and pivot tables.
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:
- 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 analyse sales information
- Connect, prepare and validate data employing editing tools, formulas, and Flash Fill
- Identify, sort and select detail data with tables and slicers
- Present and analyse data with conditional formatting, charting, sparklines, and printing parameters
- Construct IF functions that make decisions - present results visually
- Combine data with 3-D formulas
- Analyse summary data with PivotTables and implement a quick dashboard
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
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
- Pay later by invoice -OR- at the time of checkout by credit card
PREMIUM TRAINING
Unlimited Access to Everything
Unlimited annual access to:
- 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
TRAINING AT YOUR SITE
Team Training
- Bring this or any training to your organisation
- 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 USSave More on Training with Learning Tree Training Vouchers!
Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 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 Content
-
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 intended 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 enrolment 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.
In Class & Live, Online Training
Note: This course runs for 3 Days
-
23 - 25 Nov 9:00 AM - 4:30 PM GMT Online (AnyWare)
Reserve Your Seat -
1 - 3 Mar 9:00 AM - 4:30 PM GMT Online (AnyWare)
Reserve Your Seat -
30 May - 1 Jun 9:00 AM - 4:30 PM BST Online (AnyWare)
Reserve Your Seat -
30 Aug - 1 Sep 9:00 AM - 4:30 PM BST Online (AnyWare)
Reserve Your Seat -
8 - 10 Dec 2:00 PM - 9:30 PM GMT Ottawa / Online (AnyWare)
Reserve Your Seat -
23 - 25 Feb 2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare)
Reserve Your Seat -
12 - 14 Apr 2:00 PM - 9:30 PM BST Ottawa / Online (AnyWare)
Reserve Your Seat -
24 - 26 Aug 2:00 PM - 9:30 PM BST Herndon, 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 — will run. Guaranteed.Microsoft Excel Introduction Instructor-Led Course Information
Microsoft Excel Introduction Training Course Description
In this introductory course, you learn how to summarise 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, optimise 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
- 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 with dragging the mouse
- 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
- Analysing data with conditional formatting
Getting Data In and Out
- Importing data into Excel from various sources: text, web, Microsoft Access, SQL Server
- Transforming data with global replace and data tools
- TEXT and DATE functions
- 2013 Flash Fill assistant
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
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
Introducing Advanced Features
- Implementing dates
- Summarising data from other worksheets with 3-D formulas
- Designing IF functions and conditional formatting
- Analysing summary data with Pivot tables and slicers
Microsoft Excel Introduction Training FAQs
-
What background do I need?
No specific experience is required.
Unlimited Access to Everything
Note: This course runs for 3 Days
-
23 - 25 Nov 9:00 AM - 4:30 PM GMT Online (AnyWare)
-
1 - 3 Mar 9:00 AM - 4:30 PM GMT Online (AnyWare)
-
30 May - 1 Jun 9:00 AM - 4:30 PM BST Online (AnyWare)
-
30 Aug - 1 Sep 9:00 AM - 4:30 PM BST Online (AnyWare)
-
8 - 10 Dec 2:00 PM - 9:30 PM GMT Ottawa / Online (AnyWare)
-
23 - 25 Feb 2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare)
-
12 - 14 Apr 2:00 PM - 9:30 PM BST Ottawa / Online (AnyWare)
-
24 - 26 Aug 2:00 PM - 9:30 PM BST Herndon, 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 — 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.
How to Schedule Your Instructor-Led Training
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
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 Introduction 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 intended 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 enrolment 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.
How do I schedule my instructor-led training?
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
Team Training
Related Excel Training
Analysing Data with Excel Training (20779)Excel Data Analysis Training
Questions about which training is right for you?
0800 282 353
Live Chat
Why do we require your location?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.