MS Excel: Tips & Tricks
Opis
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.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
wydawany jest certyfikat
Cele
Participants are expected to demonstrate correct application of the advanced features of MS Excel and complete
tasks independently.
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)