Description

Practical Excel training that will turn you into a certified Excel master

About course

Become a master of Excel

Learn how to use the crucial Excel functions and tools.

Learn from the experts

The course is conducted by an Excel specialist with many years of experience.

Test your knowledge

In the course, you will find tests and practical tasks to consolidate your knowledge and skills.

Do you want to master Excel quickly and efficiently?

We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas.

Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period.

You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic.

On top of everything, after completion of the course, you will receive certificate confirming your skills.

Join the Excel course and get the benefits:

Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee

Your Singing Instructor:

Lewis Hardin

Excel expert

The Excel course is conducted by an MS Excel expert and trainer.

He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program.

Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way.

Overview of the course:

The Excel course program:

I. Module 1 – Editing

Basic issues

Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts.

Editing and formatting

Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit.

Graphic and special elements

Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments.

II. Module 2 – Analysis and modeling

Create charts and tables

Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts.

Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts.

Filters (Slicer and Timeline): PivotTables and Plain Tables.

Use formulas

Rules for working on formulas.

Review and application of formulas.

Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking.

Working on data (databases)

Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis).

III. Module 3 – Review, view and print

Review and data protection

Checking: spelling; thesaurus; workbook statistics.

Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink.

View, printing and formats

View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros.

Printing: print area; page settings; margin settings; sheet adjustment.

File formats and saving.

IV. Module 4 – Advanced issues

Advanced features

Work with other apps

Tools and plugins for professionals

V. Tests

Tests and repetitions of acquired knowledge

The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training.

Final test

After completing the final test at the end of the Excel course, you will get certified.

VI. Tasks

Practical tasks and exercises

Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level.

VII. Bonus materials for the course

Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more.

Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese

A letter from your expert instructor:

If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert

Course Images

Excel Course

By KEMP CENTER

Booking options

Highlights

Description

About The Provider

Tags

Reviews