MS Excel: Tips and Tricks

MS Excel: Tips and Tricks

This training covers useful features of MS Excel for day-by-day use, some unusual technics and special features that can be helpful when you work with Excel.

Продолжительность
15 часы
Тип курсу
Онлайн
Мова
Англійська
Продолжительность
15 часы
Місцезнаходження
Онлайн
Мова
Англійська
Код
OFFICE-012
Тренінг для 7-8 чи більше людей? Налаштуйте тренінги для ваших конкретних потреб
MS Excel: Tips and Tricks
Продолжительность
15 часы
Місцезнаходження
Online
Мова
English
Код
OFFICE-012
€ 350 *
Тренінг для 7-8 чи більше людей? Налаштуйте тренінги для ваших конкретних потреб

опис

Boost your productivity and efficiency in Excel with our "MS Excel: Tips & Tricks" course.

This training focuses on small yet powerful features of Excel that can significantly speed up your workflow. Learn essential hot-key combinations, data manipulation techniques, advanced conditional formatting, and more. Discover innovative ways to use traditional functions and explore various chart types for dashboards. This course is perfect for Excel users looking to enhance their skills with practical tips and tricks.

This course covers a range of advanced Excel features and techniques and is divided into seven detailed modules:

  • Hot Keys
  • Manage Workbooks & Worksheets
  • Entering Data
  • Formatting Data
  • Formulas & Functions
  • Charts
  • Power Query Editor

By the end of this course, participants will be able to:

  • Utilize hot-key combinations to increase productivity.
  • Manage and customize workbooks and worksheets efficiently.
  • Enter and manipulate data using advanced techniques.
  • Apply advanced formatting options to enhance data presentation.
  • Use a variety of advanced formulas and functions creatively.
  • Create and customize a range of charts for insightful data visualization.
  • Perform advanced data transformations using Power Query Editor.

Participants will gain practical skills to perform tasks more efficiently in Excel, making their workflow faster and more productive. This course will empower participants to leverage Excel's full potential with various tips and tricks.

сертифікат
Після проходження курсу видається сертифікат
на бланку Luxoft Training

Цілі

Participants are expected to demonstrate correct application of the advanced features of MS Excel and complete tasks independently.

Цільова аудиторія

Anyone interested in the topic.

передумови

OFFICE-009, OFFICE-010

Дорожня карта

1. Hot Keys (1 hour)

2. Manage workbooks & worksheets (2 hour):

− Excel Customization, windows positioning, workbook protection,

3. Entering data (1 hour):

− Clipboard, user form, data transformation (flash fill, text-to-columns), data consolidation, drop-down list

4. Formatting data (2 hour):

− Custom styles, formulas in conditional formatting, check list, autoformat, format painter

5. Formulas & functions (3 hours):

− COUNTIFS, SUMIFS, DSUM, DCOUNT, DAVERAGE, VLOOKUP, XLOOKUP, FILTER, SORT, SORTBY, UNIQUE, CHOOSECOLS, VSTACK, HSTACK, DATEDIF

6. Charts (3 hours):

− Pictograph Chart, Interactive charts, Waffle Chart, Speedometer, Thermometer, Plan-Fact Chart, Timeline, Forecast

7. Power Query Editor (3 hours)

Залишилися запитання?
Зв'яжітьсяз нами