Home
Courses
Introduction to Microsoft Excel

Introduction to Microsoft Excel

Course 1361

Duration: 3 days
Labs: Yes
Language: English
Level: Foundation

Get This Course £995

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

Include dates with afternoon start times

#1361

Guaranteed to Run - you can rest assured that the class will not be cancelled.
Aug 24 - 26 2:00 PM - 9:30 PM BST

Herndon, VA or AnyWare
Aug 30 - Sep 1 9:00 AM - 4:30 PM BST

AnyWare
Oct 12 - 14 2:00 PM - 9:30 PM BST

Ottawa or AnyWare
Nov 29 - Dec 1 9:00 AM - 4:30 PM GMT

AnyWare
Feb 22 - 24 2:00 PM - 9:30 PM GMT

Herndon, VA or AnyWare
Feb 28 - Mar 2 9:00 AM - 4:30 PM GMT

AnyWare

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

#70B1

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

#1361

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.

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.

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.

Introduction to Microsoft Excel Delivery Methods

Choose from on-demand and instructor-led blended learning options
Exclusive LinkedIn group membership for peer and SME community support

Introduction to Microsoft Excel Course Benefits

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

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

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

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

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Course FAQs

No specific experience is required.

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.

Once you are enrolled in the program, specific details and dates will be sent to you.

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.

Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.

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.

Once you are enrolled in the program, specific details and dates will be sent to you.