background preloader

EXCEL

Facebook Twitter

Add a Digital Signature to a Microsoft Excel Document. How to Disassemble an .XLA File. Excel - 14 Skills Every Teacher Should Have (part 2) 14 Excel Skills that Everyone Should Know. Create and manage drop-down lists - Excel. You can make a worksheet more efficient by providing drop-down lists.

Create and manage drop-down lists - Excel

Someone using your worksheet clicks an arrow, and then clicks an entry in the list. Take this course to learn more about how best to use and manage them. Drop-down lists (1:01) Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection. Drop-down list settings (4:37) You can use a comma-delimited list, a cell range, or a named range to define the options in a drop-down list. Input and error messages (2:47) To help people decide what drop-down list option to select, and even to let them know that a cell contains a drop-down list, you can create a message that appears when they select a cell. Course summary A brief reminder of the key points in this course. More courses available at Microsoft Office Training.

Apply data validation to cells - Excel. You can use data validation to restrict the type of data or the values that users enter into a cell.

Apply data validation to cells - Excel

One of the most common data validation uses is to create a drop-down list. Check out this video by Doug from Office as he gives a quick data validation overview. Download our examples You can download an example workbook with all of the data validation examples you'll find in this article. You can follow along, or create your own data validation scenarios. Sharing Tips and Tutorials for Excel. Excel 2010 Functions by Category. EXCEL FORMULAS. Excel Formulas: Defining and Creating a Formula. In this lesson, we introduce you to basic rules for creating formulas and using functions.

Excel Formulas: Defining and Creating a Formula

We feel one of the best ways to learn is through practice, so we provide several examples and explain them in detail. The topics we will cover include: rows and columnsexample math function: SUM()operatorsoperator precedenceexample financial function: PMT(), loan paymentusing a “string” function (“string” is shorthand for “string of text”) inside a formula and nesting functions Formulas are a mixture of “functions,” “operators,” and “operands.”

Before we write a few formulas, we need to create a function but before we can create a function, we first need to understand row and column notation. Rows and Columns To understand how to write formulas and functions, you need to know about rows and columns. Rows run horizontally and columns run vertically. Columns are labeled by letters; rows by numbers. Example: Function Sum() Now let’s demonstrate how to use a function. #NAME? Calculation Operators. ExcelIsFun. IntroExcel. Charting in Microsoft Excel. Excel Tutorial - Easy Excel 2010. Excel Formulas- free tutorial. Excel SUMIF function – formula examples to conditionally sum cells.

This tutorial explains the Excel SUMIF function in plain English and provides a numbers of SUMIF formula examples for numbers, text, dates and wildcards.

Excel SUMIF function – formula examples to conditionally sum cells

If you are faced with the task that requires conditional sum in Excel, the SUMIF function is what you need. This tutorial will briefly explain the function's syntax and general usage, and then you will extend the new knowledge in practice with a number of SUMIF formula examples. A good thing is that the SUMIF function is identical in all Excel versions, from 2013 to 2003. Another great news is that once you've invested some time in learning SUMIF, it will take you very little effort to get the insight of other "IF" functions such as SUMIFS, COUNTIF, SOUNIFS, AVERAGEIF etc.

SUMIF in Excel - syntax and usage The SUMIF function, also known as Excel conditional sum, is used to add cells based on a certain condition, or criteria. SUMIF(range, criteria, [sum_range]) 2. criteria - the condition that must be met. Note. Note. Note. Note. Note. Excel COUNTIFS and COUNTIF with multiple criteria – examples of usage. The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel.

Excel COUNTIFS and COUNTIF with multiple criteria – examples of usage

You will find a number of examples for different data types - numbers, dates, text, wildcard characters, non-blank cells and more. Of all Excel functions, COUNTIFS and COUNTIF are probably most often mixed up because they look very much alike and both are purposed for counting cells based on the specified criteria. The difference is that the COUNTIF function is intended for counting cells based on a single condition in one range, while COUNTIFS allows using several criteria and ranges. In practice, however, you can use Excel COUNTIF with multiple criteria as well.

So, the aim of this tutorial is to help you figure out the most efficient formula for each particular task. Excel COUNTIFS function - syntax and usage As I've already mentioned, the Excel COUNTIFS function is purposed for counting cells across multiple ranges based on one or several conditions.