Excel 2016 Essential Training

4.2 /5

(6 Ratings)

Offered byLinkedin Learning

Excel 2016 Essential Training
at
Linkedin Learning
Overview

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor

Duration	9 hours
Total fee	₹1,599
Mode of learning	Online
Credential	Certificate

Excel 2016 Essential Training
at
Linkedin Learning
Highlights

Earn a certificate of completion from LinkedIn Learning

Excel 2016 Essential Training
at
Linkedin Learning
Course details

Skills you will learn

Excel Conditional Formatting Vlookup Macros Data analysis Data Entry

More about this course

Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables
Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros

Excel 2016 Essential Training
at
Linkedin Learning
Curriculum

Introduction

Welcome

Using the exercise files

Getting Started with Excel

What is Excel used for?

Using the menu system

Using the Quick Access Toolbar

Understanding workbooks and worksheets

Using the Formula bar

Using the Status bar

Using navigation tools

Using shortcut menus and the Mini toolbar

Creating new workbooks

Using Excel Help

Entering Data

Exploring data entry and editing techniques

Entering data with AutoFill

Working with dates and times

Using Undo and Redo

Adding comments

Using Save or Save As

Creating Formulas and Functions

Creating simple formulas

Copying a formula into adjacent cells

Calculating year-to-date totals

Creating a percentage-change formula

Working with relative, absolute, and mixed references

Using SUM and AVERAGE

Using other common functions

Formatting

Exploring font styles and effects

Adjusting row heights and column widths

Working with alignment and Wrap Text

Designing borders

Exploring numeric and special formatting

Formatting numbers and dates

Using conditional formatting

Creating and using tables

Inserting shapes, arrows, and other visual features

Adjusting Worksheet Layout and Data

Inserting and deleting rows and columns

Hiding and unhiding rows and columns

Moving, copying, and inserting data

Finding and replacing data

Printing

Exploring the Page Layout tab and Page Layout view

Previewing page breaks

Working with Page Setup and printing

Excel 2016 Essential Training
at
Linkedin Learning
Faculty details

Dennis Taylor

Leading Excel trainer with more than 200 hours (60+ courses) of online Excel training available on LinkedIn Learning. Presenter of in-person Excel classes and seminars in over 40 states and Canada.

Excel 2016 Essential Training
at
Linkedin Learning
Students Ratings & Reviews

4.2/5

6 Ratings

4-5
2
3-4
3
2-3
1

Chirag Goel

Excel 2016 Essential Training

Offered by Linkedin Learning

Learning Experience: It is an excellent course if you want to know about MS-Excel. Starting from basic this cover every element of MS-Excel you need to know about which can be really helpful for you into the real world.

Faculty: Apart from having the top quality resources this course also offer you with the top quality instructors. Their way of teaching were amazing. They even make the technical aspect of this course very easy to understand for you. This course not only provides you with basic excel elements but also tales you the more advance elements of excel which are being used into the daily world. This course covers various how to use excel and various function of excel. If you are new to operate excel I would definitely recommend you to take this course to sharpen your knowledge of excel and get certified also.

Reviewed on 10 Mar 2023Read More