EXCEL SKILLS FOR BUSINESS: ADVANCED
Contact hours: 15 hours
This final course is designed to reinforce the foundational knowledge acquired in the earlier Basic and Intermediate courses. It encompasses tasks such as data cleaning, preparation for analysis, and acquiring skills in working with dates and financial functions. Upon completing this course, you will gain the ability to understand and delve into specific aspects of various work methods, whether individual or group-oriented. Additionally, you will be equipped to evaluate and utilize advanced functions for data manipulation, creating personalized analyses through techniques like pivot tables, hypothesis analysis, scenario management, and resource optimization analysis. The course will also cover the analysis of linking Excel with other applications, involving importing information from text files and databases and exporting information in diverse ways to text files. Furthermore, you will comprehend the use of macros, unlocking a realm of applications to enhance productivity. This includes the analysis and automation of data through macros, form controls, hyperlinks, and internet connections. The curriculum extends to working with subtotals, consolidation, and analytical tools like Goal Seek, scenarios, Solver, and forecasting. In summary, the course aims to provide a comprehensive understanding of advanced Excel functionalities, enabling effective data manipulation, sophisticated analyses, and seamless integration with other applications while enhancing productivity through the exploration of macros and analytical tools.