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.

Czas trwania
15 hours
Typ kursu
Online
Język
English
Czas trwania
15 hours
Lokalizacja
Online
Język
English
Kod
OFFICE-012
Szkolenie dla #uczestników# lub większej liczby osób? Dostosuj treningi dla Twoich konkretnych potrzeb
MS Excel: Tips and Tricks
Czas trwania
15 hours
Lokalizacja
Online
Język
English
Kod
OFFICE-012
€ 350 *
Szkolenie dla #uczestników# lub większej liczby osób? Dostosuj treningi dla Twoich konkretnych potrzeb

Opis

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.

certificate
Po ukończeniu kursu na formularzu Luxoft Training
wydawany jest certyfikat

Cele

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

Grupa docelowa

Anyone interested in the topic.

Warunki wstępne

OFFICE-009, OFFICE-010

Plan działania

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)

Nadal masz pytania?
Połącz sięz nami