Creating Spreadsheets with Microsoft Excel

Participants of the Creating Spreadsheets with Microsoft Excel workshop gain hands-on skills to manipulate their business data using the leading spreadsheet tool in industry Microsoft Excel. Participants will also learn to customize the Excel environment, populate, sort, secure and share data within workbooks and documents while using scripting and automation tools and techniques.

CONTENT

Manage worksheets and workbooks

• Create worksheets and workbooks
• Import data into workbooks
• Navigate within workbooks
• Format worksheets and workbooks
• Customize options and views
• Configure content for collaboration

Manage data cells and ranges

• Manipulate data in worksheets
• Format cells and ranges
• Define and reference named ranges
• Summarize data visually

Manage tables and table data

• Create and format tables
• Modify tables
• Filter and sort table data

Perform operations by using formulas and functions

• Insert references
• Calculate and transform data
• Format and modify text

Manage charts

• Create charts
• Modify charts
• Format charts

FOR WHOM: Auditors, Computer Executives, Internal Control Officers, CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals, and Security department managers who form part of the contingency planning or review team.

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.