Seminars for your success 

Excel 365 Basics

The Excel spreadsheet is the gold standard for professional business calculations. You can comfortably enter, evaluate, calculate or graphically present data, e.g. numbers or text, in tabular form.
Urs Scheufele: Seminar leader and lecturer for Excel 365 Basics

In selected seminar exercises you will learn to create expressive tables and charts in Excel. Already in the first lessons, all basic aspects of Excel are discussed using easy-to-follow examples. Participants will enter, calculate and format data, create descriptive charts and save and print tables. After a quick sense of achievement and an overview of the basics of Excel, you will gradually learn many Excel options that can be of importance in user practice. Including the use of formulas and functions via sorting. Also filtering data and efficient data evaluation with the help of table areas.

  • Getting to know the Excel interface
  • Basic techniques
  • Working with formulas
  • Format cells
  • Fill, copy and move
  • Edit table view and structure
  • Work with useful and simple functions
  • Finding and correcting errors in formulas
  • Workbooks and worksheet; Relative and absolute addressing IF and VERWEIS function;
  • Learn the basics of diagrams, create and format them;
  • Columns Insert, Delete, Copy and Column Width;
  • Number formatting: Thousand separator, Decimal places; Label, Custom formatting;
  • Cell formatting:; border, color, conditional formatting;
  • Sort, filter and evaluate lists;
  • Set print areas, controlled lettering repetition in headers and footers;
  • Use special functions
  • Perform time calculations
  • Create and design diagrams
  • Edit diagrams individually
  • Illustrate data with sparklines
  • Special design options
  • Print tables with individual layout settings
  • Use workbooks productively
  • Manage Excel templates/workbooks
  • Sort and filter data
  • Table areas
  • Edit large tables
  • Configure Excel individually

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.

Urs Scheufele: Seminar leader and lecturer for Excel 365 Basics

Training.Internet.Coding Urs Scheufele

Similar seminar topics

Word 365 Basics at Training.Internet.Coding

Word 365 Advanced 

Seminars for your success Word 365 Advanced Word 365 word processing offers sufficient functionality even for

EXCEL 365 Seminar at Training.Internet.Coding

Excel 365 Advanced 

Seminars for your success Excel 365 Excel for advanced users The spreadsheet Excel offers enough functionality

EXCEL 365 Seminar at Training.Internet.Coding

Excel 365 Basics 

Seminars for your success Excel 365 Basics The spreadsheet Excel is the gold standard for the professional

request seminar date

100% secure internet 100% SSL access Quality Icon

You are looking for another topic

Payment methods

de-pp_plus-logo-quer_ohne_PUI_540x60px
bank transfer

Shipping with

DHL

Newsletter subscription

Current information New seminars, tips and tricks around IT.