How to use Excel
October 8, 2024Logical Functions in Excel
Learn how to use Excel's logical functions such as IF AND OR and NOT.
Library
Page 19 of 29 · 695 articles
LIBRARY: 695 ARTICLESSORTED BY: DATEPAGE: 19/29
How to use Excel
October 8, 2024Convert to Proper Case in Excel VBA
Below we will look at a program in Excel VBA that converts text to proper case. That is the first letter in each word in uppercase and all other letters in lowercase.
How to use Excel
October 8, 2024Exponential Smoothing in Excel
This example teaches you how to apply exponential smoothing to a time series in Excel. Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends.
How to use Excel
October 8, 2024INDEX and MATCH in Excel
Use INDEX and MATCH in Excel and impress your boss. Instead of using VLOOKUP use INDEX and MATCH. To perform advanced lookups you'll need INDEX and MATCH.
How to use Excel
October 8, 2024Error Handling in Excel VBA
Below we will look at two programs in Excel VBA. One program simply ignores errors. The other program continues execution at a specified line upon hitting an error.
How to use Excel
October 8, 2024How to use the Excel FILTER function
Use the magic FILTER function in Excel 365/2021 to extract records that meet certain criteria. The FILTER function is quite versatile.
How to use Excel
October 8, 2024How to Sort by Date in Excel
This guide walks you through the steps to sort by date in Excel. It starts with how to convert text-formatted dates to actual date values followed by basic sorting methods and advanced techniques like sorting dates by month and sorting birthdays.
How to use Excel
October 8, 2024Create SUM formulas in Excel
Use the SUM function in Excel to sum a range of cells an entire column or non-contiguous cells. To create awesome SUM formulas combine the SUM function with other Excel functions.
How to use Excel
October 8, 2024Excel VBA Tutorial
VBA (Visual Basic for Applications) is the programming language of Excel. If you're an Excel VBA beginner these 16 chapters are a great way to start. Excel VBA is easy and fun! With Excel VBA you can automate tasks in Excel by writing so called macros.
Financial Planning
October 8, 2024Financial Functions in Excel
To illustrate Excel's most popular financial functions we consider a loan with monthly payments an annual interest rate of 6% a 20-year duration a present value of $150000 (amount borrowed) and a future value of 0 (that's what you hope to achieve when you pay off a loan).
How to use Excel
October 8, 2024View Multiple Workbooks in Excel
If you want to view multiple Excel workbooks at the same time execute the following steps.
How to use Excel
October 8, 2024Statistical Functions in Excel
This chapter gives an overview of some very useful statistical functions in Excel.
How to use Excel
October 8, 2024Combination Chart in Excel
A combination chart is a chart that combines two or more chart types in a single chart. To create a combination chart in Excel execute the following steps.
How to use Excel
October 8, 2024How to Merge Tables in Excel
You can use tables and the VLOOKUP function in Excel to quickly merge two tables. This trick will bring your Excel game to a new level.
How to use Excel
October 8, 2024LET function in Excel
Use the LET function in Excel 365/2021 to declare variables and assign values (or calculation results) to variables. Next use these variables in a calculation.
How to use Excel
October 8, 2024How to Lock Cells in Excel
You can lock cells in Excel if you want to protect cells from being edited. By default all cells are locked. However locking cells has no effect until you protect the sheet.
How to use Excel
October 8, 2024How to use the Excel OFFSET function
The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.
How to use Excel
October 8, 2024How to use Excel Online
You can edit Excel files with Excel Online from anywhere without having Excel installed on your computer. First save an Excel file to your OneDrive location.
How to use Excel
October 8, 2024Randomly Sort Data in Excel VBA
Below we will look at a program in Excel VBA that randomly sorts data (in this example randomly sorts names).
How to use Excel
October 8, 2024How to Use Absolute and Relative References in Excel
To create an absolute reference in Excel add $ symbols to a cell or range reference. This locks the reference. When you copy a formula an absolute reference never changes.
How to use Excel
October 8, 2024Date & Time Functions in Excel
To enter a date in Excel use the "/" or "-" characters. To enter a time use the ":" (colon). You can also enter a date and a time in one cell.
How to use Excel
October 8, 2024Convert XML to Excel
Convert your XML file to an Excel file or vice versa. This enables you to exchange data between different applications. From XML to Excel is really easy.
How to use Excel
October 8, 2024Create a Named Range in Excel
Create a named range or a named constant and use these names in your Excel formulas. This way you can make your formulas easier to understand.
How to use Excel
October 8, 2024How to CONCATENATE in Excel
Use CONCATENATE CONCAT TEXTJOIN or the & operator in Excel to concatenate (join) two or more text strings.