Search courses 👉
Professional Course

MS Excel: Tips and Tricks

Length
15 hours
Price
350 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
Length
15 hours
Price
350 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
This provider usually responds within 48 hours 👍

Course description

This training is focused on tiny Excel features that can improve your work and help to do many things faster then others do. You will know hot-key combinations, how to copy, paste, move your data, generate new data, input restrictions on the cells content, use data entry forms, create lists, customize excel interface, perform quick analysis of your data, use advanced conditional formatting, create useful charts for dashboards, use traditional functions in unusual way and many, many more.

Upcoming start dates

1 start date available

Start Anytime!

  • Self-paced Online
  • Online
  • English

Who should attend?

Prerequisites

OFFICE-009, OFFICE-010

Training content

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)

Certification / Credits

Objectives

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

Quick stats about Luxoft Training Center?

More than 200 training courses

Conducted over 1,500 training sessions

Customized training solutions for business

Contact this provider

Contact course provider

Fill out your details to find out more about MS Excel: Tips and Tricks.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Luxoft Training Center
Warsaw Spire, plac Europejski 1
00-844 Warsaw

Luxoft Training Center

Luxoft Training Center — an essential part of the global technology leader, Luxoft, a DXC Technology Company. We play a pivotal role in propelling B2B businesses forward by delivering customized training solutions. Emphasizing the significance of learning and employee development,...

Read more and show all training delivered by this supplier

Ads