Prompt is here 👇🏻
"I'm looking for advanced Excel formulas for [type of analysis], specifically tailored for [type of data]. I'm an [user proficiency level] user and need formulas for tasks like [specific tasks like forecasting, trend analysis]. I'm particularly interested in learning more about functions like [specific functions of interest]. The data I'm working with involves [description of the data set] with [number of variables] variables. I need formulas that are efficient for [scale of data processing], but I'm not using [specific tools or methods not being used]. Can you provide a list of formulas with detailed explanations or a step-by-step guide?"
[type of analysis]: This variable represents the specific kind of analysis you want to perform using Excel. It could be statistical analysis, financial analysis, data mining, etc.
[type of data]: This indicates the nature or category of the data you are dealing with. Examples include financial data, marketing data, scientific data, etc.
[user proficiency level]: This refers to your expertise or skill level in using Excel. It could be beginner, intermediate, advanced, or expert.
[specific tasks like forecasting, trend analysis]: Here, you specify the particular tasks or functions you want to perform with Excel formulas. This could include forecasting, trend analysis, data sorting, regression analysis, etc.
[specific functions of interest]: This variable is for mentioning specific Excel functions you are interested in exploring more deeply. Examples might include XLOOKUP, VLOOKUP, INDEX-MATCH, array formulas, etc.
[description of the data set]: This describes the characteristics of the dataset you are working with. It could detail the size, complexity, nature (like time series, cross-sectional, longitudinal), or any other relevant attributes.
[number of variables]: This refers to the number of different data points, fields, or columns in your dataset.
[scale of data processing]: This variable represents the scale or volume of data processing you need. It could be large-scale data processing, small datasets, real-time analysis, etc.
[specific tools or methods not being used]: Here, you mention any tools, methods, or features in Excel that you are not planning to use. For example, it could be macros, a specific version of Excel, add-ins, etc.
