How to use Excel
October 11, 2024Create a Heat Map in Excel
To create a heat map in Excel simply use conditional formatting. A heat map is a graphical representation of data where individual values are represented as colors.
Library
Page 2 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 2/29
How to use Excel
October 11, 2024How to use VLOOKUP in Excel
The VLOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow VLOOKUP examples.
How to use Excel
October 11, 2024Get Sheet Name in Excel
To return the sheet name in a cell use CELL FIND and MID in Excel. There's no built-in function in Excel that can get the sheet name.
How to use Excel
October 11, 2024Workbook Views in Excel
Excel offers three different workbook views: Normal Page Layout and Page Break Preview.
How to use Excel
October 11, 2024Loop through Controls in Excel VBA
With just a few lines of code we can easily loop through controls on an Excel VBA Userform.
How to use Excel
October 11, 2024How to Spell Check in Excel
Learn how to check the spelling of text in Excel add words to your custom dictionary (or AutoCorrect list) and learn how to change spell checking options.
Financial Planning
October 11, 2024Loans with Different Durations in Excel
This example teaches you how to compare loans with different durations in Excel.
How to use Excel
October 11, 2024Insert Comments in Excel
Insert a comment in Excel to start a conversation or to give feedback about the content of a cell. Old style comments are still available and are now called notes.
How to use Excel
October 11, 2024How to use LAMBDA in Excel
Use LAMBDA and the Name Manager in Excel to create your own Excel function. You can use this custom function like any other Excel function!
How to use Excel
October 11, 2024Chop off Decimals in Excel
This example illustrates two functions to chop off decimals in Excel. INT and TRUNC.
How to use Excel
October 11, 2024Generate Random Numbers in Excel
Excel has two very useful functions when it comes to generating random numbers. The RAND function generates a random decimal number between 0 and 1.
How to use Excel
October 11, 2024Swap Values in Excel VBA
This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs as we will see later.
How to use Excel
October 11, 2024Sort by Color in Excel
This example teaches you how to sort data by color in Excel.
How to use Excel
October 11, 2024Application Object in Excel VBA
The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options.
How to use Excel
October 11, 2024Mark a Workbook as Final in Excel
Mark a workbook as final in Excel to indicate that this is the final version of your workbook. Only use this feature to discourage editing. Users can still edit the workbook.
How to use Excel
October 11, 2024Day of the Year in Excel
An easy formula that returns the day of the year for a given date in Excel. There's no built-in function in Excel that can do this.
How to use Excel
October 11, 2024Life of Variables in Excel VBA
Sometimes you want to retain the value of a variable in Excel VBA when a procedure ends. You can achieve this by using the Static keyword.
How to use Excel
October 11, 2024Add Data Bars in Excel
Data bars in Excel make it very easy to visualize values in a range of cells. A longer bar represents a higher value.
How to use Excel
October 11, 2024Chart Sheet in Excel
You can find most charts on the same worksheet as the source data (embedded charts). However you can also move a chart to a separate sheet that only contains a chart (chart sheet).
How to use Excel
October 11, 2024Skip Blanks in Excel
Use the 'Paste Special Skip Blanks' option and Excel will not overwrite existing values with blanks. To create a formula that skips blank cells use IF and ISBLANK.
How to use Excel
October 11, 2024Dynamic Named Range in Excel
A dynamic named range in Excel expands automatically when you add a value to the range.
How to use Excel
October 11, 2024How to Enable Macros in Excel
Enable macros in Excel when the message bar appears. Change your macro security settings in the Trust Center. To create macros turn on the Developer tab.
How to use Excel
October 11, 2024Create External References in Excel
An external reference in Excel is a reference to a cell or range of cells in another workbook. Below you can find the workbooks of three divisions (North Mid and South).
How to use Excel
October 11, 2024Strikethrough Text in Excel (Easy Shortcut)
This example teaches you how to apply strikethrough formatting in Excel. You can still read text with a strikethrough effect.