Microsoft Excel 2021: Customization

Name: Microsoft Excel 2021: Customization
Author: Bob Akbar

Learn how to increase productivity through shortcuts, menu customization, and data input limitations.

Preview the first lesson free — get full access to all 3 lessons.

Course: On-Demand

Hello, my name is Bob Akbar, and in these lessons you will learn, Customization, which includes shortcuts, menus, and Liberty Data values. In this lesson, I will show you how to use some of the most useful shortcuts. Shortcuts help us to be able to do things faster by not having to navigate menus. For example, if we want to continuously click on things, look for them. It does take up some of our time and it does reduce our productivity. For example, help one clicks. The faster way of doing this is if we simply press F1, and there it is. The help screen does come up. Although for this lesson, we are not connected to it live. Next, if we do Control F1, the ribbon, which we can collapse or view from here, can be activated or deactivated. Next, we have alternate shift and F1, which gives us inserting a new worksheet, which usually would be down here, where we would go in, click Insert, and it would ask us what we want to insert, we would select worksheet, click OK, and you see how much time that takes. If we simply do alternate shift F1, there it is, much faster, much more efficient to get our information in there. Some of the other ones that we are going to do that are useful for us is Shift F3, which does insert function, and look at that. This beautiful screen pops up. It is a wonderful wizard. I can tell you this from being a programmer, from being an instructor. It is one of the fastest ways to get your functions up there, and it classifies them so that you can go and select the category that is the most to your advantage. For example, if I want to do statistical functions, there it is. I know middle distributions, and even count if is in there. If I want to do date and time, I can do an extract month to date. If I want to do logical, which is also Boolean, I can do and if not before, reduce. To give you a contrast of if we are not using the Shift F3 shortcut, here is what we had learned before. I know what most people know as you hit the equal sign, and you start typing. Kind of have to guess. Once you start typing, it gives you a list. You would have to know which function you are looking for to approach it this way. The other way is if you would actually go to formulas, and it would go through the drop downs, and you would find the math and trig, and if you wanted to find the absolute value, it would go in there, the code tangent, and so forth. However, easier way is for us to use Shift F3. Next, it is one of my favorite ones, which I will not demonstrate right now, but if you are trying to close everything really fast and save things, especially useful if you are having power fluctuations, or if there is a case where somebody is about to walk into your office and you don't want to show things, alternate F4 systematically starts closing every single program and application that is on your desktop. It is excellent especially for data security. If you see somebody that is approaching your office, you may not have been expecting them, or there is something on the screen that is sensitive, you do not want it to be shown. Alt F4 will do. And I will give you a quick example. You see how we have the screen, Alt F4, and it's gone. That's it, that way. Next, let's take a look at the F6. The F6 alone switches between the worksheets, ribbon task panel, and so forth. So, let's use F6 and see what it does for us. And it brings up the different screens, and if we do F7, it will actually bring us up spelling, which is something a lot of people forget to do. However, if you just remember, before you do your Alt F4, if you hit F7, you do a quick check of your spelling. And there we are. Of course, there was nothing for us to spell check. Next, we want to do macros. And I know a lot of people do not use macros, but some of you may be using macros. Alt F8 is another quick way to get into the advanced function of macros. And there it is. You have your customized macros saved in there, so that you can use them as you need them to create them, edit them, delete them, and do so forth. Stay tuned for the next lesson, where I will show you many news. Thanks for watching.

Advanced Provider : Bob Akbar 3 Lessons · 22m in English

Course Description

One of the hidden secrets of Microsoft Excel is the ability to customize the software to your specific needs and requirements. Customizing your workbook allows you to work more comfortably and efficiently.

In this course, we will discuss customization in Microsoft Excel. You will learn how to use some of the most useful shortcuts. Shortcuts boost productivity by reducing time spent navigating menus. We will explore ways to customize menus in Excel to improve your workflow. Finally, you will learn about limiting data values, also known as data validation. Data validation allows you to set restrictions for a set of cells, such as only allowing values between one and 100. This can improve ease-of-use for all users within the workbook.

What You'll Learn

Use Microsoft Excel shortcuts to navigate more efficiently and reduce time spent in menus
Customize Excel menus to improve your workflow
Apply data validation to limit the values allowed in a set of cells
Set cell restrictions, such as only allowing values between one and 100
Customize your workbook to work more comfortably and efficiently

Key Takeaways

Microsoft Excel can be customized to your specific needs and requirements, letting you work more comfortably and efficiently.
Shortcuts boost productivity by reducing the time spent navigating menus.
Excel menus can be customized to improve your workflow.
Data validation lets you set restrictions for a set of cells, such as only allowing values between one and 100.
Limiting data values through data validation can improve ease-of-use for all users within the workbook.

Frequently Asked Questions

What does this Excel customization course cover?

The course covers customizing Microsoft Excel through three lessons: Shortcuts, Menus, and Limiting Data Values. You learn how to use useful shortcuts, customize menus to improve your workflow, and apply data validation to set restrictions on cells.

What is data validation in this course?

Data validation, also referred to as limiting data values, allows you to set restrictions for a set of cells, such as only allowing values between one and 100, which can improve ease-of-use for all users within the workbook.

Why are shortcuts taught in this course?

Shortcuts are taught because they boost productivity by reducing the time spent navigating menus, helping you work more efficiently in Excel.

What skills does this course relate to?

The course relates to skills including Microsoft Excel, Excel Macros, User Customization, Microsoft Office Specialist, Microsoft Office Specialist (MOS) - Excel, and Microsoft Office Specialist Master.