Introduction to Microsoft Excel Training

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

• On-Demand

Microsoft Excel Training Information

• Microsoft Excel Training 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
  • Exclusive LinkedIn group membership for peer and SME community support
  • Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

• Microsoft Excel Training Exam Information

  • Learning Tree end-of-course exam included

Microsoft Excel Training Instructor-Led 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
• 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

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
• Analysing data with conditional formatting

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

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
• 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 Training On-Demand Training Bundle

On-Demand Training Bundle Benefits

This product offers access to a library of Microsoft Office on-demand courses, including Excel, Word, PowerPoint, and more. In addition, during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating & Designing Excel Workbooks Training .

On-Demand Training Bundle 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

Unlimited Access Microsoft Excel Training Premium Blended Training

Premium Blended Training Benefits

This product offers access to a library of Microsoft Office on-demand courses, including Excel, Word, PowerPoint, and more. During your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating & Designing Excel Workbooks Training . Enrolling in this bundle also grants you access to any of our multi-day instructor-led course events of this course, 1361, Introduction to Microsoft Excel Training .

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.

Premium Blended Training 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

Premium Blended Training Instructor-Led Contents

Module 1: Introduction to Microsoft Excel

• Working with cell ranges—navigating and selecting cells with the mouse and keyboard
• Entering and editing data
• 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

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
• Analysing data with conditional formatting

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

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
• Summarising data from other worksheets with 3-D formulas
• Designing IF functions and conditional formatting
• Analysing summary data with Pivot tables and slicers