Neue Tipps & Tricks
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”, [...]
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
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
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: 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 [...]
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 [...]
Popular Topics
Find the On-Screen Keyboard in Windows 8 and its use
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......
The excel IF function
Excel IF function: YOUR OBJECTIVE If any of your salespersons sell more of your company's products and services than the average of total sales made by all salespersons, your company will award them a bonus of 2% of their total sales. Since the value of orders can vary, exactly who receives such a bonus and the amount of the bonus can also vary. You want Excel to calculate which salespersons should receive a bonus and how much it should be. Excel's IF function can help you make the requir......
Excel: Remove filter individually
YOUR OBJECTIVE In an Excel table, you used the AutoFilter function to filter a table using criteria in two different columns. But now you want to remove both filters, so that the entire table is again displayed. In this learning module you will learn how to remove filter criteria, one by one. Excel remove filter: HOW DOES IT WORK? In excel you remove filter criteria from a table individually, you will be making use of the filter arrows in the headings of columns in which ......
-
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”, you will discover how to merge multiple cells into one and how to center the contents within it . Excel merge and center:HOW DOES IT WORK? To merge several cells into o......
Excel percentages: Calculating percentages
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......
Excel: absolute reference and relative reference
YOUR OBJECTIVE When copying a formula from one cell to another using the Auto Fill function, you sometimes want a reference to remain unchanged and not be automatically adjusted. With the Auto Fill function, however, the cell references in a formula are automatically adjusted in accord with the position of the new cell. If the automatic adjustment is not suitable for your table, it can lead to an error message or incorrect result. By using an excel absolute reference , however, you can prev......
