Microsoft Excel Advanced - english - MEA-E

Beschreibung

ILT-Instructor Led TrainingAfter the course, you will be able to: Use Lookup & Informational Functions Create Pivot Tables Use What-If Tools Sharing and Tracking Workbooks Record Basic Macros

error_outline Wichtige Information

We train the latest version of the program and show the differences in the functionality of older versions during the seminar.
If you have an older version, please let us know when registering - you will then receive the appropriate documentation and exercise PC for your seminar!

expand_more chevron_right Zielgruppe

This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros
  • Information Worker

expand_more chevron_right Vorkenntnisse

You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.

expand_more chevron_right Detail-Inhalte

  1. Further Formulas and Functions
    1. Nested functions
    2. Working with a lookup function
    3. Protecting cells
    4. Unprotecting documents
    5. Custom number formats
    6. Conditional formatting
  2. Working with Data Lists
    1. General information for creating a list
    2. Complex sorting using a dialog box
  3. Working with Data Validation
    1. Setting data validation criteria
    2. Checking data validation
    3. Applying data validation to other cells
  4. Goal Seek
  5. Consolidate
  6. Scenario Manager
    1. Working with estimates
    2. Opening the Scenario Manager
    3. Creating a scenario report
    4. Deleting a scenario
  7. Solver
  8. PivotTable
    1. What is a PivotTable?
    2. Creating a data list
    3. PivotTable Tools
    4. Creating the PivotTable report
    5. Advanced PivotTable features
    6. Changing the PivotTable
    7. Rearranging rows and columns
    8. Hiding contents
    9. Displaying extreme values
  9. Outlining Excel Data
    1. Sample spreadsheet
    2. Showing and hiding cell ranges
    3. Removing the outline
    4. Customizing levels and ranges
  10. Subtotals
  11. Charts
    1. Break­even analysis
    2. Sparklines
  12. Macros ­ Task Automation
    1. Recording a macro
    2. Running a macro
    3. Opening a workbook with macros
  13. Creating a Custom Function
    1. Procedures
    2. Custom function features
    3. Using the custom function
  14. Data Import and Export
    1. Using the clipboard to exchange data
    2. OLE and DDE
    3. Object Linking and Embedding ­ OLE
    4. Dynamic Data Exchange ­ DDE
    5. Importing graphics
    6. Editing imported graphics
    7. Picture Tools
    8. Preparing a document for sharing
  15. Templates
    1. The benefits of a template
    2. Creating a template
    3. Saving the template
    4. Using the template for a new workbook
  16. Forms
    1. Validation and cell protection
    2. Controls
    3. Other controls (calendar)
    4. Format
    5. Print
  17. Performing Settings in Excel
    1. Options
    2. Customizing the Quick Access Toolbar
  • expand_more chevron_right event_available 12.09.-13.09.2022 12.09.2022 Seminarzeitentimer2 Tage roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Classroom - im Seminarzentrum 640,00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort
      • Seminar-Services
    • expand_more chevron_right ETC>Live - Virtual Classroom 640,00
      • Online Training – aber live beim Seminar dabei
      • Keine Anfahrt ins Seminarzentrum notwendig
      • ETC>Live  Support und Hotline
      • ETC-Services

       

  • expand_more chevron_right event_available 19.12.-20.12.2022 19.12.2022 Seminarzeitentimer2 Tage roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Classroom - im Seminarzentrum 640,00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort
      • Seminar-Services
    • expand_more chevron_right ETC>Live - Virtual Classroom 640,00
      • Online Training – aber live beim Seminar dabei
      • Keine Anfahrt ins Seminarzentrum notwendig
      • ETC>Live  Support und Hotline
      • ETC-Services

       

  • expand_more chevron_right event_available 06.03.-07.03.2023 06.03.2023 Seminarzeitentimer2 Tage roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Classroom - im Seminarzentrum 640,00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort
      • Seminar-Services
    • expand_more chevron_right ETC>Live - Virtual Classroom 640,00
      • Online Training – aber live beim Seminar dabei
      • Keine Anfahrt ins Seminarzentrum notwendig
      • ETC>Live  Support und Hotline
      • ETC-Services

       

  • expand_more chevron_right event_available 05.06.-06.06.2023 05.06.2023 Seminarzeitentimer2 Tage roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Classroom - im Seminarzentrum 640,00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort
      • Seminar-Services
    • expand_more chevron_right ETC>Live - Virtual Classroom 640,00
      • Online Training – aber live beim Seminar dabei
      • Keine Anfahrt ins Seminarzentrum notwendig
      • ETC>Live  Support und Hotline
      • ETC-Services

       

  • expand_more chevron_right event_available 07.09.-08.09.2023 07.09.2023 Seminarzeitentimer2 Tage roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Classroom - im Seminarzentrum 640,00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort
      • Seminar-Services
    • expand_more chevron_right ETC>Live - Virtual Classroom 640,00
      • Online Training – aber live beim Seminar dabei
      • Keine Anfahrt ins Seminarzentrum notwendig
      • ETC>Live  Support und Hotline
      • ETC-Services

       

  • expand_more chevron_right event_available 06.12.-07.12.2023 06.12.2023 Seminarzeitentimer2 Tage roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Classroom - im Seminarzentrum 640,00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort
      • Seminar-Services
    • expand_more chevron_right ETC>Live - Virtual Classroom 640,00
      • Online Training – aber live beim Seminar dabei
      • Keine Anfahrt ins Seminarzentrum notwendig
      • ETC>Live  Support und Hotline
      • ETC-Services