-552x564.jpg "Effective work with consolidated tables in Excel")
| Summary
tables are one of Excel's most powerful tools, available since the early 90s.
Most users don't even realize what a summary can do. With summary tables, you can convert thousands of database rows into a summary report, summarize the results, and select the records you need. Not only can you use standard consolidation operations such as sum, but you can also use summary tables to present data as percentages, show difference and cumulative totals, rank items, and add additional calculated columns. You will learn how to create basic summary tables, apply design and filtering tools, customize totals, and visualize data with charts. If you want to learn new things about crosstabs, useful hacks, features on how to work, the clips collected in the microcourse will make your work many times faster! Who this course is for: Anyone who wants to improve their Excel knowledge The course will be interesting for managers and office workers of all levels and specialties, executives, secretaries, accountants, economists, analysts, logisticians and many other professionals who would like to expand their knowledge for processing MS Excel spreadsheets. What you will learn Build and layout summary tables Combine summary table data into groups Analyze summary table data Create a calculated (virtual) column Create and customize summary charts Use graphical filters (slices) Import data into other applications (PowerPoint) Course content 1 section - 9 lectures - Total duration 54 min.
|