Go beyond the traditional boundaries of spreadsheets by learning new ways to work. These tutorials will help you be more organized and productive using technology built into spreadsheet.com.

  • SUM vs. SUBTOTAL Functions
    Unlike the SUBTOTAL function, the SUM function is one of the most popular functions in spreadsheet workflow. This popularity is because we often add values in our dataset. However, it falls short in some situations because there is a more efficient way to do things. That’s where SUBTOTAL comes in. In this article, we will look at different situations… Continue reading SUM vs. SUBTOTAL Functions
  • How Dates and Times Work
    When doing any data processing work, it’s almost inevitable that you will at some point encounter a dataset that contains dates, times, or both. Most spreadsheet programs behave similarly as far as dates & times are concerned, but what of Spreadsheet.com? Do you need to be aware of any nuances? Well, let’s find out! You… Continue reading How Dates and Times Work
  • Use Forms to Collect User Data
    If you collect data from multiple people but don’t want them to access to your spreadsheet, you can use the Form view in spreadsheet.com. As a result, the recipient of your form will not see the spreadsheet that stores their responses. You will not need to use a separate app; it is simply another view… Continue reading Use Forms to Collect User Data
  • How to Use the Primary Column
    Every spreadsheet created in spreadsheet.com has a primary column. Even though it always exists, using this column is optional. For instance, if you are working on a single worksheet and keeping that worksheet in the sheet view, you may not need it. However, it can be vital if you take advantage of the kanban view,… Continue reading How to Use the Primary Column
  • Dropdown Lists in your Spreadsheet
    Spreadsheet creators may want to use a dropdown list to limit the choice of values in a spreadsheet cell. You could do this to reduce typos or help the user narrow down their options. Historically, you had to do this through a cumbersome process called data validation. Data validation is when the spreadsheet creator applies… Continue reading Dropdown Lists in your Spreadsheet
  • Use Related Rows to Link Spreadsheets
    Related rows have long been an elusive concept in spreadsheets. If you have tables that should be connected, your options have been limited to functions such as VLOOKUP or INDEX/MATCH. These functions can pull data in from other sources, but they don’t develop a built-in two-way link. However, related rows are built into Spreadsheet.com from… Continue reading Use Related Rows to Link Spreadsheets
  • How to use the header row
    Older spreadsheets start as an empty grid with no apparent header row. For better or worse, you can enter your data wherever you would like, starting in row 12 and column D if the fancy strikes you. This flexibility allows spreadsheets to have extra information such as summary data, formulas, or headers anywhere in the… Continue reading How to use the header row

© 2020 – 2023 learnspreadsheet.com