Microsoft Excel 2010 Intermediate Training in Switzerland

  • Learn via: Classroom
  • Duration: 1 Day
  • Level: Intermediate
  • Price: From €721+VAT
We can host this training at your preferred location. Contact us!

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting and filtering. You will also organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates

This course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.

  • Create more efficient formulas using range names
  • Link formulas to data in other worksheets
  • Create logical and lookup formulas using IF and VLOOKUP
  • Work with data lists effectively using sorting, filtering and subtotals
  • Take advantage of Excel’s Tables command and its benefits
  • Create and modify charts from worksheet data
  • Work with PivotTables, Slicers and PivotCharts

Module 1: Calculating with advanced formulas

  • Working with range names
  • Calculating across worksheets
  • Exploring Excel’s function categories
  • Use logical functions
  • Using the VLOOKUP function

Module 2: Working with data lists

  • Creating an effective list
  • Applying basic sorting
  • Advanced sorting
  • Summarising with subtotals
  • Filtering data lists

Module 3: Mastering Excel tables

  • Introducing tables
  • Creating a table
  • Managing tables
  • Calculations and totals in tables
  • Formatting a table
  • Further table tools

Module 4: Charts

  • Understanding charts
  • Creating a chart
  • Resizing and moving
  • Managing a chart
  • Working with chart elements
  • Formatting charts
  • Working with chart templates

Module 5: Working with PivotTables

  • Introducing PivotTables
  • Creating a PivotTable
  • Modifying PivotTables
  • Grouping data
  • Slicers
  • Creating PivotCharts


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Switzerland facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
01 July 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
14 July 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
27 July 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
06 August 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
19 August 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
20 August 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
24 August 2024
Bern, Zürih, Cenevre
1 Day
Classroom / Virtual Classroom
26 August 2024
Bern, Zürih, Cenevre
1 Day

Related Trainings

Microsoft Excel 2010 Intermediate Training Course in Switzerland

Switzerland, or officially known as the Swiss Confederation, is a federated country of central Europe. Because of its linguistic diversity, Switzerland is known by a variety of native names, such as Schweiz, Suisse, Svizzera and Svizra. While Bern is the administrative capital, Lausanne is the judicial centre of Switzerland. Zurich, Geneva and Basel are bases of some important international organisations such as the WTO, the WHO and FIFA. The country is well-known for its high welfare; Switzerland has the highest nominal wealth per adult.

Alongside the beautiful scenery, tourists visit Switzerland for the country's cultural attractions. There are many museums, galleries and historic buildings within popular cities such as Zurich, Geneva, and Lausanne. One of the most popular things to do is a train journey to the Top of Europe; Jungfraujoch. The longest glacier in Europe, the Great Aletsch Glacier begins at Jungfraujoch, and is also a UNESCO World Heritage Site.

Experience a paradigm shift in IT training with Bilginç IT Academy as we cater to the specific needs of Switzerland. Our training catalog showcases an array of Certification Exam preparation courses and accredited corporate training options, all delivered with innovative methodologies that will transform your learning journey.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.