4. Excel Beyond the Basics: Defined Names
Named cells are called named ranges, and you can easily change and manage them in your workbook. If you know how to use named ranges in Excel, you can read your formulas faster and easier.
Defined name ranges are created and used instead of cell references and functions. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box. In the example, the formula in F6 is: =MAX(sales)
This series of videos are for those who familiar with using Excel and want to pick up more skills. The videos are free to the public; however, you must sign in with your Coventry University email to access the Resources: Demonstration and Practice resources.
Please use your Coventry University email to access the resources.
Use this link to the Demonstration & Practice Resources materials that can be used for particular sills in Excel: https://bit.ly/4a17OJ0
Individual videos will have resources for that video.
You will be able to download the demonstration workbooks that have been used in the videos and you can go along with the demonstrations as a first step. There are hidden practice worksheets and solutions built into the workbook. You can just directly apply your new or more efficient MS skills to your assignment, work or class work.