AI @ WORK
Learn how to use AI in Microsoft applications, code in Visual Basic,
and make the most of AI tools for creative image generation.
All examples are based on using OpenAI's ChatGPT.
Since most popular AI language models are quite similar in terms of chatbot interface design and basic functionality, the methods explained below can easily be applied to other AI language models as well.
1. AI @ Data Analysis
ChatGPT can make working with data and Microsoft Excel much easier and more efficient.
The tool helps create complex formulas, explains their logic, supports debugging, and simplifies the use of handy keyboard shortcuts.
Additionally, GPT-3.5 provides valuable assistance with data analysis—from statistical calculations and forecasts to converting text into structured tables. With the premium version, GPT-4, you can create interactive tables and charts and present results in a visually appealing way.
ChatGPT automatically suggests suitable chart types or allows for customized visualizations.
Formulas &
Debugging
This section shows how to create complex Excel formulas, follow their logic step-by-step, troubleshoot errors, and use practical keyboard shortcuts to work more efficiently.
Data Analysis
with ChatGPT
Discover how ChatGPT can assist
with data analysis, data cleaning, forecasting, and transforming text into structured table formats.
Chat GPT @ Excel
"How-To-Guide"
We demonstrate how to efficiently optimize work in Microsoft Excel with ChatGPT, craft precise instructions, and leverage both the strengths and limitations of using this tool effectively.
Data Analysis
with ChatGPT Plus
Learn how to use the paid version of ChatGPT to analyze data, create interactive tables and charts, and summarize results in a clear and understandable way.
2. AI @ Text & Content Creation
With AI systems, creating and editing text becomes simpler, more efficient, and more focused.
From content strategy and ideation to structuring and SEO optimization, AI tools can now support the entire creative process.
We’ll show you how to use AI to generate text, design video scripts, personalize social media posts, and craft targeted emails. Plus, we’ll explain how AI enhances content through precise text editing and reliable translations.
Use Cases, Tips & Limitations
How can AI be used efficiently for content creation?
We explore the advantages and disadvantages and offer interesting and practical tips for application.
Summarization & Translation
We demonstrate how AI simplifies
text editing, grammar checks,
stylistic and formal revisions, plagiarism detection,
and text translation.
Content Creation &
Optimization
Learn how AI can efficiently create content, summarize information, conduct research, optimize for SEO, design video scripts, and generate personalized emails and
social media posts.
Ideation &
Structuring
We demonstrate how AI
supports idea generation,
structuring, SEO optimization,
and the development of
content strategies.
3. AI @ Image Generation
This section provides a comprehensive overview of effective prompting for AI image generation, emphasizing precision and creativity.
From basic tips on material selection and lighting to specialized “vibe prompts” for atmospheric images, it offers helpful guidance and examples.
Additionally, techniques for illustrations and art-historical styles are introduced, elevating image creation to new levels. Useful links to AI tools and resources complete the introduction, helping you maximize the potential of AI-based image design.
Introduction to
Image Prompting
Effective prompts in AI image generation enhance precision and creativity by focusing on intentional language choices, clear structure, and the use of English terms and styles.
11 Tips for Effektive Image Prompting
Our 11 tips for AI-assisted
image generation include detailed guidance on materials and lighting, weighted prompts, creative adjustments of existing images,
and much more.
"Vibe prompts" convey
emotions, setting, and style
to create atmospheric
AI-generated images with a
deep emotional impact.
Prompting für
General Vibes
Prompting für Illustrationen
Creative prompting with AI enables the creation of versatile illustrations, ranging from 3D textures to educational materials and cartoon styles, all crafted with precision
and mood.
Prompting for
Art Historical Styles
Precise prompting enables the generation of images in the style of past eras by carefully describing the style, atmosphere, and details of the desired image.
Useful Links to
Tools and Ressources
Here you’ll find a selection
of links to helpful AI tools for
image generation, image
editing apps, image databases,
and prompt inspiration.
Image Editing
with DALL-E
Learn how to create your own
images based on templates,
combine different elements, mark
and modify image details, and adjust backgrounds to suit your vision.
Image Generation
with Midjourney
Midjourney is perhaps the most popular AI tool for image generation. We provide a detailed introduction to working with Midjourney, exploring its features and capabilities.
4. AI @ VBA & Automation
Visual Basic for Applications (VBA) and Artificial Intelligence (AI) provide managers with powerful tools for automating tasks in Office applications.
VBA allows for the creation of macros to handle routine tasks in applications like Excel and PowerPoint, making manual work more efficient.
AI further assists by helping write and optimize VBA code, which is particularly useful for users without programming experience. This introduction explains how AI and VBA together can simplify processes and boost productivity in the office.
Introduction to
VBA & Automation
VBA enables quick automation of tasks in MS Office. This introduction explains when automation is beneficial and how AI can provide support in the process.
Prompting for VBA Code & App Integration
Here, we provide a detailed
guide on crafting effective
prompts for VBA code and
integrating VBA code into
MS Office applications.
©Urheberrecht. Alle Rechte vorbehalten.
Wir benötigen Ihre Zustimmung zum Laden der Übersetzungen
Wir nutzen einen Drittanbieter-Service, um den Inhalt der Website zu übersetzen, der möglicherweise Daten über Ihre Aktivitäten sammelt. Bitte überprüfen Sie die Details in der Datenschutzerklärung und akzeptieren Sie den Dienst, um die Übersetzungen zu sehen.