Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. You can use this flexible program to build models for analyzing data, perform sophisticated calculations that return the data that you need, write simple and complex formulas to perform calculation on that data, run powerful queries, pivot the data any way that you want, and present data in a variety of professional looking charts. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.
This course introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables.
In-class exercises also involve the use of data tables and scenarios to make projections about data and use Goal Seek and Solver to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks that has sensitive data, create and use macros to automate processes.
Upon completion of the program, the participants will be able to:
- Manage data in lists
- Filter and query data
- Use lookup and database functions
- Use PivotTables to display and chart data
- Use data tables & scenarios to make projections
- Analyze data and audit worksheets
- Work with Macros to automate database functions
- Protect data for worksheets and workbooks