Subscribe
Tutorial search

Excel Countif and Sumif - Excel tutorial


Great Excel function tutorial covering Count, CountIf, Sum, SumIf, and SumProduct.
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



Create Excel Spreadsheets Using Other Environments
Create Excel Spreadsheets Using Other Environments
Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to create .xls files directly from other programs.

Whether you're creating Excel files from databases on an Apache server or you just want to present the information stored in a Java program to Excel users, there are a variety of packages out there that will enable you to create and access .xls files without actually using Excel.
Difficulty:
Insert Data from Excel to SQL Server
Insert Data from Excel to SQL Server
Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.
Difficulty:
How To Change The Chart Legend Font In Excel
How To Change The Chart Legend Font In Excel
This video tutorial shows how to change the font of the chart legend in Excel.
Difficulty:
Microsoft Excel 2003 Help and Tips
Microsoft Excel 2003 Help and Tips
Microsoft Excel 2003 advice including formulas, analysis operations, adjusting macro security level, changing AutoRecover options, workbook password protection, visual tweaks, and manual spreadsheet calculation.
Difficulty:
Excel formulas and functions.
Excel formulas and functions.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Difficulty: