Graphics Union

Uniting Creativity and Technology


Know Excel Fundamentals to Improve Your Working

If you’re just getting started with Excel, we recommend familiarizing yourself with a few fundamental instructions excel video. These include stuff like:

  • Making a fresh spreadsheet from the ground up.
  • Performing fundamental computations such as addition, subtracting, multiplying, and dividing.
  • Column content and titles must be written and formatted.
  • Using the auto-fill tools in Excel.
  • Adding and removing individual columns, rows, and spreadsheets. (We’ll go over how to add things like additional columns and rows later.)
  • Keeping column and row headers visible as you scroll past them in a spreadsheet so you know what data you’re filling out as you travel down the page.
  • Sorting your data alphabetically.

If you have any basic Excel skills, you’re probably already aware of this easy method. But, just to be safe, let me show you the wonders of autofill. This allows you to easily fill neighboring cells with a variety of data kinds, such as values, series, and formulae.

There are other methods to use this functionality, but the fill handle is one of the simplest. Select the cells you want to be the source, find the fill handle in the lower-right corner of the cell, and either drag it to cover the cells you want to fill or double click:

Similarly, sorting is a vital tool to understand when organizing data in Excel.

There may be occasions when you have a completely unorganized list of data. Perhaps you exported a list of your marketing connections or a list of blog entries. Whatever the situation, Excel’s sort tool will assist you in alphabetizing any list.

Select the data in the column you wish to sort by clicking on it. Then, in your toolbar, pick the “Data” tab and search for the “Sort” option on the left. If the “A” is on top of the “Z,” you may just click on it once. Click the button twice if the “Z” is on top of the “A.” When the “A” is stacked on top of the “Z,” signifies that your list will be ordered alphabetically. When the “Z” is placed on top of the “A,” your list will be sorted in reverse alphabetical order.

Let’s take a closer look at a couple of these.

In spreadsheets, logical functions are used to determine if a scenario is true or untrue. You can then choose to perform one of two things based on the results of that test. These choices can be used to show information, make various computations, or run more tests.

Comprehending Logical Functions

Logical functions are decision-making tools for spreadsheet data. They enable you to examine the contents of a cell or do computation and then compare the output to a specified figure or value. Then, based on the condition, you may utilize the IF logical function to select which computation to complete or action to take.

If Is Used To Display Text

Depending on the conclusion of the condition test, the IF function can be used to show alternative information. The resultant text will be shown in the cell containing the formula containing the IF function. The IF function is used in this example to show whether figures in a neighboring column reach or exceed a given target. This greatly simplifies the process of identifying effective salespeople.

Sarah Davis: Sarah, a data scientist, shares insights on big data, machine learning, AI, and their applications in various industries.