Benjamin R. on LinkedIn: Dark mode in LinkedIn 🌜 How did I not know about this?? 👉 Click on… (2024)

Integrating Google Forms with Google Sheets 📋➡️📊But why?With Google Forms, you collect responses in real-time, and they will instantly appear in your Google Sheet. This ensures that you always have the latest information at your fingertips.➡ Responses from Google Forms are neatly organized into rows and columns in Google Sheets. This saves you the time and effort of manually entering data.How to do it >>Option 1: - Start with a Google Form (if you don't know how, just search in Google Search)- Design your form with the necessary questions and fields.- Click on the "Responses" tab.- Click on the green Sheets icon to create a new spreadsheet or select an existing one.Option 2 - Start with a Google Sheet- Click on "Tools."- Click on "Make a new form.".- From here, you can design a fresh new form (or edit it once you've made it).Give it a try.#GoogleForms #GoogleSheets #Productivity

1

If you could go back in time, where would you go?(Yes - I'll get to how this is relevant to Google Sheets in just a moment... please, indulge me --- or just skip to the bottom)Where were we? Ahhh... yes, time travel.I've been reading a lot of historical fiction recently: like Shogun 🗾 and books by Ken Follet ⛪. One thing seems pretty clear from these books... life was horrible a few centuries ago... Miserable. Dirty. Short. But... ➡➡ In Google Sheets, you can easily go back to the past, and there is very little risk of plague...You can go through all the changes made to any particular cell. So you can see:- who edited it.- what changes they made.- what it was like before.This isn't limited to just the last change; you can cycle back through all changes made to the cell.🚀 How to do it:Right-Click on the cell you’re interested in.Select "Show edit history."A box will appear, showing a changes made to that cell.Enjoy 💆♂️ Want to learn better spreadsheet skills? Get in touch.

4

2 Comments

🖱️ Save time opening multiple links 🖱️Wasting time clicking back and forth through multiple links in a spreadsheet? Highlight the range with all the links.Right-Click Go to "View More Cell Actions"Select “Open Links” ♻ Share with yo friends.#GoogleSheets #Efficiency

2

100 uses for spreadsheets:Budgeting and personal financeExpense trackingMeal planningGrocery shopping listsHome inventory managementVacation planningFitness and workout trackingHabit trackingReading lists and book trackingMovie and TV show trackingRecipe managementEvent planning (e.g., weddings, parties)Address book and contact managementGift planning and trackingGoal setting and trackingHousehold chore schedulesPet care schedules and trackingPersonal project managementMedical history and appointment trackingPersonal journal or diaryBusiness UsesFinancial statements (income statement, balance sheet, cash flow)Budgeting and forecastingExpense tracking and managementSales tracking and analysisInventory managementProject management and trackingTask managementEmployee scheduling and time trackingCRM (Customer Relationship Management)Marketing campaign trackingData analysis and reportingKPI (Key Performance Indicators) trackingInvoicing and billingVendor and supplier managementProduct pricing and cost analysisRisk management and analysisSWOT analysisCompetitive analysisStrategic planningTraining and onboarding schedulesAcademic UsesGrade trackingAttendance trackingAssignment and homework trackingClass schedulesResearch data collection and analysisLesson planningStudent performance analysisProject timelines and deadlinesCourse syllabiAcademic budgeting and fundingThesis and dissertation planningScholarship and grant trackingGroup project managementCitation managementStudy schedulesClassroom resource inventoryCurriculum developmentEducational content planningFaculty and staff schedulingAlumni trackingData Analysis and ReportingData cleaning and preparationStatistical analysisTrend analysisDashboard creationPivot tables for data summarizationGraphs and charts for data visualizationCorrelation and regression analysisHypothesis testingSurvey data analysisA/B testing resultsForecasting and predictive modelingBusiness intelligence reportsPerformance metrics trackingMarket research analysisData miningFinancial modelingScenario analysisBenchmarkingProductivity analysisROI (Return on Investment) analysisSpecialized UsesReal estate property managementConstruction project managementSupply chain managementManufacturing process trackingHealthcare patient trackingClinical trial data managementEnvironmental data trackingAgricultural planning and trackingLogistics and transportation planningLegal case managementNon-profit fundraising trackingGrant application trackingMembership and subscription trackingEvent ticket sales trackingCustomer support ticket trackingE-commerce order trackingWebsite performance trackingIT asset managementSoftware development tracking (e.g., bug tracking, feature requests)Freelance project managementPretty handy huh?Spreadsheets getting you down?Let's talk.

3

Cut out 90% of your formulas with ARRAYFORMULA in Google Sheets 🔢What is ARRAYFORMULA?ARRAYFORMULA enables you to apply a function or formula to an entire range of cells, eliminating the need to copy formulas down each row. This makes your spreadsheet more efficient and easier to manage.How to Use ARRAYFORMULA:Basic Syntax 🖥️=ARRAYFORMULA(function_or_formula(range))Suppose you have numbers in column A and want to multiply them by the numbers in column B:Formula without ARRAYFORMULA:=A2*B2Then, you would typically drag this formula down for each row.So, the next one would be =A3*B3. Then =A4*B4=A5*B5...and so on.With ARRAYFORMULA, you can wrap them all into a single formula =ARRAYFORMULA(A2:A * B2:B)This single formula automatically applies the multiplication to each pair in the ranges A2 and B2.Tired of spreadsheets slowing you down? Let's talk.#SpreadsheetTips #GoogleSheets #Productivity

8

5 Comments

How rude of me...I've been posting all kinds of (hopefully not boring) spreadsheet tips, but I haven't introduced myself...❔❓ One of these facts is untrue:🥋 I started karate one year ago. 🌪 One dream trip: to go on a storm chasing trip and see a tornado.☘ I recently launched a one-man crusade against a creeping vine that is taking over the neighbourhood and killing all the other plants. ⌛ I have solved a Rubik’s Cube in under 2 minutes.Bonus: cat pic of my main man: GoldeneyeAnyone else want to play?

4

6 Comments

Here is how I hide calculations in my spreadsheets 🔍I like to design my spreadsheets so that people only see what they need to see. If there is extra stuff there, it unnecessarily takes up valuable space and brain power.Here’s a quick way to keep calculations hidden: use conditional formatting to hide them!In Google Sheets: Go to Format > Conditional formatting. Choose "Custom formula" and make it dependant on another cell that you can use as a button. See how I've done it in the pictures.Set the text color to match the background color (e.g., white text on a white background).Magic...🧝♂️ What are your favorite spreadsheet hacks? Share them in the comments! 💬#SpreadsheetTips #GoogleSheets #ConditionalFormatting

4

2 Comments

Here is how >> I created an automatic calendar in Google Sheets that gives the correct days for any month you choose.This is super handy when making reports, so you know exactly what day it is on any given date.This allows you to track activity during the work week vs weekend.Here's the formula:=SEQUENCE(1, DAYS(DATE('year', 'month' + 1, 1), DATE('year', 'month', 1)))Note that 'year' and 'month' refer to cells with those values in them --> You can see this in the little video.Let's break it down 🔭 SEQUENCE creates a horizontal list of numbers. How many numbers?We want it to create however many numbers there are in the selected month.That's where DAYS comes in. It calculates the number of days between two dates.So, if we can find the first day of the selected month, and the first day of the following month, we can use DAYS to calculate how many days there are between them.DATE('year', 'month', 1) is the first day of the selected month.DATE('year', 'month' + 1, 1) is the first day of the next month. Slap those two into a DAYS formula to see how many days between them. and.... boom, you've got a formula that automatically spits out the number of days in any month you like.😎 Let's expand it a little...=ArrayFormula(IF(B4:AF4<>"",TEXT(DATE('year,'month,B4:AF4),"ddd"),""))I've put this one underneath. It returns the day of the week from each date above it.Let's break it down:IF(B4:AF4<>"",... ) this part just checks if there is a valid date above. If it's empty, the formula does nothing.TEXT(DATE('year,'month,B4:AF4),"ddd") --> This part looks at the date above the cell, puts it together with the chosen month and year, and returns the day of the week that corresponds to that day.ArrayFormula applies the formula to the whole row.Now... let's expand it a little more...Use conditional formatting over the whole section to highlight the weekend:=OR(B$5="Sat",B$5="Sun")And you're done!Use this to wow your colleagues with a tidy and dynamic calendar that you can use in any dashboard.♻ share and repost --------------Want to up your spreadsheet skills ? 🚀 Follow me.

6

5 Comments

✨ The Simplest Way to Instantly Make Your Sheets Look Better ✨Want a quick and easy way to give your spreadsheet a cleaner, more professional look? It'll take about... 3 seconds...💡 Remove the gridlines.Why ?Gridlines can clutter your view. Removing them makes your content stand out and improves overall readability.Without gridlines, your spreadsheet looks more polished and presentable, making it suitable for reports, presentations, and sharing with stakeholders.Removing gridlines helps you use cell borders and shading more effectively to emphasize key sections and organize your data visually.How to Remove Gridlines in Google Sheets:> In Google Sheets:> Go to the View menu.> Uncheck Gridlines.What other simple tips do you have for improving spreadsheet appearance? Share your thoughts 💬♻ Share to clean the world of messy spreadsheets#SpreadsheetTips #Productivity #DataManagement #Excel #GoogleSheets #TechTips

3