Microsoft Excel 2016 Beginner

Begin your education in Microsoft Excel, the industry-standard spreadsheet software for data management, analysis, budgeting and accounts, with this accessible online course. From the basics of navigating the interface to editing cells and creating formulas, you will build your knowledge step by step through easy-to-understand video tutorials, PDF handouts, and practical exercises, all designed and delivered by experts.

Description

Microsoft Excel is a powerful, flexible piece of software, but it can be a bit daunting at first glance. This distance learning course offers you the chance to gain a basic understanding of its functions at a pace that suits you, with the ability to rewatch tutorials as often as you like and develop your abilities in creating and saving a basic workbook, creating worksheet formulas, applying basic conditional formatting, and more. Upon successful completion you will earn a professional qualification.

Benefits of studying with Victoria Education include:

• Easy-to-understand course materials designed by industry experts, accessible through your smartphone, laptop, desktop or tablet device
• No hidden fees or costs - study a professional course and earn a professional e-certificate upon successful completion
• Get instant feedback from automated assessments and mock exams to gauge your progress
• No formal deadlines or teaching schedule, meaning you can learn at your own pace
• 24/7 help and support from your online tutors, through email and via our live online chat
• Qualify for an NUS Extra card and gain access to over 200 fantastic deals from high street brands and one free year of ISIC unlocking over 42,000 international discounts

Who is this course for?

The course Course is aimed at anyone wishing to start working in a range of business and administration roles, or existing professionals wishing to boost their skills and employability.

Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT.

CPD

How is this qualification delivered?

Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.

The courses are delivered through

• Video lessons
• Mock exams
• Online assessment

These can be accessed through any device with an internet connection. Our e-learning platform is optimized for use on mobile, tablet, laptops and desktop computers. Course Curriculum - Essentials of Mirosoft Excel 2016

• Getting around the Excel Interface
• Essentials: Commands
• Basics: Create and Save
• F1: Help function
• Basics: Input Data

How to perform calculations

• Essentials: Formulas
• Essentials: Functions
• Repeat the Formula or Function

How to amend a worksheet

• Essentials: Insert, Delete, Adjust
• Essentials: Search Function
• Essentials: Proof Functions

How to format a worksheet

• Essentials: Format for text
• Essentials Format for numbers
• Adjusting Contents
• Essentials: Styles
• Essentials: Conditional Formatting
• Template Developer

Printing the entire workbook

• Essentials: Print
• Essentials: Page Layout
• Essentials: Headers and Footers

Managing entire workbooks

• Worksheet Management
• Workbook and Worksheet Viewer
• Essentials: Adjusting the settings of Workbook

Mandatory units

The course consists of six mandatory modules

• Getting Started with Microsoft Office Excel 2016
• Performing Calculations
• Modifying a Worksheet
• Formatting a Worksheet
• Printing Workbooks
• Managing Workbooks
• And more...

Assessment

The assessment at the end of each course is a multiple-choice exam taken through our online platform. The system is fully automated so you will receive your results instantly upon completion.

Certification

Upon successful completion you will qualify for the UK and internationally-recognised professional qualification. You can order a print copy sent by post for GBP12.

Victoria Education is a leading provider of online training, practical courses and professional accreditation.

Our mission is to make learning accessible, affordable, and available to all, regardless of experience or qualifications.