Description
Course Description
Microsoft Excel 2013 has lots of time-saving tools. This course covers a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data.
Prerequisites
The prerequisites for this course are an introductory Excel course, or equivalent working knowledge of the software
Course Content
Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
Working with Tables
What is a Table?
Creating Tables
Resizing the Table
Choosing a Table Style
Clearing the Table
Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
Using Array Formulas
Resolving Formula Errors
Tracing Formula Precedents and Dependents
Showing Formulas
Evaluating Formulas
Setting Error Checking Options
Using Error Option Buttons
Running an Error Check
Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Deleting Records or Fields
Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
Data Validation Using Lists
Data Validation Using Formulas
Using Database Functions
Using Custom AutoFill Lists
Creating a Custom AutoFill List
Using a Custom AutoFill List
Modifying a Custom AutoFill List
Deleting a Custom AutoFill List
Using Comments
Inserting Comments
Editing Comments
Navigating Through Comments
Deleting Comments
Linking, Consolidating, and Combining Data
Linking Workbooks
Consolidating Workbooks
Consolidating Worksheets