Microsoft Excel is the most 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 tools.
• 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
• Analyzing 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