Tag: Excel

Using OFFSET Function in Databases in Microsoft Excel

Using OFFSET Function in Microsoft Excel

Now we are going to see how works the OFFSET function. With the OFFSET function you can returns a reference that is a number of rows and a number of columns from a cell or range of cells selected With this function you can get the specific value in a database, that allows you to search information in big lists of data Let’s see the video and learn how to use the OFFSET function, you can use it with the MATCH function explained in the last video and search specific values in a Database. You can learn more about Microsoft Excel functions and applications here: Excel Training Videos

Using MATCH Function to Manage Databases in Excel

Using MATCH Function to Manage Databases in Excel

In the following video, we are going to use the MATCH function, this functions used with another useful function the OFFSET function, allows you to search specific values in a database

These two functions are really easy to use, and when you learn to use it very well you can get the most out of the manipulation of data in large lists Let’s see the video and learn how to use initialy the MATCH function and let’s begin to get data of big lists and databases.

Excel has more and less 300 functions and you can make a lot of formulas to simplify your work. Learn how to construct formulas with the following tool: Excel Formula Helper E-Book

List of Reminders and Future Tasks in Microsoft Excel

In Microsoft Excel, you can manage all your tasks, or to-do lists in an easy way. With the following video you can see how easy you can manage your time. You now can see that Excel is a place where you can make a lot of things, including some simple applications that allows you to save time.

 

Multi Page Userform in Microsoft Excel

Multi Page Userform in Microsoft Excel

This is an Employee Database VBA Code in Microsoft Excel. Here you can learn how to construct the code in VBA that allows you to manage the employee database in your business. Save a lot of time creating this Excel Application using VBA code and Userforms. You can change the Userform too and customize it to your needs, learn the code logic and change the parameters that you need.

 

The Microsoft Excel Quick Access Toolbar

Microsoft Excel Quick Access Toolbar

Learn how to use the Quick Access Toolbar, showed in the left upper corner of the Excel Window.

In this bar you can put every excel command that you use frequently. The most common are the Save button, Print Preview button, Undo and Redo commands, and so on.

The Microsoft Excel Quick Access Toolbar

But if you right-click you can enter to the customizing menu, and put the Excel command that you use very often. See in the following video how to customize the Quick Access Toolbar:

Using the Menu System: Microsoft Excel

Using the Menu System in Microsoft Excel

The excel menu system is a basic knowledge that you have to learn initially. In the ribbon, you can find almost every command to use in Microsoft Excel; you can find all that commands organised in tabs, according to each command use.

The Excel Ribbon in Microsoft Excel
You can find button about formatting, inserting objects, about formulas, about data, view and review, and the file management options.

The Microsoft Excel File Tab Menu

Put the mouse cursor in each button without clicking and you can find an explanation of the button, try to explore all this commands and you can learn what are all the powerful tools that Microsoft Excel has. Learn more about the Microsoft Excel Ribbon in the following video: