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.

Durată
15 ore
Tipul de curs
Pe net
Limba
Engleză
Durată
15 ore
Locație
Pe net
Limba
Engleză
Cod
OFFICE-012
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice
MS Excel: Tips and Tricks
Durată
15 ore
Locație
Online
Limba
English
Cod
OFFICE-012
€ 350 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice

Descriere

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.

certificat
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training

Obiective

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

Public țintă

Anyone interested in the topic.

Cerințe preliminare

OFFICE-009, OFFICE-010

Foaia de parcurs

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)

Mai ai întrebări?
Conectați-văcu noi