Archive by Author
Excel Count
The Excel COUNT function counts the number of cells in a range that contain numbers. This function will not include blank cells or cells that contain non-numeric values (like words). To use the count function, type “=COUNT(A1:A10)” into the cell you want to hold the result. A1 to A10 is the range I chose, so you should substitute that with your own range.
Full StoryExcel Keyboard Shortcuts
Excel shortcuts can save you time when you are editing your spreadsheets. Keyboard shortcuts like ctrl-o to open a document, ctrl-n to create a new document and ctrl-s to save are common across all Microsoft Office programs, but there are some that are unique to Excel. Their use will help you get things done much quicker and will save you the hassle of searching for commands on the ribbon. It might take a little time to learn these shortcuts, but that time is well spent.
Full StoryExcel Merge And Center
Often in your worksheets, you’ll need a title or heading to span multiple cells and you’ll want Excel to display the title or heading in the center. This is where Excel’s merge and center command comes in.
Full StoryTables In Excel 2010
A table is a range of cells that hold data, with each row corresponding to a single occurrence of an entity. When you create a table, you can manage and analyze the data in that table independently of data outside the table. You can format the table, filter the table columns and also publish a table to a server that is running Windows SharePoint Services 3.0 or Windows SharePoint Services “4″. Usually there is an initial row of text headings that describe the columns of data.
Full StoryExcel Sum
Summing is simply the act of adding values together. Excel provides multiple techniques that you can use to sum data.
Full StorySparklines In Excel
New to Microsoft Excel 2010 are Sparklines. Sparklines are simple and compact graphs that show trends. Its small size means that a sparkline can fit inside a single cell to give you “at a glance” information about your data. If you need to present trends very clearly in a small space, then sparklines are an ideal solution.
Full StoryAbsolute Reference In Excel
By default, cell references in Excel are relative. For example, if you have the following formula in cell C1:
Full StoryCell References In Excel
A cell reference refers to a particular cell or range of cells in your worksheet. Cell references are useful for Excel to identify data for use in formulas to calculate results based on your data.
Full StoryFreeze Panes In Excel
If you have a large table of data in Microsoft Excel and you scroll down, it can be hard to remember what each column represents. This problem becomes exacerbated when you have a large number of columns and the data in each is of a similar size. How do you remember what each number means?
Full StoryExcel PivotTables
Excel PivotTables (pivot tables) enable us to extract meaningful information from large volumes of apparently meaningless data. Using PivotTables, we can “pivot” our data to view it from different angles to give us more useful insights. As you will see, you will soon be able to quickly discover the trends and patterns that are buried deep within your data.
Full Story
