{"id":2783,"date":"2025-09-25T21:01:12","date_gmt":"2025-09-25T21:01:12","guid":{"rendered":"https:\/\/makeaiprompt.com\/blog\/gemini-prompt-for-generating-excel-formulas-cheatsheet\/"},"modified":"2025-09-25T21:01:12","modified_gmt":"2025-09-25T21:01:12","slug":"gemini-prompt-for-generating-excel-formulas-cheatsheet","status":"publish","type":"post","link":"https:\/\/makeaiprompt.com\/blog\/gemini-prompt-for-generating-excel-formulas-cheatsheet\/","title":{"rendered":"Gemini Prompt for Generating Excel Formulas Cheatsheet"},"content":{"rendered":"<div style=\"margin-top: 0px; margin-bottom: 0px;\" class=\"sharethis-inline-share-buttons\" ><\/div><div style=\"padding:20px;border-radius:8px;margin-bottom:20px;\">\n<h3 style=\"margin-top:0;\">About Prompt<\/h3>\n<ul style=\"list-style: none; padding: 0;\">\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Prompt Type<\/strong> &#8211; Dynamic<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Prompt Platform<\/strong> &#8211; Google Gemini<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Niche<\/strong> &#8211; Microsoft office<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Language<\/strong> &#8211; English<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Category<\/strong> &#8211; Productivity<\/li>\n<li style=\"margin:8px 0;padding:8px;border-radius:4px;box-shadow:0 1px 3px rgba(255, 255, 255, 1);\"><strong>Prompt Title<\/strong> &#8211; Gemini Prompt for Generating Excel Formulas Cheatsheet<\/li>\n<\/ul>\n<\/div>\n<h3 style=\"margin-top:0;\">Prompt Details <\/h3>\n<div id=\"promptContent\">Here is an optimized, dynamic AI prompt for Google Gemini to generate an Excel Formulas Cheatsheet, designed for productivity in the Microsoft Office niche.<\/p>\n<p>&#8212;<\/p>\n<p>### **Optimized Gemini Prompt: The Dynamic Excel Productivity Cheatsheet Generator**<\/p>\n<p>**[PROMPT STARTS HERE]**<\/p>\n<p>**1. ROLE &#038; GOAL:**<br \/>\nAct as an expert Microsoft Excel trainer and productivity consultant. Your primary goal is to generate a comprehensive, yet easy-to-digest Excel Formulas Cheatsheet. The cheatsheet must be tailored to a specific user&#8217;s needs to maximize their productivity and efficiency within the Microsoft Office ecosystem.<\/p>\n<p>**2. DYNAMIC INPUT VARIABLES:**<br \/>\nYou will generate the cheatsheet based on the following user-defined variables. Do not generate the cheatsheet until I provide these inputs.<\/p>\n<p>*   **`[Target Audience]`**: (e.g., Absolute Beginner, Intermediate User, Financial Analyst, Project Manager, Data Analyst, Small Business Owner)<br \/>\n*   **`[Specific Focus Area]`**: (e.g., General Productivity, Data Cleaning &#038; Text Manipulation, Financial Modeling Basics, Date &#038; Time Management, Advanced Lookups, Data Summarization)<br \/>\n*   **`[Output Format]`**: (e.g., Markdown Table, Simple Bulleted List, CSV format)<br \/>\n*   **`[Include Keyboard Shortcuts]`**: (e.g., Yes, No)<br \/>\n*   **`[Excel Version]`**: (e.g., Microsoft 365, Excel 2021, Excel 2019). This is crucial for including modern functions like `XLOOKUP`, `FILTER`, and `SORT`.<\/p>\n<p>**3. CONTENT &#038; STRUCTURE REQUIREMENTS:**<br \/>\nFor the cheatsheet, adhere to the following structure and content guidelines:<\/p>\n<p>*   **Categorization:** Group the formulas into logical categories relevant to the `[Specific Focus Area]`. Potential categories include:<br \/>\n    *   Essential Math &#038; Aggregation (SUM, AVERAGE, COUNT)<br \/>\n    *   Logical &#038; Conditional (IF, AND, OR, IFERROR)<br \/>\n    *   Lookup &#038; Reference (VLOOKUP, INDEX\/MATCH, XLOOKUP)<br \/>\n    *   Text Manipulation (CONCAT, TEXT, LEFT, RIGHT, TRIM)<br \/>\n    *   Date &#038; Time (TODAY, NOW, DATEDIF, EOMONTH)<br \/>\n    *   Conditional Aggregation (SUMIF\/S, COUNTIF\/S, AVERAGEIF\/S)<br \/>\n    *   Dynamic Arrays (FILTER, SORT, UNIQUE) &#8211; *Only if `[Excel Version]` is Microsoft 365 or newer.*<\/p>\n<p>*   **Formula Breakdown:** For each formula listed, you must provide the following four components in a clear, consistent layout:<br \/>\n    1.  **Formula Name:** The name of the function (e.g., **VLOOKUP**).<br \/>\n    2.  **Syntax:** The complete formula structure with its arguments (e.g., `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`). Use a `code block` for the syntax.<br \/>\n    3.  **Plain English Explanation:** A concise, one-sentence description of what the formula does. (e.g., &#8220;Searches for a value in the first column of a table and returns a value in the same row from a different column.&#8221;)<br \/>\n    4.  **Practical Productivity Example:** A simple, real-world example of how it&#8217;s used. (e.g., &#8220;Find the price of &#8216;Product ID 123&#8217; from a master product list.&#8221;)<\/p>\n<p>*   **Keyboard Shortcuts Section:** If `[Include Keyboard Shortcuts]` is &#8216;Yes&#8217;, create a separate section at the end titled &#8220;Essential Productivity Shortcuts&#8221;. Include a mix of formatting, navigation, and formula-related shortcuts (e.g., `Ctrl + 1` for Format Cells, `F4` for Absolute\/Relative References, `Ctrl + Shift + L` for Filter).<\/p>\n<p>**4. FORMATTING &#038; TONE:**<\/p>\n<p>*   **Tone:** Professional, encouraging, and clear. Avoid overly technical jargon where possible, especially for beginner audiences. The tone should be that of a helpful expert.<br \/>\n*   **Formatting:** Use Markdown for structure. Use **bolding** for formula names and section headers. Use `code blocks` for all formulas and syntax for easy copying. If the `[Output Format]` is Markdown Table, ensure it is well-structured with clear headers: &#8220;Formula&#8221;, &#8220;Syntax&#8221;, &#8220;Explanation&#8221;, and &#8220;Example&#8221;.<\/p>\n<p>**5. CONSTRAINTS:**<\/p>\n<p>*   Do not include VBA or Macro-related content. This cheatsheet is strictly for worksheet formulas.<br \/>\n*   Prioritize the most common and high-impact formulas based on the `[Target Audience]` and `[Specific Focus Area]`. Do not list every single obscure formula.<br \/>\n*   Ensure the syntax and function availability are accurate for the specified `[Excel Version]`. For example, do not suggest `XLOOKUP` if the version is Excel 2019.<\/p>\n<p>**6. EXAMPLE EXECUTION (for your reference):**<\/p>\n<p>*   **User Input:**<br \/>\n    *   `[Target Audience]`: Intermediate User<br \/>\n    *   `[Specific Focus Area]`: Data Summarization<br \/>\n    *   `[Output Format]`: Markdown Table<br \/>\n    *   `[Include Keyboard Shortcuts]`: Yes<br \/>\n    *   `[Excel Version]`: Microsoft 365<\/p>\n<p>*   **Expected Snippet of Output:**<\/p>\n<p>    ### **Conditional Aggregation**<\/p>\n<p>| Formula | Syntax | Explanation | Example |<br \/>\n| :&#8212; | :&#8212; | :&#8212; | :&#8212; |<br \/>\n| **SUMIFS** | `=SUMIFS(sum_range, criteria_range1, criteria1, &#8230;)` | Adds up cells that meet multiple specified criteria. | &#8220;Calculate total sales for the &#8216;East&#8217; region in &#8216;Q1&#8217;.&#8221; |<br \/>\n| **COUNTIFS** | `=COUNTIFS(criteria_range1, criteria1, &#8230;)` | Counts the number of cells that meet multiple criteria. | &#8220;Count how many employees in the &#8216;Marketing&#8217; department are &#8216;Full-Time&#8217;.&#8221; |<\/p>\n<p>&#8212;<\/p>\n<p>**[PROMPT ENDS HERE]**<\/p>\n<p>**Please provide the values for the following variables to generate your custom Excel cheatsheet:**<\/p>\n<p>*   **`[Target Audience]`**:<br \/>\n*   **`[Specific Focus Area]`**:<br \/>\n*   **`[Output Format]`**:<br \/>\n*   **`[Include Keyboard Shortcuts]`**:<br \/>\n*   **`[Excel Version]`**:<\/p><\/div>\n<div style=\"margin-top: 40px; text-align: center;\"><button class=\"copyPostContent\" id=\"copyPostContent\">\ud83d\udccb Copy Prompt<\/button><\/div>\n<div class=\"ai-buttons\"><a href=\"https:\/\/makeaiprompt.com\">Create Your Own Prompts<\/a><a href=\"https:\/\/makeaiprompt.com\/blog\/category\/prompts\">View All Prompts<\/a><a href=\"https:\/\/makeaiprompt.com\/top-ai-tools\">Top AI Tools<\/a><a href=\"https:\/\/chatgpt.com\/\" target=\"_blank\" rel=\"noopener\">Try on ChatGPT<\/a><a href=\"https:\/\/gemini.google.com\/app\" target=\"_blank\" rel=\"noopener\">Try on Gemini<\/a><a href=\"https:\/\/aistudio.google.com\" target=\"_blank\" rel=\"noopener\">Try on Google AI Studio<\/a><a href=\"https:\/\/grok.com\" target=\"_blank\" rel=\"noopener\">Try on Grok<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Gemini Prompt for Generating Excel Formulas Cheatsheet: Keyboard Shortcuts Section: If `[Include Keyboard Shortcuts]` is &#8216;Yes&#8217;, create a separate section at&#8230;<\/p>\n","protected":false},"author":4,"featured_media":2782,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6,1],"tags":[],"class_list":["post-2783","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gemini-prompts","category-prompts"],"jetpack_featured_media_url":"https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet.jpg","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"rttpg_featured_image_url":{"full":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet.jpg",1200,630,false],"landscape":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet.jpg",1200,630,false],"portraits":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet.jpg",1200,630,false],"thumbnail":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet-150x150.jpg",150,150,true],"medium":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet-300x158.jpg",300,158,true],"large":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet-1024x538.jpg",1024,538,true],"1536x1536":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet.jpg",1200,630,false],"2048x2048":["https:\/\/makeaiprompt.com\/blog\/wp-content\/uploads\/2025\/09\/Gemini-Prompt-for-Generating-Excel-Formulas-Cheatsheet.jpg",1200,630,false]},"rttpg_author":{"display_name":"AIPrompts","author_link":"https:\/\/makeaiprompt.com\/blog\/author\/aiprompts\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/makeaiprompt.com\/blog\/category\/prompts\/gemini-prompts\/\" rel=\"category tag\">Gemini Prompts<\/a> <a href=\"https:\/\/makeaiprompt.com\/blog\/category\/prompts\/\" rel=\"category tag\">Prompts<\/a>","rttpg_excerpt":"Gemini Prompt for Generating Excel Formulas Cheatsheet: Keyboard Shortcuts Section: If `[Include Keyboard Shortcuts]` is 'Yes', create a separate section at...","_links":{"self":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/posts\/2783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/comments?post=2783"}],"version-history":[{"count":0,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/posts\/2783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/media\/2782"}],"wp:attachment":[{"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/media?parent=2783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/categories?post=2783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/makeaiprompt.com\/blog\/wp-json\/wp\/v2\/tags?post=2783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}