Excel BI Tools: Power BI for Excel Users

All Prices Are in Candian Dollars

Price :

Choose the date and press 'Add To Cart'

No class dates currently scheduled. Click here to request a date

course is guaranteed to run

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