Description

Description

MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields.

The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities.

Assessment:

This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

MS Excel 2016 Introduction is certified by CPD Qualifications Standards and CiQ. 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 MS Excel 2016 Introduction 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.

Introduction
	Introduction	FREE	00:01:00
Getting Started with Excel
	What is Excel		00:02:00
	Opening Excel		00:04:00
	Navigating the Excel User Interface		00:07: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 Columns and Rows		00:03:00
Formatting and Aligning Worksheet Data
	Formatting and Aligning Data		00:06:00
	Merging Data		00:03: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
Certificate and Transcript
	Order Your Certificates and Transcripts		00:00:00

Course Images

MS Excel 2016 Introduction

By John Academy

Booking options

Highlights

Description

About The Provider

Tags

Reviews