1.Build conditional formatting rulesDecomposes your conditions into rules with exact references and a priority order.Office work › Spreadsheets · #Drafting #Office worker #Spreadsheet2.Reconcile two tables whose numbers disagreeGives an order for tracking down a discrepancy, starting with the causes that explain most of them.Office work › Spreadsheets · #Reviewing #Spreadsheet #Office worker3.Build a data cleanup procedureClassifies the problems actually present in your sample and orders the fixes so they do not corrupt each other.Office work › Spreadsheets · #Reformatting #Analyzing #Office worker4.Diagnose a spreadsheet errorRanks likely causes against your actual formula and gives a runnable check for each.Office work › Spreadsheets · #Analyzing #Reviewing #Office worker5.Build a spreadsheet formulaUses your actual sheet layout, gives a version fallback, and states how it behaves on blanks and errors.Office work › Spreadsheets · #Drafting #Office worker #Spreadsheet6.Decode a formula someone else wroteBreaks a long nested formula into parts and explains what each does, flagging the fragile ones.Office work › Spreadsheets · #Analyzing #Spreadsheet #Office worker7.Excel Formula SenseiEnter the calculation you need, the data range, and the conditions to get an Excel formula plus a step-by-step explanation of the functions, operators, and references used.Office work › Spreadsheets · #Drafting #Analyzing #Office worker8.Write requirements for a spreadsheet macroPins down ranges, branches, and exception handling before any code is written.Office work › Spreadsheets · #Question generation #Analyzing #Office worker9.Design a pivot table layoutChecks whether the source data is pivot-ready first, then gives the field layout.Office work › Spreadsheets · #Analyzing #Office worker #Spreadsheet10.Plan how far to automate a repetitive spreadsheet taskSeparates the steps of a monthly manual process into what formulas can do, what needs a pivot or macro, and what stays manual.Office work › Spreadsheets · #Reformatting #Spreadsheet #Office worker11.Excel SheetTell it what values or formulas to put in each cell, and get back just the result as a text-based Excel table with columns A through L and 10 rows.Office work › Spreadsheets · #Reformatting #Analyzing #Spreadsheet12.Restructure a spreadsheet that fights your formulasDiagnoses when the real problem is layout — merged cells, title rows, mixed types — rather than the formula.Office work › Spreadsheets · #Analyzing #Spreadsheet #Office worker13.Job and Internship Tracker for Google SheetsEnter your major, expected graduation date, and fields of interest, and get a Google Sheets template designed to track job and internship applications, contacts, follow-ups, and networking.Office work › Spreadsheets · #Drafting #Job seeker #Spreadsheet
TukttakAI prompt library