Excel: Popular topics

 

  • Excel borders: Drawing borders around cells and cell ranges
    YOUR OBJECTIVE You already created an Excel table, but now want to make it easier to read and understand. To accomplish that, you want to format it by drawing various borders. In this learning module, you will find out how to apply excel borders to cells or cell ranges. HOW DOES EXCEL BORDERS WORK? When working with Excel borders, gridlines are usually visible on your screen. However......
  • Excel: Print a chart
    Excel: Print chart -YOUR OBJECTIVE You want to print charts without printing their underlying data tables. In this learning module “ Excel:Print chart”, you will be shown how to print Excel charts with or without their underlying data tables. Excel: Print chart - HOW DOES IT WORK? To print out a chart, first go to the worksheet with the chart. The chart may have been generated on its own......
  • Excel amortization: The SYD function
    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 depreciat......
  • 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 t......
  • Excel current date function: Inserting Headers and Footers
    Excel current date function: YOUR OBJECTIVE Using Word, you created a multipage document. Now you want to print the sender's address at the top of every page. At the bottom of every page, you want to show your bank information. In this learning object “Excel current date” , you will find out how to insert Headers and Footers in your document and some things you must keep in mind wh......
  • Excel: The COUNT and COUNTA functions
    Excel COUNT and COUNTA function: YOUR OBJECTIVE You are using Excel to compile a list in which you want to keep track of how many entries have been made in a certain column. To determine how many cells within a defined range contain content, you can use the excel  COUNT and COUNTA functions. In this learning module, you will find out how to use the excel COUNT and COUNTA functions. &nbs......
  • Excel filter: Filtering a column using two criteria (AND operator)
      Excel filter: YOUR OBJECTIVE You recorded your customers' orders in an Excel worksheet. Now you want to display the data rows with orders for article numbers that begin with the letters HD. However, you don't want to display any orders with the article number HDG1. To do this, you have to apply an Autofilter that uses the AND operator to combine two filter criteria. In this lea......
  • Excel: cut and move function
    YOUR OBJECTIVE If you want to move the content of a cell to a different place in your table, you can cut it out and paste it into the new position. You can also move it using the mouse. In this learning module “ Excel cut  and move function” you will learn how to move cell content.   HOW DOES THE EXCEL CUT AND MOVE FUNCTION WORK? Excel Cut To move the content of a cell to ......
  • Excel: Select from list – Changing the font and font size
    Excel select from list:YOUR OBJECTIVE You are creating a Word file and you want to change the font as well as the font size.   In this learning module “excel select from list”  you will learn how to change the font and the font size .   Excel select from list: HOW DOES IT WORK? To change the font and/or the font size, you first need to select the text passage you wan......
  • Excel criteria: Filtering criteria in more than one column (AND)
    YOUR OBJECTIVE Using the AutoFilter function, you filtered a table by setting a criterion in one column (e.g., Customer name). But now you want to further constrain the (already filtered) data sets by filtering them through the addition of another filter in a different column. In this learning module “Excel criteria”, you will discover how to filter a table by applying filter criteria in m......