The workshop program includes, but is not limited to, the following topics

• Excel once and today – history of program development, versions, differences and common features
• Overview of Microsoft EXCEL worksheet capabilities, program organization, document – workbook organization
• Saving files – *.xlsx, *.xlsm, *.xlsb
• Building, modifying, formatting worksheets, creating and using functions
• Specific use of Excel by sales staff
• Use of relative, absolute and mixed references in formulas (e.g. A1, $A$1, $A1, A$1), use of names
• Using basic Excel functions (math, date and time, logical functions, etc.).
• Building a database on a worksheet, entering data, selecting data using criteria
• Organizing Excel work on a computer network: simultaneous work of multiple users on one worksheet, linking worksheets and workbooks using a computer network, merging data from multiple worksheets.
• Use of controls (lists, drop-down lists, buttons, dials) to automate actions performed on worksheets.
• Graphical presentation of data using charts (charts presenting multiple data series, trend analysis on a chart, custom charts).
• Retrieving external data – database queries, use of MS Query module.
• Using pivot tables as an analysis tool (e.g. multivariate analysis of sales by selected criteria, analysis of accounting data, analysis of customers, data summaries).
• Transferring information from worksheets to databases and retrieving information from databases.
• Preparation of databases and implementation of serial correspondence by transferring data to Microsoft Word word processor.
• Importing data from text files into Excel
• Speeding up work by using Excel templates
• Recording, running and editing macros
• Consolidating data from different worksheets
• Organizing work with Excel in a computer network: simultaneous work of multiple users on one worksheet, linking worksheets and workbooks using a computer network, merging data from multiple worksheets
• Graphical presentation of financial data using charts (compound charts, charts presenting multiple data series, trend analysis on a chart, custom charts, charts based on data from pivot tables),