Microsoft Excel is a spreadsheet developed by Microsoft for Windows, MacOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.
This program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts, sorting and filtering data, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel.
The course is designed for professionals would want to learn more complex formulas, troubleshoot and customize Excel application, Automate Excel Files and Create Dashboards how sort and filter more specific data, import and export data sets, analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros.
Participants will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with Advance level formulas, dynamic charts, visualize data with use powerful graphics, dashboards and streamline their operational work
Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.
