Language
Type
Level
Release
Showing 1 to 24 of 71 results
.jpg)
Release: Nov 19, 2025
Excel für SAP-Spezialisten
ArtReich GmbH Christian Sterlepper Weijuan Dong Claudia Jost Florian Sandmann-Reetz Thomas Wicke Martin Munzel
Release: Mar 27, 2025
Tipps und Tricks in Microsoft OneNote
Florian Sandmann-Reetz
Release: Mar 27, 2025
Tipps und Tricks in Microsoft Outlook
Florian Sandmann-Reetz
Release: Mar 20, 2025
Tipps und Tricks in Windows und Office 365
Florian Sandmann-Reetz
Release: Mar 20, 2025
Tipps und Tricks in Microsoft Teams
Florian Sandmann-Reetz
Release: Mar 20, 2025
Tipps und Tricks in Microsoft PowerPoint
Florian Sandmann-Reetz
Release: Mar 20, 2025
Tipps und Tricks in Microsoft Excel
Florian Sandmann-Reetz
Release: Mar 20, 2025
Tipps und Tricks in Microsoft Word
Florian Sandmann-Reetz
.jpg)
Release: Jan 14, 2025
Embedded Analytics and Planning mit SAP Analysis for MS Excel in SAP S/4HANA
Karlheinz Weber
Release: Jan 2, 2025
Introduction to PivotTables and PivotCharts in Excel
Simon Sez IT
- Create PivotTables from scratch for data organization.
- Apply subtotals and grand totals for data summarization.
- Format PivotTable data with number formatting techniques.
- Generate PivotCharts to visualize data effectively.
Release: Jan 2, 2025
Transform Data with Data Models, PivotTables, and Power Query in Excel
Simon Sez IT
- Create and analyze PivotTables to summarize large data sets efficiently.
- Organize relationships from multiple data sources into data models.
- Use Power Query to clean,shape, and transform data for analysis.
Release: Jan 2, 2025
Using the Data Model with Pivot Tables in Excel (to Maximize Your Efficiency and Impact)
Simon Sez IT
- Create data models for efficient data analysis using Excel tables.
- Build interactive pivot tables to summarize complex datasets.
- Utilize Power Query for data cleaning and transformation.
- Establish relationships between multiple data sources in the Data Model.
Release: Jan 2, 2025
Mastering Excel Lookup Functions (to Maximize Your Efficiency and Impact)
Simon Sez IT
- Employ VLOOKUP functions to extract specific information from complex spreadsheets.
- Utilize INDEX and MATCH functions to perform versatile and bidirectional datasearches.
- Streamline data analysis tasks using XLOOKUP to simplify and enhance lookupprocesses.
- Apply two-way lookup functions to cross-reference information.
Release: Jan 2, 2025
15 Essential Advanced Excel Formulas (to Maximize Your Efficiency and Impact)
Simon Sez IT
- Analyze data efficiently using advanced Excel functions like VLOOKUP, INDEX, andMATCH.
- Employ wildcards and text manipulation techniques for data cleansing and organization.
- Utilize the FILTER function to sort and filter data dynamically.
- Create custom functions with LAMBDA for tailored data processing and analysis.
Release: Jan 2, 2025
Using LAMBDA to Create Your Own Excel Functions
Simon Sez IT
- Develop an understanding of LAMBDA function syntax and structure.
- Master the creation of custom Excel functions for tailored solutions.
- Create custom Excel functions using LAMBDA to automate tasks and streamline Excel workflows.
Release: Jan 2, 2025
Dynamic Array Functions in Excel to Maximize Your Efficiency and Impact
Simon Sez IT
- Utilize dynamic array functions to extract distinct values.
- Combine different dynamic array functions for active data organization.
- Perform data manipulation using dynamic array functions for comprehensive analysisand insights.
- Master text manipulation using new dynamic array functions for cleaner data extraction.
Release: Jan 2, 2025
New Dynamic Array Functions in Excel
Simon Sez IT
- Combine, organize, and manipulate data vertically and horizontally in Excel.
- Stack data for practical analysis and utilizing tables for dynamic updates.
- Select and extract precise data ranges confidently.
- Manage text extraction and data manipulation efficiently.
Release: Jan 2, 2025
Excel Custom Formatting to Control Your Data
Simon Sez IT
- Apply custom formatting to numbers for improved data visualization in Excel.
- Distinguish betweenhashand zero for precise data alignment.
- Integrate text seamlessly into cells while maintaining calculation capabilities.
- Combine logical conditions and symbols dynamically based on customized criteria.
Release: Jan 2, 2025
Excel Chart Formatting to Maximize Your Efficiency and Impact
Simon Sez IT
- Apply tools and advanced formatting techniques to customize Excel charts effectively.
- Create interactive visualizations using slicers andPivotChartsto enhance the impact ofdata presentations.
- Utilize conditional formatting andPivotTables for dynamic data visualizations.
- Demonstrate proficiency in creating compelling map charts for geographical datarepresentation.
Release: Jan 2, 2025
Cleaning Data in Excel to Maximize Your Efficiency and Impact
Simon Sez IT
- Adapt shortcuts and use quick formatting techniques in data cleaning for accurate analysis.
- Apply text functions to format and enhance data quality.
- Construct insightful pivot tables and charts for data analysis.
- Utilize Power Query to automate data processing by combining and cleaning data from multiple files.
Release: Jan 2, 2025
Microsoft Teams (2023 Update)
Simon Sez IT
- All about posting and receiving public and private messages
- All about using apps, bots, and connectors
- Integrating Teams with Outlook
- Teams Meetings update
Release: Jan 2, 2025
Introduction to Power Automate
Simon Sez IT
- What is a flow, and what are the types of flow?
- How to create an automated flow
- Sharing flows with other users
- Running, editing, and tracking a flow
Release: Jan 2, 2025
Visio 2019
Simon Sez IT
- How to use the Visio Workspace
- All about building Organization Charts in Visio
- About Themes, Styles, and Colors in Visio
- About Groups, Containers, Lists, and Cross-Functional Flowcharts
Showing 1 to 24 of 71 results