Microsoft Access is database application software that lets you create database of various sorts with ease. The best part about Microsoft access database is that it helps one to quickly track and report information. It provides the user with rich user interface and interactive design capabilities. It can also be used for web applications. Data macros in Access enable you to add logic to events that occur in tables such as adding, updating, or deleting data.
In Microsoft Office Outlook you can easily save the views you are working on. There are three default views and others you can create yourself.
To learn how to save view in Outlook and then later reset them, follow the tutorial below.
Excel provides its user with excellent sorting options. You can filter your data in Excel as per your requirements. Sorting in Excel allows you to re-arrange data as per your needs. In the tutorial, we will show you how to filter data according to multiple criteria.
In this tutorial, we will teach you basic and multi-field sorting in Excel.
Sorting data at times can be a huge problem when you have so many rows and columns and so much of data in them. Excel allows you to sort data the way you want. You will have a lot of choices as to how you want to sort it. For example you can classify your data according to the departments. Sorting data in Excel can be done easily by inserting a table. Even more you can delete duplicate entries in Excel after you add them in a table.
Follow this step by step tutorial to learn how to use tables in Excel to sort and filter data.
Microsoft Excel allows you to do calculations using formulas and functions. With the use of these formulas in excel you can easily calculate anything. There are some built in functions that you can use or you can use your own formulas as well. There are over three hundred functions in Excel. A function is a pre made formula so you can directly enter it by writing the name of the function and the rest of the formula will be showed to you automatically.
To learn in Microsoft Excel to how to use formulas and functions follow the tutorial below.
You can hide a column and hide a row in Excel easily of you do not require that data for the time being. Such data can be removed from view and can be brought back anytime as per your requirement.
You can also group data in Microsoft Excel that allows you to manage it better.
To learn how to hide and group rows and columns in Excel, follow the tutorial below.
Excel workbook has multiple sheets in a single workbook. You can add as many sheets in it as you like. In this tutorial we have worksheets which are exactly the same except for the values in them. While using Microsoft Excel if we want to make changes in all of them, instead of making changes in them one by one we can easily do that in one go.
Follow this step by step tutorial to learn how to calculate formula in excel across separate worksheets.
Microsoft Excel provides several levels of protection for your valuable workbooks by using passwords. However If you forget or lose your passwords, you won’t be able to undo the areas you protected by any normal means.
To learn how to set workbook permissions in Excel follow this tutorial.
When numerous users are working on an Excel spreadsheet, they may want to leave comments for the other user to see. This comment box comes in very hand in case you want to make a note and discuss it in detail with someone later. In this tutorial, we will teach you how to add comments, edit them and navigate through them.
In this tutorial, we will teach you how to insert and edit comments in Excel.
Many users avail the share features in Excel. In Excel, one can share workbook with other users. In this tutorial, we will teach you how to track changes these other users make in your Excel workbook. Highlight these changes, review them and then decide whether you want to accept or reject the changes.
In this tutorial, we will teach you how to share workbook and track changes in Excel.
Home