
This eBook contains all the ChatGPT prompts and responses from the course.
Download the practise files to follow along with the lectures and explore.
Introduction to the built-in-AI tools of Microsoft Excel.
Learn how to turbocharge your data manipulation tasks with Flash Fill. Harness the power of AI with Flash Fill in your spreadsheets for lightning-fast data transformations.
Using 'From Picture' in Excel, you can extract data from photos and screenshots directly into Excel. It even includes a Review tool to check the results before importing.
Use Column from Examples in Power Query to perform data transformations and write custom M formulas for you from your examples.
Generate insights and create dynamic reports quickly using Analyze Data, the built-in AI of analysis tool in Excel. Use natural language to ask Excel for specific insights from your data.
In this lesson, you will learn how to get access to ChatGPT, adjust some key settings, and install the ChatGPT add-in ready for the course.
Learn the differences between completing Excel tasks using ChatGPT in the browser and using the official ChatGPT for Excel add-in.
Get started with ChatGPT and use it to complete everyday Excel tasks such as formulas and setting up Conditional Formatting rules.
ChatGPT is your Excel buddy and assistant. It will help you to write formulas, explain how they work and fix them when they go wrong. Let's see how to use ChatGPT with Excel formulas.
Use the ChatGPT add-in to write simple Excel formulas to extract text from a cell and perform date calculations to help track important dates.
In this lesson, we get ChatGPT writing Excel formulas that use Tables. We have it creating report sheets, removing duplicates and writing SUMIFS formulas.
In this lesson, we give ChatGPT a real challenge. We have a complicated formula to achieve and we've created a problem in our dataset. Can ChatGPT figure this out and write the advanced formula we require?
Lookup formulas in Excel are very commonly used. In this lesson, we see ChatGPT write lookup formulas to retrieve data from other sheets. The lesson shows two examples, including a two-way lookup.
In this lesson, we use ChatGPT in the browser to write a single formula report from data in an image. We also see how ChatGPT responses are very dependent on the information we share.
In this lesson, we work with ChatGPT to write an advanced Excel formula. This is a big ask for ChatGPT and it's done with a single prompt. We get a report sheet built with a single dynamic report that does various calculations and formatting.
ChatGPT is fantastic at explaining complex formulas. In this video, it easily explains a high-level formula.
When working with complex Excel workbooks, documentation is key. Especially when sharing the workbook with other members of your team. In this lesson, ChatGPT creates a sheet that documents all the workbook formulas.
In this lesson, we fix an XLOOKUP formula problem using ChatGPT.
ChatGPT can be used to improve formulas that may not be the cleanest and best way of doing things. In this lesson, ChatGPT offers a more concise alternative to a formula that it wrote itself, earlier in the course.
In this section, we use ChatGPT to identify possible issues in our Excel data and correct them. It also covers extracting data from PDF and other Excel files, and building a refreshable Power Query process with ChatGPT.
You cannot fix an issue with your data, if you do not know it exists, regardless of your Excel prowess. In this video, we use ChatGPT in Excel to identify inconsistencies in our data and other possible problems.
In this video, we make the required corrections to the problems identified in the previous lesson. We use ChatGPT to make all the corrections itself, including removing duplicate rows, standardising text, and deleting excess spaces.
Our data regularly begins its life outside of Excel. In this video, we extract data from a PDF file into Excel. During the extraction, ChatGPT will need to infer some information, propagate data down rows and perform a simple calculation.
In this complex Excel transformation, we use ChatGPT to transform tricky, multi-row headers and uneven attendee lists into a perfectly structured, clean tabular format. All from a different Excel workbook.
It is time to clean and transform our data with a Power Query solution.
In this lesson, we generate a Power Query formula (M code) that combines all tables from the current workbook to a single table. we also clean the data including splitting a column, naming columns, and replacing unrequired characters in a column.
There is a problem in our Power Query solution. We know what's happening but not how to fix it. ChatGPT provides a fix with a code solution and also provides steps that we can follow in the UI to get our query working 100%.
This is a practise exercise for the data cleaning and transformation section of the course.
Introduction to what to expect from this section of the course, where we cover getting data insights, producing charts, building PivotTables and performing sentiment analysis with ChatGPT in Excel.
In this lesson, we ask ChatGPT for definitive results from an uploaded dataset (a CSV file) and also for summary text and explanations to explain the results returned.
ChatGPT is very capable of generating visuals from your standard columns charts, to geographic maps, and Sankey diagrams. In this lesson, we visualise the student learning data using a violin chart and a scatter plot to understand relationships between learning methods and hours studied and exam scores.
It’s great that ChatGPT can produce any chart, but when creating regular reports, we really want these charts built in Excel and linked to our data. In this lesson, you will learn how to create Excel charts using ChatGPT and make further refinements to make them more effective.
In this lesson, we perform sentiment analysis on a list of social media posts. We categorise the comments into positive, negative, or neutral using the ChatGPT for Excel add-in.
In this lesson, we build a PivotTable from a simple prompt to ChatGPT. The PivotTable analyses the sentiment analysis data from the previous lesson.
Introduction to how ChatGPT can help you write, debug, explain and comment your Excel VBA code.
See how ChatGPT can be used to write your Excel macros for you. In this lesson we create a simple macro using ChatGPT. We then ask ChatGPT to adapt the code and how we can create a button to trigger the macro.
Taking things a little further in this lesson, we use ChatGPT to write macro code to update all power queries of a workbook from the worksheet change event.
In this lesson, we use ChatGPT to write Excel VBA that exports all worksheets to PDF files.
Understand Excel VBA code through ChatGPT's Generative AI insights. Provide the code and ChatGPT will explain it in awesome detail.
Let ChatGPT add comments to your VBA code for you. Save time on this very important but time consuming task. Did you forget? Just ask ChatGPT.
Use ChatGPT and the power of generative AI to improve upon existing Excel VBA code. In this example, we expand upon a recommendation that ChatGPT made in a prvious lesson to improve the macro code.
In this lesson, we see ChatGPT assist in debugging two Excel macros. One with a runtime error returned and another that does not return an error, but fails to execute correctly.
Work Smartly with AI – Leverage AI for Unmatched Efficiency and Accuracy with ChatGPT for Excel!
Proficiency in Excel is not just an asset but a necessity, with almost 60% of businesses relying on it for various business tasks.
Advanced Excel skills, including data analysis and formula creation, are among the top requisites in job listings across multiple industries.
The integration of AI in Excel, a relatively new and evolving field, is rapidly becoming a game-changer, making it essential for professionals to stay ahead of the curve.
However, mastering Excel's complex features like pivot tables, advanced formulas, and data analysis can be daunting and overwhelming.
This complexity often leads to underutilization of Excel's full potential.
The repetitive nature of data cleaning and formula writing in Excel can be not only time-consuming but also prone to errors, leading to frustration and decreased productivity.
But lucky for you, it’s the era of Artificial Intelligence!
And with the right knowledge and skills, you can have AI do all the hard-work for you…
With this knowledge, you won’t need to memorize formulas, watch tons of tutorials or spend a fortune on Excel gurus!
You can use AI and Excel to do all the work for you, without lifting a finger!
With this game-changing solution, It's not about spending countless hours trying to memorize formulas or manually sifting through data.
It’s about understanding how to smartly integrate AI, like ChatGPT, to automate and simplify these processes.
With the right guidance and tools, you can transform MS Excel from a mere spreadsheet tool into a powerful ally for data analysis, making your work not only more efficient and smooth, but also more impactful.
This course is designed to bridge that gap, turning complexity into simplicity and transforming your Excel experience.
Introducing a Comprehensive Course on Mastering Excel with ChatGPT
Dive into a comprehensive course designed to unlock the full potential of Microsoft Excel using the power of ChatGPT.
Experience not just a significant boost in productivity but also the assurance of precision and accuracy in your data analysis and spreadsheet management.
With our expert guidance, you'll:
Transform the way you handle data in Excel, making complex tasks simple and efficient.
Elevate your data analysis skills, leveraging AI to gain deeper insights and make informed decisions.
Witness a noticeable increase in efficiency and accuracy in your work, leading to better outcomes and recognition in your professional life.
This course equips you for:
AI-Enhanced Excel Proficiency: Whether it's creating intricate formulas, managing large datasets, or automating repetitive tasks, learn how to infuse AI and generative AI capabilities into your Excel skills for superior results.
Task-Specific Excel Strategies: From data cleaning with Flash Fill to generating insights with pivot tables, tailor your AI-enhanced Excel strategies to handle a variety of tasks effortlessly.
Simplified Technical Understanding: Not an Excel expert? No problem. We guide you through the fundamentals and advanced aspects of Excel and ChatGPT, ensuring you can leverage these tools effectively, regardless of your prior experience.
Informed Data-Driven Decisions: Move beyond guesswork in data analysis. Gain clarity and precision in your work, ensuring every decision is backed by robust data and AI insights.
Ready-to-Use Excel Solutions: Save time with our pre-designed Excel templates and ChatGPT prompts, tailored for various data tasks. Jumpstart your data processing without spending hours on setup.
Practical Application and Real-World Scenarios: Engage in hands-on exercises and real-world case studies that build not just knowledge but also confidence in applying AI-driven Excel strategies in your daily tasks.
This ChatGPT for Microsoft Excel course is your pathway to:
Confident Data Handling: With in-depth knowledge at your fingertips, manage and analyze data in Excel with confidence and precision.
Eliminate Guesswork in Data Analysis: Say goodbye to uncertainty. Consistently deliver accurate and insightful data analysis without the stress and strain.
Enhanced Professional Value: Transform your Excel skills into a powerful asset. Better data handling means better career opportunities – it's that simple.
Streamlined Excel Processes: Leave behind the frustration of complex data tasks. We provide the roadmap to make Excel usage efficient and effective, with ready-to-use templates and proven methods.
Why Our Advanced Excel and ChatGPT Course Stands Out From the Crowd
Beyond Basic Content: While some courses might not go beyond the fundamentals, our course is designed to challenge and expand your knowledge. We cover not just the 'how' but also the 'why', providing deeper understanding and more comprehensive learning.
Comprehensive ChatGPT Coverage: We've heard that some courses skim over the capabilities of ChatGPT. In contrast, our course thoroughly explores the power of ChatGPT in Excel, from writing complex formulas to automating data analysis tasks, ensuring you fully understand and can leverage this technology.
Clear, Practical Demonstrations: Most of the courses lack clarity in demonstrations, especially in using ChatGPT with MS Excel. We've addressed this by providing step-by-step, clear instructions and practical examples that show exactly how to integrate ChatGPT into your Excel workflow.
About the Instructor
Alan Murray, a Microsoft MVP with over two decades of experience, is a renowned Excel & Power BI trainer. He's the brain behind the successful Computergaga blog and YouTube channel, which has amassed over 40 million views across 650+ videos. As the author of "Advanced Excel Formulas" and "Advanced Excel Success," Alan brings a wealth of practical knowledge to his courses. Known for his engaging and efficient teaching style, he focuses on real-world applications, ensuring learners not only understand Excel's complexities but can apply them effectively. With Alan, you're not just learning; you're being mentored by a seasoned expert dedicated to your success.
Instead of learning through costly and time-consuming mistakes, benefit from the guidance of an experienced expert and accelerate your Excel mastery.
Requirements:
Basic Understanding of Excel: Familiarity with basic Excel functions and the interface will help you grasp the more complex concepts more effectively.
Access to Microsoft Excel: To fully benefit from the practical exercises and follow along with the tutorials, you should have access to Microsoft Excel.
Willingness to Learn and Experiment: The course involves exploring new ways of using Excel with ChatGPT, which requires a willingness to experiment and apply the concepts in various scenarios.
Who Can Benefit From This Course:
Excel Beginners Eager to Advance: If you're familiar with the basics of Excel and ready to elevate your skills, this course will introduce you to advanced functionalities and AI integration, setting you apart in any data-driven role.
Data Analysts and Professionals: For those already working with data, learning how to synergize Excel with ChatGPT opens new avenues for efficient data processing, complex analysis, and insightful reporting, enhancing your professional capabilities.
Business Managers and Entrepreneurs: If you're managing business operations or running your own venture, this course will equip you with the skills to analyze data more effectively, make informed decisions, and automate repetitive Excel tasks, saving valuable time.
Students in Business and Finance Fields: As a student preparing for a career in business, finance, or any field involving data, gaining advanced Excel skills combined with AI knowledge will give you a competitive edge in your studies and future career.
IT and Software Professionals: For those in IT and software development, understanding how to integrate and utilize AI in Excel can enhance your ability to create sophisticated data solutions and automate various aspects of data management and analysis.
Freelancers and Consultants: Stand out in the freelance market by offering advanced Excel and AI-driven data analysis services. This course will provide you with the skills to offer more value to your clients and expand your service offerings.
Streamline and Automate your Excel Tasks while Increasing Accuracy!
If this course doesn't align with your goals or meet your expectations, rest assured, we've got your back.
We are confident in the transformative power of our training and offer a straightforward, full refund policy – no questions asked.
Avail this opportunity to revolutionize your data analysis, streamline your Excel tasks, and hit new levels of efficiencies in your professional life!
Excited to be your guide on this journey
– Alan Murray & Phil Ebiner