Course Methodology
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. This course aims to teach individuals how to easily monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. In addition, hands-on practical would be carried out to solidify participants’ training.

Course Objectives
By the end of this course, participants should be able to:

• Work with data
• Use collaboration tools effectively
• Work with outlines
• Analyze data with pivot tables

Target Audience
Managers, Senior Supervisors and Professionals who want to learn the basic to intermediate excel skills.

Target Competencies

• Managing performance
• Multi-tasking skill
• Analytical skill
• Coaching skill

Course Outline

Working with Functions

• Using the paste function tool
• Absolute and relative cell references
• Using range name in functions
• Crested nested functions
• Logical functions (SUMIF, COUNTIF)

Working with Data

• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tool

Working with External Data

• Writing formulas in cells
• Using the formula bar
• AutoSum and other basic functions

Working with External Data

• Data consolidation
• Linking to another workbook
• Linking to an external database
• Getting data from the web

Collaboration tools

• Protecting a workbook
• Protecting worksheets and cells
• Adding comments to cells
• Sharing workbooks

What-if Analysis

• Using the scenario manager
• Creating and editing scenarios
• Creating a scenario report
• Using Goal Seek

Working with Outlines

• Applying an outline
• Automatic outlining
• Displaying and collapsing levels
• Modifying outline settings
• Creating subtotals

Analysing Data with Pivot Tables

• Creating a pivot table
• Defining the source range
• Inserting, moving and deleting fields
• Showing and hiding fields
• Grouping and ungrouping fields

Excel Macros

• About macros and VBA
• Macro security
• Recording macros
• Running a Macro
• Absolute and relative references
• Saving and distributing macros
• Assigning a macro to a button
• Editing macro code
• Automatic macros

Customize Your Training
This training solution and other training topics from Nosak Group are currently available as a residential/in-house option. It can be customized for your team/organisation at your preferred location.