25,000+ Courses Nationwide
0345 4506120

Microsoft Excel Introduction 2007-2016 Blended Learning

Overview

This Premium course offers both classroom training and video learning to enhance your learning experience. Please see below for full details.

Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Introduction to Microsoft Excel training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.

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.

Software

This course is applicable to all versions of Excel, from Excel 97 to Excel 2016

What's Included

This Premium course offers both classroom training and video learning to enhance your learning experience. Please see below for full details.

Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Introduction to Microsoft Excel training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.

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.

Included - 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
  • End-of-course exam included

This product offers access to a library of Microsoft Office on-demand courses including Excel, Word, PowerPoint, and more. At any time during yourannual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating and Designing Excel Workbooks.

More Information

Pre-requisites

Familiarity working in Microsoft Windows.

Learning Objectives

You Will Learn How To:

  • Summarise data with Excel by incorporating formulas, formatting, and charts and graphs
  • Optimise your worksheets using templates, graphs, and formulas
  • Design simple to complex formulas by nesting Excel functions
  • Import, fine-tune, and share Excel data
  • Create, manage, and launch macros

Course Content

Introduction to Microsoft Excel

  • Examining the Excel interface
  • 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 and columns, and adjusting column width and row height
  • Manipulating data with cut, copy, paste, and the clipboard
  • Dragging and dropping data with the mouse without using the clipboard
  • 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
  • Fixing data with global replace and data tools
  • TEXT and DATE functions
  • 2013 Flash Fill assistant
  • Sorting, filtering, and summarising data with auto filterand tables

Creating Visual Presentation of Data

  • Leveraging charts to create a visual presentation
  • Creating charts using wizards
  • Adjusting chart settings, including titles, labels, and chart types
  • 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 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 TrainingFAQs

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 yourannual enrolment period.

How will I access my course materials if I choose this method?

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

One Day Instructor-Led Review

You'll be able to register for a Training Review Session at any time after you've placed your order.

Related Courses

We work with the best