• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

MS Excel 2016 Introduction

MS Excel 2016 Introduction

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 3 hours 45 minutes

  • All levels

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

About The Provider

Tags

Reviews