title
10x your productivity with these AI tools in Excel 😲

description
There is a lot of hype around ChatGPT, but do you know that Excel has really powerful AI built-into it? YES!!! In this video, let me share of 5 of my favourite AI features (plus a bonus one) in Excel that really save time & make you more productive! Learn all about the AI features in Excel like Flash Fill, Column from examples (Power Query), AI automatic analysis of data, Recommendations, AI formula writer & Automatic forecast with real world examples. 0:00 - Forget ChatGPT 0:34 - Feature 1 - Flash Fill 🦸‍♂️ 2:19 - Feature 2 - Let Excel write the formulas 🧪 6:00 - Feature 3 - AI Automatic Analysis of Data 🤖 10:01 - Feature 4 - Recommendations in Excel 🆘 12:26 - Bonus - Formula writer in Excel ⌨ 15:03 - Feature 5 - Forecasting in Excel 📈📈📈 17:59 - More AI 😎 ~ 📂 Download Sample File ====================== Learn more about these concepts here 👉 https://chandoo.org/wp/top-ai-features-in-excel/ Need to practice these concepts in Excel? Try with my sample data file here 👇 https://chandoo.org/wp/wp-content/uploads/2023/02/Excel-AI-Features.xlsx 🚨 COMPATIBILITY ================ While the AI features are exciting, they don't work in all versions of Excel. See below for compatibility information. Feature 1 - Flashfill - Excel 2013 or above, Excel 365 Feature 2 - Column from Examples - Excel 2106 or above, Excel 365 Feature 3 - AI Analysis of Data - Excel 365 Feature 4 - Recommendations - Excel 365, Excel 2016 (?) Feature 5 - Forecasting - Excel 2103 or above, Excel 365 Bonus feature - Formula Writer - Excel Online ~ 💻💡 LEARN MORE ================ New to Excel and want to level up quick? Check out below curated playlists to upskill fast. Free Excel Crash Course - https://youtu.be/F7aPazuS8QY Data Analysis with Excel - https://www.youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3 30 Advanced Excel tips - https://youtu.be/m2C_-6PW6WE Essential Excel Keyboard Shortcuts - https://youtu.be/ykP-agYOtC4 FULL Excel Course - https://chandoo.org/wp/excel-school-program/ ~ Why can't AI get a permanent driving license? 🚗 Because it is always learning 🤓🤣 #chatgpt #excel

