Microsoft® Excel 2016 Crash Course: Learn Excel in Two Days!

‘

Course Description: This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level, as well as those who are self-taught and want to learn short cuts and tips, plus some of the more advanced features.  Packed full of information, topics range from fundamentals (using shortcuts) through advanced topics.  The topics in this class are the most often-used and are a combination of features taught in the Foundations, Intermediate and Advanced Topics courses.

Course Outline:

Use the Excel Ribbon
Contextual Tabs
Quick Access Toolbar
Shortcut menus
Changing views

Entering Data Into a Worksheet
Entering text (labels)
Editing text with the formula bar
Replacing contents of cells
Using delete, undo/redo
Using AutoFill to enter data
Customize AutoFill
Use a List to enter data

Using a Simple Formula
Resizing the Formula Bar
Enter a Formula using the keyboard
Enter a cell or Range Reference using the mouse
Using AutoSum to calculate totals
Using Relative References
Using Absolute References

Using Simple Functions
Enter a function directly
Using AutoComplete to create formulas
Turn Formula Autocomplete on and off
Insert other functions using AutoSum button
Using AutoCalculate to do a calculation without a formula

Adjusting Rows and Columns
Adjust Rows and columns using the mouse and the Menu
Hide/Unhide rows and columns
Freeze a column or a row
Split a worksheet into panes

Formatting Cells Using Ribbons
Change the font and font properties
Align data in a cell
Indent data in a cell
Merge cells
Change numbers to percentages
Increase/decrease decimal places
Copy a format using Format Painter

Creating A Chart
How To Insert a Chart
How To Move a Chart
How To Resize a Chart
How To Change The Chart Type
How To Add, Edit or Remove a Chart Data Source
How To Swap Labels In The Legend With The Horizontal Axis
How To Change The Order Of a Data Series
How To Move An Existing Chart To a New Worksheet

Formatting a Chart
How To Select a Chart Element
How To Format The Chart Elements
How To Format Text In a Chart Using WordArt
How To Change The Text Orientation
How To Change The Color Of a Chart Element
How To Create a Combination Of Chart Types
How To Create a Pie Chart
How To Set The 3-D Rotation
How To Explode a Wedge In A Pie Chart
How To Create a Picture Chart

Setting Up a Page and Printing
How To Insert And Remove a Page Break
How To Set And Clear The Print Area
How To Change The Margin In The Page Layout View
How To Change The Page Orientation
How To Change The Scaling
How To Change The Paper Size
How To Change The Page Margin
How To Align To The Center Of The Page
How To Add A Header / Footer
How To Add An Image As a Watermark

Previewing and Printing
How To Preview The Print
How To Print Active Sheets
How To Print Selected Cells
How To Print A Chart
How To Print Multiple Copies

Creating Tables
How To Create a Table
How To Change The Style Of a Table
How To Create A New Table Style
How To Show Or Hide Table Elements
How To Create A Calculation In a Table
How To Insert And Delete A Table Row
How To Resize a Table
How To Convert A Table To a Range
How To Sort The Data In a Table
How To Perform Multiple Sort
How To Customize The Sort Order

Using The AutoFilter
How To Enable / Disable The AutoFilter
How To Apply / Remove The Filter
How To Customize The Filter

Using The Advanced Filter
How To Define The Criteria Range
How To Use The Advanced Filter

Creating a PivotTable
How To Create a PivotTable
Updating a PivotTable
How To Update The Information In a PivotTable
How To Change The Layout Of a PivotTable
How To Add An Information Field To a PivotTable
How To Arrange Information In a PivotTable
How To Filter The Report In a PivotTable
How To Filter Specific Records

Exploring What-If Tables
How To Create a One Variable What-If Table
How To Create a Two Variables What-If Table

Using Scenarios
How To Create Scenarios
How To Apply a Scenario

Implementing Problem Solving
How To Use The Goal Seek Tool
How To Load Add-Ins
How To Use The Solver Tools

Validating, Protecting, and Auditing Forms and Templates
Using Data Validation And Tracing Invalid Data
How To Validate Data Input
How To Compose A Data Input Message
How To Create An Error Alert Message
How To Circle Invalid Data

Protecting Worksheet Styles, Contents And Elements
How To Protect The Worksheet
How To Unprotect The Worksheet
How To Unlock Cells For Editing In A Protected Sheet
How To Hide A Cell Formula
How To Set A Password To Edit A Specific Range
How To Grant Selected Users Permission To Edit A Range Without A Password

Auditing Worksheets And Tracing Cell References
How To Find Cells That Provide Data To An Active Cell (Precedents)
How To Find Cells That Are Referred To By An Active Cell (Dependents)
How To Correct Calculation Errors
How To Set Error Checking Options
How To Scan And Correct All Errors
How To Use The Watch Window

Working with Advanced Formatting, Styles and Outlining
Customizing The Appearance Of Data With Advanced Formatting
How To Use The Built-In Number Formats
How To Customize The Number Format
How To Customize The Date Format

Using Conditional Formatting
How To Use The Conditional Formatting To Highlight Cells
How To Use The Data Bars
How To Use The Color Scales
How To Use The Icon Sets
How To Edit The Rules
How To Change The Precedence Of The Rules
How To Stop A Rule
How To Clear The Rules

Using Data Outlining
How To Create An Outline Automatically
How To Remove An Outline
How To Create An Outline Manually
How To Use A Subtotal To Create An Outline
How To Show / Hide Details Using Outline Symbols

Working With Multiple Worksheets and Workbooks
Managing Data in Multiple Worksheets
How To Select Adjacent Worksheets
How To Select Non-Adjacent Worksheets
How To Enter Data Into Multiple Worksheets

Using Range Names
How To Define Names Quickly
How To Define A Range Name Manually
How To Define A 3-D Range Using The Menu
How To Manage Names Using The Name Manager
How To Redefine The Cell References For A Range Name
How To Insert A Name In A Formula

Combining Worksheets And Data From Different Workbooks
How To Consolidate Data
How To Move Or Copy Worksheets to Another Workbook
Linking Information From Different Worksheets And Workbooks
How To Link Information Using Copy And Paste Link
How To Update A Link

Using Advanced Functions
Using Financial Functions
How To Use The PMT Function
How To Use The ABS Function

Using Logical Functions
How To Use A Logical Test
How To Use The IF Function To Return A Text
How To Use The IF Function To Return A Value
How To Use A Nested IF Function
How To Use The OR Function
How To Use The AND Function
How To Use the COUNTIF Function

Understanding Macros
How To Record A New Macro
How To Run A Macro
How To Create A Run Macro Button On The Quick Access Toolbar

Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22