cropped-PrivataktionaerLogoRund-1.png

Excel 365 Advanced

Seminar Excel 365 Excel for Advanced Users

The spreadsheet Excel offers enough functionality even for sophisticated business calculations. Use names and conditional formatting, work with database functions and the special filter, perform complex evaluations by using pivot tables and matrices, etc.
Urs Scheufele: Seminar leader and lecturer for Excel 365 Advanced

Request appointment
In selected seminar exercises, seminar participants learn how to analyze their data quickly and professionally and present it in a graphically visualized way. In the seminar, I explain the required advanced Excel techniques in an easy-to-understand manner, using concrete practical examples with many visualizations. The training content and focus can be determined in the seminar and, if necessary, directly applied to concrete examples in professional practice.
Urs Scheufele: Seminar leader and lecturer for Excel 365 advanced users.

Miscellaneous

  • Insert names
  • Structure tables
  • Use individual conditional formatting
  • Trend analyses, data tables, target value search, solver,
  • Structure tables
  • Link formatting to conditions
  • Monitor formulas and cell contents automatically
  • Special filter
  • Create Excel databases
  • Combine and consolidate data
  • Create pivot tables and adjust pivot tables
  • Take advantage of the time advantage by using ShortCuts;
  • Helpful functions in the Excell everyday life:IF, OR, AND, REFERENCE, INDEX... Text operation, Boolean functions;
  • Cell protection, workbook protection or file protection; AutoFilter, SpecialFilter; 
  • Useful functions for; list management/analysis; images and
  • Expert diagrams, sparklines;
  • Conditional formatting in detail; links between; tables, to Word and to PowerPoint;
  • Macro processing; the group mode; partial result calculation
  • Trend analyses, data tables, target value search
  • Solver in Excel
  • Scenarios
  • Matrices
  • Use and format different chart types
  • Working professionally with diagrams
  • Design tables with illustrations
  • Working in a team

Data manipulation & evaluation

  • Scenario manager and matrices) Visualise data professionally with diagrams and illustrations
  • Import data (e.g. with Power Query) or export data
  • Combine and consolidate data
  • Create and customise complex pivot tables
  • Analyse data (e.g. with special filter,
  • Import or export data
  • Create queries with Power Query
  •  

At least 2 days

Recommended 3 - 4 days

Business people, technicians, professionals and private individuals who want to start using Excel professionally. All those who already have experience with information technologies and want to expand their knowledge.

Your trainer

Urs Scheufele: Seminar leader and lecturer for Excel 365 Advanced

Price from: 539,- Euro p. p. plus VAT.
Training.Internet.Coding Urs Scheufele

request seminar date

100% secure internet 100% SSL access Quality Icon

Similar seminars

Social

Youtube Linkedin Facebook

Categories

Hiscox-logo-1536x864
Cybersecurity and IT liability insurance

Word cloud topics

© 2024 Training.Internet.Coding privataktionaer.com ALL RIGHTS RESERVED!

Log in

Newsletter subscription

Current information New seminars, tips and tricks around IT.