detail
{'title': '10x your productivity with these AI tools in Excel 😲', 'heatmap': [{'end': 406.715, 'start': 381.277, 'weight': 1}], 'summary': "Learn how to leverage excel's ai features to 10x your productivity with 5 ai tools for streamlining data processing and analysis, flash fill for value extraction, dynamic formula generation, power query for email address generation, sales data visualization, and automated data processing and forecasting.", 'chapters': [{'end': 116.351, 'segs': [{'end': 89.066, 'src': 'embed', 'start': 44.066, 'weight': 0, 'content': [{'end': 48.027, 'text': "And I would like to extract the domain name here, but I don't know the formula.", 'start': 44.066, 'duration': 3.961}, {'end': 52.529, 'text': 'What I really want is anything that appears after the at the rate symbol.', 'start': 48.547, 'duration': 3.982}, {'end': 55.09, 'text': 'Here is how the pattern recognition works.', 'start': 53.369, 'duration': 1.721}, {'end': 59.211, 'text': 'You type some values and Excel will figure out what to do for the rest of the cells.', 'start': 55.33, 'duration': 3.881}, {'end': 63.383, 'text': 'so multiply.com.', 'start': 61.542, 'duration': 1.841}, {'end': 70.826, 'text': 'mappy and you can see that as i type the first two, three letters, excel has already done a pretty good job.', 'start': 63.383, 'duration': 7.443}, {'end': 78.428, 'text': 'when you are ready, you just hit enter and all of these values get automatically extracted for you.', 'start': 70.826, 'duration': 7.602}, {'end': 81.27, 'text': 'this feature is called flash fill.', 'start': 78.428, 'duration': 2.842}, {'end': 84.991, 'text': 'you can also trigger this by pressing ctrl e.', 'start': 81.27, 'duration': 3.721}, {'end': 89.066, 'text': "Let's see this in a more advanced scenario.", 'start': 86.345, 'duration': 2.721}], 'summary': "Excel's flash fill feature automatically extracts values, such as domain names, after the '@' symbol by recognizing patterns and can be triggered using ctrl+e.", 'duration': 45, 'max_score': 44.066, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU44066.jpg'}], 'start': 6.774, 'title': "Excel's ai features", 'summary': 'Explores five useful ai features in excel, including pattern recognition and flash fill, which streamline data processing and analysis.', 'chapters': [{'end': 116.351, 'start': 6.774, 'title': "Excel's ai features", 'summary': 'Explores five useful ai features in excel, including pattern recognition and flash fill, which automatically extracts domain names and amounts from text data, streamlining data processing and analysis.', 'duration': 109.577, 'highlights': ["Excel's flash fill feature automatically extracts domain names and amounts from text data, significantly streamlining data processing and analysis.", 'Pattern recognition in Excel allows for the automatic extraction of domain names from email addresses, enhancing efficiency in data manipulation and analysis.', "Excel's flash fill feature enables the automatic extraction of domain names and amounts from text data, reducing manual effort and enhancing data processing efficiency.", 'Pattern recognition in Excel simplifies the extraction of domain names from email addresses, improving the efficiency of data manipulation and analysis.', "Excel's flash fill feature streamlines data processing by automatically extracting domain names and amounts from text data, reducing manual effort and improving efficiency."]}], 'duration': 109.577, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU6774.jpg', 'highlights': ["Excel's flash fill feature automatically extracts domain names and amounts from text data, significantly streamlining data processing and analysis.", "Excel's flash fill feature enables the automatic extraction of domain names and amounts from text data, reducing manual effort and enhancing data processing efficiency.", "Excel's flash fill feature streamlines data processing by automatically extracting domain names and amounts from text data, reducing manual effort and improving efficiency.", 'Pattern recognition in Excel allows for the automatic extraction of domain names from email addresses, enhancing efficiency in data manipulation and analysis.', 'Pattern recognition in Excel simplifies the extraction of domain names from email addresses, improving the efficiency of data manipulation and analysis.']}, {'end': 439.355, 'segs': [{'end': 162.627, 'src': 'embed', 'start': 116.351, 'weight': 2, 'content': [{'end': 122.415, 'text': "And after typing few values, I'm going to press control E and Excel will extract the values again for me.", 'start': 116.351, 'duration': 6.064}, {'end': 124.597, 'text': 'Pretty good job really.', 'start': 123.436, 'duration': 1.161}, {'end': 132.502, 'text': 'So this particular artificial intelligence feature of Excel is called flash fill and you can access this with either control E or,', 'start': 124.757, 'duration': 7.745}, {'end': 137.846, 'text': "if you go to the data ribbon, you'll see that there is a flash fill option right here.", 'start': 132.502, 'duration': 5.344}, {'end': 149.338, 'text': "While the flash field does a pretty good job of extracting the data for you, it doesn't tell you what formula it has used to extract the data.", 'start': 139.431, 'duration': 9.907}, {'end': 154.941, 'text': "So now let's use Excel to generate the actual formula logic.", 'start': 150.057, 'duration': 4.884}, {'end': 162.627, 'text': 'So here I have a file with 1000 names and what I want is I want to generate an email address for these names.', 'start': 155.582, 'duration': 7.045}], 'summary': "Excel's flash fill feature extracts data efficiently, but doesn't reveal the formula used.", 'duration': 46.276, 'max_score': 116.351, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU116351.jpg'}, {'end': 246.219, 'src': 'embed', 'start': 223.439, 'weight': 1, 'content': [{'end': 233.204, 'text': 'Power Query is a very advanced feature built right into Excel so that you can do a lot of data related stuff quite easily.', 'start': 223.439, 'duration': 9.765}, {'end': 239.773, 'text': "So let's understand how we can use Power Query to generate that email address with a formula.", 'start': 233.908, 'duration': 5.865}, {'end': 246.219, 'text': "The first thing that I'm going to do is make sure that the name is actually used as the heading of this table.", 'start': 240.634, 'duration': 5.585}], 'summary': 'Power query in excel simplifies data tasks for generating email addresses.', 'duration': 22.78, 'max_score': 223.439, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU223439.jpg'}, {'end': 417.719, 'src': 'heatmap', 'start': 381.277, 'weight': 0, 'content': [{'end': 390.204, 'text': 'no worries, just select the any cell in this data and from home ribbon, click on analyze data button.', 'start': 381.277, 'duration': 8.927}, {'end': 399.351, 'text': "this button looks fairly harmless, but when you tap on this, it's actually gonna look at your data and do the analysis for you.", 'start': 390.204, 'duration': 9.147}, {'end': 406.715, 'text': 'so, for example, here it has done all of this analysis and produce it some pretty cool and interesting graphs.', 'start': 399.351, 'duration': 7.364}, {'end': 416.218, 'text': 'so, for example, here it has done an analysis of expenses by salesperson and product and provided me with a matrix format.', 'start': 406.715, 'duration': 9.503}, {'end': 417.719, 'text': 'if i think this is valuable,', 'start': 416.218, 'duration': 1.501}], 'summary': 'Analyze data in excel to produce cool graphs and matrix format for expenses by salesperson and product.', 'duration': 27.515, 'max_score': 381.277, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU381277.jpg'}], 'start': 116.351, 'title': 'Excel features for data manipulation', 'summary': "Covers excel's flash fill for value extraction, formula generation for dynamic data, power query for email address generation, and ai analysis for sales data visualization.", 'chapters': [{'end': 190.38, 'start': 116.351, 'title': 'Excel flash fill and formula generation', 'summary': "Discusses the use of excel's flash fill feature, which automatically extracts values, and the need to generate formulas to handle dynamic data for tasks like creating email addresses for a changing list of names.", 'duration': 74.029, 'highlights': ["Excel's flash fill feature, accessed with control E or through the data ribbon, automatically extracts data without revealing the underlying formula logic.", 'The need to generate formulas in Excel to handle dynamic data, such as creating email addresses for a changing list of names, is highlighted to address the challenge of dealing with evolving datasets.', 'The challenge of generating email addresses for a dynamic list of names in Excel is outlined, with the example of creating email addresses for 1000 names and the anticipation of receiving an additional 500 IDs next week.']}, {'end': 439.355, 'start': 191.581, 'title': 'Excel power query and ai analysis', 'summary': 'Demonstrates how to use power query in excel to automatically generate email addresses and utilize ai analysis feature to analyze and visualize sales data.', 'duration': 247.774, 'highlights': ['Power Query feature in Excel allows for automatic generation of email addresses by using examples and generating relevant formulas, saving time and effort. Power Query feature in Excel, generates email addresses using examples and formulas', 'AI analysis feature in Excel provides automatic analysis and visualization of sales data, including producing graphs and identifying outliers, streamlining the analysis process. AI analysis feature in Excel, automatic analysis and visualization of sales data, producing graphs and identifying outliers']}], 'duration': 323.004, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU116351.jpg', 'highlights': ['AI analysis feature in Excel, automatic analysis and visualization of sales data, producing graphs and identifying outliers', 'Power Query feature in Excel, generates email addresses using examples and formulas', 'The need to generate formulas in Excel to handle dynamic data, such as creating email addresses for a changing list of names, is highlighted to address the challenge of dealing with evolving datasets', "Excel's flash fill feature, accessed with control E or through the data ribbon, automatically extracts data without revealing the underlying formula logic"]}, {'end': 1111.222, 'segs': [{'end': 551.048, 'src': 'embed', 'start': 520.373, 'weight': 0, 'content': [{'end': 528.439, 'text': "So this is only December data points and I'm gonna select the sales thing and make a note of this number.", 'start': 520.373, 'duration': 8.066}, {'end': 533.742, 'text': "So 3, 070, 228, that's exactly the number that Excel has come up with.", 'start': 528.739, 'duration': 5.003}, {'end': 537.265, 'text': 'Not only that, but you can ask more specific questions too.', 'start': 534.103, 'duration': 3.162}, {'end': 548.926, 'text': "for, and then let's just say after nines so that is a very specific product after nines, within the month of december 2022,", 'start': 538.379, 'duration': 10.547}, {'end': 551.048, 'text': 'and then that total has come up.', 'start': 548.926, 'duration': 2.122}], 'summary': 'December 2022 sales for after nines: 3,070,228', 'duration': 30.675, 'max_score': 520.373, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU520373.jpg'}, {'end': 742.784, 'src': 'embed', 'start': 718.355, 'weight': 1, 'content': [{'end': 727.86, 'text': 'Once I like a particular pivot table, I can just click on the new sheet button and such a pivot table will be generated for me and neatly presented.', 'start': 718.355, 'duration': 9.505}, {'end': 733.542, 'text': 'This is also a good thing for beginners who are not sure how to set up a pivot table.', 'start': 728.86, 'duration': 4.682}, {'end': 739.143, 'text': 'They can use this feature to generate the pivot table, study it and learn more about it.', 'start': 734.102, 'duration': 5.041}, {'end': 742.784, 'text': 'So those are the two kinds of things that Excel can recommend for you.', 'start': 739.884, 'duration': 2.9}], 'summary': 'Excel can automatically generate pivot tables, benefiting both experienced users and beginners.', 'duration': 24.429, 'max_score': 718.355, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU718355.jpg'}, {'end': 795.975, 'src': 'embed', 'start': 767.762, 'weight': 2, 'content': [{'end': 775.426, 'text': 'For this to work, currently you need to use Excel online on OneDrive for either personal or family accounts.', 'start': 767.762, 'duration': 7.664}, {'end': 781.228, 'text': 'Eventually this feature is going to be available on the desktop as well as business accounts too.', 'start': 775.846, 'duration': 5.382}, {'end': 784.69, 'text': 'Once you have some data, make it a table.', 'start': 782.089, 'duration': 2.601}, {'end': 791.873, 'text': 'So select all of this and use the format as table button here or insert table button here.', 'start': 784.95, 'duration': 6.923}, {'end': 795.975, 'text': 'This is going to turn your data into a tabular format.', 'start': 793.134, 'duration': 2.841}], 'summary': 'Excel online on onedrive supports data tables; desktop and business accounts to follow.', 'duration': 28.213, 'max_score': 767.762, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU767762.jpg'}, {'end': 855.908, 'src': 'embed', 'start': 822.41, 'weight': 3, 'content': [{'end': 829.854, 'text': "and if you tap on show formula, it's gonna show you the formula that you could use to generate this data automatically.", 'start': 822.41, 'duration': 7.444}, {'end': 830.694, 'text': 'when you are ready.', 'start': 829.854, 'duration': 0.84}, {'end': 837.857, 'text': 'just hit the apply button and you will get all the names automatically calculated to you through formula.', 'start': 830.694, 'duration': 7.163}, {'end': 840.256, 'text': "let's write one more formula.", 'start': 838.854, 'duration': 1.402}, {'end': 843.26, 'text': 'this time we want to generate an id number for these people.', 'start': 840.256, 'duration': 3.004}, {'end': 855.908, 'text': "so we'll say id number and then say id 001, id 002, id 003.", 'start': 843.26, 'duration': 12.648}], 'summary': 'Demonstrates using formulas to generate data automatically.', 'duration': 33.498, 'max_score': 822.41, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU822410.jpg'}, {'end': 944.35, 'src': 'embed', 'start': 903.683, 'weight': 6, 'content': [{'end': 910.732, 'text': "Now let's talk about the fifth example of Excel's AI features, and this is by far my favorite as well.", 'start': 903.683, 'duration': 7.049}, {'end': 916.079, 'text': 'So here I have got some app downloads for our chocolate crossing app.', 'start': 911.393, 'duration': 4.686}, {'end': 923.919, 'text': "It's a small game and here is the download information for the first six weeks of 2023.", 'start': 916.914, 'duration': 7.005}, {'end': 934.406, 'text': 'Given this information, my boss is asking me hey, can you forecast what would be the total downloads going forward in the next three weeks??', 'start': 923.919, 'duration': 10.487}, {'end': 944.35, 'text': "so one way to do this is you can select all of this data, insert a line chart or, if you're not sure you know, use the recommended chart and it will.", 'start': 935.126, 'duration': 9.224}], 'summary': "Excel's ai feature can forecast app downloads, based on the first six weeks of 2023 data.", 'duration': 40.667, 'max_score': 903.683, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU903683.jpg'}, {'end': 1111.222, 'src': 'embed', 'start': 1070.667, 'weight': 4, 'content': [{'end': 1078.672, 'text': 'So if your data changes, you just have to update these values and it will figure out what the forecast would be as per that.', 'start': 1070.667, 'duration': 8.005}, {'end': 1085.077, 'text': 'Using these five techniques, we can get a lot out of Excel without even doing any work.', 'start': 1079.073, 'duration': 6.004}, {'end': 1088.98, 'text': 'We just tell Excel what we want and Excel does the work for us.', 'start': 1085.577, 'duration': 3.403}, {'end': 1100.051, 'text': 'but if you take it one step further and understand the actual language that excel speaks the formula language then you can get even more out of your data.', 'start': 1089.62, 'duration': 10.431}, {'end': 1105.416, 'text': 'here is a video in which i introduce the 10 most important functions in excel.', 'start': 1100.051, 'duration': 5.365}, {'end': 1109.8, 'text': 'check it out and learn the important functions for data analysis.', 'start': 1105.416, 'duration': 4.384}, {'end': 1111.222, 'text': "i'll catch you there bye.", 'start': 1109.8, 'duration': 1.422}], 'summary': 'Learn 10 important excel functions for data analysis to get more out of your data.', 'duration': 40.555, 'max_score': 1070.667, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU1070667.jpg'}], 'start': 440.135, 'title': "Excel's data analysis and ai features", 'summary': "Covers excel data analysis tips including sales data analysis, recommended charts, pivot tables, and automatic formulas. it also discusses excel's ai features for data processing, forecasting, and automation, with examples of name and id generation and forecasting app downloads.", 'chapters': [{'end': 795.975, 'start': 440.135, 'title': 'Excel data analysis tips', 'summary': 'Discusses how to analyze and interact with data in excel, including analyzing sales data, using recommended charts and pivot tables, and utilizing automatic formulas in excel online on onedrive.', 'duration': 355.84, 'highlights': ["Excel can analyze and interact with data, such as total sales in December 2022, specific product sales, and distinct count of products in a given period. Excel can analyze and interact with data, providing the total sales in December 2022 (3,070,000), specific product sales for 'After Nines' in December 2022, and distinct count of products in a specific date period (21 products sold in the last week of December 2022).", 'Excel can recommend chart options and pivot table formats based on the available data, making it easier for beginners to generate and study pivot tables and charts. Excel can recommend chart options and pivot table formats based on available data, making it easier for beginners to generate and study pivot tables and charts for data representation and analysis.', 'Automatic formulas in Excel Online on OneDrive can be used to convert data into tabular format for analysis and presentation. Automatic formulas in Excel Online on OneDrive can be used to convert data into tabular format for analysis and presentation, which is beneficial for beginners and will eventually be available on desktop and business accounts.']}, {'end': 1111.222, 'start': 797.059, 'title': "Excel's ai features and forecasting in excel", 'summary': "Discusses how excel's ai features such as formula by example and forecast sheet can automate data processing and forecasting, with examples of generating names and ids using patterns and forecasting app downloads, allowing for easy data analysis without manual work.", 'duration': 314.163, 'highlights': ["Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, simplifying tasks and reducing manual work. It recommends formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "The 'forecast sheet' feature in Excel enables automated forecasting based on data patterns, providing graphical representations and forecasting formulas for future data analysis. It allows for automated forecasting based on data patterns, provides graphical representations, and forecasting formulas for future data analysis.", "Using Excel's AI features, it is possible to forecast future data trends, such as app downloads, by analyzing patterns and applying automated forecasting techniques. It demonstrates the ability to forecast future data trends, such as app downloads, by analyzing patterns and applying automated forecasting techniques.", "Introduction to important functions in Excel's formula language for advanced data analysis, enhancing the understanding and utilization of Excel's capabilities. It introduces the importance of understanding and utilizing Excel's formula language for advanced data analysis, enhancing data analysis capabilities."]}], 'duration': 671.087, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xGqH__hLVcU/pics/xGqH__hLVcU440135.jpg', 'highlights': ["Excel can analyze and interact with data, providing the total sales in December 2022 (3,070,000), specific product sales for 'After Nines' in December 2022, and distinct count of products in a specific date period (21 products sold in the last week of December 2022).", 'Excel can recommend chart options and pivot table formats based on available data, making it easier for beginners to generate and study pivot tables and charts for data representation and analysis.', 'Automatic formulas in Excel Online on OneDrive can be used to convert data into tabular format for analysis and presentation, which is beneficial for beginners and will eventually be available on desktop and business accounts.', "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "The 'forecast sheet' feature in Excel enables automated forecasting based on data patterns, providing graphical representations and forecasting formulas for future data analysis.", 'It allows for automated forecasting based on data patterns, provides graphical representations, and forecasting formulas for future data analysis.', "Using Excel's AI features, it is possible to forecast future data trends, such as app downloads, by analyzing patterns and applying automated forecasting techniques.", 'It demonstrates the ability to forecast future data trends, such as app downloads, by analyzing patterns and applying automated forecasting techniques.', "Introduction to important functions in Excel's formula language for advanced data analysis, enhancing the understanding and utilization of Excel's capabilities."]}], 'highlights': ["Excel's flash fill feature automatically extracts domain names and amounts from text data, significantly streamlining data processing and analysis.", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel's flash fill feature enables the automatic extraction of domain names and amounts from text data, reducing manual effort and enhancing data processing efficiency.", "Excel's flash fill feature streamlines data processing by automatically extracting domain names and amounts from text data, reducing manual effort and improving efficiency.", 'Pattern recognition in Excel allows for the automatic extraction of domain names from email addresses, enhancing efficiency in data manipulation and analysis.', "Excel's flash fill feature, accessed with control E or through the data ribbon, automatically extracts data without revealing the underlying formula logic", 'AI analysis feature in Excel, automatic analysis and visualization of sales data, producing graphs and identifying outliers', "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel can analyze and interact with data, providing the total sales in December 2022 (3,070,000), specific product sales for 'After Nines' in December 2022, and distinct count of products in a specific date period (21 products sold in the last week of December 2022).", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work.", "Excel's AI feature 'formula by example' automates data processing by recommending formulas based on input patterns, such as generating names and IDs, simplifying tasks and reducing manual work."]}