Currently Open Education doesn’t offer this course. Please follow our website and social media pages for updates
About the course:
This course presents the concept of Microsoft Excel, its functions and opportunities. It shows how easy data analysis is and how to report it graphically; provides participants with the practical skills to speed up calculations and optimize work time in any company and develop an automated process.
The course focuses on live business examples from Armenia, as well as analyses and reports data in certain areas of businesses.
Learning objectives:
At the end of the course, participants will have a clear understanding of:
- Interface of the program, its functionality, formatting etc.
- Conditional formatting, its role to reporting
- The differences of excel functions and formulas
- User defined, mathematical, statistic, logical, date & time, database, information, text, lookup & reference, and financial functions
- How to name and apply to named ranges
- Shared files, data validation and track changes
- Data analysis, filtering, sorting, transposing, consolidating, smart tables, what-if-analysis and solver
- Pivot reporting, external connections & queries, advanced charting
- Protection and integration with office applications, macro recordings and automation
Who should attend this course?
The course benefits for all those working or want to work in the marketing, finance, accounting and auditing sectors who are working on data analysis, statistics and risk management plans by providing them the right skills to apply on fast reports and set-up structures.
Comments are closed, but trackbacks and pingbacks are open.