Excel is an excellent application for mathematical operations, but sometimes you just need to organize data in tables that have text labels in every other row. We will walk through different methods to complete this task. For this tutorial, we will use a data set of “Name”, “Date”, and “Salary”. Using Visual Basic for Applications … Read more
Indenting text in Excel increases the readability of lists and assists with breaking large amounts of data into sections, making it easier for you to decipher. Excel provides a few methods for indenting text. Let’s delve into the Excel world of indenting text! Using the Tools in the Alignment Group to Indent in Excel Using … Read more
Excel is not just for mathematical calculations, the software also offers many powerful ways to manipulate data, including separating text strings. Manipulating text is accomplished through several methods and we walk through five options in this tutorial. Use the Find and Replace Function to Remove Text Before or After a Specific Character in Excel For … Read more
Excel can handle many complex calculations and formulas to assist you with datasets. There are times when you need to use Excel to open files that are not native to the Excel application. This tutorial will walk you through the steps necessary to open your .dbf file in Excel. Open a DBF File in Excel … Read more
Sorting information in Excel helps with classifying your data and arranging it in ascending or descending patterns. This tutorial walks you through several ways of sorting the data, including sorting statically or using formulas to keep the datasets dynamic. Using the Sort Function to Sort by Last Name in Excel Sometimes the data used in … Read more