course-premium

Microsoft Excel 2016

Short course

Online

Save 84%

Special Emagister price

£ 30 £ 195 VAT inc.

Domina Excel and increase your work opportunities!

  • Type

    Short course

  • Methodology

    Online

  • Class hours

    35h

  • Start date

    Different dates available

  • Support service

    Yes

Eligible to Apply

To be successful in the business world today, you must have competencies and skills in Microsoft Office. It does not matter if you are an administrative assistant, office manager, sales professional or business manager, knowing how to use all the powerful features of Microsoft Office will make you more efficient and, later, more commercial. The vast majority of all jobs in the business world use these office products. That's why Emagister presents you this Microsoft Excel 2016 online course, so you can advance your professional skills.

Microsoft Excel is one of the most commonly used spreadsheet programs, whether used in business for accounting and customer data or at home for family budgets. Having proven skills in this software will demonstrate to employers that you have had hands-on experience and will give you full confidence in your ability to navigate the software efficiently.

Depending on the version of Excel you need, we have the perfect course for you; including the most updated version, Microsoft Excel 2016, as well as 2013 and 2010. Our course will also help you to take the Microsoft Office Specialist Test (MOS).

This course is designed to provide you with the fundamental skills you will need to master Excel, in a work or home environment, in the shortest possible time. You do not need to have any previous experience in the use of Microsoft Excel, our training in Microsoft Excel 2013 covers beginner, intermediate and advanced level training to help you develop the skills you need to advance your career.

Do not miss this opportunity to learn! If this course is of interest, request more information on Emagister.com

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Anyone looking to develop their Microsoft Excel 2016 skills. By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s. For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Upon course completion, you’ll be awarded a certificate of completion at no additional cost to show employers your newly acquired skills. Enrol Online today and start learning straight away.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

This centre has demonstrated its quality on Emagister
5 years with Emagister

Subjects

  • Excel
  • Office IT
  • Microsoft Excel
  • Art
  • Ms Office
  • Microsoft excel training
  • MS Excel
  • Microsoft Office
  • Hyperlinks
  • Numbers
  • Alignment
  • Charting
  • Keyboard Shortcuts
  • Sorting
  • Filtering
  • Formatting Cells
  • Creating functions
  • Smart Art
  • Table Features
  • Section Review
  • Spark lines
  • Naming Cells and Ranges
  • Find and Replace
  • Using Cell References
  • Error Messages
  • Conditional Statements
  • Applying Formats
  • AutoContent

Course programme

Introduction

  • Course Outline
  • Introducing Excel 2016
  • The Excel Interface
  • Keyboard Shortcuts
  • Section Review

Basic File Commands and Operations

  • Creating, Saving and Closing Workbooks
  • Personalizing Files and Opening Workbooks
  • Viewing Existing Workbooks and Applying Templates
  • Keyboard Shortcuts
  • Section Review

Creating, Managing and Navigating the Worksheets

  • Creating and Managing Worksheets
  • Navigating the Worksheets
  • Keyboard Shortcuts
  • Section Review

Entering and Managing Worksheet Data

  • Worksheet Basics and Cell Range Selection
  • Entering Cell Content and Multiple Cells
  • AutoContent and Undo, Redo and Repeat
  • Updating and Clearing Cell Content
  • Inserting and Deleting, Rows and Columns
  • Copying, Cutting, Pasting and Moving Contents
  • Keyboard Shortcuts
  • Section Review

Formatting Cells and Worksheets

  • Formatting Cells and Applying Formats
  • Alignment
  • Merging Cells and Cell Styles
  • Numbers
  • Apply and Modify Formats
  • Using Table Features
  • Keyboard Shortcuts
  • Section Review

Applying Formulas and Functions

  • Creating Formulas
  • Using Cell References
  • Managing and Updating Formulas
  • Creating Functions
  • Conditional Statements
  • Error Messages
  • Keyboard Shortcuts
  • Section Review

Analyzing and Organizing Data

  • Find and Replace
  • Sorting
  • Filtering
  • Conditional Formatting and Keyboard Shortcuts
  • Section Review

Naming and Hyperlinks

  • Naming Cells and Ranges
  • Hyperlinks
  • Section Review

Displaying Data Visually Using Charts

  • Charting
  • Layout Chart Element Options and Format
  • Spark lines
  • Keyboard shortcuts
  • Section Review

Preparing to Print and Printing

  • Preparing to Print with Page Layouts
  • Section Review

Share Worksheet Data with Other Users

  • Sharing a Document and Managing Comments
  • Section Review

Including Illustrations and Graphics in a Workbook

  • Inserting and Formatting Pictures
  • Inserting and Formatting Clip Art
  • Inserting and Formatting Shapes, Word Art and Text Boxes
  • Inserting and Formatting Smart Art
  • Keyboard Shortcuts
  • Section Review

Customize the Excel Interface

  • Section Review

Additional information

Once you’ve enrolled you’ll receive the following courses: Microsoft Excel Beginners Microsoft Excel Intermediate Microsoft Excel Advanced

Microsoft Excel 2016

Special Emagister price

£ 30 £ 195 VAT inc.