Keyboard Shortcuts in Excel
Keyboard shortcuts in Excel allow you to do things with your keyboard instead of your mouse to increase your speed.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 9/22
October 10, 2024
How to Hide Columns in Excel
Sometimes it can be useful to hide columns or rows in Excel. Learn how to hide a column unhide all columns hide cells and much more.
Variables in Excel VBA
This chapter teaches you how to declare initialize and display a variable in Excel VBA. Letting Excel VBA know you are using a variable is called declaring a variable. Initializing simply means assigning a beginning (initial) value to a variable.
Compare Text in Excel
This examples shows two ways to compare text strings in Excel. One is case-sensitive and one is case-insensitive.
Sum Largest Numbers in Excel
To sum the largest numbers in an Excel range create an array formula or simply combine the SUMIF function with the LARGE function.
Square Root in Excel
The square root of a number is a value that when multiplied by itself gives the number. The SQRT function in Excel returns the square root of a number.
Userform with Multiple Pages in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that contains multiple pages. This userform also contains images.
Data Analysis in Excel
This section illustrates the powerful features Excel has to offer to analyze data. Learn all about conditional formatting charts pivot tables and much more.
How to Subtract in Excel - Easy Formulas
There's no SUBTRACT function in Excel. However there are many ways to subtract numbers in Excel. Are you ready to improve your Excel skills?
Find Unique Values in Excel
To find unique values in Excel use the Advanced Filter to extract unique values or filter for unique values. If you have Excel 365 or Excel 2021 use the magic UNIQUE function.
Controls Collection in Excel VBA
When creating Userforms in Excel VBA you can use the Controls collection to easily loop through controls and set a property of each control to a specific value.
Basics of Excel
This section explains the basics of Excel. It is good to know the basic terminology explained in this section before you start using Excel.
Save to OneDrive in Excel
Save your Excel files to your OneDrive location and access your files from any computer or share them with other people.
How to Create Charts in Excel
A simple chart in Excel can say more than a sheet full of numbers. As you'll see creating charts is very easy.
Insert a Check Mark in Excel
To insert a check mark symbol in Excel simply press SHIFT + P and use the Wingdings 2 font. You can also insert a checkbox in Excel.
Fibonacci Sequence in Excel
It's easy to create all sorts of sequences in Excel. For example the Fibonacci sequence.
Compare Two Lists in Excel
This page describes how to compare two lists in Excel using conditional formatting and COUNTIF. For example let's compare two lists of NFL teams.
Rounding Times in Excel
Use MROUND in Excel to round a time to the nearest 15 minutes the nearest 30 minutes the nearest hour etc.
Transportation Problem in Excel
Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost.
BMI calculator in Excel
Create a BMI calculator in Excel and find out if you are a healthy weight. Body mass index (BMI) is a measure of body fat based on weight and height that applies to adult men and women.
Vlookup in Excel VBA
Use the WorksheetFunction property in Excel VBA to access the VLOOKUP function. All you need is a single code line.
Tasks on Schedule in Excel VBA
Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule to green and sets the background color of tasks that are behind schedule to red.
Floating Point Errors in Excel
Excel stores and calculates floating point numbers. Sometimes the result of a formula is a very close approximation.
Userform in Excel VBA
This chapter teaches you how to create an Excel VBA Userform. The Userform we are going to create looks as follows: