All categories
Education & Personal
Learning, teaching, personal workflows, health, hobbies, and lifestyle skills
- 2,399
- 100
Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.
Open in full browserBrowse education & personal skills
Showing 1,777–1,800 of 2,399 skills
- Excel Vba Search Copy And Format MacroA VBA subroutine to search a source sheet for a value, copy all matches to a destination sheet, apply random column colors (excluding white), highlight source cells yellow, and log the search term.Votes: 0GitHub stars: 438
- Excel Vba Repeating Day Sequence ValidatorValidates a repeating sequence of days (Monday to Sunday) in a column, highlights cells that break the sequence in yellow, and resets the sequence check from the breaking cell.Votes: 0GitHub stars: 438
- Excel Vba Mark Latest Time Per DateGenerates VBA code to identify the row with the latest time value for each unique date in a dataset and appends a specified text marker to a target column.Votes: 0GitHub stars: 438
- Excel Vba Formula Protection With User Interface RestrictionGenerates VBA code to protect only formula cells on the active sheet while allowing VBA execution and user edits on non-formula cells, with optional user notifications.Votes: 0GitHub stars: 438
- Excel Vba File Renaming Based On Hyperlinks And StatusA VBA macro to rename files linked in an Excel sheet by adding a 'PRO' prefix, based on a 'Processed' status flag in an adjacent column, including checks for file existence and open status.Votes: 0GitHub stars: 438
- Excel Vba Duplicate Prevention For Composite Keys Columns A AndGenerates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and clears the new value in Column D.Votes: 0GitHub stars: 438
- Excel Vba Double Click Task Duplication MacroGenerates a VBA Worksheet_BeforeDoubleClick event handler to duplicate data rows, shift content down, clear the immediate next row, and prevent cell edit mode based on specific user requirements.Votes: 0GitHub stars: 438
- Excel Vba Day Boundary HighlightingGenerates VBA code to iterate through a column, detect changes in the day value, and highlight the cell preceding the change, while excluding specific time values.Votes: 0GitHub stars: 438
- Excel Vba Conditional Row Coloring MacroGenerates VBA code to color rows based on column values (e.g., FREE/PAID) and the presence of a marker (e.g., X) in the row, while ensuring empty cells are white.Votes: 0GitHub stars: 438
- Excel Vba Column Validation LogicGenerates VBA code for a Worksheet_Change event to validate that a cell in Column J is not blank and the corresponding cell in Column B does not contain specific text (e.g., 'Request').Votes: 0GitHub stars: 438
- Excel Vba Caller Specific Macro ExecutionImplement logic to ensure a macro on a target sheet executes only when triggered programmatically from a specific source sheet, preventing execution during manual navigation.Votes: 0GitHub stars: 438
- Excel Status Calculation Based On Column ComparisonGenerates an Excel nested IF formula to determine task status (Completed, Incomplete, or Pending) by comparing a Target column against an Actual column and appending the status to an ID column.Votes: 0GitHub stars: 438
- Excel Formula For Right To Left Text ExtractionGenerates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string.Votes: 0GitHub stars: 438
- Excel Financial Data Analysis And VisualizationAnalyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.Votes: 0GitHub stars: 438
- Excel Drop Down List Without BlanksGenerates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range.Votes: 0GitHub stars: 438
- Event Quote Review And Site Visit Coordination WorkflowManages the specific workflow for reviewing vendor quotes against requirements, negotiating costs, validating with the service providers team, and coordinating site visits involving the events team.Votes: 0GitHub stars: 438
- Ev Recommendation With Weighted Criteria ScoringRecommends top electric vehicles based on user-defined technical constraints (features, range, body type, brand) and calculates a weighted percentage match score for ranking.Votes: 0GitHub stars: 438
- Ethical Case Study AnalysisAnalyze ethical case studies by identifying the main issue, conflicting values, applicable decision-making models, and appropriate responses.Votes: 0GitHub stars: 438
- Esl Writing Worksheet DesignerDesigns educational writing worksheets for ESL students, specializing in structured tasks like expository career essays with planner tables, checklists, and age-appropriate content.Votes: 0GitHub stars: 438
- Erotic Rpg Dungeon Master With Screen TriggersAct as a Dungeon Master for an erotic role-playing game, displaying specific game screens in bullet points when triggered by user commands.Votes: 0GitHub stars: 438
- Equipment Information Gathering WorkflowGathers context about user equipment via clarifying questions before providing a final answer, ensuring accuracy by synthesizing gathered details.Votes: 0GitHub stars: 438
- Equipment Spare Parts Cost EstimationGenerates a list of common repair or replacement parts for a specified list of equipment, including the average national price and the frequency of replacement per year.Votes: 0GitHub stars: 438
- English To Literary Chinese TranslatorTranslates English text into Simplified Chinese, upgrading the vocabulary and style to be more literary and elegant. Outputs only the corrected text without explanations.Votes: 0GitHub stars: 438
- English To Katakana TranscriptionTranscribes English sentences into Japanese Katakana characters based on phonetic syllables without translating the meaning.Votes: 0GitHub stars: 438