Excel BI Tools: Power BI for Excel Users

Days : 2
Price :

This product is currently out of stock and unavailable.


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.

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