Seminarkatalog

Microsoft Excel Level 3 is tailored for users who have mastered the basics and intermediate features of Excel and are ready to tackle more complex data analysis and management tasks. This advanced course is ideal for professionals seeking to leverage Excel for sophisticated financial management, data visualization, and comprehensive data analysis. Participants will gain skills in creating and managing intricate financial templates such as invoices and expense sheets, displaying data effectively on charts, summarizing large datasets using pivot tables, and crafting advanced formulas for detailed calculations.

Training Course Outline

The course covers a wide range of advanced Excel functionalities, starting with linking worksheets and workbooks to facilitate seamless data integration. Participants will explore various functions, including XLOOKUP, VSTACK, and other database functions, as well as Excel's new dynamic array functions. The curriculum includes naming cells or ranges, creating and managing pivot tables, and applying conditional formatting to enhance data visualization. Attendees will learn to record macros for automating repetitive tasks, customize toolbars and menus, and use advanced tools like Goal Seek and Paste Special. Additional topics include auditing, data validation, and securing workbooks with passwords.

After the Course

Upon completion of the course, participants will be equipped to create complex formulas for modeling financial data, automate tasks by recording macros, and efficiently enter large volumes of data. They will also learn to format their work professionally, create reusable templates, summarize information with pivot tables, and protect their work with passwords. This advanced training empowers users to perform in-depth data analysis and enhance their overall productivity.

• Link Worksheets and Workbooks
• Functions
• XLOOKUP, VSTACK and other Database Functions
• Excel’s new Dynamic Array Functions
• Name a Cell or Range
• Pivot Tables
• Conditional Formatting
• Record Macros
• Customise Toolbars and Menus
• Goal Seek
• Paste Special
• Auditing
• Validation

• Link Worksheets and Workbooks
• Functions
• XLOOKUP, VSTACK and other Database Functions
• Excel's new Dynamic Array Functions
• Name a Cell or Range
• Pivot Tables
• Conditional Formatting
• Record Macros
• Customise Toolbars and Menus
• Goal Seek
• Paste Special
• Auditing
• Validation

Lernformate

Unsere Seminare bieten dir maximale Flexibilität: Du kannst zwischen Live-Online und Vor Ort in unseren modernen Schulungszentren im D-A-CH Raum wählen. Beide Formate garantieren dir die gleiche hohe Qualität und interaktive Lernerfahrung.

Schulungsarten

Wir bieten dir verschiedene Schulungsarten: Offene Seminare, Firmenseminare für Teams und Inhouse-Schulungen direkt bei dir vor Ort. So findest du genau das Format, das zu deinen Bedürfnissen passt.

Uhrzeiten

09:00-16:00 Uhr

Aktuelle Software

In unseren offenen Kursen arbeiten wir mit der aktuellsten Software-Version. So lernst du direkt mit den Tools und Features, die du auch in deinem Arbeitsalltag verwendest - praxisnah und zukunftsorientiert. Bei Inhouse- und Firmenschulungen bestimmt ihr die Version.

D