DJL Training, Inc.
DJL Training, Inc.
Increasing Efficiency and Productivity

Excel 2016, Part x

Excel 2016 Part 1 will equip new learners with an overview of Excel basics, providing a beginner level foundation of the application and prepare learners for Microsoft Excel 2016 Part 2.

Prerequisites: Learners should have a working knowledge of Windows and how to use their mouse and keyboard.

Skill level: Foundation

TAB 1 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.
TAB 2 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to...

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 3 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 4 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 5 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 6 (1 hr)

ABOUT THIS MODULE

You can edit text on your website by double clicking on a text box on your website. Alternatively, when you select a text box a settings menu will appear. your website by double clicking on a text box on your website. Alternatively, when you select a text box.

MODULE OUTLINE

Copy table here.

TAB 7 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 8 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 9 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Copy table here.

TAB 10 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 


MODULE OUTLINE

Copy table here.

Excel 2016 Part 1

Excel 2016 Part 1 will equip new learners with an overview of Excel basics, providing a beginner level foundation of the application and prepare learners for Microsoft Excel 2016 Part 2.

01A Exploring Excel 2016 (1 hr)

ABOUT THIS MODULE

Upon successful completion of this module, learners will be able to... 

Skill level: Intermediate

Prerequisites: 

MODULE OUTLINE

Introducing Excel
 - What Is a Spreadsheet?
 - Cell Ranges
The Excel Environment
 - Exploring the Ribbon, Tabs, and Groups
 - Modifying the Quick Access Toolbar
 - Using Scroll Bars
 - Using the Formula Bar
 - Changing Views
 - Using the Zoom Control
 - Using Tell Me What You Want To Do
Navigating Around a Worksheet
 - Understanding Rows and Columns
 - Working With the Name Box
 - Selecting Cells Using the Mouse
 - Selecting Cells Using the Keyboard
 - Selecting Adjacent Ranges
 - Selecting Non-adjacent Ranges
01B Designing a Spreadsheet From Scratch (1 hr)

Module description goes here...

 Starting with a Template
 - Exploring Templates
 Entering Data
 - Entering and Editing Text
 - Using AutoComplete 
 - Entering and Editing Values
 - Entering and Editing Dates
 - Using Find and Replace
 Adjust Column Width and Row Height
 - Adjusting Column Widths
 - Adjusting Row Heights
 Format Cells
 - Applying Borders and Fill 
 - Changing Cell Alignment 
 - Clearing Formatting
01C Using AutoFill (1 hr)

Module description goes here...

 Enter a Series Using AutoFill
 - Entering a Number Series
 - Entering a Date Series
 - Entering a Text Series
 - Entering a Custom Series
 - Exploring AutoFill Options
02A Managing Worksheets (1 hr)

Module description goes here...

Working With Rows and Columns
 - Inserting and Delete Rows, Columns, and Cells 
 - Hiding and Unhiding Rows and Columns 
 Managing Multiple Worksheets
 - Inserting and Delete Worksheets 
 - Renaming Worksheets 
 - Moving a Worksheet 
 - Changing the Worksheet Tab Color 
 - Hiding a Worksheet 
 - Creating  a Copy of a Worksheet 
 - Editing Multiple Sheets at One Time 
02B Creating and Troubleshooting Basic Formulas (3 hrs)

Module description goes here...

 What is a Formula
 - Understanding the 3 Key Elements of a Formula
 - Exploring a Formula
 - Changing the Inputs of a Formula
 Sample Formulas
 - Translating Formulas from Excel to English
 - Creating Formulas
 - Using the Point and Click Method
 - When to Use a Function
 - Observing Changes to Relative Cell References
 - Using Values in Formulas
 - Introduction to the SUM Function
 Order of Operations
 - Examine Similar and Dissimilar Formulas
 - Multiplication and Division
 - Addition and Subtraction
 - How do you know when you need parenthesis?
 - Why do some formulas need parenthesis and others don't?
 - What difference do parenthesis make?
 Create a Formula
 - Identifying the Purpose of the Formula
 - Stating the Equation in Plain English
 - Entering the Formula
 - Testing the Formula
 - Understanding the Problem With Using Values in Formulas
 - Recognizing Potential Formula Errors
 Reference Types
 - Understanding Relative References
 - Understanding Mixed References
 - Understanding Absolute References
 Auditing Tools
 - Showing formulas
 - Selecting (and format) formula cells
 - Tracing Precedents
 - Tracing Dependents
 - Color-coding precedents
 - Calculating part of a formula
 - Using Status Bar functions
 - Checking for Errors 
 - Evaluating a Formula 
 Error Messages
 - ##### (not an error)
 - #DIV/0!
 - #N/A!
 - #NAME?
 - #NULL!
 - #NUM!
 - #REF!
 - #VALUE!
