Ghost Writer is an office add-in that allows you to use charge GPT in Excel. It is an AI-powered writing assistant designed to help users get the most out of Excel quickly. The add-in uses advanced natural language processing and machine learning technology, allowing you to create and build Excel sheets and formulas faster.
To install Ghost Writer in Excel desktop, open the desktop version of Microsoft Excel, click on ‘Blank Workbook’ to open a new workbook, click on ‘Insert’ and then click on ‘Get Add-ins’. In the search box, enter ‘Ghost Writer’ and click on the search icon. In the search results, click on the ‘Add’ button beside ‘Ghost Writer’. In the pop-up, click on ‘Continue’. Ghost Writer is installed and the icon will appear in the ribbon.
The add-in offers a free trial. Ghost Writer will open in a panel on the right side. Click on ‘Purchase’ to buy a product key and unlock the add-in to use it with the OpenAI GPT models. Purchase the Excel Edition, a shared OpenAI API key is included in the purchase. If you already purchased the product, enter the product email and product key, and click on ‘Validate’.
You can now use Ghost Writer within Microsoft Excel to create formulas, forms, and more. For example, to get the sales for a region in February, you can ask Ghost Writer to generate a formula using VLOOKUP. Enter the prompt in the ‘Write About’ text box and click on ‘Send Request to the AI’. The formula will be returned in the response box. Select the cell where you want to enter the formula and click on ‘Place in Active Cell’.
Ghost Writer also allows you to create VBA code. For example, you can enter the prompt ‘Loop through range of cells’ and click on ‘Excel Action’, then select ‘Create VBA for me’ and click on ‘Send Request’. Ghost Writer will respond with an example VBA code. You can also use Ghost Writer to create macros. Enter the prompt ‘Macro to sort data in ascending order’, click on ‘Excel Action’, select ‘How can I create’, and click on ‘Send Request’. Ghost Writer will respond with an example macro and steps to use it.
You can install Ghost Writer in Excel online by going to Microsoft Office online apps, signing in to your Microsoft account, and opening a new workbook. Click on the ‘Add-ins’ icon on the top right and select ‘More Add-ins’. In the store tab, search for ‘Ghost Writer’ and click on ‘Add’ to install the app to your account. This will integrate Ghost Writer into Excel.
Once installed, Ghost Writer will appear in the ribbon. To use all the features of this extension, you will have to purchase a license. If you like this article, please subscribe to our channel.
