This quick tip shows you 3 ways to insert a worksheet in Excel. Steps to insert a worksheet in 3 ways Below are 3 ways you can insert a worksheet in Excel. Method 1 Firstly, in method 1, we use the main menu and ribbon to insert a sheet. So, there you have it. A […]
How to add a footnote marker to a category in Excel This quick tip shows you how to add a footnote marker to a category in Excel. If you try to add a footnote to a category on the sheet, then it will not work. Well, it will add the marker to any text on […]
How to add average line to column chart This quick tip shows you how to add average line to column chart in Excel. Also, you may hear the term “target line” to describe this type of chart. Target line Overall, a target line represents a goal or a particular measuring point. So, your target may […]
This quick how to tip shows you how to add comments to your VBA code. Add comments to your VBA code VBA is short for Visual Basic for Applications. Overall, it is the coding language for Office apps. To make your code more readable, we suggest placing comments in your code. The image below illustrates […]
This quick how-to video shows you how to add Excel camera tool to quick access toolbar (or QAT). In addition, we took it for a test drive. Video to add Excel camera to QAT One thing to note is, there is a part that jumps directly to Excel options, without seeing the mouse movement. So, […]
This lesson shows you how to assign a name to an object in Excel. When you work with objects in Excel, it helps to give them unique names. Especially, if you plan to use them in code. That is probably the main purpose for naming an object. Steps to assign a name to an object […]
The basic computer architecture (or BCA) quiz measures knowledge and operation of various components of a computer system. Although all the questions remain the same in this quiz, we randomize them to keep you on your toes. Take the basic computer architecture quiz This BCA quiz contains eight questions. To pass this quiz, you need […]
The basic computer architecture II (or BCA II) quiz measures knowledge and operation of various components of a computer system. It is very similar to our BCA I quiz. Although all the questions remain the same in this quiz, we randomize them to keep you on your toes. Take the basic computer architecture II quiz […]
This how-to quick snapshot video shows you examples of using For Next statement for basic counting in Excel VBA. Remember, this snapshot is not a full tutorial. How to show basic counting using For Next statement We use Debug.Print to show results of different ways to count numbers from zero to ten. Debug.Print is a […]
This quick how-to snapshot shows you basic Excel operators that you use in spreadsheet development and analysis. Please pay attention to the table and not the chart holder. Overview of basic Excel operators So, the main operators to use in spreadsheets are: assignment, addition, subtraction, multiplication, division, power, and concatenation. Keep in mind, we are […]
This quick video tip shows you how to change cells from night to day in Excel. Change cells from night to day in Excel In this instance, we use a macro to accomplish this task. So, what we do is record the process of selecting all the cells in the sheet. Then, we change the […]
This quick snapshot shows you how to change chart x-axis number format. Snapshot to change chart x-axis number format Below is the snapshot card showing you how to change millions to thousands, without modifying any data on the spreadsheet. Everything is done on the chart, retaing the data. Excel is the main vehicle for this […]
