spreadsheetplanet.com
Open in
urlscan Pro
162.159.135.42
Public Scan
Submitted URL: http://spreadsheetplanet.com/
Effective URL: https://spreadsheetplanet.com/
Submission: On November 23 via manual from US — Scanned from DE
Effective URL: https://spreadsheetplanet.com/
Submission: On November 23 via manual from US — Scanned from DE
Form analysis
1 forms found in the DOMGET https://spreadsheetplanet.com/
<form method="get" class="search-form navigation-search" action="https://spreadsheetplanet.com/">
<input type="search" class="search-field" value="" name="s" title="Search">
</form>
Text Content
Skip to content Menu * About * Excel Tips * Formulas * Charts * Excel VBA * Shortcuts SPREADSHEET PLANET TIME SAVING EXCEL TIPS & TUTORIALS I am Steve Scott and I regularly write about easy to follow how-to tutorials about Excel spreadsheets. I started this website as a side project to document some of the cool things I was learning in MS Excel, and now I am so happy that it reaches thousands on Excel learners every day. Remember, Excel is not just a software – it’s a skill that can significantly boost your productivity and career. So dive in, explore the tutorials, and happy Excelling! POPULAR EXCEL ARTICLES HOW TO ADD TEXT TO THE BEGINNING OR END OF ALL CELLS IN EXCEL There may be instances where you need to add the same text to all cells in a column. You might need to add a particular CLICK HERE TO READ MORE HOW TO CONVERT DATE TO DAY OF WEEK IN EXCEL? When working with date-specific information, there might be instances where you need to find the day of the week corresponding to a date. For example, CLICK HERE TO READ MORE MULTIPLE IF STATEMENTS IN EXCEL (NESTED IFS, AND/OR) WITH EXAMPLES We use the IF statement in Excel to test one condition and return one value if the condition is met and another if the condition CLICK HERE TO READ MORE HOW TO COMPARE TWO COLUMNS IN EXCEL (USING VLOOKUP & IF) When you’re working with data in Excel, sooner or later you will have to compare data. This could be comparing two columns or even data CLICK HERE TO READ MORE HOW TO FILL BLANK CELLS WITH VALUE ABOVE IN EXCEL? Sometimes, you may have a dataset where there are empty/blank cells in a dataset that should have been filled with the same value. Below is CLICK HERE TO READ MORE USING IF FUNCTION WITH DATES IN EXCEL (EASY EXAMPLES) The IF function is one of the most useful Excel functions. It is used to test a condition and return one value if the condition CLICK HERE TO READ MORE HOW TO ENTER SEQUENTIAL NUMBERS IN EXCEL? Sequential numbers are an ordered list of consecutive numbers. It can sometimes be needed to have your rows numbered with sequential numbers. For example, if CLICK HERE TO READ MORE HOW TO STRIKETHROUGH IN EXCEL (5 WAYS + SHORTCUTS) While strikethrough is mostly used in Office applications such as Microsoft Word or Outlook, a lot of users also use it in Excel. One common CLICK HERE TO READ MORE XLS VS. XLSX FILES – WHAT’S THE DIFFERENCE? When working with Microsoft Excel, you might have come across two different file formats, namely XLS and XLSX. Understanding the difference between these two formats CLICK HERE TO READ MORE LATEST EXCEL ARTICLES EXCEL VS ACCESS – ULTIMATE COMPARISON GUIDE Have you ever felt overwhelmed by endless rows of data or struggled to make sense of complex datasets? You’re not alone. Microsoft Excel and Access CLICK HERE TO READ MORE DATABASE VS SPREADSHEET In the digital age, data management is more crucial than ever. Businesses and organizations thrive on their ability to organize, analyze, and secure their data. CLICK HERE TO READ MORE USING VLOOKUP APPROXIMATE MATCH IN EXCEL (EXAMPLES) Using VLOOKUP Approximate Match – Examples The VLOOKUP Function is, arguably, one of the most useful built-in Excel functions. It allows you to search for CLICK HERE TO READ MORE REMOVE NEGATIVE SIGN IN EXCEL Are you Working on an Excel spreadsheet and wondering how to get rid of negative signs? I often need to do this when working on CLICK HERE TO READ MORE HOW TO COPY A PIVOT TABLE IN EXCEL? At times, we need to copy Pivot Tables in Excel for different reasons. Sometimes, you might want an exact copy, including all the Pivot Table CLICK HERE TO READ MORE SEARCH VS FIND FUNCTION IN EXCEL When working with text data in Microsoft Excel, you often need to locate specific characters or substrates within a larger string. In such situations, Excel CLICK HERE TO READ MORE « Previous Page1 Page2 Page3 Page4 Page5 Next » spreadsheetplanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com 2023 © spreadsheetplanet.com Privacy Policy | Sitemap Spreadsheet Planet Data and Cookie Consent In order to provide a more personal user experience, we and our 215 partners use technology such as cookies to store and/or access device information. By clicking “Accept” you consent to these technologies which will allow us and our partners to process non-sensitive data such as IP address, unique ID, and browsing data for the purposes of serving personalized ads and content, ad and content measurement, audience insights, and to develop and improve products. Your choices on this site will be applied only for this site. You can change your settings at any time, including withdrawing your consent, by going to the Privacy Policy page of this site. Manage Settings Accept Update Privacy Settings