Workout with Excel

Comments

Post a Comment

Popular posts from this blog

Basic Excel Formulas Guide

Image
Basic Excel Formulas Guide Mastering the basic Excel formulas is critical for beginners to become highly proficient in financial analysis. Microsoft Excel is considered the industry standard piece of software in data analysis. Microsoft’s spreadsheet program also happens to be one of the most preferred software by investment bankers and financial analysts in data processing, financial modeling, and presentation. This guide will provide an overview and list of basic Excel functions. Basic Terms in Excel There are two basic ways to perform calculations in Excel: Formulas and Functions. 1. Formulas In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3. 2. Functions Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example: =SUM(A1:A3). The function sums all the valu...
Read more

COUNT, COUNTIF, COUNTIFS

Image
Count function Summary  The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges. Purpose Count numbers Return value  Count of numeric values Syntax   =COUNT (value1, [value2], ...) Arguments   value1 - An item, cell reference, or range. value2 - [optional] An item, cell reference, or range. Usage notes   The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references, or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions, and time are counted. Empty cells and text values are ignored. Example #1 - range In the example shown, COUNT is set up to count numbers in the range B5:B11: =COUNT(B5:B11) // returns 4 COUNT returns 4, since there are 4 numeric values in the range B5:B11. Text values and blank cells are ignored. E...
Read more