How to use Excel
October 11, 2024Count Cells with Text in Excel - Easy Formulas
This page illustrates multiple ways to count cells with text in Excel. Visit our page about the COUNTIF function to count cells that contain specific text.
Library
Page 4 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 4/29
How to use Excel
October 11, 2024Range Object in Excel VBA
The Range object which is the representation of a cell (or cells) on your worksheet is the most important object of Excel VBA. This chapter gives an overview of the properties and methods of the Range object.
How to use Excel
October 11, 2024Paste Options in Excel
This example illustrates the various paste options in Excel. Cell B5 below contains the SUM function which calculates the sum of the range B2:B4. Furthermore we changed the background color of this cell to yellow and added borders.
How to use Excel
October 11, 2024InputBox Function in Excel VBA
You can use the InputBox function in Excel VBA to prompt the user to enter a value.
How to use Excel
October 11, 2024Dependent Combo Boxes in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes.
How to use Excel
October 11, 2024How to Roll two Dice in Excel
This example teaches you how to simulate the roll of two dice in Excel. If you are in a hurry simply download the Excel file.
How to use Excel
October 11, 2024Copy Visible Cells Only in Excel
By default Excel copies both visible and hidden cells. However it is possible to copy visible cells only.
How to use Excel
October 11, 2024Standard Deviation in Excel
This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel.
How to use Excel
October 11, 2024Two-column Lookup in Excel
This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark not James Smith not James Anderson.
How to use Excel
October 11, 2024Weekday Formulas in Excel
Use WEEKDAY NETWORKDAYS and WORKDAY to create cool weekday formulas in Excel. Are you ready to improve your Excel skills?
How to use Excel
October 11, 2024How to Change Case in Excel
To change the case of text in Excel use LOWER UPPER or PROPER. If you're not a formula hero use Flash Fill to change case in Excel.
How to use Excel
October 11, 2024Cell Styles in Excel
Quickly format a cell by choosing a cell style. You can also create your own cell style in Excel. Quickly format a range of cells by choosing a table style.
How to use Excel
October 11, 2024How to Unhide Sheets in Excel
Unhiding sheets in Excel is easy. A workbook must contain at least one visible worksheet. To unhide sheets execute the following steps.
How to use Excel
October 11, 2024How to Print Sheets in Excel
This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
How to use Excel
October 11, 2024Worksheets in Excel
A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
How to use Excel
October 11, 2024Weekdays in Excel VBA
Below we will look at a program in Excel VBA that calculates the number of weekdays between two dates.
How to use Excel
October 11, 2024Logical Operators in Excel VBA
The three most used logical operators in Excel VBA are: And Or and Not. As always we will use easy examples to make things more clear.
How to use Excel
October 11, 2024Sum with Or Criteria - Excel Formulas
Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples.
How to use Excel
October 11, 2024Workbook Themes in Excel
Excel offers themes to change the look of your workbook with the click of a button. Each theme consists of 12 colors two fonts (Headings and Body) and effects for shapes and SmartArt.
How to use Excel
October 11, 2024DateDiff Function in Excel VBA
The DateDiff function in Excel VBA can be used to get the number of days weeks months or years between two dates. You can also use the DateDiff function to calculate the time difference between two times.
How to use Excel
October 11, 2024Font Color in Excel VBA
The Font property of the Range object in Excel VBA gives access to a lot of other properties. That is because the Font property returns an object itself; the Font object. The Font object has many properties like the Color property and the Bold property.
How to use Excel
October 11, 2024t-Test in Excel
This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal.
How to use Excel
October 11, 2024Use Relative References in Excel VBA
By default Excel records macros in absolute mode. However sometimes it is useful to record macros in relative mode. This program teaches you how to do this. If you don't know how to record a macro we highly recommend you to read this example first.
How to use Excel
October 11, 2024Interrupt a Macro in Excel
You can interrupt a macro in Excel at any time by pressing Esc or Ctrl + Break.