MS Excel 2016 - Expert
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.
Creating a Dynamic Range Name |
Assigning a Name to a Formula |
Applying Custom Data Validation |
Using Offset Functions |
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 |
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 |
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 |
ISERR |
ISERROR |
ISBLANK |
ISNUMBER |
ISNA |
DSUM and DCOUNT |
DMIN and DMAX |
DAVERAGE |