Excel 2016 Essential Training at Linkedin Learning Overview
Duration | 9 hours |
Total fee | ₹1,599 |
Mode of learning | Online |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Faculty
- + 1 more item
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
- 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
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?