MS EXCEL 2016 : Microsoft Excel 2016

MS-EXCEL-2016
Microsoft Excel 2016
ISBN : 978-1-61691-798-2
Gain hands-on expertise in MOS: Microsoft Office Excel 2016 Core certification exam by Microsoft Excel 2016 course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. Microsoft Excel 2016 certification program validates the skills and expertise of information workers to create and manage worksheets and workbooks; manage data cells and ranges; create tables; perform operations with formulas and functions; create charts and objects.

Lessons

uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keep the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keep learners engaged and make learning fun.

Here's What You Get

Flashcards Quizzes Glossary

Each lesson comes with Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Flashcards help master the key concepts. Glossary defines the key terms.

Quizzes
93+
Flashcards
110+
Glossary of terms
110+
Lessons
15+
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.

Videos
30+
Hours
08:23+

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
30+
Full Length Tests
2+
Post-Assessments Questions
45+

Features

Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Labs

Online labs can be used to supplement training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Here's What You Get

Performance based lab
44+
Video tutorials
32+
Minutes
16+

Hands on Activities

Introducing Excel

  • Identifying elements of Excel
  • Identifying keys of Worksheet
  • Modifying worksheet in MS Excel 2016

Entering and Editing Worksheet Data

  • Modifying cell contents
  • Identifying key combinations
  • Changing date format in MS Excel 2016

Essential Worksheet Operations

  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016

Working with Cells and Ranges

  • Understanding cell range address
  • Understanding paste options
  • Adding comments in MS Excel 2016 

Tables, Charts, and Sparklines

  • 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

Worksheet Formatting

  • Formatting heading in MS Excel 2016
  • Wrapping text in MS Excel 2016
  • Applying border on the MS Excel 2016 sheet

Understanding Excel Files

  • Saving a workbook in MS Excel 2016
  • Understanding Workbook
  • Understanding file compatibility

Printing and Protecting Your Work

  • 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

Introducing Formulas and Functions

  • 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

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting in MS Excel 2016

Enhancing Your Work with Pictures and Drawings

  • Inserting and configuring shape
  • Understanding graphic types

Using Data Validation

  • Hiding column in MS Excel 2016
  • Adding data validation in MS Excel 2016

Introducing Pivot Tables

  • Understanding pivot table

Performing Spreadsheet What-If Analysis

  • Understanding the Scenarios dropdown-list

Appendix A

Live Lab

Live-Lab is an add-on component. Please select it while buying the course. It is a real computer equipment, networked together and conveniently accessible over the Internet using virtualization. A live-lab has equipment such as a computer, server, switch or router in it that a user is free to configure.

The benefits of live-labs are:

  • Exam based practical tasks
  • Real equipment, absolutely no simulations
  • Access to the latest industry technologies
  • Available anytime, anywhere on any device
  • Break and Reset functionality
  • No hardware costs

Here's What You Get

live lab
20+
Video tutorials
32+
Minutes
16+

Hands on Activities

Introducing Excel

  • Identifying elements of Excel
  • Identifying keys of Worksheet
  • Modifying worksheet in MS Excel 2016

Entering and Editing Worksheet Data

  • Modifying cell contents
  • Identifying key combinations
  • Changing date format in MS Excel 2016

Essential Worksheet Operations

  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016

Working with Cells and Ranges

  • Understanding cell range address
  • Understanding paste options
  • Adding comments in MS Excel 2016 

Tables, Charts, and Sparklines

  • 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

Worksheet Formatting

  • Formatting heading in MS Excel 2016
  • Wrapping text in MS Excel 2016
  • Applying border on the MS Excel 2016 sheet

Understanding Excel Files

  • Saving a workbook in MS Excel 2016
  • Understanding Workbook
  • Understanding file compatibility

Printing and Protecting Your Work

  • 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

Introducing Formulas and Functions

  • 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

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting in MS Excel 2016

Enhancing Your Work with Pictures and Drawings

  • Inserting and configuring shape
  • Understanding graphic types

Using Data Validation

  • Hiding column in MS Excel 2016
  • Adding data validation in MS Excel 2016

Introducing Pivot Tables

  • Understanding pivot table

Performing Spreadsheet What-If Analysis

  • Understanding the Scenarios dropdown-list

Appendix A

Exam Information

Microsoft Excel 2016 exam provides the candidates the basic idea of the Excel environment and the skill to deliver tasks without any help. The exam helps the candidates in demonstrating the correct application of the basic features of Excel 2016 by making and editing workbook with multiple sheets, and they use a graphic element to represent data visually, for example, sales invoices, financial statements,professional-looking budgets, team performance charts, and data-entry logs.

Prepare for the following certifications

Career Prospects
  • Data Analyst
  • Project Manager
  • Product Developer
  • Office Professional
Exam FAQs
Where do I take the exam?
What is the format of the exam?
Multiple choice, Best answer, Short answer, Case study and so on.
How many questions are asked in the exam?
The exam contains 40-50 questions.
What is the duration of the exam?
  minutes
What is the exam's retake policy?

Microsoft Office Specialist (MOS) exam retake policy is as follows:

  • Retake vouchers can only be used to retake the same exam that was failed.
  • All vouchers must be used prior to their expiration dates, without exception.
  • Retake vouchers must be used within 30 days of the initial failed exam.
  • As of July 1, 2014, the retake policy changed to the following:
    • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
    • If a candidate does not achieve a passing score the second time, the candidate must wait 48 hours before retaking the exam.
    • A two-day waiting period is imposed for each subsequent exam retake.
    • If a candidate achieves a passing score on an exam, the candidate may take it again.

Where can I find more information about this exam?
To know more about the MS-EXCEL-2016, click here.

Table of Content

Here's What you will Learn

Lesson 1: Introducing Excel

  • 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

Lesson 2: Entering and Editing Worksheet Data

  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting
  • Summary

Lesson 3: Essential Worksheet Operations

  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary

Lesson 4: Working with Cells and Ranges

  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary

Lesson 5: Tables, Charts, and Sparklines

  • 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

Lesson 6: Worksheet Formatting

  • 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

Lesson 7: Understanding Excel Files

  • Creating a New Workbook
  • Saving a Workbook
  • Password-Protecting a Workbook
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility
  • Exploring Excel Templates
  • Summary

Lesson 8: Printing and Protecting Your Work

  • 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

Lesson 9: Introducing Formulas and Functions

  • 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

Lesson 10: Visualizing Data Using Conditional Formatting

  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary

Lesson 11: Enhancing Your Work with Pictures and Drawings

  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Working with Hyperlinks
  • Summary

Lesson 12: Using Data Validation

  • 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

Lesson 13: Introducing Pivot Tables

  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Summary

Lesson 14: Performing Spreadsheet What-If Analysis

  • A What-If Example
  • Types of What-If Analysis
  • Single-Cell Goal Seeking
  • Summary

Lesson 15: Appendix A

  • Certification Objectives Map
uCertify

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved
app_store
google_play