22.1 Introduction
Learning Objectives
Create hyperlinks to a wide variety of resources in Excel.
Use the CONVERT function to convert between different units of measurement.
Create an interactive form on an Excel worksheet using UI Controls, VBA, and named ranges.
Solve simultaneous equations using matrices and the MMULT and MINVERSE functions in Excel.
Become familiar with various rounding functions available in Excel.
In this module, we’ll be covering miscellaneous calculations and features. There are some good things to know that just aren’t covered in any other lesson, so we will cover them here. So, think of this as the catch-all lesson of the entire course.
Lesson Files
Miscellaneous Calculations Class File