MS Excel 2010

Our training is focused on teaching participants the basic functions of working with Excel so that they can take full advantage of its features.
Code: OFFICE-002
Duration: 16 hours

Description

No matter what role you have in your company, chances are you spend quite a bit of time working with Excel. Whether you’re working on your budget, preparing data analysis for a presentation, tracking inventory or any other of the many uses that Excel has. Our training is focused on teaching participants the basic functions of working with Excel so that they can take full advantage of its features.

Roadmap

Working with Formulas
  • Calculations and operators
  • Data analysis
  • Syntax of basic formulas and the logic of their construction

Data Validation
  • Naming of areas
  • Creating an automatic pop-up
  • Customizing limit entering
  • Customizing error messages
  • Customizing user formatting

Working with Charts
  • Chart creation
  • Changing a chart type
  • Managing chart data

Pivot Tables
  • Elements of the Pivot Table
  • Advantages
  • Databases for the Pivot Table

Conditional Formatting
  • Automatic conditional formatting options
  • Manual setting of conditional formatting
  • Freezing rows and columns

Useful Functions of MS Excel
“Features” of MS Excel

Objectives

  • Learn strategies that help reduce the time spent on Excel tasks
  • Discover how to work with the most common standard formulas in Excel
  • What are some of the key best practices when working with Excel

Target Audience

  • Operational staff
  • Analytics
  • Managers


Trainer in Krakow
Zbigniew Baran Senior Project Management Officer
Zbigniew is a Senior Project Management Officer and Financial Analyst in one of Luxoft’s key projects. In this position he is responsible for, among others, coordinating finance planning, forecasting and actuals as well as supporting the business' financial decision-making process by providing analysis and reporting.

He has extensive expertise in working with Excel for budgeting, forecasting, reporting and preparing financial/statistical/analytical models. For Luxoft Training Zbigniew facilitates our Excel courses such as MS Excel 2010 and Statistics in MS Excel. He also holds an ITIL Foundation certification.
Course is scheduled in: Krakow
26.08.2019 - 27.08.2019
Time: 09:00-17:00
City: Krakow
Duration: 16 hours
Language: English
Trainer
Zbigniew Baran
Senior Project Management Officer
€136
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €136
Krakow €136
Wroclaw €136

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.