Skip to content

Microsoft Office 2016 Excel Beginners - Complete Video Course


John Academy

Summary

Price
£350 inc VAT
Or £58.33/mo. for 6 months...
Study method
Online
Duration
4 hours · Self-paced
Qualification
No formal qualification
CPD
10 CPD hours / points

Overview

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of the data is becoming more and more challenging. By this Microsoft Office 2016 Excel Beginners – Complete Video Course you will gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheet. You will learn all novice computer users get up to speed with excel quickly, you can access to video tutorial, pdf documents, excel sheets on excel 2016.

If you want to get your work done faster you should have the knowledge of excel concepts and functions. By taking this course you will understand all the concepts of different examples in excel 2016.

CPD

10 CPD hours / points
Accredited by The CPD Certification Service

Course media

Description

Why choose us?

  • Study in a user-friendly, advanced online learning platform;
  • All the study materials are available in your student portal including videos tutorials.
  • One of the most successful online education platforms in the UK.
  • Affordable, engaging & high-quality e-learning study materials;
  • You will have unlimited access to online learning platform in 24 hours a day, 7 days a week in 12 Months.
  • Efficient exam systems for the assessment and instant result;
  • The UK & internationally recognised accredited qualification;
  • Access to course content on mobile, tablet or desktop from anywhere anytime;
  • The benefit of applying for NUS Extra Discount Card;
  • 24/7 student support.
  • Technical supports and live chat service for your inquiries. This is very helpful for international learners.
  • Excellent and flexible mentor supports by our team of experienced tutors/trainers via email.

COURSE CURRICULUM

Getting Started with Microsoft Office Excel 2016

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

John Academy: A Great Place to Learn for Everyone, Forever

Expert Authors: We select authors with expertise and experience of training professionals. Our authors are industry experts, academics, authors, face-to-face trainers or online trainers; most often they have a combination of these backgrounds

Engaging Content: Our succinct, bite-sized and business-focussed course materials are designed to deliver the most effective training for you. Each course is made up of modules, manageable learning chunks of text, images, videos and tasks.

Assessment and Certification:

Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £24 for a PDF copy and £39 for an original print copy sent to you by post.

Who is this course for?

Microsoft Office 2016 Excel Beginners – Complete Video Course is certified by International Accreditation Organization (IAO). This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Microsoft Office 2016 Excel Beginners – Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Questions and answers


No questions or answers found containing ''.


Mac asked:

Do you learn how to use pivot tables?

Answer:

Hi Mac, Thanks for your query. Unfortunately, as this is an Excel course for beginners, it does not cover pivot tables. Please refer to our Advanced Excel course as it will cover Pivot Tables. Regards, Help Desk

This was helpful. Thank you for your feedback.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.