top of page

83 items found for ""

Blog Posts (69)

  • How to Password Protect a Spreadsheet: Spreadsheet Security 101

    While a spreadsheet may seem insignificant, it can contain sensitive information that you wouldn't want falling into the wrong hands. That's why it's important to know how to password protect a spreadsheet. When it comes to keeping our information safe and secure, it's easy to focus on the big things - like our bank accounts and credit cards. But what about seemingly little things, like our Excel and Google Sheets spreadsheets which can also contain all kinds of personal information? So, how do you password-protect a spreadsheet? Excel and Google Sheets make it extremely easy. If you're in Excel, go to File > Info > Protect Workbook > Encrypt with Password. If you're in Google Sheets, got to File > Protect sheet Here are more examples regarding why you would password Protect a spreadsheet and the easy-to-follow step-by-step instructions to do it! But first, check out our video that walks through the steps as well! Why Should I Password Protect a Spreadsheet? You might be thinking, "Why would I need to password-protect a spreadsheet? It's just a bunch of numbers and words." The truth is, even the most mundane spreadsheet can contain sensitive information that you wouldn't want falling into the wrong hands. For example, lets you're using a spreadsheet to track your monthly budget. It might not seem like a big deal if someone else sees it, but it could be embarrassing if someone found out how much you spend on avocado toast. Or maybe you're using a spreadsheet to plan a surprise party for your spouse. The last thing you want is for the surprise to be ruined because someone stumbled upon your guest list. In these situations, knowing how to password-protect a spreadsheet can prevent any potential embarrassment or ruined surprises. But it's not just personal use - even a small business can benefit from password-protecting their spreadsheets, perhaps even more so than those using spreadsheets for personal use. Imagine you're a freelance writer and you use a spreadsheet to track your clients and their payments. If that spreadsheet fell into the hands of a competitor, they could use that information to poach your clients. Or maybe you're a real estate agent and you use a spreadsheet to track properties and their owners. If that spreadsheet got into the wrong hands, it could be used for identity theft. Keeping your business information secure is crucial, that's why it's important to know how to password-protect a spreadsheet. How to Password Protect a Spreadsheet in Google Drive Google Drive is a great platform for storing and sharing your spreadsheets on the cloud, but it's important to keep them secure. Instead of setting a specific password for a sheet or range of cells, Google Sheets limits it by the user who is logged in while editing. You can choose who you want to have access to edit the sheet and those users must be logged into their Google account in order to make those edits. Here's how to password-protect a spreadsheet in Google Drive: Click on Data in the top menu. Select Protected Sheets & Ranges from the dropdown menu. Click on Add a sheet or range Toggle between the Range and Sheet tabs to set what you would like to password protect. Select the specific range or sheet you want to protect. Click on Set Permissions Lastly, select if you would simply like a warning message to appear (which means anyone will still be able to edit, but will see a warning message first) or if you want only specific people to have edit access. Click Done and your changes will be saved. Now that the sheet is protected, viewers will need the exact permissions you set to determine if they are able to edit the spreadsheet or not. How to Password Protect a Spreadsheet in Excel Microsoft Excel is one of the most popular spreadsheet programs, and it's easy to password protect your spreadsheets. Here's how to do it: Click on File in the top menu and then click on Info from the left menu. Click on Protect Workbook" Click on Encrypt with Password Enter a password in the Password field and click OK Re-enter the password to confirm it and then click OK Your spreadsheet is now password protected and you'll need to enter the password in order to make any changes to it. In short, password-protecting your spreadsheet is like locking the door to your house - it's a simple step that can keep your information safe and secure. So don't let your spreadsheets be the weak link in your security chain. Protect them like you would any other valuable asset by knowing how to password-protect a spreadsheet, whether you're using Google Drive or Microsoft Excel.

  • How to Take a Screenshot on Windows

    Being able to take screenshots can be extremely helpful if you are trying to share something or demonstrate how to do a task on your Windows computer. However, it might not be immediately clear how to do this on Windows (especially if you don't have a Print Screen/PrtScr button on your keyboard). So, how do you take a screenshot on Windows? All Windows computers come with the Snipping Tool which you can access from Start > Search > Snipping Tool or by tapping the Print Screen button on your keyboard. However, the snipping tool does have annotation limitations and you might find an alternative tool to be a better solution. Lets walk through how to use the Snipping Tool on your Windows 10 or 11 computer and also a great alternative solution for annotating your screenshots (which I personally use and recommend). Find out how to use the Snipping Tool on Windows 10! How to Use Windows Snipping Tool As previously stated, you can access this tool directly by opening the tool or by tapping the Print Screen/PrtScr button on your keyboard. To open the program directly on your Windows computer, Click on the Start button Search for Snipping Tool Click Open Once the program is open, you will see a new window open for the Snipping Tool. If you do not have your Print Screen button connected to the Snipping Tool (like me since I use an alternative) you will see instructions for how to automatically trigger the Print Screen using a hotkey on your keyboard. Windows logo key + Shift +S Additionally, you can start a new print screen by clicking on New in the upper left. However, before starting a new screen capture, you might want to change the mode. By default, the tool is set to select in Rectangle mode which means when you click and drag over an area, your screenshot will be in rectagle shape. Perhaps you would like something different. If you click on Rectangle mode, you will see some other options to choose from: Rectangle mode Window mode Full-screen mode Free-form mode While fairly self-explainatory, per Windows support article, these modes are defined as, Here are examples of all 4 screen capture modes: Now that you've selected the mode you would like to use, you are ready to take a screenshot. By either clicking New or using the hotkey, you will notice that your screen turns a gray color. If you're using the Rectangle mode or Free-form mode, simply click and drag over the area that you would like to capture. If you're using Window mode or Full-screen mode, you simply need to click on the window and the entire view will be captured. The Snipping tool has limited annotation capabilities, but here is an overview of what you can do with your screenshots after they are captured in the Snipping Tool software. Drawing with different color and pen thickness: Highlight text with a freeform highlighter in different colors and thicknesses: Draw perfectly round or straight lines with the Ruler or Protractor tool: Also, if you captured too much, you can always crop your images: Once you are done editing your screenshot, you simply click on the save icon in the upper right! Windows Snipping Tool Alternative The Snipping Tool is great for basic screenshots, however, you might want additional annotation capabilities such as blurring content, drawing shapes or even adding numbered steps to your images. This is what I felt and I found a great FREE alternative that I use for everything! It's called Greenshot and you you can download it for free here. Here is an example of the Greenshot image editor and some of the different editing and annotation capabilities that I added to the below screenshot: Blurred area Highlighter Number sequencing Free hand drawing Shapes Speachboxes Text Arrows Border and image effects In addition to what I used in the above image, you can also rotate, flip, crop, and resize the image to fit your needs!

  • How to Insert Excel into OneNote 365

    OneNote 365 is a great place to keep your life and your work organized and easy to find. Instead of needing to remember the file path where your Excel spreadsheet is located, you might want to have access to your spreadsheet right in your notes. The good news for us is OneNote made this super easy and gave us multiple options for doing so in both Windows 10 and 11! You could even incorporate this into your OneNote templates! So, how do you insert Excel into OneNote 365? You can easily find this option in OneNote by on the "Insert" tab and then clicking on "Spreadsheet". From here you will be given the option to choose "Existing Excel Spreadsheet" or "New Excel Spreadsheet". Here are the step-by-step instructions on how to insert or create an Excel spreadsheet in OneNote 365 and what to do if your spreadsheet is not updating in OneNote on Windows 10 and Windows 11. It's important to note that while you can attach an XSLS file on the OneNote web app version, you cannot insert a visual spreadsheet like you can on the desktop version. Find out how to insert an Excel Spreadsheet to OneNote on Windows 10! How to Add an Existing Excel Spreadsheet to OneNote If you choose Existing Excel Spreadsheet from the drop down list, your file explorer will open to select the spreadsheet you would like to insert into the page. Once you have selected the file, you will see a popup box that asks if you want to do one of the following: Attach File Insert Spreadsheet Insert a Chart or Table If you select Attach File, you will see a simple thumbnail of your excel file. As a side note, if you right-click on the thumbnail, you can rename the file. Additionally, double-clicking the thumbnail will open the file in Excel. If you select Insert Spreadsheet, you will see a thumbnail to open your spreadsheet directly and the visual output of your actual spreadsheet right on the page. If you click on the visual output of the spreadsheet, you will see an edit button. Clicking Edit will open the spreadsheet in Excel so you can work on it there. Currently, OneNote does not allow you to edit the spreadsheet directly on OneNote. Last but not least, what you you want to insert only the table or only the chart into your spreadsheet? No worries! There are two ways to do this. If you added your spreadsheet using the Insert Spreadsheet (which means the entire sheet displays like the screenshot above), simply right click on the spreadsheet and click on Select What to Display. On the popup window, you can select exactly which sheet and which tables or charts you would like to display. However, if from the Insert Tab > Spreadsheet > Existing Excel Spreadsheet option you selected Insert a Chart or Table you will immediately see the popup box that allows you to select from which sheet and which tables or charts you would like to display. If I decide that I only want to display the chart in the example above, I would select Chart 2 (Votes) and my chart would be inserted by itself into the OneNote page (along with the file thumbnail for easy access to the Excel spreadsheet). How to Create an Excel Spreadsheet in OneNote This is a really neat feature that OneNote has added! Let's say you're writing your notes out on the OneNote page and then decide that this would really be much better organized on a sheet. While this won't add your content to the sheet automatically, it will create a sheet using the name of your page in OneNote so that you can organize your data and display the sheet in your notes To do this, simply go to the Insert Tab and click on Spreadsheet. From the dropdown menu, click on New Excel Spreadsheet. Once the new blank sheet is added to your page, you can open the file by double-clicking on the thumbnail. You can also open the spreadsheet in Excel by clicking on the table and then clicking Edit. What to do if OneNote Excel Spreadsheet is Not Updating Occasionally, you might notice that after making changes to your spreadsheet in Excel, the visual of your sheet on OneNote is outdated. If the spreadsheet on OneNote is not updating, make sure to first save your file in Excel so that the file is saved with the most current version. Next, on the spreadsheet on OneNote, right-click to see the menu and then click Refresh. This should update your spreadsheet on OneNote so that it is displaying the most current information.

View All

Other Pages (13)

  • Free Local SEO Title & Description Generator | Free Meta Tag Generator

    LOCAL SEO META TAG GENERATOR Get Meta Tags Main City . This should be the main area that you want to advertise in. Likely the city your business is located in or the largest city in your service area (meaning the most difficult city to rank on Google for). Service Area #1 and #2 . These are the next largest cities that you service and want to optimize your site to rank for. You can leave one or both of these blank if you do not have any other service area. State and State Abbreviation . Since you never know how someone might type the state in their search, it's a good idea to include the full state name and the state abbreviation. Main Keyword . This should be your most important keyword and will be the one that appears toward the beginning of your title tag and description. This is the keyword you most want to rank for. Similar Keyword #1 and #2. These keywords should be similar to the main keyword. If there are different variations to your main keyword that people might use to search for your service, add them here. Title Tag: character count Title Tag Copy to Clipboard Copied! Copy Description Tag: character count Description Tag Copy to Clipboard Copied! Copy How to use this tool: Input your business information on the form to the left and click Get Meta Tags . Once the Meta Tags are generated, you can click to copy the tags and paste them to your website. ​ These tags are a great place to start but feel free to customize them further after you've copied them. ​ If you have feedback on this tool, you can contact me here . ​ Enjoy! GET MORE IDEAS More Ideas More Title Tag Variations: character count Title Tag Copy to Clipboard Copied! Copy character count Title Tag Copy to Clipboard Copy Copied! character count Title Tag Copy to Clipboard Copy Copied! character count Title Tag Copy to Clipboard Copied! Copy More Description Tag Variations: character count Description Tag Copy to Clipboard Copied! Copy character count Description Tag Copy to Clipboard Copied! Copy character count Description Tag Copy to Clipboard Copied! Copy character count Description Tag Copy to Clipboard Copied! Copy

  • Services | Local Web Strategies

    SEO Website Analysis $ 350 350$ Complete SEO Analysis to Grow Your Search Traffic Sign-up Video Recording of Your SEO Analysis SEO Checklist of Next Steps You Should Take Lifetime Access to SEO Forum Teach Me Local SEO $ 250 250$ Sign-up

View All
bottom of page