Microsoft Excel 2016

Here's what you will get

Lessons
Lessons
15+
Quizzes
93+
Flashcards
110+
Glossary of terms
110+
Test prep
Pre-assessment Questions
30+
Full Length Tests
2+
Post-Assessment Questions
45+
Lab
Performance lab
44+
Video tutorials
32+
Minutes
16+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
30+
Hours
08:23+

Here's what you will learn

  • Identifying What Excel Is Good For
  • Seeing What's New in Excel 2016
  • Understanding Workbooks and Worksheets
  • Moving Around a Worksheet
  • Using the Ribbon
  • Customizing the Ribbon
  • Creating Your First Excel Workbook
  • Customizing the Quick Access Toolbar
  • Summary
  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting
  • Summary
  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary
  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary
  • What Is a Table?
  • Creating a Table
  • Changing the Look of a Table
  • Working with Tables
  • What Is a Chart?
  • Understanding How Excel Handles Charts
  • Creating a Chart
  • Hands On: Creating and Customizing a Chart
  • Working with Charts
  • Understanding Chart Types
  • Working with Titles in a Chart
  • Working with a Legend
  • Working with Gridlines
  • Working with Data Series
  • Sparkline Types
  • Creating Sparklines
  • Customizing Sparklines
  • Summary
  • Getting to Know the Formatting Tools
  • Using Different Fonts to Format Your Worksheet
  • Changing Text Alignment
  • Using Colors and Shading
  • Adding Borders and Lines
  • Understanding Document Themes
  • About Number Formatting
  • Summary
  • Creating a New Workbook
  • Saving a Workbook
  • Password-Protecting a Workbook
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility
  • Exploring Excel Templates
  • Summary
  • Basic Printing
  • Changing Your Page View
  • Adjusting Common Page Setup Settings
  • Adding a Header or Footer to Your Reports
  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • Exporting Data
  • Importing Data
  • Summary
  • Understanding Formula Basics
  • Entering Formulas into Your Worksheets
  • Editing Formulas
  • Using Cell References in Formulas
  • Correcting Common Formula Errors
  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Summing Formulas
  • Basic Lookup Formulas
  • Summary
  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary
  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Working with Hyperlinks
  • Summary
  • About Data Validation
  • Specifying Validation Criteria
  • Types of Validation Criteria You Can Apply
  • Creating a Drop-Down List
  • Using Formulas for Data Validation Rules
  • Understanding Cell References
  • Data Validation Formula Examples
  • Summary
  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Summary
  • A What-If Example
  • Types of What-If Analysis
  • Single-Cell Goal Seeking
  • Summary
  • Certification Objectives Map

Hands on Activities (Labs)

  • Identifying elements of Excel
  • Identifying keys of Worksheet
  • Modifying worksheet in MS Excel 2016
  • Modifying cell contents
  • Identifying key combinations
  • Changing date format in MS Excel 2016
  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016
  • Understanding cell range address
  • Understanding paste options
  • Adding comments in MS Excel 2016 
  • Formatting data as table in MS Excel 2016
  • Removing duplicates in MS Excel 2016
  • Sorting data in MS Excel 2016
  • Filtering data in MS Excel 2016
  • Inserting a chart in MS Excel 2016
  • Changing chart style in MS Excel 2016
  • Changing chart color in MS Excel 2016
  • Customizing a chart in MS Excel 2016
  • Identifying chart types
  • Removing gridlines and headings in MS Excel 2016
  • Creating Sparklines in MS Excel 2016
  • Formatting heading in MS Excel 2016
  • Wrapping text in MS Excel 2016
  • Applying border on the MS Excel 2016 sheet
  • Saving a workbook in MS Excel 2016
  • Understanding Workbook
  • Understanding file compatibility
  • Setting page margin in MS Excel 2016
  • Printing an area in MS Excel 2016
  • Adding header in MS Excel 2016
  • Protecting a workbook in MS excel 2016
  • Using the Concatenate function in MS Excel 2016
  • Using the Average function in MS Excel 2016
  • Using the SUMIF function in MS Excel 2016
  • Using the SUM function in MS Excel 2016
  • Using VLOOKUP in MS Excel 2016
  • Applying conditional formatting in MS Excel 2016
  • Inserting and configuring shape
  • Understanding graphic types
  • Hiding column in MS Excel 2016
  • Adding data validation in MS Excel 2016
  • Understanding pivot table
  • Understanding the Scenarios dropdown-list
ms-excel-2016 ms-excel-2016
MS-EXCEL-2016
Microsoft Excel 2016
ISBN : 9781616917982
Rating :
(28)