This course is a way to quickly familiarize yourself with the capabilities of MS Excel as the most popular data processing program in business for any position. It is designed to make the beginner a confident business user of Excel's core functionality in the shortest possible time and without frills.

The course is for those who have already tried to learn from Microsoft's official tutorials, free tutorials, and youtube: "picked up" a lot of things, but due to the scattered information in the head instead of a systematic view of Excel as a tool for solving applied business tasks only "some patchwork quilt of scraps of knowledge".....

The course does not just give the basic minimum, but teaches a set of Excel functionalities for a full-fledged solution of applied cases and tasks

In the course the main emphasis is not on demonstrations of the screen and buttons in the course of lectures, but on practical mastering of the functionality. That's why the course is full of practical tasks that not only perfectly elaborate the lecture material, but also allow students to understand Excel more broadly and deeply and learn something new.

Excel has not lost its relevance for more than 30 years. On the contrary: despite the availability of professional programs, ERP systems and peer products - Excel is only gaining momentum among students and teachers, as well as among scientists, businessmen, managers and professionals.

Who this course is for:
Students of any discipline
Managers and professionals of different specialties who have recently encountered Excel and want to quickly learn its basic functions for work.
Job seekers: serious and large employers require Excel skills from almost all job applicants. This course contains everything you need.
Professionals and specialists who want to increase their value on the labor market or in the company through knowledge of Excel.
Business owners. Every business (even small businesses) are Excel cells. The "sea of numbers" for your business in Excel are not just numbers: they are your money.

What you'll learn
How to use Excel: basics, menus and structure, logic, data entry and filling, data organization, searching/replacing, copying, sorting and filters.
Calculations: basic formulas/functions covering 95% of business applications
Knowledge retrieval in data sets: summary tables and summary charts
Data formatting: cell and table formatting (incl. conditional formatting), groupings, fonts and alignment, use of annotations, insertion of shape elements, etc.
Visualization: different types of charts (bar charts, pie charts, dot charts, combo charts, spar charts, etc.).
Protection in Excel: protection of sheets and data fields, input validation rules, password encryption.

Course content 10 sections - 70 lectures - Total duration 4 h 43 min