02C Linking Data With Formulas and Hyperlinks (1 hr)

Module description goes here...

 Define Names for Cells and Ranges
 - Creating a Name in the New Name Dialog Box
 - Using Names to Navigate
 - Using Names to Create Linking Formulas
 - Creating a Defined Name and Modify Its Range
 - Deleting a Defined Name
 - Creating Names from Titles in a Column 
 - Inserting Linking Formulas in a Worksheet
 Perform Worksheet Calculations
 - Creating a Cell Reference to Another Worksheet
 - Creating a Cell Reference to Another Workbook
 Creating Hyperlinks
 - Creating Hyperlinks for Navigation
 - Creating a Hyperlink to a Worksheet Cell
 - Creating a Hyperlink to a File
 - Editing a Hyperlink
 - Navigating with the Hyperlinks
 - Changing the Appearance of Hyperlinks
 - Removing and Restore a Hyperlink
 3-D Cell References
 - Creating a 3-D Cell Reference to One Cell in Several Worksheets
 - Creating a 3-D Cell Reference to a Cell Range
03 Charts (3 hrs)

Module description goes here...

 Create Charts to Compare Data
 - Choosing a Chart Type 
 - Selecting Chart Data 
 - Working With Chart Elements 
 Changing the Appearance of a Chart
 - Applying a Chart Style
 - Adding Chart Elements
 - Changing the Chart Type
 - Formatting the Chart Type
 Move and Size Charts
 - Moving and Sizing Charts 
 Edit Chart Data
 - Editing Chart Data 
 - Filtering Chart Data 
 Creating Sparklines
 - Creating Sparklines 
04A Working with Large Worksheets and Tables (1 hr)

Module description goes here...

 Sort and Filter to Organize Data
 - Sorting Data
 - Filtering Data
 Adjust View Options for Large Worksheets
 - Freezing Panes
 - Spliting a Window
 - Changing the Workbook View
 Using Zoom Tools
 - Using Zoom Tools 
 Multiple Windows
 - Opening a Worksheet in a New Window
 - Working With Multiple Windows
04B Importing and Exporting Data (1 hr)

Lesson Outline

 Importing Data
 - Importing a Text File
 - Importing a Word Table and Text
 - Importing Data from a Text File
 - Converting Text to Columns
Exporting Data
 - Converting Excel Data to Text
 - Saving a Worksheet as a Single File Web Page
 - Publishing the Web Page
 - Saving as a PDF Document
 - Sharing Excel Data with Access
04C Printing and Page Setup (1 hr)

Lesson Outline

 Print a Worksheet
 - Setting the Print Range
 - Page Break Preview
 - Quick Print
 - Print Preview
 - Selecting a Printer
 - Setting the Orientation
 - Choosing Paper Size
 - Scaling
 - Setting Margins
 - Adding a Header or Footer 
 - Repeating Row and Columns
 - Adding a Watermark Image
 - Applying a Background
 - Printing Multiple-Sheet Workbooks

Excel 2016 Part 2

This intermediate level course will expand learners' knowledge with an in-depth look at Excel 2016 and prepare learners for Microsoft Excel 2016 Part 3.

05A Advanced Workbook Formatting (1 hr)

Module description goes here...

 Using the Format Cells Dialog Box
 - Working With Alignment and Indent
 - Rotating Text in Cells
 - Changing Vertical Alignment
 - Wrapping Text
 - Using Shrink to Fit
 - Merging Cells
 - Creating a Customized Border
 - Creating a Customized Fill Formatting
 Format Painter
 - Copying Cell Formatting With the Format Painter
 Formatting with Themes
 - Applying a Theme
 - Customizing a Theme
 - Saving a New Theme
 Formatting with Styles
 - Applying a Cell Style
 - Creating a Cell Style
05B Custom Number Formats (1 hr)

Module description goes here...

 Creating Custom Number Formats
 - Creating a Custom Numeric Format
 - Displaying Text and Spacing
 - Using 4-digit ANSI Codes
 - Displaying Leading Zeros
 - Displaying Percentages
 - Displaying Fractions
 - Displaying Scientific Notation
 - Displaying Zeroes as Dashes or Blanks
 - Changing Font Color
 - Repeating Characters
06A Date Functions (1 hr)

