MS Excel has become an essential element in the work of many business establishments and individual users as it considerably facilitates and accelerates the working process. Despite widespread perception, the scope of its possibilities is not limited to finance and accounting activities but also includes data organization, programming graphing and many more. In this respect, the American Chamber of Commerce in Ukraine held free Chamber Friday University Course "Excel Basics". Session 1 to master participants' level of competence with Excel.
October 2, Module 1:
Topic 1. Keyboard shortcuts and quick analysis
- Navigation in the program
- Keyboard shortcuts
- Lists, creating custom lists
- Conditional formatting
- Data protection in Microsoft Excel
- Special insert
Topic 2. Preparation of data for work. Simplification of work with the text
- Sort and filter
- Creating tables
- Converting and stripping text
- Column text
- Insert and transpose
- Notes in cells
- Working with hyperlinks
- Custom formats in Excel
- Creating basic formulas
- Copying formulas
- Types of errors in formulas, correction of formulas
- Using data from other sheets in formulas - deleted links
- Text processing functions (SEARCH, SPACEBAR, PSTR, CLICK)
- Date and time processing functions (TODAY, DAY)
Speaker:
Oleksandr Kruglyakovsky
Founder and curator, ProExcel. Earlier Oleksandr was Senior PM at the department of operational processes in Eastern Europe at 4service company and managing director at EMPO company where he was engaged in the analysis of key performance indicators of companies to increase profitability.
Upcoming Sessions:
- Topic 3. Building a Dashboard. Calculations in Microsoft Excel
- Topic 4. Work with large tables. Organizing and summarizing data
- Topic 5. Creation of "smart" tables. Named Tables
- Topic 6. Pivot tables. Bulk data analytics and verification
- Topic 7. Work with charts. Simple visualization
