info@northportsoftware.com

978-582-9550

  • Home

  • Services

  • About

  • Contact

  • Blog

  • Book Online

  • More

    Use tab to navigate through the menu items.
    North Port Solutions Header.png
    Software Partner for Small Businesses
    • Facebook Social Icon
    • LinkedIn Social Icon
    • All Posts
    • Excel Programming
    • Excel
    • Data Management
    • Microsoft Access
    • VBA
    • Business
    Search
    Dynamic Highlighting in Excel
    Kimberlee Martin
    • Jun 7
    • 3 min

    Dynamic Highlighting in Excel

    Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge, so I’ll share it with you here. The customer has a list of part numbers and their components. When they select a component part number, they want to quickly find all parent part numbers that contain that component. The parent part number is in column A, and the component part number is in column B. Here’s an example: Notice that the parent p
    3 views0 comments
    One Click to Run Your Macro
    Kimberlee Martin
    • Apr 20
    • 6 min

    One Click to Run Your Macro

    I’ve written a couple of blogs lately about creating Excel macros. In a related topic, today I’m going to talk about one of the easiest and most intuitive ways of running your macro: a button. Before we get to that, though, let’s review some of the methods of running your macro. You can use any of the following methods: · The Macro dialog box (Press “Macro” on the “View” ribbon) · Shortcut keys, assigned when you create the macro · Customizing the ribb
    3 views0 comments
    It's All Relative
    Kimberlee Martin
    • Mar 21
    • 3 min

    It's All Relative

    Relative references vs absolute references in Microsoft Excel macros
    4 views0 comments
    Where to Start with the Excel Macro Recorder
    Kimberlee Martin
    • Mar 14
    • 2 min

    Where to Start with the Excel Macro Recorder

    When getting started with the Excel macro recorder, start small, and build on your successes.
    6 views0 comments
    Making the Most of Excel – Data Validation
    Kimberlee Martin
    • Jun 9, 2021
    • 4 min

    Making the Most of Excel – Data Validation

    Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today, giving you some ideas about how you can use Excel features to validate the data that is being entered into your Excel sheet. Are you capturing data in Excel, but finding that the quality of that data isn’t great? Maybe someone types in their name in the phone number field, or they type a date in a field where you’re expecting a dollar amount
    9 views0 comments
    Making the Most of Excel
    Kimberlee Martin
    • Jun 3, 2021
    • 4 min

    Making the Most of Excel

    Ideas for maximizing your use of Microsoft Excel
    9 views0 comments
    Check Marks in Excel
    Kimberlee Martin
    • May 26, 2021
    • 3 min

    Check Marks in Excel

    Excel is a great tool for helping you stay organized, and many people create checklists in Excel for just that purpose. I’ve got a packing checklist, for example, so that when I go on vacation, I don’t forget any important items. From a business perspective, I have a client in the construction industry, and they use a check list to ensure that key tasks are performed when a job is complete. Their checklist looks something like this: To make life a little easier for them, I wi
    15 views0 comments
    Adding an "Always On Top" panel in Excel
    Kimberlee Martin
    • Apr 19, 2021
    • 3 min

    Adding an "Always On Top" panel in Excel

    There’s a cool feature in PowerPoint that allows you to see all of your slides in sequence, move them around, and double-click to edit them. I don’t know what it’s called, but it usually appears at the left side of your screen in PowerPoint, like this: On a recent Excel project, my client had an idea to implement a similar feature in their Excel workbook. In this case, the user is sometimes working with dozens, or even hundreds, of Excel worksheets in a single workbook. To ma
    8 views0 comments
    Temporary Watermark in Excel
    Kimberlee Martin
    • Jan 18, 2021
    • 5 min

    Temporary Watermark in Excel

    Adding a Watermark to an Excel document only when printing
    13 views0 comments
    What are Pivot Tables?
    Kimberlee Martin
    • Aug 17, 2020
    • 4 min

    What are Pivot Tables?

    A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.
    9 views0 comments
    Scaffolding in Excel
    Kimberlee Martin
    • Aug 10, 2020
    • 5 min

    Scaffolding in Excel

    Using a scaffolding technique to build complex formulas in Excel
    176 views0 comments
    I Don't Know It All
    Kimberlee Martin
    • Aug 3, 2020
    • 3 min

    I Don't Know It All

    I am the first to admit that when it comes to Excel, I don’t know it all. Hard to believe, I know (LOL!!) I’ve had students who don’t seem to believe that. Like any good instructor, I can appear to walk on water from time to time. It’s all illusion, though, trust me. There’s a quote I’ve always liked: Any sufficiently advanced technology is indistinguishable from magic. - Sir Arthur C. Clarke That’s why I sometimes seem magical to my students. I’m using the sufficiently advan
    6 views0 comments
    The Arguments of VLOOKUP
    Kimberlee Martin
    • Jul 27, 2020
    • 4 min

    The Arguments of VLOOKUP

    In previous blogs, I’ve talked about Excel’s VLOOKUP function. In one, I covered the purpose of VLOOKUP, and in the other, I explained the difference between VLOOKUP and HLOOKUP. Today, let’s take a look at the arguments of the VLOOKUP function. I’ve never been happy with the way Microsoft explains them in the Insert Function dialog box – I find their terminology confusing. In this blog, I’m going to try to clarify these arguments for you. Let me start by showing you what the
    4 views0 comments
    Three Excel Functions You Should Be Using
    Kimberlee Martin
    • Jul 17, 2020
    • 3 min

    Three Excel Functions You Should Be Using

    Excel is a great tool for data analysis, with a powerful suite of built-in functions to help. You’re probably already familiar with some of the most common features, like SUM, AVERAGE and VLOOKUP. Here are three that you may not have heard of, but that are likely to help with your Excel projects. 1. DAYS The first function is DAYS. This function calculates the number of days between two dates. Here’s an example of when this might come in handy: In this example, I am calculati
    13 views0 comments
    VLOOKUP vs. HLOOKUP
    Kimberlee Martin
    • Jul 9, 2020
    • 2 min

    VLOOKUP vs. HLOOKUP

    In my last post, I talked about why you might use the VLOOKUP feature. If you missed it, you can find it here. Today, I’m going to discuss the difference between VLOOKUP and HLOOKUP. The two features are nearly identical. The difference between the two is in the orientation of your lookup data. Let me explain. VLOOKUP stands for Vertical look-up. It works great when your look-up data is oriented vertically. Take a look at this example: Notice that the names go down column A,
    7 views0 comments
    What is VLOOKUP, and Why Do I Need It?
    Kimberlee Martin
    • Apr 30, 2020
    • 2 min

    What is VLOOKUP, and Why Do I Need It?

    VLOOKUP is one of the coolest features of Microsoft Excel, and also one of the least understood. Lots of people are interested in it and have great cases for using it. But I get many people who tell me that they don't use it because they don't really understand how it works. Is it magic? YES! Well, sort of. OK, no. But still, it's one of the coolest features of Excel, and well worth understanding. In a nutshell, VLOOKUP is a database feature. Now, mind you, I don't recommend
    23 views0 comments
    Data Accessibility
    Kimberlee Martin
    • Aug 28, 2017
    • 3 min

    Data Accessibility

    Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a few of the common mistakes that I see frequently. Some companies keep their data in text documents, overwriting the existing data each time something changes. This is fast and convenient, but doesn’t allow you to view historical information. What if the customer says that you previously offered them a lower price – can you prove that, or do y
    18 views0 comments
    Option Explicit
    Kimberlee Martin
    • Apr 18, 2017
    • 3 min

    Option Explicit

    If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar with Option Explicit. If you’re not, it'll be worth a few minutes of your time to learn about it. It’s a useful tool that will save you a lot of headaches. In order to understand the Option Explicit statement, you need to start by understanding that Visual Basic allows implicit variable declaration by default. This means that you are not re
    16 views0 comments
    VBA Line Numbers
    Kimberlee Martin
    • Mar 29, 2017
    • 3 min

    VBA Line Numbers

    How to add line numbers to VBA
    420 views0 comments
    Tips for Structuring your Excel Data
    Kimberlee Martin
    • Feb 27, 2017
    • 4 min

    Tips for Structuring your Excel Data

    Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some spectacular reports. However, if your data is not structured cleanly, these tools will stumble. When clients ask us to create reports on their Excel data, the first (and often, longest) task is to clean up the data so that it’s in a consistent state for reporting. Since Excel is not a database tool, it allows you to enter your data in a way that may b
    14 views0 comments
    1
    2

    info@northportsoftware.com

    978-582-9550

    522 Burrage St.  Lunenburg, MA 01462

    ©2022 by North Port Solutions, LLC. Proudly created with Wix.com

    • Facebook Social Icon
    • LinkedIn Social Icon