Module description goes here...

 Understanding Date Serial Numbers
 - Applying Custom Date Formatting 
 Entering Time Information in Excel
 - Entering Time Information in Excel 
 Using Date Functions
 - Using Date Functions 
 Entering Date and Time Calculations
 - Entering Date and Time Calculations 
06B Conditional Formatting (1 hr)

Module description goes here...

 Use Conditional Formatting
 - Using a Preset to Apply Highlight Formatting
 - Creating a Conditional Formatting Rule
 - Formatting with Data Bars and Icons
 - Creating Conditional Formatting with Graphics
 - Formatting with a Top Rule
 - Formatting Using a Formula
 - Using the Conditional Formatting Rules Manager
 - Removing Conditional Formatting
07A Text Functions (1 hr)

Module description goes here...

 Using Functions to Modify Text
 - CLEAN, Removes all Nonprintable Characters from Text
 - CONCATENATE, Joins Several Text Items Into One Text Item
 - FIND, Finds One Text Value Within Another
 - LEFT, Returns the Leftmost Characters from a Text Value
 - LEN, Returns the Number of Characters in Text String
 - LOWER, Convert Text to Lowercase
 - PROPER, Capitalizes the first Letter in Each Word of a Text Value
 - REPT, Repeats Text a Given Number of Times
 - RIGHT, Returns the Rightmost Characters from a Text Value
 - TRIM, Remove Spaces from Text
 - UPPER, Convert Text to Uppercase
 - Using Flash Fill
07B IF and Nested Functions (2 hrs)

Module description goes here...

 Perform Advanced Calculations
 - The IF Function 
 Creating Conditional Functions Using IF Criteria
 - Function Syntax 
 Nested Functions
 - Understanding Nested Functions
08A Lookup Functions (2 hrs)

Module description goes here...

 Introducing VLOOKUP
 - Creating a Table Array
 - Assign a Range Name to the Table Array
 - Create a VLOOKUP Formula
08B Outlines and Subtotals (1 hr)

Module description goes here...

 Using the Outline Feature
 - Using the Outline Feature 
 - Outline a Worksheet Manually
 - Outline a Worksheet Automatically
 - Create Groups
 - Using the Outline Bar
 - Ungroup Rows
 - Clear the Entire Outline
 Creating Subtotals
 - Using AutoSum to Sum the List
 - Filtering the List
 - Summing the Filtered List
 - Averaging the Filtered List
 - SUBTOTAL vs. SUM
53 Graphics, Pictures, Clip Art, and SmartArt (1 hr)

Module description goes here...

Working With Illustrations
 - Adding and Editing a Picture
 - Adding and Editing a Screenshot
 - Adding and Editing Clip Art
 - Scaling and Cropping an Image
 - Applying Special Effects
Working With Shapes
 - Inserting and Editing Shapes
Working With SmartArt
 - Inserting SmartArt
 - Formatting, Resizing, and Moving SmartArt
 - Applying a SmartArt Style
Watermarks and Background
 - Adding a Watermark Image
 - Adding a Background

Excel 2016 Part 3

09 Working with Tables (2 hrs)

Module description goes here...

 Working with Tables
 - Creating a Table
 - Formatting a Table
 - Inserting and Deleting Table Rows and Columns 
 - Adding Calculated Columns 
 - Using Enhanced Sorting and Filtering
 Special Table Features
 - Changing the Table Name
 - Formatting the Header Row
 - Adding a Total Row
 - Applying Table Styles
 Understanding Structured References
 - Viewing Structured References
 - Creating Formulas with Structured References
10A Financial Functions (1 hr)

Module description goes here...

 Creating Financial Functions
 - Financial Function Arguments 
 - Creating the PMT Function 
 - Creating the FV Function 
 - Creating the NPER Function 
 - Working With Optional Arguments
10B What-If Analysis Tools (2 hrs)

Module description goes here...

 Quick Analysis Tool
 - Exploring the Quick Analysis Tool
 Using Data Tables
 - Setting Up the Data Table
 - Creating One-Variable Data Tables
 - Creating Two-Variable Data Tables
 Scenario Manager
 - Setting Up the Model
 - Naming the Variable Cells and Results Cells
 - Creating the First Scenario
 - Create the Second Scenario
 - Creating the Third Scenario
 - Showing the Results
 - Editing a Scenario
 - Displaying a Summary of All Scenarios
 Goal Seek
 - Using Goal Seek
 - Using Goal Seek to Adjust a Value
 - Using Goal Seek to Adjust a Percentage
 - Change Values in a What-If Analysis
11 PivotTables and PivotCharts (3 hrs)

