Neue Tipps & Tricks
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”, [...]
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 [...]
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 [...]
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: 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 [...]
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 [...]
YOUR OBJECTIVE When you copy or cut objects, they are added to the excel clipboard. Typically the last item added to the clipboard is pasted. You can, however, also access and paste items previously copied or cut to the excel clipboard. In this learning module you will learn how to use the excel clipboard and what settings you can apply to it. HOW DOES EXCEL CLIPBOARD WORK? The clipboard is one of Windows' storage facilities. Every active programme can access it, temporarily store data ......
If you use a tablet with Windows 8, then you have probably already seen the on-screen keyboard and noticed that it is missing some features. We explain how to open the on-screen keyboard in Windows 8. To use the on-screen keyboard in Windows 8 You can only use your on-screen keyboard if you own a touchscreen device that runs Windows 8. With a touch screen device, the keyboard will appear at any time the user clicks a field that requires text. Let’s use the Windows Explorer function as an e......
Use excel to edit chart: YOUR OBJECTIVE You generated a chart to graphically depict your company's sales data, but now, to better suit your needs, you want to alter some of the chart's elements, such as the number format used on the vertical axis and possibly the chart's background. In this learning module “ Excel: Edit chart", you will be shown how to edit various chart elements and some thing to consider when doing so. Use excel to edit chart: HOW DOES IT WORK?......
Excel percentagesYOUR OBJECTIVE For your business, you want to determine how much each of several product categories contributed to total sales. To best understand the data, you wish to present the contributions in terms of percentage of total sales. In this learning module “Excel percentages” you will discover how to use Excel to calculate percentages and some of the things you should consider when doing so. Excel percentages: HOW DOES IT WORK? An Excel spreadsheet that contains......
YOUR OBJECTIVE Your company just acquired a new machine for $10,000. This machine has a useful life of ten years. It has been estimated that it will then have a residual value of $2,500. Bookkeeping asked you to use the sum-of-years' digits depreciation method to calculate how much it should be depreciated each year. Excel amortization and the SYD function use this method to calculate depreciation. In this learning module, you will be shown how to use the excel amortization and the SYD functi......
Excel pivot filter: YOUR OBJECTIVE You generated a pivot table. At this moment you are interested in viewing and understanding various aspects of your data. Perhaps you want to compare certain values; perhaps you want to present particular data without an excess of 'data clutter'. To accomplish such things, it would be expedient if you could temporarily hide some of the data that is available in your pivot table. The pivot table has filter functions that allow you to reduce or control the......