Follow these steps to set up a general ledger accounting system in Excel. A small business can use Excel as a substitute for expensive accounting software.

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find ...

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT() function in Excel.

How to Use the $ Sign in Excel. Whether knowing how to use the dollar sign in Microsoft Excel is a need-to-know or a nice-to-know for you, the sign is something that will enable you to present ...