Eligible to Apply

Microsoft Excel 2016

Short course

Online

£ 79 VAT inc.

Description

  • Typology

    Short course

  • Methodology

    Online

  • Class hours

    35h

  • Start

    Different dates available

  • Support service

    Yes

Description

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

Facilities

Location

Starts

Online

Starts

Different dates availableNow taking bookings

To take into account

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

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Achievements for this centre

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

Subjects

  • Smart Art
  • Section Review
  • Spark lines
  • Charting
  • Hyperlinks
  • Naming Cells and Ranges
  • Find and Replace
  • Sorting
  • Filtering
  • Using Cell References
  • Creating functions
  • Error Messages
  • Keyboard Shortcuts
  • Conditional Statements
  • Numbers
  • Alignment
  • Formatting Cells
  • Applying Formats
  • Table Features
  • 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

£ 79 VAT inc.