Tag Archives: Excel

Office

How to Understand Formulas and Functions in Excel

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.


read more »

Office

How to Hide or Group Rows and Columns in Excel

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.


read more »

Office

How to Calculate Formulas Across Worksheets in Excel

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.


read more »

Office

How to set Workbook Permissions in Excel

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.


read more »

Office

How to Insert and Edit comments in Excel

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.


read more »

Office

How to Share a Workbook and Track Changes 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.


read more »

Office

How to Join Data from Multiple Cells in Excel

In this tutorial we will be showing you how to join cells in Excel such that their data is combined into one cell which was previously present in two cells. People have a whole list of names of employees in their excel sheets. This can go up to several hundred or even thousands of rows. Suppose if you want to join or merge the data from two cells into one then it would take a lot of time. In order to do that you can use a formula that will do this step for you easily.
Follow this step by step tutorial to learn how to combine two Excel cells such that their data is combined into one.


read more »

Office

How to Find the Commands You Need and Use Backstage View or the File Tab in Excel

In this tutorial, we will teach you how to find commands in Excel. The new version of Excel comprises of the Ribbon bar. This ribbon bar contains eight tabs which provide the user with different options. This tutorial will provide an overview of Excel to the viewer.
Furthermore, we will show you the options you can work with in the backstage view that Excel provides. You can access the backstage view by clicking on the file button and find commands in Excel.


read more »

Basics

How to insert an Excel spreadsheet in Microsoft Word 2010

If you want to use an excel spreadsheet, you can simply insert excel spreadsheet from a table in a document. Insert spreadsheet in Word so that you can perform all the actions that you’d otherwise perform in Excel. You can do calculations with your data by inserting different formulas and arrange the data in a spreadsheet table.
In this tutorial, you will learn how to insert an Excel spreadsheet in word.


read more »

Office

How to Using Sum and AutoSum in Excel 2010

Whenever you have to work with tons of numbers and make various calculations, use the sum function in Excel to make your task easy. You can also apply autosum in excel to make calculations for you. Furthermore in this tutorial, we will show you how to check these functions at a glance for any errors that might exist. Follow this step by step guide and master the sum functions that Excel has to offer.
In this tutorial, we will show you how to add numbers using Sum and AutoSum in Excel.


read more »