Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. The management and reporting of data is an important function of any modern business organisation. Business data is often available in the form of tables or data lists, which is a convenient format for Excel’s very considerable collection of powerful analytical and organisational tools.
You can use this flexible program to 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; use lookup and database functions and PivotTables.
This course also introduces participants to the use of Goal seek, data tables and scenarios to make projections about data. Participants will also learn how to audit worksheets, protect worksheets and workbooks that have sensitive data and create and use macros to automate processes.
At the end of this training, participants will be able to:
- Manage data in lists
- Filter and query data
- Use lookup and database functions
- Protect data for worksheets and workbooks
- Use PivotTables to display and chart data
- Use data tables & scenarios to make projections
- Audit worksheets
- Work with Macros to automate database functions
Who Should Attend and Prerequisites
This course is designed for professionals working with this application daily, this course provides a deeper knowledge of Excel. All learners should be comfortable with the Microsoft Windows® environment.
Note: As this is a hands-on workshop, participants are requested to have Microsoft Office 2013, 2016 or 2019 installed.
MCO OFFER! Get RM399 off when you enter our COUPON CODE upon Checkout.