Neue Tipps & Tricks

Excel: Merge and center cells

Excel: Merge and center cells

YOUR OBJECTIVE In your Excel table, you added a major heading that applies equally to several columns of data. You want this heading to be centered over those columns. To accomplish this, you want to merge several cells into one and center the title within it. In this learning module “ Excel merge and center”, [...]

introduction_1

Excel: Introduction to functions

YOUR OBJECTIVE Because of the amount of typing involved and the typing mistakes you sometimes make, you feel it is troublesome to use formulas to add together any more than two numbers. For that reason, you would like to find a faster and less error-prone method to do so. Moreover, you often deal with lists [...]

Excel: Lock (freeze) rows and columns

Excel: Lock (freeze) rows and columns

YOUR OBJECTIVE It is often difficult to maintain an overview when working with big tables in Excel: What information is in column D? What name is in row 19? In such instances it is useful to lock the first row or the first column, so that it is always visible, even when you scroll down [...]

Excel cell references: Working with cell references to other files

Excel cell references: Working with cell references to other files

YOUR OBJECTIVE Your company, an ice-cream retailer, does business in several cities. In an Excel workbook, you recorded your company’s first quarter’s sales from all business locations, broken down by ice cream varieties. To obtain a clearer overview, you listed the sales for each month on a separate worksheet. That is, there is a worksheet [...]

Excel edit a chart: Repositioning and resizing a chart

Excel edit a chart: Repositioning and resizing a chart

Excel edit a chart: YOUR OBJECTIVE In an Excel table, you recorded your company’s sales for the first three quarters of 2010. You already created pie charts for the first and second quarters, each on its own separate worksheet. But now you would like to shift both of those charts to the worksheet with the [...]

delte_rows_1

Excel delete rows:Deleting cells, rows, or columns

YOUR OBJECTIVE An Excel worksheet has too many empty rows between the heading and the contents. You don’t like this and want to delete an empty row. There is also a column with sales in British Pounds in your table, which you would like to remove. In this learning module “Excel delete  rows” you will learn [...]