What is Orientation? Orientation, in Excel, means the way text in a cell faces the user. The various ways in which the text maybe oriented in a cell are: Clockwise Counter-clockwise Vertical Up Down Format Cell Alignment Where is the ‘Orientation’ button located? One can find the options for orientation under ‘Home’ menu in the …
Wrapping and aligning text comes very useful to organize and format our data.When we enter a lot of data into cell, by default, what happens is that some of the text gets hidden by the cells adjacent to it. The figure below explains the point. However, this can be prevented by ‘wrapping the text’. What …
Microsoft Excel allows the user to create and design tables according to the needs. This module deals with this and following is a list of topics you will learn from this. Inserting a Table Designing a Table Filtering Expanding a Table What is a Table? A table is a collection of rows and columns which …
Tables in MS Excel – Free Excel Tutorials and Online Training Read More »
Microsoft Excel gives you various options for protecting your Excel. A user has the following options Protecting a specific sheet Protecting a Specific Workbook Allowing Certain Users to Edit Ranges Protecting your Excel-Protecting All Cells in a Sheet Drushti is the Principal of a school. She has some important data about the school on her …
Protecting Your Excel – Free excel tutorials and online training Read More »
‘What-if Analysis’ is an option that allows you to change the values in cells to see how the result would have changed due to the formulas computing this new values. There are three ‘What-if’ tools: Scenario Manager Goal Seek Data Table Where to find the ‘What-if Analysis’ option? Go to the ‘Data’ menu. You can …
What-if Analysis in MS Excel – Free Excel Tutorials Read More »