MS Excel: Practical Course
Our training helps you understand the main MS Excel functions and how to use them.
16 hours
Online
English
OFFICE-002
MS Excel: Practical Course
Sign Up
Duration
16 hours
Location
Online
Language
English
Code
OFFICE-002
Schedule and prices
€ 250
Training for 7-8 or more people? Customize trainings for your specific needs
MS Excel: Practical Course
Sign Up
Duration
16 hours
Location
Online
Language
English
Code
OFFICE-002
Schedule and prices
€ 250
Training for 7-8 or more people? Customize trainings for your specific needs

Description

Excel is still one of the most popular tools for collecting, processing and analyzing information. Its widely used by a variety of professionals for accounting, planning, budgeting, project management, information analysis, decision-making and many other activities.

Of course, a tool designed for such a wide range of tasks contains many functions and capabilities, which sometimes make it difficult to master.

The aim of this course is to help you master the basic set of functions in MS Excel, in particular the built-in formulas and methods of data visualization. We want to develop your understanding of the basic principles of working with spreadsheets, so that you are more comfortable and efficient in MS Excel. Youll discover a whole arsenal of "subtleties" in working with the program, which are fundamentally important for its successful use.

Youll learn to work with a minimum and necessary set of formulas that allow you to perform most daily tasks related to the analysis of various types data. Youll master the algorithm for writing formulas, which allows you to avoid gross errors - both explicit (syntactic) and hidden (leading to incorrect results).

Particular attention is paid to the capabilities of MS Excel for information visualization, by which large arrays of data can be visualized better, the analysis can be more detailed and the results made better. Well look at how to set the smart formatting of cells, set up preliminary data validation for entering into cells, the process of plotting, study the purpose of each graph element and their properties.

The main idea of the training is to develop a correct understanding of the fundamental principles of constructing formulas, graphs, pivot tables. This will allow you to improve the efficiency of using MS Excel in your current work and lay the foundation for further improvements to your knowledge of the capabilities of this powerful tool.
After completing the course, a certificate
is issued on the Luxoft Training form

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

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
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. Well notify you when we schedule the next course on this topic
+
Courses you may be interested in
Introduction to SQL
This training offers an introduction to SQL and helps participants develop the necessary skills for searching and modifying data in SQL databases. It is aimed at developers, analysts and other specialists who need to learn SQL basics.
Key Aspects of Project Management
This training is an introduction into software project management, for prospective and current project managers.
PM-001
28 hours
Sign Up
Basics of Agile Methodology for Software Development
The training is built on practical exercises, Scrum simulations, discussions and case studies illustrating the basic principles and practices of Agile development.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you.
Your request has been received.
Thank you!
The form has been submitted successfully.