Views on a worksheet

Depending on what we want to acomplish it is possible to use several different views on the worksheet. These views make it easier to get into large tables or to adjust the appearance of the work environment in accordance with our own desires. In this way, Excel can be configured to resemble more like a data entry form or print preparation software. Personally, when preparing to print a document, I often use the Page Layout view, and in the text that follows, you will see and why!

Ribbons and shortcuts

Excel 2007 brought a new work environment based on ribbons. This novelty was annoyed by many experienced users (who were able to set shortcuts to the most commonly used options) and delighted new users (who saw some options they did not even suspect that existed). In order to “calm down passions,” Office programmers first added the Quick Access Toolbar and the ability to adjust the toolbar content (Office 2010).

Data series within a chart

Charts can be based on one or more data sets. More series are used when we want to show business results by quarter or over a few years. When making such charts, it is important to pay attention to the subtype as it determines their appearance. That is, we should choose whether to make a Stacked or Clustered chart. Also, during work with such charts, users may need to add, edit or delete series of data…

What kind of charts exist?

It’s not too difficult to create a chart, but you need to choose the type that best reflects our data. Excel has a multitude of charts, and every one of them suits best certain types of data. In the text that follows you will meet most commonly used charts, with suggestions on how to choose the right one that will meet your needs.

Worksheet manipulation

The data we enter and process is often found in multiple spreadsheets. Depending on the version of Excel you’re using, after starting the program, each new document has one or more worksheets present. The number of worksheets appearing in each new document can be set in general options, and users can add, delete, move, change color or name of the worksheet on their own. The redistribution of the table on the worksheets can help you get a lot more organized.