Microsoft Office Excel 2016 (with Expert Exam)
Here's what you will get
Lessons
38+
Quizzes
155+
Flashcards
157+
Glossary of terms
157+
Pre-assessment Questions
45+
Full Length Tests
2+
Post-Assessment Questions
50+
Performance lab
49+
Video tutorials
49+
Minutes
29+
Here's what you will learn
- TOPIC A: Navigate the Excel User Interface
- TOPIC B: Use Excel Commands
- TOPIC C: Create and Save a Basic Workbook
- TOPIC D: Enter Cell Data
- TOPIC E: Use Excel Help
- Summary
- TOPIC A: Create Worksheet Formulas
- TOPIC B: Insert Functions
- TOPIC C: Reuse Formulas and Functions
- Summary
- TOPIC A: Insert, Delete, and Adjust Cells, Columns, and Rows
- TOPIC B: Search for and Replace Data
- TOPIC C: Use Proofing and Research Tools
- Summary
- TOPIC A: Apply Text Formats
- TOPIC B: Apply Number Formats
- TOPIC C: Align Cell Contents
- TOPIC D: Apply Styles and Themes
- TOPIC E: Apply Basic Conditional Formatting
- TOPIC F: Create and Use Templates
- Summary
- TOPIC A: Preview and Print a Workbook
- TOPIC B: Set Up the Page Layout
- TOPIC C: Configure Headers and Footers
- Summary
- TOPIC A: Manage Worksheets
- TOPIC B: Manage Workbook and Worksheet Views
- TOPIC C: Manage Workbook Properties
- Summary
- TOPIC A: Add Borders and Colors to Worksheets
- TOPIC A: Customize General Options and the Excel UI
- Mastery Builder 1-1: Creating and Saving a Workbook Activity
- Mastery Builder 2-1: Creating and Reusing Formulas and Functions
- Mastery Builder 3-1: Modifying a Worksheet
- Mastery Builder 4-1: Formatting a Worksheet
- Mastery Builder 5-1: Printing Workbooks
- Mastery Builder 6-1: Managing Workbooks
- TOPIC A: Work with Ranges
- TOPIC B: Use Specialized Functions
- TOPIC C: Work with Logical Functions
- TOPIC D: Work with Date & Time Functions
- TOPIC E: Work with Text Functions
- Summary
- TOPIC A: Sort Data
- TOPIC B: Filter Data
- TOPIC C: Query Data with Database Functions
- TOPIC D: Outline and Subtotal Data
- Summary
- TOPIC A: Create and Modify Tables
- TOPIC B: Apply Intermediate Conditional Formatting
- TOPIC C: Apply Advanced Conditional Formatting
- Summary
- TOPIC A: Create Charts
- TOPIC B: Modify and Format Charts
- TOPIC C: Use Advanced Chart Features
- Summary
- TOPIC A: Create a PivotTable
- TOPIC B: Analyze PivotTable Data
- TOPIC C: Present Data with PivotCharts
- TOPIC D: Filter Data by Using Timelines and Slicers
- Summary
- TOPIC A: Insert Graphical Objects
- TOPIC B: Modify Graphical Objects
- TOPIC C: Work with SmartArt
- TOPIC A: Use Array Formulas
- Mastery Builder 1-1: Working with Functions
- Mastery Builder 2-1: Working with Lists
- Mastery Builder 3-1: Analyzing Data
- Mastery Builder 4-1: Visualizing Data with Charts
- Mastery Builder 5-1: Using PivotTables and PivotCharts
- TOPIC A: Use Links and External References
- TOPIC B: Use 3-D References
- TOPIC C: Consolidate Data
- Summary
- TOPIC A: Use Lookup Functions
- TOPIC B: Trace Cells
- TOPIC C: Watch and Evaluate Formulas
- Summary
- TOPIC A: Collaborate on a Workbook
- TOPIC B: Protect Worksheets and Workbooks
- Summary
- TOPIC A: Apply Data Validation
- TOPIC B: Search for Invalid Data and Formulas with Errors
- TOPIC C: Work with Macros
- Summary
- TOPIC A: Create Sparklines
- TOPIC B: Map Data
- Summary
- TOPIC A: Determine Potential Outcomes Using Data Tables
- TOPIC B: Determine Potential Outcomes Using Scenarios
- TOPIC C: Use the Goal Seek Feature
- TOPIC D: Forecasting Data Trends
- Summary
- TOPIC A: Import and Export Data
- TOPIC A: Internationalize Workbooks
- TOPIC A: Work with Power Pivot
- TOPIC A: Customize Advanced Options
- TOPIC A: Work with Forms and Controls
- Mastery Builder 1-1: Working with Multiple Worksheets and Workbooks
- Mastery Builder 2-1: Using Lookup Functions and Formula Auditing
- Mastery Builder 3-1: Sharing and Protecting Workbooks
- Mastery Builder 4-1: Automating Workbook Functionality
- Mastery Builder 5-1: Creating Sparklines and Mapping Data
- Mastery Builder 6-1: Forecasting Data
Hands on Activities (Labs)
- Exploring the backstage view
- Adding and replacing the data in an excel sheet
- Saving a workbook
- Copying and pasting the text
- Opening the Excel help
- Creating worksheet formulas
- Using the Average function
- Using the SUM function
- Using the Autofill function
- Finding and Replacing the text
- Checking spelling and grammar
- Changing the worksheet font color
- Changing the number format
- Wrapping text
- Formatting a cell range as a table
- Applying a theme to a table
- Applying conditional formatting
- Saving the workbook as an Excel Template file
- Printing an area
- Setting page margin
- Configuring page setup for printing
- Adding a header and footer
- Adding color to the worksheet tabs
- Freezing the top row
- Creating a custom workbook property
- Calculating the years of service values
- Using the SUMIF function
- Changing date format
- Using the Concatenate function
- Filtering data
- Sorting data and using the Subtotal feature
- Deleting duplicate rows and sorting the table
- Formatting values that are above or below average
- Using logical functions
- Inserting a chart and changing the chart style
- Changing chart color
- Customizing a chart
- Creating a combo chart
- Creating a PivotTable and PivotChart and inserting slicers to filter the PivotTable
- Consolidating the quantity of products data
- Using VLOOKUP
- Adding a watch to several cells
- Adding comments
- Protecting a workbook
- Adding data validation
- Creating Sparklines
- Creating a scenario that preserves the original values
- Copying the original data using the Goal Seek feature
- Creating a forecast sheet from monthly sales data
LO-EXCEL-2016
uCertify provides Courses, Hands-on Labs, Test Prep for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe, and many more.
© 2002-2019 uCertify.
All Rights Reserved
Know Us
- About us
- Careers
- Partners
- Sitemap
- Contact us
- Terms & Conditions
- Privacy Statement