Module description goes here...

 Creating PivotTables
 - What Is a PivotTable? 
 - Arranging the Source Data 
 - Removing Duplicates 
 - Adding PivotTable Fields 
 Working with PivotTables
 - Formatting PivotTables 
 - Changing Value Field Settings 
 Filtering a PivotTable
 - Filtering a PivotTable with AutoFilter 
 - Filtering a PivotTable with a Filter Field 
 - Filtering a PivotTable with Slicers 
 Creating Calculated Fields
 - Show Values As 
 - Refreshing PivotTable Data 
 Creating PivotCharts
 - Filtering PivotCharts 
12A Preparing Workbooks for Distribution (1 hr)

Module description goes here...

 Editing Document Properties
 - Editing Document Properties 
 Alternative Navigation Methods
 - Using Find 
 - Using Go To or the Name Box 
 Adding Alternative Text to Objects for Accessibility
 - Adding Alternative Text to Objects for Accessibility 
 Inspecting Your Workbook
 - Inspect a Workbook for Hidden Properties or Personal Information 
 - Inspect a Workbook for Accessibility 
 - Inspect a Workbook for Compatibility 
12B Worksheet Protection (1 hr)

Module description goes here...

Protecting a Cell
 - Locking and Unlocking Cells
 - Hiding Formulas in the Formula Bar
Protecting a Worksheet
 - Allowing Selecting Locked and Unlocked Cells
 - Allowing Formatting Columns and Rows
 - Allowing Using Sort and AutoFilter
 - Allowing Editing Objects
Protecting a Workbook
 - Protect Workbook Structure
 - Mark as Final
 - Encrypt with a Password
Requiring a Password to Open a Workbook
 - Locking an Excel File
51 Comments, Track Changes, and Merging Workbooks (2 hrs)

Module description goes here...

 Working With Comments
 - Review Comments
 - Setting the User Name
 - Insert and Edit Comments
 - Delete Comments
 - Print Comments
 Track Changes
 - Setting the User Name
 - Track Changes to a Workbook
 - Review Tracked Changes
 - Turn Off Track Changes
 Merge Multiple Workbooks
 - Enable Workbook Sharing
 - Enable Track Changes
 - Merge the Workbooks
 - Visually Review the Changes
 - Accept and Reject Changes
 - Disable Workbook Sharing
52 Recording Macros (2 hrs)

Module description goes here...

 Recording Macros
 - Using Macros
 - Verifying Macro Security
 - Recording a Macro 
 - Running an Unassigned Macro
 - Looping a Macro
 - Assigning a Macro to a Shortcut Key
 - Assigning Macros to Shapes

Excel 2016 Part 4

71 Using Paste Special and Go To Special (2 hrs)

Module description goes here...

Paste
 - All
 - Formulas
 - Values
 - Formats
 - Comments
 - Validation
 - All Using Source Theme
 - All Except Borders
 - Column Widths
 - Formula and Number Formats
 - Values and Number Formats
 - All Merging Conditional Formats
Paste Operations
 - Add
 - Subtract
 - Multiply
 - Divide
More Paste Options
 - Skip Blanks
 - Transpose
 - Paste Link
Go To Special
 - Go To Comments
 - Go To Constants
 - Go To Formulas
 - Go To Blanks
 - Go To Current Region
 - Go To Current Array
 - Go To Objects
 - Go To Row Differences
 - Go To Column Differences
 - Go To Precedents
 - Go To Dependents
 - Go To Last Cell
 - Go To Visible Cells Only
 - Go To Conditional Formats
 - Go To Data Validation
72 Adding Interactivity to a Worksheet - Dashboard (2 hrs)

Module description goes here...

Data Validation
 - Add a Drop-down to a Cell
 Working With Developer Form Controls
 - Display the Developer Tab
 - Adding a Button
 - Adding a Combo Box
 - Adding a Check Box
 - Adding a Spin Button
 - Adding a List Button
 - Adding a Option Button and Option Group
 - Adding a Scroll Bar
 - Adding a Combo List
 - Adding a Combo Drop-down
 Using the Camera Tool
 - Adding the Camera Tool to the Ribbon
 - Taking a snapshot
 - Pasting a snapshot
 - Pasting a linked snapshot
TAB 3

Module description goes here...

TAB 3

Module description goes here...

TAB 3

Module description goes here...

DJL Training, Inc. | PO Box 72362 | Durham NC 27722 | www.djltraining.com | firstclass.djltraining.com

(c) Copyright 2010-2019 | All Rights Reserved