GET THIS COURSE AND 2500+ OTHERS FOR ONLY £49 FIND OUT MORE

Home
Curriculum

Excel 2016 Training Course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Excel 2016 Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.

To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.

The training materials of this Excel 2016 Training Course are available online for you to learn at your own pace and fast-track your career with ease.

Sneak Peek of The Excel 2016 Training Course

Who Should Take The Excel 2016 Training Course

Anyone with a knack for learning new skills can take this Excel 2016 Training Course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your Excel 2016 Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this Excel 2016 Training Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Assessment

At the end of the Excel 2016 Training Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Course Curriculum

Introduction

Getting Started with Excel

Creating Workbooks and Using Templates

Entering Data

Excel Formula Basics Data

Adjusting a Worksheet

Formatting and Aligning Worksheet Data

Using Cell Styles and Themes

Inserting Objects and Graphics

Proofing a Workbook

Printing an Excel File

Managing Worksheets

Navigating and Viewing Excel Files

Conclusion

Course Curriculum

Introduction
	Introduction	00:01:00
Getting Started with Excel
	What is Excel	00:02:00
	Opening Excel	00:04:00
	Navigating the Excel User Interface	00:08:00
	Using the Excel Ribbon	00:03:00
	Understanding Excel Work Components	00:04:00
	Using the Backstage View	00:03:00
Creating Workbooks and Using Templates
	Creating a New Workbook	00:03:00
	Creating Workbooks Using Templates	00:03:00
	Saving an Excel Workbook	00:05:00
	Using Convert and Checking Compatiblity	00:02:00
Entering Data
	Navigating a Worksheet by Mouse or Keyboard	00:05:00
	Excel Data Types	00:03:00
	Cell and Range Addressing	00:02:00
	Data Selection Techniques	00:05:00
	Common Excel Commands	00:07:00
	Using the Autofill Handle	00:03:00
Excel Formula Basics Data
	What are Formulas and Functions	00:02:00
	Components of a Formula	00:06:00
	Calculation Hierarchy Using the Order of Operations_Revise	00:02:00
	Creating Basic Formulas	00:08:00
	Working with Basic Functions and Autosum	00:04:00
	Using Cell References	00:04:00
	Using the Quick Analysis Tool	00:01:00
Adjusting a Worksheet
	Modifying Columns and Rows	00:06:00
	Hiding and Unhiding Worksheets	00:02:00
Formatting and Aligning Worksheet Data
	Formatting and Aligning Data	00:06:00
	Merging Data	00:04:00
	Wrapping Text Orientation	00:02:00
	Formatting Numbers	00:03:00
	Using Borders and Shading	00:03:00
	Using the Format Painter	00:01:00
	Removing Formatting Quickly	00:01:00
Using Cell Styles and Themes
	Understanding Cell Styles	00:02:00
	Applying Cell Styles	00:04:00
	Applying Themes	00:03:00
Inserting Objects and Graphics
	Inserting and Formatting Images	00:03:00
	Inserting and Formatting Shapes	00:04:00
	Inserting and Formatting Smart Art	00:04:00
	Inserting Screenshots	00:02:00
	Inserting Hyperlinks	00:03:00
	Inserting Symbols and Equations	00:03:00
	Inserting Word Art Or Text Boxes	00:04:00
	Inserting Other Excel Objects	00:04:00
	Arranging Objects	00:04:00
Proofing a Workbook
	Using Find and Replace	00:04:00
	Finding and Replacing Formatting	00:01:00
	Using Got to and Go to Special	00:02:00
	Using the Spell Checker	00:03:00
	Using the Theasaurus and Translation Feature	00:03:00
Printing an Excel File
	Printing and Previewing Excel Files	00:03:00
	Creating Custom Margins and Scaling	00:05:00
	Adding Headers and Footers	00:04:00
	Formatting a Page with the Page Layout Tab	00:03:00
	Printing Titles and Specific Worksheet Areas	00:05:00
	Exporting to PDF and XPs	00:02:00
Managing Worksheets
	Renaming and Coloring Worksheet Tabs	00:03:00
	Adding, Deleting, and Navigating Worksheets	00:03:00
	Moving and Copying Worksheets	00:04:00
	Hiding and Unhiding Worksheets	00:02:00
Navigating and Viewing Excel Files
	Viewing Workbooks	00:03:00
	Using Zoom Tools	00:02:00
	Configure Sheet Options	00:02:00
	Using Freeze Panes and Split Commands	00:05:00
	Working with Window Commands	00:04:00
	Adjusting Workbook Properties	00:03:00
Conclusion
	Course Recap	00:02:00