This Expert level course is aimed at learners who want to get the most out of MS Excel and who have a very good practical knowledge of using MS Excel.
By the end of this course you will be to create dynamic ranges, use ISERR, ISBLANK and ISNA functions and DSUM and DCOUNT. You will also take macros to another level by exploring the Visual Basic Editor and turning off screen flashing. Lastly you will explore further features with pivot tables such as filtering fields and calculated items
Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete.
You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.
Course Content
string(3) "596"
Advanced Features
Creating a Dynamic Range Name
Assigning a Name to a Formula
Applying Custom Data Validation
Using Offset Functions
More on Pivot Tables
Grouping Fields
Creating Calculated Fields
Creating Calculated Items
Creating Filter Fields
Showing Filter Page Fields
Drilling Down into the Data
Creating a Table from Multiple Ranges
Using VLookup In Pivots
Working with Macros
Assign a Macro to a Worksheet Control
Exploring the Visual Basic Editor
Making Simple Changes to a Macro
Turn Off Screen Flashing
Creating a Worksheet Function
Using a Worksheet Function
Distribute a Worksheet Function
Excel Integration
Create a Link in a Cell
Link to a Website or a File
Link to a Location in a Workbook
Link to an Email Address
Link to a Graphic
Using Excel Data in Word
Using Excel Charts in Word
Using Excel Data as a Mail Merge
Information Functions
ISERR
ISERROR
ISBLANK
ISNUMBER
ISNA
Database Functions
DSUM and DCOUNT
DMIN and DMAX
DAVERAGE
Use the X inside a lesson to save your progress.Continue
